GENERAL INSTRUCTIONS TO CANDIDATES:

This assignment comprises 100 marks and weighs 40% in the final score of this module.

1.   The assignment should be accomplished in English.

2.   All the contents and results are required to be summarized in a report (in the format of a doc or docx file), which is supposed to be uploaded to LMO before 20:00, 31st December, 2025.

3.   The name of the report should include the module number, the student ID, followed by    the    term    “Individual    assignment”    (e.g.    IOM121-xxxxxxx-Individual assignment).

4.   Standard  XJTLU penalties  apply  for  lateness  and plagiarism.  Please note that weekends are treated as normal working days and count towards the lateness.

HAND-IN REQUIREMENTS:

Given below is a business case of Brew Haven Café. All data in the case are summarized in a separate csv file. Following the case, there are 11 questions, in each of which you are supposed to calculate some critical quantities based on the case and the data set. Please check carefully the following requirements for the assignment:

1.    The standard coversheet provided by our school should be used. The cover sheet will be uploaded on LMO.

2.    Please  write  down  in  the assignment all detailed calculation processes.  Only giving the final answer will not achieve full marks.

3.    Please support all your conclusions by solid evidence, both from your numerical results and reasonable business analysis.

The report is supposed to be uploaded on LMO by 20:00, 31st December, 2025.

Brew Haven CaféCase Study

Brew Haven Café is a neighborhood café located in Shanghai’s downtown financial district. Opened in 2021, it has grown into a local favorite for both office workers and weekend families. The caféoperates 7 days a week with 5 full-time staff (2 baristas, 1 chef, 1 cashier, 1 manager) and several part-time student employees who cover peak hours.

The  café offers  specialty  coffee,  loose-leaf teas,  artisan  pastries,  healthy  bowls,  and sandwiches. It has seating for 45 people inside and 10 outdoor tables (in warmer months). Opening hours are 7:30 AM – 7:00 PM on weekdays and 8:30 AM – 6:00 PM on weekends. Surrounded by chain coffee shops, it differentiates itself through atmosphere, food quality, and personalized service. Promotions are occasional: 10% discounts or loyalty stamp cards. Its social media presence is modest but growing.

The  owner,  Angela  Chen,  is  considering  whether  to  hire  more  staff,  expand  loyalty promotions, and apply for a small business loan to renovate. She believes the caféhas potential to grow but wants to back decisions with data

Over  3  months  (Jan–Mar  2025),  the  café recorded  daily  data:  Date,  Day  of Week, Promotion  type  (None,  Discount,  Loyalty),  Customers  per  day,  Average  spend  per customer (AvgSpend), Total daily sales ($), and Average satisfaction score (survey, 1–10). Angela asks you (student consultants) to analyze this dataset and provide insights for her strategic decisions.

Part A: Describing & Probability Tools

Q1. Summarize Customers, AvgSpend, and Satisfaction by Day of Week using tables and charts. Compare weekdays vs weekends, in terms of customer counts and satisfaction. Please interpret the reasons for the difference. (10 points)

Q2. Compare daily averages of Customers, AvgSpend, and Satisfaction by Promotion type using tables and charts. Which promotion drives more customers visiting? Which risks lowering per-customer revenue? Are customers happier during promotions? If Angela could run only  one type of promotion next  quarter, under what  situation would you recommend discount or loyalty, and why? (10 points)

Q3. Angela says, 'We usually make about $2400 a day'. Plot distribution of daily Sales. Calculate P(Sales < $2000) and P(Sales > $3000) using the empirical data. Does the average reflect reality? How might misinterpreting 'average' sales affect planning (e.g., staffing, inventory)? (10 points)