Hi,
Please help!
The Boston Bar Chocolate Company's (BBCC) best-selling chocolate bar is The-Bar. BBCC is looking for a dashboard presentation of break-even options and analysis for a board meeting.The-Bar - Budget data for break-even visualization (20X8 forecast) Table 1: Variable costs per batch Cost Description Cost Cost Cost Per Number of units code behaviour classification in finished (V/F) (PR/PE)* product LIQ Chocolate liquor V $5.55 KG 140.00 BUT Cocoa butter V PR 56.10 KG 53.20 POW Cocoa powder V $1.18 KG 28.00 SUG Cane sugar V PR $0.70 KG 53.20 EMU Emulsifier V 50.80 KG 2.40 VAN Vanilla V PR $70.00 LITRE 3.20 WRA Wrapper V PR $0.08 EACH 4,000.00 DLA Direct labour V PR $33.10 DLH 21.16 PLU Plant utilities V PR $10.39 DLH 21.16 MTC Plant V PR $8.98 DLH 21.16 maintenance COM Commission V PE $0.05 EACH 4,000.00 DEL Delivery and V PE $180.00 EACH 1.00 shipping *PR = product , PE = period Table 2: Annual fixed costs FCost FDescription FCost FCost FCost code behaviour classification (V/F PR/PE) CTL Quality control F PR $15,430.00 COM Computer and supplies F PR $77,400.00 PEA Plant and equipment amortization F PR $61,740.00 RDE Research and development F PR $55,560.00 PSA Plant salary F PR $79,440.00 PLE Plant lease F PR $80,670.00 ASA Admin. salary F PE $85,000.00 INT Interest and bank charges F PE $4,200.00 PRO Professional fees F PE $8, 750.00 ADV Advertising and promotion F PE $22,560.00 ACM Admin. computer services F PE $45,000.00 BBCC produces The-Bar in batches of 4,000 units. All variables costs are based on this batch size. The-Bar sells for $1.50 per unit. Prepare a presentation and analysis of the relationship between selling price and break-even units for The-Bar based on information provided in Table 1 and Table 2. The purpose of the presentation is to assistthe management team with cost and selling price planning for 20X8. The presentation will consist of a Power Bl dashboard. The appendix at the end of this project provides instructions on how to find the data and create the dashboard using Power Bl. The analysis should address the following: a) Using the 20X8 budget data provided, create a Power Bl dashboard. Insert into your project a screenshot of the completed dashboard. Based on the dashboard created, prepare an analysis that addresses the following questions: i) What is the break-even in batches? ii) Compare this to actual 20X? sales of $1 ,164,000 of The-Bar that represents 776,000 units. BBCC would like a minimum margin of safety of 4%. Comment on the risk of loss. 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 breakeven sales and the risk of loss? Insert a screenshot of the revised dashboard and 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 of 4,000 units is 10% higher. Display and answer the above question. c) In reference to part a), assume that BBCC has decided to only use product costs for its breakeven analysis. Use the interactivity of the dashboard as explained in Task 4 in the Appendix to display only product costs. Insert a screenshot of the updated dashboard. What is the break-even in batches? What is the margin of safety? d) Identify any concerns or recommendations you have with the data being used in this analysis
