acca ethics module unit 7 answers

Acca Ethics Module Unit — 7 Answers

The first half of Unit 7 requires you to manipulate a large dataset (often 200+ rows). You are usually asked three to five quantitative questions, such as:

Step 1: Download and Native Tools Never try to do this in your head. Download the Excel/CSV file provided. Use pivot tables. If the module embeds a spreadsheet tool, use the filter and sum functions.

Step 2: The Three Essential Functions To get the right answers, you must master:

Step 3: Check for Outliers A common trap in Unit 7 is that the dataset includes a "one-off" transaction (e.g., a massive bulk order in December). If you include that outlier, your "average monthly growth" will be wrong. The correct answer requires you to exclude anomalous data or note it in your commentary.

Pro-tip: If the question asks for "typical" growth, use median instead of mean. If it asks for "total," include everything. acca ethics module unit 7 answers

Your conclusion must do three things:

After your analysis, the module presents 3–6 MCQs. These are based directly on your calculations. Common questions:

  • “Which product line has the highest contribution margin per unit?”

  • “If the company reduces staffing costs by 15% and increases marketing spend by 10%, what is the net effect on operating profit?” The first half of Unit 7 requires you

  • “Which of the following is the most commercially viable strategic option?”

    • Note: Actual data in your module will differ.

    Suppose the spreadsheet shows:

    | Region | Revenue (£k) | COGS (£k) | Operating Costs (£k) | Profit (£k) | |--------|--------------|------------|----------------------|--------------| | UK | 500 | 200 | 150 | 150 | | EU | 300 | 180 | 120 | 0 | | Asia | 200 | 80 | 70 | 50 | Step 3: Check for Outliers A common trap

    Calculations:

    Decision: Close EU branch, reallocate resources to Asia.

    Impact: Lose EU revenue but save £300k (£180k COGS + £120k op costs). Use part of savings to double Asian marketing.

    New profit = UK £150k + Asia (50 × 2?) – needs careful adjustment.

    This is the type of logic you must apply.

    Once the numbers are crunched, Unit 7 pivots to the ACCA ethical framework. The scenario usually introduces pressure from a senior colleague (e.g., the Sales Director) to "adjust" the forecast presentation to avoid a bonus clawback or to hide poor performance in a specific region.