H I See The Light Projected Income Statement For the Period Ending December 31, 20x1 750,000.00 $ 375,000.00 Sales 25,000 lamps @ $45.00 Cost of Goods Sold @ $30.00 Gross Profit Selling Expenses Fixed Variable (Commission per unit) $3.00 Administrative Expenses. Fixed Variable @ $200 Total Selling and Administrative Expenses Net Profit ### 75,000.00 $ 98,000.00 50,000.00 92.000.00 190 000.00 $ 185,000.00 I See The Light Projected Balance Sheet As of December 31, 20x1 471000 I See The Light Projected Balance Sheet As of December 31, 20x1 $ 34710.00 67,500.00 Current Assets Cash Accounts Receivable Inventory Raw Material Lamp Kits Work in Process Finished Goods Total Current Assets 8,000.00 500 51600 0 3000 $30.00 90,000.00 $ 200,210.00 Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets $ 20,000.00 6 800.00 13.200.00 $ 213 410.00 $ 5400000 $ 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12,000.00 147.410.00 159 410.00 $ 213 410 00 12 13 14 18 Presente 15 16 10 Center FOR 5. % Sunda 06 Ahonen 04 17 The projected cost of a lamp is calculated based upon the projected increases or decreases to E 10 current costs. The present costs to manufacture one lampe 19 29 Lamp Kit $16.0000000 per lamp 32 Direct Labor 20000000 per lamp (4 tamps) 33 Variable Overhead 20000000 per lamp 43 Fixed Overhead 10 0000000 per lamp (based on normal capacity of 25.000 amps) 44 45 Cost per lamp $30,0000000 per lamp 46 47 Expected increases for 20x2 57 When calculating projected increases round to TWO (50.00) decimal places Sa 59 1. Material Costs are expected to increase by 3 50% 60 61 2 Labor Costs are expected to increase by 4.50% 71 72 3. Variable Overhead is expected to increase by 2 60% 73 74 4. Fixed Overhead is expected to increase to $270,000 75 85 6. Fixed Administrative expenses are expected to increase to $60,000 86 87 6 Variable selling expenses (measured on a per lamp basis) are expected to increase 88 by 6.50% 39 99 7. Fixed selling expenses are expected to be 533,000 in 2012 100 101 8 Variable administrative expenses (measured a pertamp basis) are expected to 102 03 increase by 2009 13 On the following schedule develop the following figures a Alam 58 culating projected increases found to TWO (50.00) decimal places 1. Material Costs are expected to increase by 3.50% 2 Labor Costs are expected to increase by 4.50% 3. Variable Overhead is expected to increase by 250% 4. Foxed Overhead is expected to increase to $270,000 59 50 51 71 72 73 74 75 85 5. Fixed Administrative expenses are expected to increase to 560,000 86 87 6. Variable selling expenses (measured on a per lamp basis) are expected to increase 88 by 6 50% 89 99 7. Fixed selling expenses are expected to be $33,000 in 2012 100 101 8. Variable administrative expenses (measured a per lamp basis) are expected to 102 increase by 2.00% 103 113 On the following schedule develop the following figures 114 1. 20x2 Projected Variable Manufacturing Unit Cost of a lamp 115 116 220x2 Projected Variable Unit Cost per lamp 117 127 3- 20x2 Projected Fixed Costs 128 129 9 7 12 10 13 11 5 14 6 4 12 15 16 17 . * Ready o Type here to search fo One 1 5 I See The Line Schedule of Projected Costs 16 13 14 15 Valable Manufacturing untos 20x1 Cost Projecte Percent Increase 2012 Cost Rounded to 2 Decimal Places 4 TF) 1402 16 17 Lamp kit 24 Labor 25 Variable Overhead 25 27 Projected Variable Manufacturing Cost Per Unit 20 35 36 37 Total Variable oster Unit 14.041 20x1 Cost Projected Percent Increase 2012 Cost Rounded to 2 Decimal Places 1405 406 400 30 39 Variable Selling 46 Variable Administrative 47 Projected Vanable Manufacturing Unit Cost 48 40 50 Projected Total Variable Cost Per Unit 7 (407 12 15 10 16 Clipboard 2 Eete- Font 5 - % 35 36 37 Total Vanable Cost Per Unit 2041 Cost Projected Percent Increase 2012 Cost Rounded to 2 Decimal Places 1405 4409 38 39 Variable Selling 46 Variable Administrative 47 Projected Variable Manufacturing Unit Cost 48 49 50 Projected Total Variable Cost Per Unit 57 58 59 60 Schedule of fixed Coats 1407 20x1 Cost 2012 Cost Projeded Percent Increase 140 lamps @__) 61 68 Fixed Overhead 59 (normal capacity of 0 Fixed Selling *1 Faxed Administrative 2 Projected Total Fixed Costs 1409 14101 (411)