Question: Please double-check my work, and if wrong, show me where you got the numbers. to get the correct answer. Please use Excel Calculations, thank you
Please double-check my work, and if wrong, show me where you got the numbers. to get the correct answer. Please use Excel Calculations, thank you in advance.
| The Company is preparing its production budget for the first quarter (January-March) of next year. The company is moving ahead with the expansion and using the sales budget based on 25,000 units for next year. | ||||||
| It purchases chocolate from a European chocolatier. Sweetwater makes its own fillings for the chocolates, produces the filled chocolates, and boxes the final product at its facility in Fort Collins. | ||||||
| Chocolate is purchased by the pound and costs $8 per pound or $0.50 per ounce. NOTE: 1 pound = 16 ounces. | ||||||
| Budgeted sales for the next five months follow: | ||||||
| January | February | March | April | May | ||
| Sales in units | 1,200 | 2,800 | 1,500 | 1,400 | 2,500 | |
| The company desires the ending Finished Goods Inventory to be equal to 25% of the next month's sales in units. | ||||||
| The December 31 balance of Finished Goods inventory is 300 units. | ||||||
| Company policy calls for a given month's ending raw materials inventory to equal 40% of the next month's materials requirements. The actual December 31 raw materials inventory is 11,520 ounces. Each finished unit requires 18 ounces of chocolate. March 31 raw materials inventory is 12,060. | ||||||
| Each finished unit requires 0.10 hours of direct labor at $20 per hour. | ||||||
| Variable overhead is applied at the rate of $25 per direct labor hour. | ||||||
| The company budgets fixed overhead of $6,000 per month. | ||||||
| Required: | ||||||
| (A.) Prepare the first quarter production budget to determine the number of units (i.e., boxes of chocolates) to be produced. | ||||||
| (B.) Prepare the first quarter direct materials (chocolate) budget; include the number of ounces to be purchased and the dollar cost of purchases. | ||||||
| (C.) Prepare the direct labor budget for the first quarter. | ||||||
| (D.) Prepare the factory overhead budget for the first quarter. | ||||||
| (A) Production Budget | January | February | March |
| Budgeted Unit Sales | 1,200 | 2800 | 1500 |
| Add: Desired ending inventory | |||
| Next period budgeted sales units | 2,800 | 1500 | 1400 |
| Ratio of inventory to future sales | 40% | 40% | 40% |
| Desired ending inventory units | 1,120 | 600 | 560 |
| Total required units | 2,320 | 3,400 | 2,060 |
| Less: Beginning inventory units | 560 | 1,120 | 600 |
| Units to produce | 1,760 | 2,280 | 1,460 |
| (B) Direct Materials Budget | January | February | March |
| Units to produce | 1,760 | 2,280 | 1,460 |
| Material required per unit | $ 0.50 | $ 0.50 | $ 0.50 |
| Materials needed for production (pounds) | 880 | 1,140 | 730 |
| Add: Desired ending materials inventory (pounds) | 570 | 365 | 300 |
| Total materials required (pounds) | 1,450 | 1,505 | 1,030 |
| Less: Beginning materials inventory (pounds) | 720 | 570 | 365 |
| Materials to purchase (ounces) | 730 | 935 | 665 |
| Materials cost per ounce | $ 8.00 | $ 8.00 | $ 8.00 |
| Cost of direct material purchases | $ 5,840 | $ 7,480 | $ 5,320 |
| (C). Direct Labor Budget | January | February | March |
| Units to produce | 1,760 | 2,280 | 1,460 |
| Direct labor hours required per unit | 0.10 | 0.10 | 0.10 |
| Direct labor hours needed | 176 | 228 | 146 |
| Direct labor cost per hour | $ 20 | $ 20 | $ 20 |
| Cost of direct labor | $ 3,520 | $ 4,560 | $ 2,920 |
| (D) Factory Overhead Budget | January | February | March |
| Direct labor hours needed | 176 | 228 | 146 |
| Variable overhead rate per direct labor hour | $ 25.00 | $ 25.00 | $ 25.00 |
| Budgeted variable overhead | 4,400 | 5,700 | 3,650 |
| Budgeted fixed overhead (given) | 6,000 | 6,000 | 6,000 |
| Budgeted total factory overhead | $ 10,400 | $ 11,700 | $ 9,650 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
