Based on your decision tree analysis, calculate the expected monetary value (EMV) of the two options at the root of Mexton’s decision problem and advise the company on the alternatives or strategy that maximizes expected monetary value (EMV)
2024-11-12 16:07:45
BUS9040M: Decision Analysis for Managers
Assignment 3: Using decision models to make choices:
Case Study Analysis -The Mexton Machines Company decision problem
(Written as at January 2024)
The Mexton Machines Company was founded in the 1970`s in Lincoln, England. Originally, the company produced a range of small machines and tools for industry, but it expanded rapidly during the 80`s and early 90`s and acquired interests in industrial paint manufacture, pre-fabricated garages and building materials. New production units were opened in Leicestershire, Yorkshire and Bristol and the Head Office was moved to Loughborough.However, the company fared badly during the recession of the early 1980`s. The paint manufacturing side of the business was scaled down and prefabricated garage production ceased.
In recent years a new management team took over and it was decided that the company should diversify into the consumer goods market.A range of products was developed for the Do it Yourself (DIY) enthusiast including an electric drill and a car engine tuner. These are sold through the major DIY chains and hardware stores. To date, the products have been fairly successful,though sales are still small when compared with more established firms in this market. They also form only a relatively small part of the company`s total turnover, as shown below:
|
Sales (£ million)
|
Product Group/Year
|
2019
|
2020
|
2021
|
2022
|
2023
|
Industrial Machinery
|
32.4
|
24.8
|
36.8
|
33.6
|
34.4
|
Paint
|
14.4
|
13.2
|
12.4
|
11.6
|
10.4
|
Building Materials
|
25.2
|
26.0
|
26.8
|
28.8
|
30.8
|
Consumer Goods
|
0
|
1.2
|
2.4
|
3.6
|
4.4
|
The company is now (January 2024) considering the development of gardening tools and equipment and, as a first step, a detailed plan has been put forward to produce an electric lawnmower (code named the L5).Market research has suggested that consumers make their decisions in this market on the basis of price, convenience, safety and the presence of features such as a grass collecting box and an edge trimmer. Taking this market research information into account, an outline design has been formulated. This includes a processor that will precisely control the height of the blades on uneven lawns and an electronic voice that announces when the grass collecting box is full. Now a decision has to be made on whether the project should be continued. The market research and development of the design has already cost £2.5 million.
If a decision to continue is made, it is hoped that a successful prototype can be developed by December 2024.The company`s chief engineer, David Castle, has estimated that there is a 75% chance that the December target could be achieved and that research and development costs would amount to about £8 million. If the target is not achieved, the company will review the situation in January 2025. It could decide to abandon the entire project or to allow further work on the prototype.
David Castle estimates that modification of an unsuccessful prototype would cost around £6.4 million and the modifications would take an additional year to implement.
He is, however, sure that all problems would be overcome by December 2025.
The company also has to consider possible locations for the production of the L5. The list of possible sites has now been reduced to two: Wiltham in West Yorkshire could be a new site for the company, while an existing, but unused, factory at Eastoak in Leicestershire could be converted for L5 production.
The Wiltham site is an old textile mill which has been closed for two years. The site can be purchased immediately for £6 million. It is thought, however, that there is a 20% chance that the site will still be available in one year`s time for the same price, though it is unlikely that the site will still be available in two year’s time. Equipping the mill, which would not commence until the prototype had been successfully developed, would cost an additional £4 million. Because of the age of the buildings, and the need to carry out renovation work, it would take a year before the equipment could be installed. This means that, if a successful prototype was developed within a year, production could commence in January 2026. However, if the prototype development took two years, production could not commence at Wiltham until January 2027. The site is relatively small and could only cope with production of an estimated 50,000 lawn mowers per year. However, there are warehousing and transportation facilities and the availability of skilled labour force locally.
Converting the existing site at Eastoak would involve the construction of some new buildings.The conversion would take a year and would cost about £24 million,but a decision to go ahead with conversion would not be taken until a successful prototype had been developed. This again means that production would commence in January 2026 if the prototype was successfully developed within a year.However, if the prototype took two years to develop, production could not commence until January 2027. If the site is converted, it is anticipated that it would have a capacity to produce 166,000 lawn mowers per year.
Sales of the L5 would be supported by a major advertising campaign, especially in the first few months after its launch. In order to estimate the sales that would result, extensive use has been made of market research, economic and industry-wide data. To simplify the problem, the management team has decided to estimate sales under two different market conditions:Good, and Poor.These conditions can be assumed to prevail through the entire life of the product. The probabilities of these conditions prevailing are thought to depend to some extent on how quickly the product can be launched since an early launch will give Mexton an edge over any potential competitors. The Marketing Department has estimated the following probabilities:
Market Conditions Prevailing
Month production commences
|
Good
|
Poor
|
January 2026
|
0.7
|
0.3
|
January 2027
|
0.4
|
0.6
|
It has been decided to use a 6 year planning horizon (i.e. up to December 2029) since technological developments would probably mean that a new model would be required for the market for later years. The tables below show the estimated net cash flows which will occur during the years of the product`s life. These tables exclude cash flows relating to purchase or value of buildings or installation of equipment. In arriving at these estimates, it has been assumed that, because the Wiltham site can only cope with a relatively small volume of production, net cash flows generated by production at this site will be largely unaffected by market conditions.
If production is at Wiltham
Net Cash flow in product`s 1st year £16m
2nd year £16m
3rd year £16m
4th year £16m *
(* if applicable)
If production is at Eastoak
Market Conditions
Good Poor
Net Cash flow in product`s 1st year £24m £8m2nd year £24m £8m
3rd year £24m £8m
4th year £24m* £8m
(* if applicable)
At the end of 2029 it has been estimated that the Wiltham site would have a value of £16m, while the Eastoak factory would have a value of £32m.In the event of the Wiltham site being disposed of without being equipped (because of the abandonment of the project after the failure of the prototype) it can be expected to be sold for its original price of £6m. The company`s cost of capital (discount rate) is estimated to be 10%. For simplicity, it can be assumed that all cash flows occur at the end of the year. Also, the effect of factors like taxation and development grants should be ignored.
Question 1
Construct a decision tree to represent Mexton’s decision problem
Question 2 [approx. 300 words]
Based on your decision tree analysis, calculate the expected monetary value (EMV) of the two options at the root of Mexton’s decision problem
(i.e., whether to continue the project or abandon it) and advise the company on the alternatives or strategy that maximizes expected monetary value (EMV) (for example, should they continue with the project? If you advise they do, which site should they set up production if the prototype has been successfully developed after a year, etc.). Clearly justify your answers.
Question 3 [approx. 200 words]
It may be expected that the EMV and hence your recommended strategy for Mexton obtained in in questions 2 above critically depends on uncertain variables or chance events that are not within the control of the decision maker.
Therefore, conduct a sensitivity analysis on your recommended strategy for Mexton, supported by constructing a one-way sensitivity graph.Briefly explain the implications of your results to Mexton’s decision problem.
BUS9040M: Decision Analysis for Managers Assignment 4: Self Reflection of learning
[Number of words guide: approximately 500 words]
1.In your own words/opinions,reflect on your key learning or what you have learnt throughout the Decision Analysis for Managers module, including the knowledge and skills gained from the lectures, seminar series, learning activities, and assignments.
OPTIONAL: You may structure your reflection using a reflective writing framework such as Gibbs’ (1988) reflective cycle, Kolb’s (1984) Experiential Learning Theory (ELT) or any other reflective writing framework of your choice. You can learn about these famous approaches for reflection through your independent reading; ensure you reference your sources appropriately, as usual.
Note: Your reflection MUST be supported by SPECIFIC examples of what you have learnt in the module. Just a general reflection without giving examples of specific learning points drawn from the module content will be assessed as failing to effectively deal with the requirements of this assignment.
100% Plagiarism Free & Custom Written, Tailored to your instructions