Make CVP Calculations for the Baseline Case

On the first sheet of your workbook (the sheet labeled baseline case), do a-d below.

1. Prepare a contribution margin income statement (also called a variable-costing income statement) for the manufacturing company for the upcoming year.
2. Compute the companys contribution margin per unit and contribution margin percentage for the upcoming year. The contribution margin percentage is calculated as contribution margin per unit / selling price per unit or as total contribution margin / total revenue. Make these calculations below your income statement. Clearly label these calculations.
3. Calculate the companys breakeven point in units for the upcoming year. Make this calculation below your contribution margin calculations. Use Excels round function to round up to the nearest whole number. To do this, move your curser to the cell beside the decimal number and key in the following formula: =ROUNDUP(cell reference,0). The italicized cell reference means you need to key in the cell where the decimal number is located (e.g., F12). The number 0 means zero decimal places. Clearly label this calculation.
4. Calculate the companys breakeven point in sales dollars for the upcoming year. Make this calculation below your breakeven calculation in units and use the companys contribution margin percentage to make this calculation. Clearly label this calculation.

PARAMETERS FOR BASELINE CASE
The following numbers are estimates for the upcoming year for a manufacturing company.
Since the company is effective at implementing a JIT inventory system, assume there is
no beginning or ending inventory.
No. of units sold	150,000
Selling price per unit	$220.00
	Fixed Expenses	Variable Expenses (per unit sold
Production costs:
Direct materials		$16.00
Direct labor		32.00
Factory overhead	$2,360,000	22.00
Marketing expenses:
Sales salaries and commissions	520,000	6.50
Advertising	320,000
Miscellaneous mktg. expenses	120,000
Administration expenses:
Office salaries	650,000
Supplies	103,000	2.00
Miscellaneous admin. expenses	75,000
TOTAL EXPENSES	$4,148,000	$78.50