Question: please double check my work and if wrong p lease show me how you got the right answer, and if I entered the wrong the
please double check my work and if wrong p
lease show me how you got the right answer, and if I entered the wrong the number in the entries show me what the right answer is and where you got it from. please use Excel formulas when showing me what you go. The answers are pointless unless I know how you got them. 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 - 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: - The company desires the ending Finished Goods Inventory to be equal to 25% of the next monthis 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. 13 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. 16 (D.) Prepare the factory overhead budget for the first quarter. 50 (D) Factory Overhead Budget 52 Direct labor hours needed lanuary February March 53 Variable overhead rate per direct labor hour 54 Budgeted variable overhead 55 Budgeted fixed overhead (given)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
