Question: For this question, please refer to the Chocolate dataset, which can be found in the Q7 - Q9 worksheet within the file: CMS Final Exam

For this question, please refer to the Chocolate dataset, which can be found in the "Q7 - Q9" worksheet within the file: CMS Final Exam Data (S1-2023.xlsx v The Chocolate Dataset shows budgeted monthly sales (January December 2024) of products, grouped by product category, across four states in Australia; New South Wales (NSW), Queensland (QLD), South Australia (SA) and Victoria (Vic). The New South Wales (NSW) regional sales manager is concerned about the hot weather forecast over summer, so would like to order enough products to last the 3 months between January and March 2024 inclusive. Analyse the dataset to calculate the total number of units sold within New South Wales for January - March inclusive. For this question, please refer to the Chocolate dataset, which can be found in the "Q7 - Q9" worksheet within the file: CMS Final Exam Data (S1-2023.xlsx v The Chocolate Dataset shows budgeted monthly sales (January December 2024) of products, grouped by product category, across four states in Australia; New South Wales (NSW), Queensland (QLD), South Australia (SA) and Victoria (Vic). The New South Wales (NSW) regional sales manager is concerned about the hot weather forecast over summer, so would like to order enough products to last the 3 months between January and March 2024 inclusive. Analyse the dataset to calculate the total number of units sold within New South Wales for January - March inclusive
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
