please answer everything in yellow!!

File Home Insert Draw Page Layout Formulas Data Review View Help Arial 10 29 Wrap Text X cut [h Copy Paste Format Painter BI A Merge & Center $ % 28 Clipboard Font Number 2 Alignment A1 X f J D A B 1 K UN- E F G H I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $1,125,000.00 750,000.00 $ 375,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 52 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 Administrativo Expenses Net Profit $23,000.00 75,000.00 $8,000.00 $42,000.00 50,000 00 92.000.00 190,000.00 $ 185,000.00 1 See The Light Projected Balance Sheet As of December 31, 20x1 $ Current Assets Cash Accounts Receivable Inst Introduction FAQ 1 34,710.00 67,500.00 2 3 4 5 6 7 8 9 10 11 12 18 14 15 16 17 18 Prese Ready 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 500 @ $16.00 8,000.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 8 19 BO 31 $ 54,000.00 $ 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 86 $ 12,000.00 147,410.00 87 88 89 90 91 09 159 410.00 $ 213,410.00 Introduction FAQ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Pre Ready H J27 x fe A B E G 10 16 Lamp Kit $16.0000000 per lamp 19 Direct Labor 2.0000000 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 1. Material Costs are expected to increase by 3.00% 39 40 46 47 2. Labor Costs are expected to increase by 3.00% 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 544,000 57 58 6 Variable selling expensos (measured on a per bamp 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 administrativo expenses (measured a por lamp basis) are oxpected to 69 increase by 4.00% 70 76 On the following schedule develop the following figures Introduction FAQ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 77 B D E A Variable Manufacturing Unit Cost 20x1 Cost Projected Percent Increase 3 20x2 Cost Rounded to 2 Decimal Places 16 3 NN $16.48 $2.06 $2.13 (4011 14.02) (403) 6.5 ho 11 Lamp Kit 18 Labor 19 Variable Overhead 20 21 Projected Variable Manufacturing Cost Per Unit 22 29 30 20 $20.67 14.04) 31 Total Variable Cost Per Unit 20x1 Cost Projected Percent Increase 20x2 Cost Rounded to 2 Decimal Places 2 4 2.08 (405) 1406) 1404) 20 32 33. Vanable Seling 40 Variable Administrative 41 Projected Variable Manufacturing Unit Cost 42 43 44 Projected Total Variable Cost Per Unit 51 52 53 54 Schedule of Fixed Costs 25 1407) 20x1 Cost 20x2 Cost Projected Carnan 9110 FAQ | 112 3 4 5 6 7 Introduction 8 11 12 13 14 15 16 17 18 Prese 4 2.08 2 20 (406) (404) 40 Variable Administrative 41 Projected Variable Manufacturing Unit Cost 42 43 44 Projected Total Vanable Cost Per Unit 51 52 53 54 Schedule of Fixed Costs 25 14071 20x1 Cost 2012 Cost Projected Percent Increase (408) lamps @ 1409) 14101 55 62 Fixed Overhead 63 (normal capacity of 64 Fixed Selling 65 Fixed Administrative 66 73 Projected Total Fixed Costs 74 75 76 77 84 85 B6 (411) B CD E F G H 1 For 20x2 the selling price per lamp will be $45.00 What is the projected contribution margin and contribution margin ratio for each lamp sold? A 20 21 1 22 23 24 32 33 34 Contribution Margin per unit (Round to two places, St ##) (5011 Contribution Margin Ratio (Round to four places, % is two of those places ## ##%) 15021 For 20x2 the selling price per lamp will be $45.00 The desired net income in 20x2 is $187,500 would sales in units have to be in 202 to reach the profit goal? What 35 36 44 45 46 47 48 56 57 2 58 59 60 68 69 70 71 72 80 81 B2 83 84 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit needed) 503) Introduction FAQ 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 Ready 18 Prese G 15031 A B D E H 69 70 71 72 80 81 82 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) 83 84 92 93 94 3. For 2012 the selling price per lamp will be $45.00 If the fixed cost increase by $40,000 00 how many lamps 95 must be sold to breakeven? 96 104 105 106 107 108 116 117 118 119 120 121 Breakovon sales in units (Since we cannot sell part of a unt round up to the next until needed) 15.04 122 123 124 125