Prepare a forecast through week

Assignment Help Strategic Management

Reference no: EM13218988

A rental car manager estimates the number of full-size sedans rented per week 5 so that she can maintain adequate number of cars in the lot. Data for the past 10 weeks are shown here: SCLM 456

Week Rentals Week Rentals

1 23 6 28

2 24 7 32

332 8 35

4 269 26

5 311024

a) Prepare a forecast through week 11 by using a five -week moving average

b) Prepare a forecast through week 11 by using a 3-period weighted moving average, giving the weight of 0.5 to the most recent week, 0.3 to the second week and 0.2 to the third week.

c) Prepare a forecast using exponential smoothing method with α = 0.2. Forecast for week 1 was 22.

d) Prepare a forecast through week 11 by using a regression model Y= 26.33 + 0.3212X

d) Which method is preferred for this data if mean absolute deviation (MAD) is used?

e) Make a recommendation for number of full-size sedans for a week.

Reference no: EM13218988

Questions Cloud

Security efforts for any target environment : Why does the author stress that security efforts for any target environment are a never-ending process and that security objectives change over time?

What does the documentation mean : Using the Internet, a magazine, or a provided list of memory modules, determine the exact part numbers and quantities of memory modules that you would buy. List them with the location of where you obtained the information.

What happens t o the economic profits earned by widget corp : The widget Industry in Anytown is a monopoly, controlled by Widget Corp. Its demand curve for the local market is given by P = 800 - 20 W Where W represents the number of widgets sold per period. What happens t o the economic profits earned by Widg..

Use microsoft excel to compare costs : Use Microsoft Excel to compare costs from at least three different vendors and reasons to accept specific bids. (May use graphs in Excel to provide a better visual comparison)

Prepare a forecast through week : Prepare a forecast through week 11 by using a 3-period weighted moving average, giving the weight of 0.5 to the most recent week, 0.3 to the second week and 0.2 to the third week and Prepare a forecast through week 11 by using a regression model Y=..

What is the minimum number of bits required : What is the minimum number of bits required to represent each of the following decimal numbers: 10, 1000, 100,000, and 1,000,000?

Would the antitrust division likely challenge the merger : Assume an industry is composed of the following eight firms. Company Market Share Firm A 30 percent Firm B 25 percent Firm C 15 percent Firm D 10 percent Firm E 7 percent Firm F 6 percent Firm G 4 percent Firm H 3 percent a.

Conventional methods of prison rehabilitation-newer methods : What is a diffrence between conventional methods of prison rehabilitation and newer methods.

Explain number of units transferred out of the department : The master budget of Handy Company shows that the planned activity level for next year is expected to be 100,000 machine hours. At this level of activity, the following manufacturing overhead costs are expected: The actual quantity of materials use..

User Account

All Pages