Set up formulas in the appropriate cells to calculate percentages for net sales,
ID: 2609275 • Letter: S
Question
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.
Explanation / Answer
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