Question
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
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 |
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 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 31,500 units over 4 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. (Leave no cells blank - be certain to enter "0" wherever required.) |
Ending Inventory | |
March | units |
April | units |
May | units |
June | units |
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 1 percent as the monthly rate.) (Leave no cells blank - be certain to enter "0" wherever required.) |
Inventory Financing Cost | |
March | $ |
April | |
May | |
June | |
Total financing cost | $ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started