Hi, Can you please help with question 5. I'm very stuck

Exhibit 7 Cocoa bean processing division options The cocoa bean processing division receives unprocessed beans and processes them. A portion of the output comes to the chocolate bar division at the cocoa bean process division's cost plus a small profit. The cocoa bean processing division is able to satisfy both the external and internal demand for its products. The manager of the bean processing division has asked that an analysis be done on the best way to process and package products given the following information. Additional information on cocoa bean processing The job in the cocoa bean processing division is to process raw cocoa beans through fermentation and roasting, and processing the chocolate nibs into chocolate liquor, cocoa butter, and cocoa cakes. The cocoa cakes are what is left of the chocolate liquor after the cocoa butter is removed. The original purpose was to process the beans for the chocolate bar division; however, there is enough capacity to process more beans and sell the intermediate products to outside customers. The questions are the profitability of the products currently being sold to outside customers and the opportunities for a new product. Currently, the chocolate liquor, which is the first saleable product in the bean processing division, is processed further into cocoa butter and cocoa cakes. The cocoa butter is sold to a plant that processes it for skin cream and the cocoa cakes are packaged in bulk and sold to other manufacturers to include in baking products. One option to consider is to grind the cocoa cakes into powder and package the final product into cans to be sold to retail grocery stores as baking chocolate. However, there is also a market for chocolate liquor. An illustration including the proposed process follows. The company needs advice on the following: 1. Is it profitable to process cocoa cakes further into a powder, package it in cans, and sell it as baking cocoa? 2. Is it still profitable to process chocolate liquor into cocoa cakes and cocoa butter? 3. Using the most profitable method of processing cocoa beans, how should the joint cost be allocated?Illustration of cocoa bean processing and opportunities Procedure cocoa bean processing division Gooon cultas Canned baking Bales value: Grinding And packaging $17.880 Balas value: Fallning Chocolate liquor - Funding and procuss on value: $84,050 drying Cost: $5,5001 Cost $3,800 Processing and sales Sales Sides vilun: opportunity opportunity The illustration is based on the following data: Unprocessed cocoa beans - price per 5,000 kg $10,000 Roasting and refining costs - resulting in chocolate liquor $6,500 Yield of chocolate liquor 80% Selling price of chocolate liquor per kilogram $13.50 Cost of processing liquor into cocoa butter and cakes $3,800 Yield of cocoa butter 55% Yield of cocoa cakes 45% Sales value of cocoa butter per kilogram $14.50 Sales value of cocoa cakes per kilogram $9.75 Cost of grinding cocoa cakes into powder and packaging $6,500 Yield of cans of powdered baking cocoa 6,800 Selling price per can of powdered baking cocoa $4.25 The final issue is the increasing cost of cocoa for production. Because of rising temperatures in cocoa-producing countries, it is predicted that many of Africa's cocoa- production areas will be too hot to grow cocoa crops in the near future. Some farmers are already replacing their cocoa crops with palm oil or rubber. This will put upwards pressure on the price of cocoa if there are fewer suppliers.ii) Compare this to actual 20X7 sales of The-Bar. Your answer should include a brief discussion on the risk of loss including addressing the margin of safety. b) Consider that the current selling price of The-Bar ($1.50 per bar) can increase by 10% before sales will begin to drop off. What effect will this increase in price have on break-even sales? Discuss any significant differences. NOTE: The dashboard is interactive. Step 7 in the Appendix creates a slider that will allow you to change the total sales dollars per case. Move the slider to a point where the total selling price of a case at $1.65 (or $1.50 plus 10%) displays and answer the above question. c) In reference to part a), assume BBCC has decided to only use product costs for their breakeven analysis. Use the interactivity of the dashboard as explained in Task 4 in the Appendix to display only product costs. NOTE: Clicking on the Product Costs section of either of the pie charts will make the following changes: All period costs on the bar chart become shaded. The break-even point in units will be recalculated without the period costs. This interactivity will help you answer this question. d) Identify any concerns you have with the quality of the data being used in this analysis. NOTE: Insert into your project a screenshot of the completed dashboard, illustrating the break-even point in units at a selling price of $6,000 ($1.50 per bar). Additionally, use screenshots of the dashboard to reinforce your discussion. While the dashboard must consist of all elements displayed, your placement of the visualizations can be arranged differently. 5. Cocoa bean processing division options (8 marks) a) (4 marks) Based on the information provided by the cocoa bean processing division manager from Exhibit 7, assess the total gross profits and total gross margin percentage of each of the following options (include total joint costs in your calculation, but do not allocate the joint costs to individual products): i) Current sales of cocoa butter and cocoa cakes ii) Proposed sales of cocoa butter and canned, powdered baking cocoa iii) Proposed sales of chocolate liquor Comment on which of the three options is most desirable for the company to pursue and why (consider other non-financial concerns that should also be taken into consideration).b) (4 marks) Allocate joint costs using the following options and methods: i) Based on the current sales of cocoa butter and cocoa cakes, use the sales value at split-off method. ii) Based on the proposed sales of cocoa butter and canned, powdered baking cocoa, use the net realizable method. Note on rounding: Use unrounded numbers for all calculations and round the final answer to the nearest dollar