PART 2 Cost Volume Relationships - Profit Planning Betty's about to begin work on the budget for 2017 and they have requested that you prepare an analysis based on the following assumptions. Note: Remember, that we cannot sell part of a lamp, therefore to find the number of units you have to round up to the next complete unit. Furthermore, to find the required sales in dollars it may be easier to find the number of units and then multiply by the selling price per unit. 1. For 2017 the selling price per lamp will be $45.00. What is the projected contribution margin and contribution margin ratio for each lamp sold? Contribution Margin per Unit (Round to seven places $XX.XXXXXXX) Contribution Margin Ratio (Round to seven places, % is two of those places XX.XXXXX%) 19.28 42.84 5.01 5.02 2. For 2017 the selling price per lamp will be $45.00. How many lamps must be sold to breakeven? Breakeven sales in units (Round up to zero places XXX,XXX units) 129.201.00 3. For the selling price per lamp will be $45.00. The desired operating income in 2017 is $276,500. What would sales in units have to be in 2017 to reach the profit goal? Breakeven sales in units (Round up to zero places XXX,XXX units) 21,162.00 5.0 4. For 2017 the selling price per lamp will be $45.00. The company would like to have an operating income equal to 26% of sales. If that is to be achieved, what would be the sales in units in 2017? Sales in units (Round up to zero places XXX,XXX units) 260 5. For 2017, if the company believes that it could only sell 25,000 lamps, what would the new selling price have to be so that the new contribution margin per unit is equal to last year's contribution margin per unit? New Selling Price (Round up to two places $XXX,XXX.XX) 6. For 2017, the selling price per lamp will be $45.00. How many units must be sold to generate an net income of $264,000 assuming the tax rate of 40%? Sales in units (Round up to zero places XXX,XXX units) 7. For 2017, if the company believes that the demand will be 27,500 units for the year. What selling price per lamp, rounded to two places, would generate an operating income of $824,500? New Selling Price (Round up to two places $XXX,XXX.XX)