(d) The UK food and drink manufacturing market is on the rise, being worth £470 billion in total revenue as of 2021 indicating an increase from £455 billion in 2020. In 2025 revenue for the sector is projected to reach £675 billion.

  
🔴 LIVE EXPERT
  83 Orders

MN5070QA – The Practice of Consultancy 

The coursework consists of two parts. All tasks in both parts need to be attempted.
Note that Bakery, Local Supermarket and Retail Cases are fictitious clients.

NOTE: Kindly share your UPDATED exam paper to the LIVE EXPERT with an updated Case Study (if any)

PART 1

Task 1: The Bread Factory [30 marks]
The client is the CEO of The Bread Factory (TBF), a bakery and café located in London’s Borough and Hackney neighbourhoods. The Bread Factory is one of London`s leading artisanal bakeries, providing freshly baked bread and pastries to some of the city`s best restaurants, cafes, and shops. Earlier, you had worked on optimizing the firm’s cost structure. Your final recommendations related to this consultation were presented to the client in December 2024. The
CEO, Jonathan Warburton, has now asked you to help further improve the firm’s profitability.

Additional Information: The Bread Factory (TBF) Customers

  • TBF has 2 types of customers: diners and wholesale consumers.
  • While TBF`s diner consumers are typically not very price sensitive, they are keener on luxury experiences.
  • Increasing numbers of consumers are seeking to enjoy the dining experience (pizza and wine) in the café.
  • The typical TBF customer is a 35 to 55-year-old professional, with an annual household income above £75,000.
  • On average, customers spend £45 per transaction, with an average price for pizzas at £35.


Company

  • TBF bakes high-quality dough and has excellent reviews.
  • TBF`s distribution channels: Borough site is the original home and HQ of The Bread Factory (Bakery); Hackney site (Bakery and dining).
  • Previously, the client also sold pastries online. This channel was closed following a cost structure optimization consultation in 2024, as its cost-to- revenue ratio was unsustainable. TBF still maintains a website where customers can pre-order pastries for store pickup, but delivery to private customers is not currently offered.
  • TBF has a cost-efficient operating structure, with fixed and variable costs coming in below industry benchmarks. The Cost Revenue Ratio is 1:3 or 33%.
  • TBF`s total annual revenue (net sales) for the year ending 31 December 2024 is £8,000,000.
  • Revenue breakdown: Borough bakery contributed £4,500,000; restaurant sales added £3,500,000.
  • Average transaction values for Borough bakery outlet and Hackney site (Bakery and dining) are £60 and £105 respectively.
  • Return on Sales (margin) is 75% for the Borough bakery outlet and 45% for the Hackney site (Bakery and dining).
  • TBF`s target gross profit for the next financial year is £6,000,000.

Industry and Competition

  • The industry growth rate is in line with the UK GDP growth rate.
  • The market is intense, with the top 4 artisanal bakeries controlling 75% the luxury bread market.
  • TBF holds 32% of the freshly baked pastry market (North London).
  • Its main rival has 22% market share. The third and fourth largest rivals hold 11% and 10% respectively. Additionally, there are several small local bakeries serving the exclusive segment in different regions.
  • The foremost competitor has five distribution channels.
  • Data on the main competitor’s profitability is not available.


Required (Comments for task 1 should not exceed 800 words in total.)

  1. To understand the underlying dynamics, use a relevant strategic framework, such as Porter’s Five Forces, to inspect the problem and analyze the situation.
  2. Estimate TBF’s gross profit for the financial year ending 31 December 2025 and present recommendations aimed at improving profitability.
  3. Comment on the feasibility of the profit target in the current environment. You are expected to analyze and discuss cost and revenue projections, as well as the impact of current political-legal, economic, social, technological, and environmental factors on profit, if considered relevant.
  4. Present your analysis (for points 1 to 3 above), deliverables, and recommendations in a 600 to 800-word report addressed to the CEO of The Bread Factory. Your report should follow a clear structure and contain an introduction and conclusion with recommendations.

NB: Work for points (1) to (3) is completed ‘behind the scenes. The resultant framework, analyses, calculations, and recommendations should be presented to the client in the report and/or in the appendix of the report.
You may assume that TBF is not immune to the impact of increases in inflation (e.g., higher energy and commodity prices) and lower economic growth caused by crises such as the pandemic, BREXIT, and cost of living (growth rate: 1.2%, inflation: 2.7%).

Task 2 : Brown`s Retail Market Entry [30 marks]
You are a business analyst consulting for Brown`s Retail, a UK retail company. It had invested in food and drink retailing but presently plans to enter into the packaged food manufacturing market. Brown`s Retail has asked you and your team of analysts to determine the viability of the market.

Required for Task 2 (Comments for task 2 should not exceed 800 words in total.)
Prepare a short 600 to 800-word report for Brown`s Retail UK Limited, addressing the points/questions below. Your report should follow a clear structure and contain an introduction and conclusion with recommendations.

a. At the first meeting, the client seemed concerned about how you plan to approach the viability and market entry questions. Provide a brief overview of the market entry framework/approach you will focus on to analyse the decision problem.
b. Based on the proposed approach, how would you go about conducting the analysis and gathering the data and information required? Including the key sources of information and insights, you intend to consult.
c. Do a situational analysis to identify opportunities and challenges, both internal and external, to the organisation. You can also use the analysis to define the scope of the problem.

N.B: The words contained in the framework are not part of the word limit.

(d) The UK food and drink manufacturing market is on the rise, being worth £470 billion in total revenue as of 2021 indicating an increase from £455 billion in 2020. In 2025 revenue for the sector is projected to reach £675 billion.
You and your team of consultants should consider the following points:

  1. Calculate the projected percentage market growth rate (revenue) between 2020 and 2021 and provide an estimate of the projected growth rate between 2021 and 2025
  2. Given the market was estimated to be worth £380 billion in 2022, £330 billion in 2023 and £350 billion in 2024, calculate the expected annual growth rate (CAGR) between 2021 and 2025


(e)
 Brown’s Retail revenue was £2000,000 in 2022. Following its investment in the food and drink manufacturing market, the firm has set a revenue target of £4800,000 by 2025. By what percentage should revenue grow each year to reach the target?


PART 2

Task 1: Statistical Consulting for Greenside Supermarket [30 Marks]
Greenside Supermarket in Tingley introduced a loyalty card app in December 2024. Customers buy groceries using the loyalty card app on their mobile phones. As a consultant to the Greenside Supermarket, you have been asked to conduct a study to examine the frequency of repeat purchases by customers. Specifically, you have been asked to assess whether there is a disparity in repeat purchases between consumers who use the loyalty card app and those who are not.

The following research questions were set.
1. Is the proportion of consumers who use the loyalty card app greater than 60%?
2. Is the proportion of consumers who make repeat purchases different between those who use the loyalty app and those who do not?

The following two sets of hypotheses were stated.
Null: The proportion of consumers who use the loyalty app is equal to 60%.
Alternative: The proportion of consumers who use the loyalty app is greater than 60%.
Null: The proportion of consumers who make repeat purchases is not different between those who use the loyalty app and those who do not.
Alternative: The proportion of consumers who make repeat purchases is different between those who use the loyalty app and those who do not?

A simple random survey was conducted among traditional supermarket shoppers. Two of the questions, taken from the research instrument, are reproduced below.
Question 1: Do you make repeat purchases?           0. No Ο        1. Yes Ο
Question 2: Do you use the loyalty app?                 0. No Ο        1. Yes Ο

Appendix – SPSS Output for Part 2
Required for Part 2 ( comments for Part 2 should not exceed 400 words in total)
To complete the following, you need to refer to the output in the Appendix below. The SPSS tables should be inserted into your report and used as statistical evidence. Use either a snipping tool to copy the tables in the appendix or copy the tables (saved as PNG images) from the file: SPSS Evidence in the coursework folder.
The tables are made available but a data set is NOT made available for Part 2.

Tables can be found in the Appendix.
Interpret Table 2.1 and prepare a short comment on your findings.
(B) Table 2.2 shows the output for a hypothesis test conducted to inform on research question 1 above. Interpret the output and prepare a short statistical report, in the classical style, to summarise your findings. In your report, you need to state the null and alternative hypotheses, name the hypothesis test conducted and fully explain the output (all relevant values), calculate and interpret the effect size, where relevant, and discuss the assumptions of the test.
Based on your statistical interpretation, write a second comment aimed at the client to explain the outcome of the research in plain English.
(C) Table 2.3 shows the output for a hypothesis test conducted to inform on research question 2 above. Interpret the output and prepare a short statistical report, in the classical style, to summarise your findings. In your report, you need to state the null and alternative hypotheses, name the hypothesis test conducted and fully explain the output (all relevant values), calculate and interpret the effect size, where relevant, and discuss the assumptions.
Based on your statistical interpretation, write a second comment aimed at the client to explain the outcome of the research in plain English.


NB: Up to 10% of the marks is awarded for coursework management. Marks are awarded for professional presentation, use of section and paragraph titles and starting each task on a new page, among others.

Appendix – SPSS Output for Part 2
Table 2.1 

The Proportion using the Loyalty App
  Frequency Percent Valid Percent
Valid No 400 40.0 40.0
  Yes 600 60.0 60.0
Total 1000 100.0 100.0


Table
2.2 

Binomial Test

 

Category

N

Observed Prop.

Test Prop.

Exact Sig. (2- tailed)

The proportion using Loyalty App

No

400

0.40

0.60

0.005

Yes

600

0.60

 

 

Total

1000

1.00

 

 


Table
2.3 

Chi-Square Tests

 

        Value                     df               Asymptotic Significance (2-sided)

Pearson Chi-Square

69.856a

1

< 0.03

N of Valid Cases

1000

 

 

a. 0 cells (0%) have expected count less than 5. The minimum expected count is 5.92.

Symmetric Measures 

 

 

Value

Approximate Significance

Nominal by Nominal

Phi

.535

<.004 

 

Cramer`s V

.535

<.004 

N of Valid Cases

 

1000

 


The quoted price covers Theory & SPSS Evaluation. For custom requirements Live Chat or Whatsapp Click Here



                             

Email: care@academiasupport.co.uk

100% Plagiarism Free & Custom Written, Tailored to your instructions