Boxer Company plans to sell 400,000 units of finished product in July 20x1. Management (1) anticipates a growth rate in sales of 5% per month thereafter and (2) desires a monthly ending finished-goods inventory (in units) of 80% of the following month's estimated sales. There are 300,000 completed units in the June 30, 20x1 inventory. Each unit of finished product requires four pounds of direct material at a cost of $1.50 per pound. There are 1,600,000 pounds of direct material in inventory on June 30, 20x1.Required: A.Prepare a production budget for the quarter ended September 30, 20x1. Note: For both part "A" and part "B" of this problem, prepare your budget on a quarterly (not monthly) basis.B.Independent of your answer to part "A," assume that Boxer plans to produce 1,200,000
units of finished product for the quarter ended September 30. If the firm desires to stock direct materials at the end of this period equal to 25% of current production usage, compute the cost of direct material purchases for the quarter.
What will be an ideal response?
A. Projected sales | ? |
July | 400,000 |
August (400,000 × 1.05) | 420,000 |
September (420,000 × 1.05) | 441,000 |
Quarterly total | 1,261,000 |
? | ? |
Total Quarterly sales | 1,261,000 |
Add: Desired 9/30 inventory (463,050* × 80%) | 370,400 |
Total units needed | 1,631,440 |
Less: 6/30 inventory | 300,000 |
Total Quarterly production requirement | 1,331,440 |
* October sales : 441,000 × 1.05 = 463,050 | ? |
? | ? |
B. Material to be used in production (1,200,000 × 4 pounds) | 4,800,000 |
Add: Desired 9/30 inventory (4,800,000 × 25%) | 1,200,000 |
Direct materials needed | 6,000,000 |
Less: 6/30 inventory | 1,600,000 |
Pounds to be purchased during the quarter | 4,400,000 |
Direct materials cost per pound | × $1.50 |
Total Quarterly cost of purchases | $6,600,000 |
You might also like to view...
A leverage point is the feature of the ad that moves the viewer from understanding the product's benefits to linking those benefits with:
A) a liking for the product B) personal values C) the visual element into both a mental picture and words D) some type of action or change in attitude
Budgeting involves all of the following management functions except ________
a. directing b. explaining c. controlling d. planning
What type of advertising appeal calls on the feeling and sympathies of the audience?
A) emotional B) logical C) scarcity D) celebrity E) humor
A limitation on the scope of an audit sufficient to preclude an unmodified opinion is most likely to result when management
A. Engages the auditor after the year-end physical inventory count is completed. B. Fails to correct a material internal control weakness that had been identified during the prior year's audit. C. Refuses to furnish a management representation letter to the auditor. D. Prevents the auditor from reviewing the audit documentation of the predecessor auditor.