Question

only anser the yellow shaded boxes

Arial B92. SM2594 [Compatibility Mode] - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Cut -10A A = = = Wrap Text En Copy - BIU - 2 - Et Merge & Center - $ - % , Format Painter 8. Con Fom Clipboard Font E l Alignment Number Num - X for ABC I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $ 1,125,000.00 723,250.00 $ 401,750.00 Sales 25,000 lamps @ $45.00 Cost of Goods Sold @ $28.93 Gross Profit Selling Expenses Fixed Variable (Commission per unit) @ $3.15 Administrative Expenses Fixed Variable @ $0.06 Total Selling and Administrative Expenses: Net Profit $ 23,000.00 78.750.00 $ 101,750.00 $42.000.00 1.500.00 43,500.00 145.250.00 256,500.00 $

Answer 1

I see The Light Inc. 70 Schedule of Projected Costs 71 Variable Manufacturing Unit Cost 72 20X1 Cost Projecte Percent 20X2 Cost Rounded to 73 7 Decimal Places 74 Increase Figurines 2% 9.3840000 75 9.2000000 Electrical Sets 2% 1.2750000 76 1.2500000 Lamp Shade 2% 77 6.0000000 6.1200000 Labor 2.2500000 3% 78 2.2950000 4.50% Variable Overhead 79 0.2250000 0.2295000 80 Projecte Variable Manufaturing Cost Per Unit 81 18.9250000 19.3035000 82 Total Variable Cost Per Unit 83 Projecte Percent 20X2 Cost Rounded to 84 20X1 Cost 7 Decimal Places 85 Increase Variable Selling 3.50% 3.2130000 86 3.1500000 Variable Adminstrative 0.0600000 5.00% 0.0612000 87 Projectd Variable Manufacturing Unit Cost 19.3035000 88 18.9250000 89 Projected Total Variable Cost Per Unit 22.1350000 90 22.5777000 91 R R

Schedule of Fixed Costs Projecte Percent 20X2 Cost Rounded to 92 20X1 Cost 7 Decimal Places 93 Increase Fixed Overhead 94 normal Capacity of 25000 lamps@ 95 250,000 20,000 270,000 Fixed Selling 23,000 16,000 39,000 96 Fixed Adminstrative 60,000 97 42,000 18,000 98 Projected Total Fixed Costs 315,000 99 369,000 100 101