Acc 220 HW assignment the picture has all data given on the excel.

Prepare: One Period Do not have to do Cash portion of Budget [a] Sales budget [b] Ending FG Budget // Production Qty. Direct Material budget [d] Direct Labor budget [e] Manufacturing Overhead Budget [f] CoGS Chart [e] Selling Expense and Administrative Expense Budget [h] Statement of Income through Operating Income [ No interest] Do in order above No Balance sheet // No ending Cash Show work Use Class Examples Data Set Budget Period Next Period Unit Sales 22000 24000 Sales Price per unit $ 28.00 Ending FG inventory = 1/4 next period Sales units Beginning Material inventory 0.00 compute ending FG Qty./Inventory Beginning FG inventory 0.00 Ending Material inventory = -0- Fixed Manufacturing overhead per period = |$ 60,000 Variable manufacturing overhead per unit $ 12.00 applied on direct labor hours Variable Selling and Administrative Expense $ 8.00 applied per unit sold Fixed Selling and Administrative Expense $ 14,000 Direct Labor rate per hr. = $ 11.00 Hr. of direct labor per unit 0.10 Hr. for production = the Direct labor hrs. paid; -0- extra hours paid Ibs. of Material used per unit 0.30 cost per Lb. of material $ 2.00