Formula: Add; Cell Referencing

BE$2\mathrm{.}12-$ Using Excel to Calculate Gross Margin and Revenue

PROBLEM

Bugsy provided the following operating information during the current year.

Operating income

Selling, general, and administrative costs

Cost of goods sold

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated.

What was Bugsy's gross margin this year?

Gross margin

What was its total revenue this year?

Total revenue