Set up formulas in the appropriate cells to calculate percentages for net sales, cost of goods sold, gross margin, operating expenses, and profit/loss.

Enter the components of the operating statement that you have available in each problem. Then calculate the dollar value of gross margin and profit/loss. Finally, calculate the percentage value of each component of the operating statement

The swimwear department has the following figures available: sales were $135,000, cost of goods sold was $120,000, and operating expenses were $11,500.