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) 6. Using the actual sales data provided in Figure 1 and the forecast data provided in Figure 2, calculate the forecast for each product family for 2020 Q1 using the Exponential Smoothing forecast model where =0.2 (or 20% ). SHOW YOUR WORK, ROUND ANSWERS TO NEAREST WHOLE NUMBER ( 6 Rts) HINT: Use 2019 Q4 forecast from Figure 2 for F11 7. Using the actual sales data provided in Figure 1 and the forecast data provided Figure 2, calculate the forecast for each product family for 2020 Q1 using the Exponential Smoothing with Trend forecast model where =0.1 and =0.3. SHOW YOUR WORK, ROUND ANSWERS TO NEAREST WHOLE NUMBER ( 12pts ) HINT: Use 2019 Q4 forecast from Figure 2 for FIT 1.1 . PVB T11=17,232 Fire Valve T:1=16

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