Using the worksheet pictured above, answer the following questions:

a.

Describe the steps you would follow to create the Profit calculation portion of the worksheet. Within the Profit calculation portion of the worksheet pictured, which cells would contain formulas? Specify each cell that would contain a formula and what each of those formulas would be.

b.

Describe the steps you would follow to create the Data table portion of the worksheet pictured.

c.

What is the current break even volume of sales if the selling price remains at $50? How do you know?

d.

If the company raises the selling price to $60 and sells 600 units, what would be the operating income?

e.

If the company's suppliers increase the cost of direct materials, would you expect the table to contain the same, fewer, or more shaded cells?

f.

If the company can negotiate lower plant property taxes with the county, would you expect the table to contain the same, fewer, or more shaded cells?

g.

If the company increased its target profit goal to $15,000 per month, would you expect the table to contain the same, fewer, or more shaded cells?