Worked solution
To make an informed decision, we can calculate the absolute financial figures for each branch:
**Branch X:**
* Gross Profit = \( 60\% \times \$200,000 = \$120,000 \)
* Cost of Sales = \( \$200,000 - \$120,000 = \$80,000 \)
* Net Profit = \( 5\% \times \$200,000 = \$10,000 \)
* Operating Expenses = \( \$120,000 - \$10,000 = \$110,000 \)
**Branch Y:**
* Gross Profit = \( 40\% \times \$150,000 = \$60,000 \)
* Cost of Sales = \( \$150,000 - \$60,000 = \$90,000 \)
* Net Profit = \( 12\% \times \$150,000 = \$18,000 \)
* Operating Expenses = \( \$60,000 - \$18,000 = \$42,000 \)
**Branch Z:**
* Gross Profit = \( 70\% \times \$100,000 = \$70,000 \)
* Cost of Sales = \( \$100,000 - \$70,000 = \$30,000 \)
* Net Profit = \( 20\% \times \$100,000 = \$20,000 \)
* Operating Expenses = \( \$70,000 - \$20,000 = \$50,000 \)
**Analysis of Branches:**
* **Branch X** generates the highest revenue ($200,000) and gross profit ($120,000), but has an extremely low net profit margin of \( 5\% \), translating to only $10,000 profit. This is because its overhead operating expenses (like rent and wages) are massive at $110,000.
* **Branch Y** has a low gross profit margin (\( 40\% \)), meaning its direct costs (cost of sales, e.g., gym supplies, direct staff) are very high ($90,000). However, its operating expenses are lower ($42,000), allowing it to earn $18,000 net profit.
* **Branch Z** is highly efficient. It has a high gross profit margin (\( 70\% \)) and a high net profit margin (\( 20\% \)), yielding $20,000 in net profit despite having the lowest sales revenue.
**Recommendation:**
SF should close **Branch X**. Despite having the highest revenue of $200,000, it makes the lowest absolute net profit of only $10,000 due to its excessive operating expenses of $110,000. If SF closes Branch X, it will shed $110,000 in expenses. Even though it loses $200,000 in revenue, its overheads are disproportionately high. Branch Z is the most efficient and profitable branch in absolute terms ($20,000) and relative terms (\( 20\% \)), so it must be kept. Branch Y is also more profitable than Branch X ($18,000 vs $10,000). Therefore, closing Branch X is the best financial decision to improve the firm's overall margin.
Marking scheme
**Level 1 (1–4 marks):**
Candidate identifies simple points or trends from the raw percentage figures.
* *Example:* Branch Z has the highest gross profit margin. (1 mark) Branch X has the lowest profit margin. (1 mark)
**Level 2 (5–8 marks):**
Candidate performs accurate mathematical calculations of profitability figures and/or explains the significance of the ratios in context.
* *Example:* Branch X's gross profit is $120,000, but its net profit is only $10,000 because its operating expenses are extremely high at $110,000. This shows that despite high sales, Branch X is highly inefficient at controlling overheads. (6 marks)
* *Note: Up to 4 marks within Level 2 can be awarded for correct calculations (Gross Profit, Net Profit, or Operating Expenses).*
* Branch X: GP = $120,000; NP = $10,000; Exp = $110,000
* Branch Y: GP = $60,000; NP = $18,000; Exp = $42,000
* Branch Z: GP = $70,000; NP = $20,000; Exp = $50,000
**Level 3 (9–12 marks):**
Candidate provides a justified recommendation on which branch to close, comparing the financial trade-offs of each branch.
* *Example:* I recommend closing Branch X. Although it generates the highest revenue of $200,000, it is financially the weakest because it only yields $10,000 in net profit due to its huge expenses of $110,000. Closing Branch X immediately removes a massive expense burden from SF. I reject closing Branch Z because it is the most efficient branch, earning the highest net profit of $20,000 (\( 20\% \) margin) on only half of Branch X’s revenue. I also reject closing Branch Y because even though its gross margin is low at \( 40\% \), it still produces $18,000 in net profit, which is almost double that of Branch X. Thus, closing X is the best decision to increase SF's overall profitability. (12 marks)