Excel File Edit View Insert Format Tools Data Window Help CJ7471 (1).xls [Compatibility Mode AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View D3 A C H For 20x2 the selling price per lamp wil be $45.00 If the variable cost increase by $5.00 a unit how many lamps must be sold to breakeven? 7 14 15 16 17 18 25 26 27 28 Breakeven sales in units (Since we cavot sell part of a unt round up to the net unit if needed) (6.01) 29 36 37 5 For 20x2 the selling price per lamp will be $45.00 If the variable cost decreased by $5.00 a unit how many lamps 38 must be sold to breakeven? 39 40 47 48 49 50 Breakeven sales in units (Since we cannot sel part of a unit round up to the next unit if needed) 51 (6.02) 58 59 6 If for 20x2 the selling price per lamp is increased to $50.00 a unit how many lamps must be sold to breakeven? 60 61 62 70 71 72 73 81 Breakeven sales in units (Since we cannot sell part of a unit round up to the net unit if neooded) 82 (6.03) 84 7 If for 20x2 the seling price per lamp is decreased to $40.00 a unit how many lamps must be sold to breakeven? 91 92 94 95 102 103 104 105 106 Breakeven sales in units (Since we canol sell part of a unit round up to the next unit if noeded) 107 (6.04) 108 109 110 2 Excel File Edit View Insert Format Tools Data Window Help CJ7471 (1).xls [Compatibility Mode AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View D3 A C H For 20x2 the selling price per lamp wil be $45.00 If the variable cost increase by $5.00 a unit how many lamps must be sold to breakeven? 7 14 15 16 17 18 25 26 27 28 Breakeven sales in units (Since we cavot sell part of a unt round up to the net unit if needed) (6.01) 29 36 37 5 For 20x2 the selling price per lamp will be $45.00 If the variable cost decreased by $5.00 a unit how many lamps 38 must be sold to breakeven? 39 40 47 48 49 50 Breakeven sales in units (Since we cannot sel part of a unit round up to the next unit if needed) 51 (6.02) 58 59 6 If for 20x2 the selling price per lamp is increased to $50.00 a unit how many lamps must be sold to breakeven? 60 61 62 70 71 72 73 81 Breakeven sales in units (Since we cannot sell part of a unit round up to the net unit if neooded) 82 (6.03) 84 7 If for 20x2 the seling price per lamp is decreased to $40.00 a unit how many lamps must be sold to breakeven? 91 92 94 95 102 103 104 105 106 Breakeven sales in units (Since we canol sell part of a unit round up to the next unit if noeded) 107 (6.04) 108 109 110 2