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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!