Solution-Prepare a forecast using exponential smoothing

Prepare a forecast using exponential smoothing method

Assignment Help Strategic Management

Reference no: EM13222185

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
3	32	8	35
4	26	9	26
5	31	10	24

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.

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: EM13222185

Questions Cloud

What type of goods are pepsi and coke for mary : Show this utility maximiz- ing combination combination of Pepsi and Coke on the graph. how would her consumption and utility maximizing bundle of Coke and Pepsi change if the price of Coke decreases to 50 cents.

What was the level of government spending in second quarter : In the second quarter of 2006, household income was $13,134 billion, consumption was $9,162 billion, investment was $3,340 billion, and net exports were -$777 billion. What was the level of government spending in the second quarter of 2006

What is the amount of the three equal payments : A series of 10 annual payments of $7,500 is equivalent to three equal payments at the end of years 6, 10, and 15 at 15% interest compounded annually. What is the amount of these three equal payments

What is double counting in calculation gdp : Assume that we have a economy with no government and no capital investment that is closed to the outside world.draw a simple circular flow diagram with just firms:downstream firms that product final goods and services for consumption, and upstream..

Prepare a forecast using exponential smoothing method : Prepare a forecast through week 11 by using a five -week moving average and prepare a forecast using exponential smoothing method with α = 0.2. Forecast for week 1 was 22.

Explain what is the mol fraction of propane : below which there is too little fuel to support combustion. For propane, the LFL is 2.1 mol-%. What is the mol fraction of propane in the air at the stoichiometric concentration?

What aspects of p-o-l-c would be most likely to change : Nobel laureate economist Milton Friedman said that companies should focus on maximizing profits, not social responsibilities or purposes. Do you agree with this view? Why or why not?

State the relative charge of glutamate as a function of ph : Ionizable protons are in rapid equilibrium and so you can think of an amino acid having a relative charge between 0 and 1. Plot the relative charge of glutamate as a function of pH

What is being bought and sold in each direction : an economist might say that collage and universatys "produce" education, using facility members and students as inputs. According to this line of reasoning, education is then "consumed" by house holds. Construct a circular-flow diagram like the on..

User Account

All Pages

Prepare a forecast using exponential smoothing method

Reference no: EM13222185

Reference no: EM13222185

Questions Cloud

Reviews

Write a Review

Strategic Management Questions & Answers

Case study in strategic plan adelphi art centre

Pestle analysis of a new uk based business plan

Diversity reflection paper

Crafting a personal vision and mission statement

Business strategy and strategic human resource management

Steak sauce - lawry’s defense: case analysis

Write a report on best buy strategic audit

Cross-cultural management

Calculate the expected value of returns of stock

Influence the making of public policy

Strategic management principles

Resource base view theory versus positioning theory

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT