Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Bambino Sporting Goods makes baseball gloves that are very popular in the spring and early summer season. Units sold are anticipated as follows:

March

3,250

April

7,250

May

11,500

June

9,500

Total units

31,500

If seasonal production is used, it is assumed that inventory will directly match sales for each month and there will be no inventory build-up. The production manager thinks the preceding assumption is too optimistic and decides to go with level production to avoid being out of merchandise. He will produce the 31,500 units over four months at a level of 7,875 per month.

a. What is the ending inventory at the end of each month? Compare the unit sales to the units produced and keep a running total.

b. If the inventory costs $12 per unit and will be financed at the bank at a cost of 12 percent, what is the monthly financing cost and the total for the four months? (Use 0.01 as the monthly rate.)

Short Answer

Expert verified

The ending inventory at the end of March is 4,625 units, April is 5,250 units, May is 1,625 units, and June is 0 units. The total cost of financing is $1,380.

Step by step solution

01

Calculation of ending inventory at the end of each month

Month

Units sold

Units produced

Change in inventory

Ending inventory

March

3,250

7,875

4,625

4,625

April

7,250

7,875

625

5,250

May

11,500

7,875

(3,625)

1,625

June

9,500

7,875

(1,625)

0

02

Expected sales for next year

Month

Ending inventory

Total cost per unit ($12 per unit)

Inventory financing cost (at 1% per month)

March

4,625

55,500

555

April

5,250

63,000

630

May

1,625

19,500

195

June

0

0

0

The total financing cost is $1,380.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Johnson Electronics is considering extending trade credit to some customers previously considered poor risks. Sales would increase by \(150,000 if credit is extended to these new customers. Of the new accounts receivable generated, 5 percent will prove to be uncollectible. Additional collection costs will be 2 percent of sales, and production and selling costs will be 74 percent of sales. The firm is in the 35 percent tax bracket.

Assume that Henderson also needs to increase its level of inventory to support new sales and that inventory turnover is two times.

d. What would be the total incremental investment in accounts receivable and inventory to support a \)65,000 increase in sales?

Bombs Away Video Games Corporation has forecasted the following monthly sales:

January

\(100,000

February

\)93,000

March

\(25,000

April

\)25,000

May

\(20,000

June

\)35,000

July

\(45,000

August

\)45,000

September

\(55,000

October

\)85,000

November

\(105,000

December

\)123,000

Total annual sales

\(756,000

Bombs Away Video Games sells the popular Strafe and Capture video game. It sells for \)5 per unit and costs \(2 per unit to produce. A level production policy is followed. Each month’s production is equal to annual sales (in units) divided by 12.

Of each month’s sales, 30 percent are for cash and 70 percent are on account. All accounts receivable are collected in the month after the sale is made.

b. Prepare a monthly schedule of cash receipts. Sales in the December before the planning year are \)100,000. Work part b using dollars.

Esquire Products Inc. expects the following monthly sales:

January

\(28,000

February

\)19,000

March

\(12,000

April

\)14,000

May

\(8,000

June

\)6,000

July

\(22,000

August

\)26,000

September

\(29,000

October

\)34,000

November

\(42,000

December

\)24,000

Total annual sales

\(264,000

Cash sales are 40 percent in a given month, with the remainder going into accounts receivable. All receivables are collected in the month following the sale. Esquire sells all of its goods for \)2 each and produces them for \(1 each. Esquire uses level production, and average monthly production is equal to annual production divided by 12.

d. Construct a cash budget for January through December using the cash receipts schedule from part b and the cash payments schedule from part c. The beginning cash balance is \)3,000, which is also the minimum desired.

What are the 5 Cs of credit that are sometimes used by bankers and others to determine whether a potential loan will be repaid?

Guardian Inc. is trying to develop an asset financing plan. The firm has \(400,000 in temporary current assets and \)300,000 in permanent current assets. Guardian also has \(500,000 in fixed assets. Assume a tax rate of 40 percent.

b. Given that Guardian’s earnings before interest and taxes are \)200,000, calculate earnings after taxes for each of your alternatives.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free