The Task As you have already seen from the LBP data sheet within the Excel Project, Le Petit Bakery
The Task As you have already seen from the LBP data sheet within the Excel Project, Le Petit Bakery (LBP) have collected data starting from January 2020 all the way to the end of 2022 on the sales of cakes, pies, cookies, smoothies and coffee, and they have also registered whenever they have offered their customers a promotion to increase sales. The company believes there are multiple differentinsights they can derive from the data they have collected using a right set of analyses to reinforce their future decision making. In particular, they have asked you to have a go with the data, apply a set of appropriate analysis and provide a comprehensive report with actionable recommendations concerning the following main themes:
1. They need you to analyse the data and report back whether you find out that their promotions have worked well or not. They would also like to know whether your analysis can provide any insight regarding the day(s) on which having a promotion would be the best (hint: focus on the total sale of all items). In your report, dedicate a section to this, explain exactly how you’ve gone about this, and using appropriate charts, tables, figures, etc. support your findings and clearly state your relevant results and recommendations.
2. They believe when they offer a promotion, customers who buy cakes, pies, or cookies, tend to also buy coffee. In other words, they think the sale of coffee depends on the sales of cakes, pies, or cookies (at the times of promotion). They want you to carry out an appropriate regression analysis to confirm this and to report back a regression model which clearly shows this relationship. If your analysis finds that coffee sales are not essentially dependent on all these items, but two or only one of them clearly state your reasoning backed with your analysis. Explain clearly all the steps you take to come up with your final regression model, and support your findings and recommendations with appropriate charts, tables, figures, etc.
3. The company would like to see if the overall trend of their total sales over the past three years has been upward or not and if there is any quarterly seasonality in the data that they are unaware of Support your findings and recommendations with appropriate charts, tables, figures, etc.
4. They would be very happy if there are other insights you have derived from the data set as a side analysis you have carried out and that would be a bonus for you.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
