Question: Question 6. Look at the numbers in the table given below 1) Plot it on paper using appropriate scale 2) Calculate the seasonality index 3)

Question 6. Look at the numbers in the table given below 1) Plot it on paper using appropriate scale 2) Calculate the seasonality index 3) Suppose Trend line equation for the above plot is Y=A+bX, where A-450 and b-4.5, then make the forecast for the 20th week. (Show calculation) Weeks 1 2 3 4 5 6 7 12 9 10 11 Sales 461 450 463 458 476 492 482 511 491 488 506 8 522 Friday (Practice Midterm 2) Question 4. A gift shop in PG is open on weekends (Friday, Saturday, and Sunday). The Manager hopes to improve scheduling of part time employees by determining seasonal index for each of these days. Data on past activity of the store have been tabulated below: Day Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 1490 1540 1520 1500 1590 1630 Saturday 2500 2550 2600 2680 2730 2760 Sunday 1660 1620 1710 1730 1760 1830 1) Calculate seasonal index for the shop. 2) What should be the forecast for the Friday of Week 7? Use 3 days moving average to make a forecast for Friday 3) If the forecast of demand for the Friday of week 6 was 1650 instead of 1630, then what should be the forecast for Friday of week 7

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!

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

413-432_CH18_Nachmias.qxd 1/17/07 3:47 PM Page 413 Chapter Index Construction and Scaling Methods INDEX CONSTRUCTION The Purpose of the Index The Sources of the Data The Base of Comparison Methods of...

Hi again, I was hoping you can help with this investment management assignment. I am attaching the word document. It is 4 problems about asset management. Thank you for your help! Fin 6310 1. Assume...

Math\t107-6381\t-\tQuiz\t#4\t-\tSchultz\t-\tDue\tFebruary\t21,\t2016\t-\tpage\t1\tof 3 Follow\tthese\tdirections\tcarefully. This\tquiz\tis\tdue\tby\t11:59\tEastern\ttime\ton\tFebruary\t21,\t2016. o...

PART A: The following table gives restaurant sales data for the Timber Ridge ski lodge over a three year period. For the first part of this exercise, assume that the revenues are randomly...

Please don't give me wrong data for answers already on Chegg. Column D3 is 123559 not 1235559. Figure 1. below displays the quarterly number of U.S. passengers (in thousands) using light rail as a...

Figure 1. below displays the quarterly number of U.S. passengers (in thousands) using light rail as a mode of transportation. The series begins with the first quarter of 2009 and ends with the first...

Harvard University FIN 900 Assignment #4 Case Study: Time Series Forecasting and Centered Moving Averages (LETS GOOO CHEGG LETS GO) Please show correct excel ouput for a thumbs up! Figure 1. below...

Calculate the specific heat of a metal from the following data. A container made of the metal has a mass of 3.6 kg and contains 14 kg of water. A 1.8 kg piece of the metal initially at a temperature...

In June, Keith loses his job, and he doesn't pay his rent. In July, the landlord starts an unlawful detainer (eviction) action. If Keith files for [Choose ] [Choose] personal bankruptcy, the lawsuit...

Suppose that long term risk is oercied to decrease. What would be the preducted effect in the yield curve

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....