1 Formul Addis Cell Rerencins 3 BE2.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 $185,00042,00077,500 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