type in the formulas to calculate all the cells highlighted in green, including sold quantity of each product, total sales of each product, total cost of each product, total profit of each product, the grand total of advertising cost, the grand total of sold quantity, the grand total sales, the grand total cost, the grand total profit, and the gross margin ratio. All the numbers must be calculated by using the following formulas:

? Sold Quantity=Advertising Cost / Average Conversion Cost. Make sure the numbers are in the general format (not accounting format because it is just a number).

? Total Sales = Retail Price Per Unit Sold Quantity

? Total Cost = Production Cost Per Unit Sold Quantity + Advertising Cost

? Total Profit = Total Sales - Total Cost

? In the Grand Total row, display the sum of advertising cost, sum of sold

quantity, sum of total sales, sum of total cost, and sum of total profit.

? Gross Margin Ratio= Grand Total Profit / Grand Total Sales

Remember: always use cell reference instead of directly typing in the calculated numbers for all formulas: Also, make sure that you format cells that displays dollar amount in the accounting format. Your finished worksheet should have a grand total profit of $116400.00.