Bambino Sporting Goods makes baseball gloves that are very popular in the spring

Question

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

  

  

If seasonal production is used, it is assumed that inventory will directly match sales for each month and there will be no inventory buildup.

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 30,900 units over four months at a level of 7,725 per month.

  

What is the ending inventory at the end of each month? Compare the unit sales to the units produced and keep a running total. (Leave no cells blank - be certain to enter "0" wherever required.)

  

  

If the inventory costs $16 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 1.0 percent as the monthly rate.) (Leave no cells blank - be certain to enter "0" wherever required.)

  

  March 3,150   April 7,150   May 11,300   June 9,300 30,900

Explanation / Answer

Assumption:There is no opening stock in the month of March.

Invetory Cost per unit=$16

so Finance cost:

Month Opening Stock-1 Production-2 Sales-3 Closing Stock(1+2-3) March                           -                  7,725         3,150                                  4,575 April                    4,575                7,725         7,150                                  5,150 May                    5,150                7,725      11,300                                  1,575 June                    1,575                7,725         9,300                                         -                30,900      30,900

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.