Refer to the information pertaining to Endless Mountain Company that is provided in Integration Exercise 8. In addition to the budget schedules that you prepared in Integration Exercise 8, insert two new tabs in your Microsoft Excel worksheet titled “CVP Analysis” and “Variable Costing.”

Required (For all questions, be sure to use formulas that link to the other tabs in your Microsoft Excel worksheet when performing your calculations):

1. Calculate the following budgeted figures for 2017:

a. The total fixed cost.

b. The variable cost per unit sold.

c. The contribution margin per unit sold.

d. The break-even point in unit sales and dollar sales.

e. The margin of safety.

f. The degree of operating leverage.

2. Calculate the following budgeted figures for 2017:

a. A variable costing income statement. Stop your computations at net operating income.

b. A reconciliation that explains the difference in the absorption costing and variable costing net operating incomes.