Question
Use the data provided to answer the following questions: 1. The company is concerned that the sales department may try to increase the sales revenue
Use the data provided to answer the following questions: 1. The company is concerned that the sales department may try to increase the sales revenue in December to receive more bonuses. Based on the average quantity sold each month in 2021 and 2022, is this a valid concern? Provide a supported response, using appropriate graphs/charts.
2. Starting from 2023, the company decides to use the change in average quantity sold between December 2021 and December 2022 to predict the inventory level needed for each product in 2023. Which products will require a higher inventory level, and which products can maintain a similar inventory level? Provide a supported response, using appropriate graphs/charts.
3. Provide any other insights or observations that you can derive from the data. Support your response using appropriate graphs/charts, etc.
https://docs.google.com/spreadsheets/d/1mYx_hkZai7Y9FLZffZ3uvgbdeeQXeEJ-MqLT_wOxVEM/edit?usp=sharing
Step by Step Solution
3.47 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
1 Concern about the sales department trying to increase sales revenue in December To address this concern we need to analyze the average quantity sold for each product in December 2021 and December 20...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started