Coolpak Company sells coolers. Their controller requests that you prepare acontribution margin income statement and do an analysis to determine the
Following items:
1. Total Sales, Variable Costs, Contribution Margin, & Operating Income (round to the nearest whole dollar)
2. Contribution margin per unit (round to two decimal places)
3. Breakeven point in units (round up to the nearest whole unit)
4. Breakeven point in dollars (round to the nearest whole dollar)
5. Calculate the contribution margin ratio (format the answer as a percent and round your percentage one decimal place)
6. Calculate variable cost as a percentage of selling price.(format the answer as a percent and round your percentage one decimal place)
7. Calculate operating leverage. (round to two decimal places)Coolpak's projected data for the upcoming year, 2017, is presented below.
Sales Price $65.00 Variable Manufacturing expense per unit $18.00 Variable Marketing expense per unit $8.00 Variable Administrative Expenses per unit $3.00 Fixed manufacturing Overhead $2,375,000.00 Fixed operating expenses $275,000.00 Number of flags produced & sold 230000
Prepare an excel model to answer all requirements.
Be sure to keep your input section of data separate from the section of your model that includes the formulas/calculations