Mars Corporation incurs the following overhead costs to manufacture its product: Indirect materials $................................$ $$2$ per unit

Indirect labor $.......................................$ $$1\mathrm{.}50$ per unit

Supervisory salaries $............................$ $$84,000$ per month

Depreciation of plant and equipment $..$ $$58,000$ per month

Utilities $................................................$ $$3,000$ per month $+$

$$0\mathrm{.}25$ per unit

Using the Excel Case: Flexible Budgets Answer Sheet, prepare a flexible overhead cost budget for the following production levels: $6,000$ units, $8,000$ units, and $10,000$ units.

Required:

$1.$ Label the $3$ Variable Costs you will be calculating in cells A$7,$ A$8,$ and A$9.$

$2.$ Calculate the $3$ variable costs at each level by using formulas in excel cells B$7-$D$7,$ B$8-$D$8,$ and B$9-$

D$9.$

$3.$ Find the total variable overhead costs by using a formula in excel in cells B$10-$D$10$

$4.$ Label the $3$ Fixed Costs you will be calculating in cells A$13,$ A$14,$ and A$15.$

$5.$ Fill in the $3$ Fixed Costs in cells B$13-$D$13,$ B$14-$D$14,$ and B$15-$D$15.$

$6.$ Sum the total Fixed Overhead Costs by using a formula in excel in cells B$16-$D$16.$

$7.$ Find the Total Factory Overhead Costs by using a formula in cells B$18-$D$18.$

To ensure you are on the right track, Cell B$18$ should be $$167,500.$Mars Corporation incurs the following overhead costs to manufacture its product:

Indirect materials

$$2$ per unit

Indirect labor

$$1\mathrm{.}50$ per unit

Supervisory salaries

$$84,000$ per month

Depreciation of plant and equipment $..$ $$58,000$ per month

Utilities

$$3,000$ per month $+$

$$0\mathrm{.}25$ per unit

Using the Excel Case: Flexible Budgets Answer Sheet, prepare a flexible overhead cost budget for the

following production levels: $6,000$ units, $8,000$ units, and $10,000$ units.

Required:

Label the $3$ Variable Costs you will be calculating in cells A$7,$ A$8,$ and A$9.$

Calculate the $3$ variable costs at each level by using formulas in excel cells B$7-$D$7,$ B$8-$D$8,$ and B$9-$

D$9.$

Find the total variable overhead costs by using a formula in excel in cells B$10-$D$10$

Label the $3$ Fixed Costs you will be calculating in cells A$13,$ A$14,$ and A$15.$

Fill in the $3$ Fixed Costs in cells B$13-$D$13,$ B$14-$D$14,$ and B$15-$D$15.$

Sum the total Fixed Overhead Costs by using a formula in excel in cells B$16-$D$16.$

Find the Total Factory Overhead Costs by using a formula in cells B$18-$D$18.$

MARS CORPORATION

MONTHLY FACTORY OVERHEAD COST BUDGET

TOTAL VARIABLE OVERHEAD COSTS

Fixed Costs:

TOTAL FIXED OVERHEAD COSTS

TOTAL FACTORY OVERHEAD COSTS