Please help I need 9.09, 9.12, 9.13, 9.14. The rest of the yellow cells are correct. (I see the light CyberText project)

4 Factory Overhead Budget Overhead Allocation rate based on: 1. Number of Units Total Factory Overhead / Number of Units (Round to two places, $###.###) 341440/36400 $9.38 {9.01} 5 Cost of making one unit next year Cost of one Lamp Kit Labor Cost Per Lamp Factory overhead per unit 16.56 $2.11 {9.02) $ 28.05 {9.03} Total cost of one unit (Round to two places, $##.##) 6 Selling and Admin. Budget lamps x rate 37000 x 3.09 {9.04) Fixed Selling Variable Selling (Round to two places, $##.##) Fixed Administrative Variable Administrative (Round to two places, $#.##) Total Selling and Administrative (Round to two places, $##.##) 25000 $114,330.00 56000 76,960.00 272,290.00 37000 x 2.08 add all 4 $ $ {9.05) {9.06) YUV Goods Sold Budget Round dollars to two places, $##.## $ 90,000.00 {9.07} Beginning Inventory, Finished Goods Production Costs: Materials: Lamp Kits: Beginning Inventory Purchased Available for Use Ending Inventory of Lamp Kits Lamp Kits Used In Production $ $ 500 units 36450 units ? 550 x 16.56 $ 16.560 8,280.000 603612 611,892.000 9,108.00 364001 $ {9.08} 36400 x 16.56 = 602784 wrong $ $ 76,804.00 341,440.00 Total Materials: Labor Overhead Cost of Goods Available Less: Ending Inventory, Finished Goods Cost of Goods Sold {9.09} {9.10) {9.11} {9.12} {9.13) {9.14) opening FG + COGM 2 Materials Budget Lamp Kits Needed for Production Desired Ending Inventory Total Needed Less: Beginning Inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, $##.##) 36,400 units 550 units 36,950 units 500 units 36450 16.56 603,612.00 {8.01) {8.02) {8.03) (8.04) $ S {8.05) {8.06) 3 Direct Labor Budget $ {8.07) Labor Cost Per Lamp Production Total Labor Cost (Round to two places, $##.##) 2.11 36,400 units 76,804.00 S {8.08 4 Factory Overhead Budget S Variable Factory Overhead: Variable Factory Overhead Cost Per Unit Number of Units to be produced Total Variable Factory Overhead (Round to two places, $##.##) Fixed Factory Overhead 2.1000000 36,400 units 76,440.00 265000 $ {8.09} {8.10) Total Factory Overhead (Round to two places, $##.##) $ 341,440.00 {8.11) Variable Manufacturing Unit Cost 20x1 Cost 20x2 Cost Rounded to 2 Decimal Places Projected Percent Increase 3.50% 5.50% 16 $16.56 Lamp Kit Labor 2 $2.11 $2.10 {4.01} {4.02} {4.03} Variable Overhead 2 5% Projected Variable Manufacturing Cost Per Unit $20.77 {4.04) Total Variable Cost Per Unit 20x 1 Cost Projected Percent Increase 20x2 Cost Rounded to 2 Decimal Places 3 Variable Selling Variable Administrative Projected Variable Manufacturing Unit Cost 3% 4% 3.09 2.08 20.77 {4.05) {4.06 {4.04 Projected Total Variable Cost Per Unit 25.94 {4.07} Schedule of Fixed Costs 20x1 Cost 20x2 Cost Projected Percent Increase 265,000 10 x 25000 $ 265,000.00 {4.08} lamps @ ) Fixed Overhead (normal capacity of Fixed Selling Fixed Administrative $ 23,000 42,000 25,000 56,000 25,000.00 56,000.00 {4.09} {4.10} $ Projected Total Fixed Costs $ 346,000.00 {4.11} 4 Factory Overhead Budget Overhead Allocation rate based on: 1. Number of Units Total Factory Overhead / Number of Units (Round to two places, $###.###) 341440/36400 $9.38 {9.01} 5 Cost of making one unit next year Cost of one Lamp Kit Labor Cost Per Lamp Factory overhead per unit 16.56 $2.11 {9.02) $ 28.05 {9.03} Total cost of one unit (Round to two places, $##.##) 6 Selling and Admin. Budget lamps x rate 37000 x 3.09 {9.04) Fixed Selling Variable Selling (Round to two places, $##.##) Fixed Administrative Variable Administrative (Round to two places, $#.##) Total Selling and Administrative (Round to two places, $##.##) 25000 $114,330.00 56000 76,960.00 272,290.00 37000 x 2.08 add all 4 $ $ {9.05) {9.06) YUV Goods Sold Budget Round dollars to two places, $##.## $ 90,000.00 {9.07} Beginning Inventory, Finished Goods Production Costs: Materials: Lamp Kits: Beginning Inventory Purchased Available for Use Ending Inventory of Lamp Kits Lamp Kits Used In Production $ $ 500 units 36450 units ? 550 x 16.56 $ 16.560 8,280.000 603612 611,892.000 9,108.00 364001 $ {9.08} 36400 x 16.56 = 602784 wrong $ $ 76,804.00 341,440.00 Total Materials: Labor Overhead Cost of Goods Available Less: Ending Inventory, Finished Goods Cost of Goods Sold {9.09} {9.10) {9.11} {9.12} {9.13) {9.14) opening FG + COGM 2 Materials Budget Lamp Kits Needed for Production Desired Ending Inventory Total Needed Less: Beginning Inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, $##.##) 36,400 units 550 units 36,950 units 500 units 36450 16.56 603,612.00 {8.01) {8.02) {8.03) (8.04) $ S {8.05) {8.06) 3 Direct Labor Budget $ {8.07) Labor Cost Per Lamp Production Total Labor Cost (Round to two places, $##.##) 2.11 36,400 units 76,804.00 S {8.08 4 Factory Overhead Budget S Variable Factory Overhead: Variable Factory Overhead Cost Per Unit Number of Units to be produced Total Variable Factory Overhead (Round to two places, $##.##) Fixed Factory Overhead 2.1000000 36,400 units 76,440.00 265000 $ {8.09} {8.10) Total Factory Overhead (Round to two places, $##.##) $ 341,440.00 {8.11) Variable Manufacturing Unit Cost 20x1 Cost 20x2 Cost Rounded to 2 Decimal Places Projected Percent Increase 3.50% 5.50% 16 $16.56 Lamp Kit Labor 2 $2.11 $2.10 {4.01} {4.02} {4.03} Variable Overhead 2 5% Projected Variable Manufacturing Cost Per Unit $20.77 {4.04) Total Variable Cost Per Unit 20x 1 Cost Projected Percent Increase 20x2 Cost Rounded to 2 Decimal Places 3 Variable Selling Variable Administrative Projected Variable Manufacturing Unit Cost 3% 4% 3.09 2.08 20.77 {4.05) {4.06 {4.04 Projected Total Variable Cost Per Unit 25.94 {4.07} Schedule of Fixed Costs 20x1 Cost 20x2 Cost Projected Percent Increase 265,000 10 x 25000 $ 265,000.00 {4.08} lamps @ ) Fixed Overhead (normal capacity of Fixed Selling Fixed Administrative $ 23,000 42,000 25,000 56,000 25,000.00 56,000.00 {4.09} {4.10} $ Projected Total Fixed Costs $ 346,000.00 {4.11}