Value: 15% Assessment 3 This assessment is worth 15% of the total subject assessment and is marked out of 100. Part A (50 marks) Capital Budgeting Background: This case is fictional and bears no relation to actual practice at Mars Australia New Zealand Mars Australia and New Zealand manufacture a range of fast moving consumer goods (FMCG) including pet food and pet care products, chocolates, confectionery, ice cream, and a variety of food products and supplements. These products are largely sold through supermarkets and specialty retailers. The Head Office for Mars Australia is in Albury Wodonga on the New South Wales – Victorian border. The company opened its first manufacturing facility in Albury Wodonga in 1966. Since then they have expanded their manufacturing footprint to include other sites in regional Australia and New Zealand. In the past two years Mars have launched their ‘Sustainable in a Generation’ plan which reflects their plan to “grow in ways that are good for people, good for the planet, and good for our business” (Mars, 2019: https://www.mars.com/global/sustainable-in-a-generation). A key focus to achieve these a goals is to focus on more efficient use of water and energy resources. Mars has a large confectionery factory in Ballarat which first opened 40 years ago in 1979. Confectionery manufactured in Ballarat includes the eponymous Mars Bar, Snickers, Maltesers, M&Ms, Bounty and Dove chocolates. The factory that manufactures the ‘Nutty Nut’ chocolate bar has not undergone a major refurbishment in the past 20 years and product managers are concerned that the cost of operating and maintaining old technology has impacted the cost and quality of the product. Problem: A full product market research analysis of the ‘Nutty Nut’ brand has been undertaken by external consultants at a cost of $500,000. The consultants found that by improving the quality of the product and lowering the cost, Nutty Nut can potentially become a market leader. Facilities management have produced the following budget on a factory refurbishment and technology upgrade which will cost an initial capital outlay of AUD$17.5 million. The existing plant and equipment will be sold for salvage and is expected to have a salvage value of $400,000. The existing equipment has a zero written down value in the
https://outlines.csu.edu.au/delivery/published/ACC515/201930/SM/I/outline.html#contentPanel
https://www.mars.com/global/sustainable-in-a-generation
accounts having been fully depreciated over its life. The upgraded facility will be ready for use at the commencement of the 2019-20 financial year. The upgrade will result in a 20% cut in power usage which represents a saving in electricity costs of $25,000 per week and an annual saving of $600,000 in water costs. The use of advanced robotics mean that less direct labour is required and labour savings and on-costs will amount to $2.5 million per annum. It is estimated that the cost of training staff to operate the new production line will amount to $750,000 which will be incurred before the new facilities come on-line. This cost is expected to be recorded as labour costs in the 2019 financial year. Extra maintenance of the new information technology (IT) and robotics is estimated to cost approximately $4,000 per week. The new production facility will be depreciated on a straight line basis over its 10 year life cycle to zero. Because of anticipated technology changes the production facility is expected to have a salvage value of $1 million at the end of 10 years. Mars are an international company and pay Australian tax at the rate of 30% on profits. The capital budgeting analysis should be conducted on an after tax basis. For the purpose of this analysis, tax should be recognised in the same year as the cash flow generating activity. The upgrade will increase the production capacity of the original factory by 50% and all costs other than Raw Materials will now be fixed. Whilst the proposed refurbished facility will achieve many facets of the Mars sustainability agenda the project must still pass the company’s international benchmark for capital investment of achieving a return of 20%. (i) Prepare an excel spreadsheet calculating whether this product will satisfy the investment parameters set by Mars. For the proposed ‘Nutty Nut’ capital investment calculate the following (using formula and worked out solutions):
● After-tax cash flows (15 marks) ● Payback period (3 marks) ● Net present value (5 marks) ● Profitability index (2 marks)
(ii) You are asked to present a report on your findings regarding the upgrade proposal. Make a recommendation to Management on whether they should proceed with the upgrade or not. Explain the criteria on which you have based your decision and ensure that you include an analysis of the strategic implications of some of the cost assumptions which underpin the budget. (10 marks) (iii) The closure of a Mars product line at their Ballarat site has left the company with an unoccupied manufacturing facility. Two projects have been proposed to use the
space and the following estimates of the present value of the competing project cash flows have been made:
Chocolate Ice cream
Net Present Value $25,000 $32,000
Estimated useful life 6 years 9 years