Problem: Frozen Olaf - Ice cream shop
Since January 2015, Elsa and Anna - originally from Arendelle - established a new ice cream shop in Hobart, they named it "Frozen Olaf". They specialised in making gourmet ice cream with a unique combination, such as:
- Very Vanilla
This ice cream flavour is a thirst quencher during summer and the creamiest ice cream produced with secret custard recipe. It has refreshing scent and loved by kids and adults.
- Batman Chocolate
Just like the name, this dark chocolate ice cream offers quality ice cream with only 30% fat of normal chocolate ice cream. The cocoa bean is sourced from North Sumatran forest in Indonesia.
- Almond Hazelnut
This nutty flavoured ice cream is a combination of high quality almond and hazelnut imported from Turkey and goat milk from Farmers in Invermay.
- Egg Bacon
Inspired by the famous chef Heston Blumenthal, this unique and unusual combination ice cream is the only one produced in Australia. Try this flavour if you are dare.
- Scotch Lavender
This ice cream uses only the best of Tasmanian produced. Awards winning Sullivan's cove single malt whisky and freshly harvested lavender from north east Tasmania. This ice cream contains 3% alcohol contents.
One month ago, Elsa and Anna attended a seminar about Accounting Information and Analysis. They hired you as a consultant to analyse and provide a report on Frozen Olaf data. They want to know to how to grow their revenue and profit streams. (Data is provided in attached files Excel)
Your report shall comprise:
1. An executive summary (around 200 words). The executive summary is an excellent summary of the key points of the main report. The problems are clearly identified, the alternatives are developed and the recommendation clearly addresses the problems.
2. The main report is around 800 words. There are two parts to the main report:
a. Elsa wants to know how to increase revenues: which ice creams sell more and generate more profit. Your report should be in language that the marketing managers can understand. (400 words)
b. Anna wants to know if ice creams are increased by $1 each, demand will fall by 10%. Recommend if the selling price should be increased.
Attachment:- Assignment Files.rar