Use the data provided to answer the following questions: 1. The company is concerned that the sales
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 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
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill