Gundy Company expects to produce 1,259,760 units of Product XX in 2012. Monthly

Question

Gundy Company expects to produce 1,259,760 units of Product XX in 2012. Monthly production is expected to range from 80,810 to 122,370 units. Budgeted variable manufacturing costs per unit are: direct materials $3, direct labor $6, and overhead $10. Budgeted fixed manufacturing costs per unit for depreciation are $5 and for supervision are $1. Prepare a flexible manufacturing budget for the relevant range value using 20,780 unit increments. Below is a snipit of what I have so far, I'm having difficulty with the rest

GUNDY COMPANY
Monthly Flexible Manufacturing Budget
For the Year 2012

GUNDY COMPANY
Monthly Flexible Manufacturing Budget
For the Year 2012

Total CostsTotal Fixed CostsSupervisionTotal Variable CostsVariable CostsActivity LevelOverheadDirect MaterialsDepreciationDirect LaborFinished UnitsFixed Costs Total CostsActivity LevelDirect MaterialsTotal Fixed CostsDirect LaborFinished UnitsSupervisionTotal Variable CostsVariable CostsFixed CostsDepreciationOverhead

SupervisionTotal Variable CostsTotal CostsVariable CostsActivity LevelFixed CostsDepreciationTotal Fixed CostsDirect LaborDirect MaterialsFinished UnitsOverhead Direct LaborFixed CostsVariable CostsOverheadDirect MaterialsSupervisionTotal CostsDepreciationActivity LevelFinished UnitsTotal Fixed CostsTotal Variable Costs

$

$

$

Direct LaborDirect MaterialsFinished UnitsFixed CostsTotal Variable CostsTotal Fixed CostsDepreciationOverheadSupervisionTotal CostsVariable CostsActivity Level

Variable CostsFinished UnitsFixed CostsOverheadTotal Fixed CostsTotal Variable CostsSupervisionActivity LevelDirect LaborTotal CostsDepreciationDirect Materials

Total CostsDepreciationDirect LaborVariable CostsActivity LevelOverheadTotal Fixed CostsDirect MaterialsFinished UnitsFixed CostsSupervisionTotal Variable Costs

$

$

$

Activity LevelDirect LaborSupervisionTotal CostsDepreciationTotal Variable CostsFixed CostsDirect MaterialsTotal Fixed CostsFinished UnitsOverheadVariable Costs Total Fixed CostsTotal Variable CostsDepreciationFinished UnitsVariable CostsActivity LevelDirect LaborDirect MaterialsFixed CostsSupervisionTotal CostsOverhead

Total Fixed CostsFixed CostsDirect LaborTotal Variable CostsVariable CostsActivity LevelDepreciationDirect MaterialsOverheadFinished UnitsSupervisionTotal Costs

Total CostsTotal Variable CostsSupervisionFixed CostsActivity LevelVariable CostsDepreciationDirect MaterialsDirect LaborOverheadTotal Fixed CostsFinished Units

DepreciationActivity LevelFixed CostsTotal CostsVariable CostsOverheadSupervisionTotal Fixed CostsTotal Variable CostsDirect LaborDirect MaterialsFinished Units

$

$

$

Explanation / Answer

FLEXIBLE BUDGET

PARTICULRS 80810 UNITS 101590 UNITS 122370 UNITS DIRECT MATERIAL 242430 304770 367110 DIRECT LABOUR 484860 609540 734220 OVERHEAD 808100 1015900 1223700 DEPRECIATION 404050 404050 404050 SUPERVISION 80810 80810 80810 TOTAL COST 2020250 2415070 2809890

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

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