please answer everything in yellow!

D A E I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $1,125,000.00 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 @ $2.00 Total Selling and Administrative Expenses Net Profit $23,000.00 75,000.00 $ 98,000.00 $42,000.00 50,000.00 92,000 00 190,000.00 $ 185,000.00 2 3 4 5 6 7 8 9 14 15 16 17 18 23 24 25 26 27 32 33 34 35 36 41 42 43 44 45 50 51 See The Light Projected Balance Sheet As of December 31, 20x1 $ Current Assets Cash Accounts Receivable inuento 2 3 4 5 6 34,710.00 67,500.00 18 Present Value Tables 7 10 8 11 9 12 13 14 17 15 1 16 Ready Tu hare to coarch O TI A D E H G I See The Light Projected Balance Sheet As of December 31, 20x1 $ 34,710.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 @ $16.00 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 $ 54,000.00 $ 54,000.00 Current Liabilities Accounts Payablo 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 1 N 3 4 5 6 7 8 9 10 11 | 12 13 14 15 16 17 18 Present Value Tables Clipboard Font Alignment Number J27 X f A B D E F G H 8 The projected cost of a lamp is calculated based upon the projected increases or decreases to 9 current costs. The present costs to manufacture one lamp are 10 16 Lamp Kit $16 0000000 per lamp 19 Direct Labor 20000000 per lamp (4 lamps/hr) 20 Variable Overhead 2.0000000 per lamp 26 Fixed Overhead 10.0000000 per lamp (based on normal capacity of 25,000 lamps) 27 28 Cost per lamp $30.0000000 per lamp 29 30 Expected increases for 20x2 36 When calculating projected increases round to TWO ($0.00) decimal places 37 38 39 40 46 47 48 49 50 58 57 58 59 60 66 67 68 69 70 1. Material Costs are expected to increase by 3.00% 2 Labor Costs are expected to increase by 3.00% 3. Variable Overhead is expected to increase by 6.50% 4. Fixed Overhead is expected to increase to $280,000 5 Fixed Administrative expenses are expected to increase to $44,000 6 Variable selling expensos (measured on a per lamp basis) are expected to increase by 6.50% 7. Fixed selling expenses are expected to be $35,000 in 20x2. 8 Variable administrative expenses (measured a per lamp basis) are expected to increase by 400% 36 When calculating projected increases round to TWO ($0.00) decimal places 37 38 1. Material Costs are expected to increase by 3.00% 39 40 2. Labor Costs are expected to increase by 3.00% 46 47 3. Variable Overhead is expected to increase by 6.50%. 48 49 4. Fixed Overhead is expected to increase to $280,000 50 56 5. Fixed Administrative expenses are expected to increase to $44,000 57 58 6. Variable selling expenses (measured on a per lamp basis) are expected to increase 59 by 6.50% 60 66 7 Fixed selling expenses are expected to be $35,000 in 20x2. 67 68 8. Variable administrative expenses (measured a per lamp basis) are expected to 69 increase by 4.00% 70 76 On the following schedule develop the following figures: 77 1- 20x2 Projected Variable Manufacturing Unit Cost of a lamp. 78 79 2- 20x2 Projected Variable Unit Cost per lamp 80 86 87 RR 3- 20x2 Projected Fixed Costs 3 44 For 20x2 the selling price per lamp will be $45.00 If the variable cost increase by $4.00 a unit how many lamps 5 must be sold to breakeven? 6 7 8 9 10 11 12 13 22 23 24 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) 1601) 25 26 35 5 For 2012 the selling price per lamp will be $45.00 If the variable cost decreased by $100 a unit how many lamps 36 must be sold to breakeven? 37 38 39 48 49 50 51 Breakoven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) 16 02) 52 61 6. If for 20x2 the selling price por lamp is increased to $49.00 a unit how many lamps must be sold 62 to breakeven? 63 64 65 1 2 3 6 7 8 9 10 12 13 14 15 16 17 18 Present Value Tables 4 5 8 11 1 1 B D E If for 202 the selling price per lamp is increased to $49.00 a unit how many lamps must be sold to breakeven? 16.03) A 61 6 62 63 64 65 74 75 76 77 78 87 88 89 90 7 91 100 101 102 103 104 113 114 115 116 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit needed) If for 20x2 the selling price per lamp is decreased to $11.00 a unit how many lamps must be sold to breakeven? 117 Breakoon solos in units (Since we cannot sell part of a unit round up to the next unit needed) 16041