Market-based price (elasticity formula), uncertainties Hanson & Daughters produces a premium label apple juice to wholesalers at a current price of $7 per 5-litre container. Costs for a recent month, in which 100 000 5-litre containers were produced and sold are:

Please give the answer and detailed steps with Excel, I will give you points

Market-based price (elasticity formula), uncertainties Hanson & Daughters produces a premium label apple juice to wholesalers at a current price of $7 per 5-litre container. Costs for a recent month, in which 100 000 5-litre containers were produced and sold are: Materials Labour Factory overhead Selling and administration Total Variable Fixed $10 000 $ 0 20 000 40 000 10 000 80 000 10 000 100 000 $50 000 $220 000 Hanson & Daughters' customers are loyal. Recently, a 10% increase in wholesale price resulted in only a 10 per cent decrease in litres sold. Required (a) Calculate the price elasticity of demand. (b) Calculate the profit-maximising price. (c) Explain why the management of Hanson & Daughters cannot be certain that another 10 per cent price increase would cause only another 10 per cent decrease in litres sold. (d) Provide possible reasons why so many customers were willing to continue purchasing the apple juice when prices increased by 10 per cent. List as many reasons as you can. (e) Describe the assumptions underlying the profit-maximising price you calculated in part (b). How realistic are these assumptions for Hanson & Daughters? What might occur if these assumptions are not met for Hanson & Daughters? (f) What would you recommend to Hanson & Daughters concerning its price for apple juice? Explain your reasoning. Market-based price (elasticity formula), uncertainties Hanson & Daughters produces a premium label apple juice to wholesalers at a current price of $7 per 5-litre container. Costs for a recent month, in which 100 000 5-litre containers were produced and sold are: Materials Labour Factory overhead Selling and administration Total Variable Fixed $10 000 $ 0 20 000 40 000 10 000 80 000 10 000 100 000 $50 000 $220 000 Hanson & Daughters' customers are loyal. Recently, a 10% increase in wholesale price resulted in only a 10 per cent decrease in litres sold. Required (a) Calculate the price elasticity of demand. (b) Calculate the profit-maximising price. (c) Explain why the management of Hanson & Daughters cannot be certain that another 10 per cent price increase would cause only another 10 per cent decrease in litres sold. (d) Provide possible reasons why so many customers were willing to continue purchasing the apple juice when prices increased by 10 per cent. List as many reasons as you can. (e) Describe the assumptions underlying the profit-maximising price you calculated in part (b). How realistic are these assumptions for Hanson & Daughters? What might occur if these assumptions are not met for Hanson & Daughters? (f) What would you recommend to Hanson & Daughters concerning its price for apple juice? Explain your reasoning