I need help with 2, 3, and 4. apparently my math is off. please and thank you FE

Question

I need help with 2, 3, and 4. apparently my math is off. please and thank you

FE- B 1 u . |?, | a , A- | EE E Merge a center , $ , % , : Candtional Format as del Formatting Table tyles Format Painter Irmert Delete Format ignment Shies Celh 110 t BUDGETS 2 Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. 3 Create a sales budget. 6 Budget#1: Sales Budget Feb Q1 Total April May 72,000 4,000 Budgeted units to be sold 8 Sales price per unit 9 Total Sales 18,000 0,000 36,000 34 S 816,000|$ 1,020.000 | s2448,00 su,6,??1S $ 612,000|$ Thunder Creek wants to finish each month with 20% of next month's sales inunits Create a production budget. Hint: Beginning inventory for the period is equal to the ending inventory of the previous period. 0.2 Feb Mat 01 Total 16 Budget #2: Production Budget Budgeted units to be sold Plus: Desired units in ending inventory Total units needed Less: Units in beginning inventory Budgeted urnits to be produced nctionsBudgets

Explanation / Answer

Answer 1.

Sales Budget

Jan Feb March Total April May

Sales in Units 18,000.00 24,000.00 30,000.00 72,000.00 34,000.00 36,000.00

SP per Unit 34.00 34.00 34.00 34.00 34.00 34.00

Sales in $ 612,000.00 816,000.00 1,020,000.00 2,448,000.00 1,156,000.00 1,224,000.00

Answer 2.

Production Budget

Jan Feb March Total April May

Sales in Units 18,000.00 24,000.00 30,000.00 72,000.00 34,000.00 36,000.00

Add: Ending Inventory -20% 4,800.00 6,000.00 6,800.00 6,800.00 7,200.00

Total Needs 22,800.00 30,000.00 36,800.00 78,800.00 41,200.00

Less: Beginning Inventory in uints (3,600.00) (4,800.00) (6,000.00) (3,600.00) (6,800.00)

Required Production in Units 19,200.00 25,200.00 30,800.00 75,200.00 34,400.00

Answer 3.

Direct Material Budget

Jan Feb March Total April

Required Production in Units 19,200.00 25,200.00 30,800.00 75,200.00 34,400.00

Raw Material required per Unit - in Pounds 2.00 2.00 2.00 2.00 2.00

Total Raw Material Required 38,400.00 50,400.00 61,600.00 150,400.00 68,800.00

Add: Ending Inventory - Raw Material 12,600.00 15,400.00 17,200.00 17,200.00

Total Needs 51,000.00 65,800.00 78,800.00 167,600.00

Less: Beginning Inventory (9,600.00) (12,600.00) (15,400.00) (9,600.00)

Total Raw Material Purchased 41,400.00 53,200.00 63,400.00 158,000.00

Cost per Pound 4.00 4.00 4.00 4.00

Cost of Raw Material Purchased 165,600.00 212,800.00 253,600.00 632,000.00

Answer 4.

Direct Labor Budget

Jan Feb March Total

Required Production in Units 19,200.00 25,200.00 30,800.00 75,200.00

Direct Labor Hour per Unit 0.50 0.50 0.50 0.50

Total Direct Labor Hours Required 9,600.00 12,600.00 15,400.00 37,600.00

Cost per Direct Labor Hour 20.00 20.00 20.00 20.00

Direct Labor Cost 192,000.00 252,000.00 308,000.00 752,000.00

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.