Set up formulas in the appropriate cells to calculate percen

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.

Solution

Particulars amount percentage Sales 135000 100 Cost of goods sold 120000 88.88 Gross profit 15000 11.12 Operating expenses 10500 7.77 Net profit 4500 3.33