Question: Use the following problem statement to answer questlons 1 - 6 . A manager wanes to make annuat purchacing plane for gardenling items. One of

Use the following problem statement to answer questlons 1-6.
A manager wanes to make annuat purchacing plane for gardenling items. One of the items the company stocko is Fast-Grow, a llquid fertilien The salos of the item are seatonal, Quarterly demand (in cases) fo the past fwo years is shown in the table. The manager knows that the expected sales for Fast-Grow are 080 cases for year 3. The actual demands from Quarter 1 of year 1 to Quarter 4 of year 2 are shown in the table below, Use the multiplicative seasonal reethod to prepare a forecast for cach guartec of the vear Round to four decimal places whon You calculate all centered averages and seavonal indexes INote- Seasonal Index =(sales)7centered average) Four period centered average Dt+Dt+1+Dt+2+Dt+34 Adjusted seasoral index -(each avg. Indexy 4)(sum of ave. indexes)
\table[[Year,Quarter,Demand,\table[[4 period centered],[AVR.]],\table[[2 period Centered],[Ave.]],\table[[Scasonal],[Index]]],[1,01,55,,,],[1,Q2,220,,,],[1,Q3,150,154.2500,,],[1,Q4,192,157.2500,,],[,,,1497500,,],[2,Q1,67,147.2500,,],[2,02,190,,,],[2,03,140,156.7500,,],[2,04,230,,,]]
What is the two period centered average for 93 of year i?
1557500
811318721
Question 2
7 pts
What to the adfusted seasonal index for Q1 of yes? 3?
0.6610
Q.810
Question 3
7 pts
Whatrs Whe woperlod centered average for Q4 of vear 1?
15.55000
(c)131672
Question 4
7 pts
What is the wo perlod centered average for g2 of year 2?
Is oogop
1496721
Question 5
7 pts
What st the forecost tor Qa of vear a?
147200
(5)171147?
1597301
Question 6
7 pts
What is the two perlod centered average for 92 of year 2?
14 E900
125700
 Use the following problem statement to answer questlons 1-6. A manager

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!