Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show work Each quarter, the General Manager and the Sales Manager develop the quarterly demand forecasts for each Product Family. They start with the

please show work image text in transcribed
image text in transcribed
Each quarter, the General Manager and the Sales Manager develop the quarterly demand forecasts for each Product Family. They start with the "Product Family Master" (Figure 1) which provides the actual unit sales history for each Product Family by quarter and year. They create a "Product Family Forecast" (Figure 2) for the expected demand by Product Family for the next quarter based on their knowledge of industry trends, competitive strategies, and sales history. Figure 1: Product Family Master (Product Family Actual Sales in Units) Figure 2: Product Family Forecast Master (Product Family Forecast Sales in Units) 4. Using the actual sales data provided in Figure 1, calculate your own forecast for each product family for 2020 Q1 using a 3-quarter simple moving average forecast model. SHOW YOUR WORK, ROUND ANSWERS TO NEAREST WHOLE NUMBER ( 6pts ) 5. Using the actual sales data provide in Figure 1, calculate your own forecast for each product family for 2020 Q1 using a 3-quarter weighted moving average forecast model where W1 is 50%, w2 is 30% and w3 is 20%. SHGW YOUR WORK, ROUND ANSWERS TO NEAREST WHOLE NUMBER ( 6pts )

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Project Management

Authors: James P. Lewis

3rd Edition

0814408796, 978-0814408797

More Books

Students also viewed these General Management questions