Question
ASSIGNMENT STEPS A manufacturing company produces 4 products (AAA, BBB, CCC, and DDD). The previous year's sales and product structure have been illustrated in the
ASSIGNMENT STEPS
A manufacturing company produces 4 products (AAA, BBB, CCC, and DDD). The previous year's sales and product structure have been illustrated in the Excel file.
- Please use Excel tools to plot-line chart for each product.
- Review the sales history of these four products and discuss demand behaviour. Can you see any trends? What about seasonality? Which product has only random sales fluctuations? For your answer, you need to show reason and justification.
- Determine demand forecast for January 2022 by using the Simple Average Method. Determine demand forecast for January 2022 by using the Moving Average Method (moving average of 6 periods).
- Determine demand forecast for January 2022 by using the Weighted Moving Average Method. Weights of last 6 months are 30%, 25%, 15%, 15%, 10%, 5% respectively.
- Determine demand forecast for January 2022 by using the Exponential Smoothing Method. Assume that the Smoothing Factor is 0.2 and you only have sales information for October, November, and December.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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
Accounting Principles Part 2
Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Kinnear, Joan E. Barlow
6th Canadian edition Volume 1
1118306791, 978-1118306796
