Using a five –week moving average

Assignment Help Business Management

Reference no: EM13823971

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

Week	Rental	Week	Rental
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: EM13823971

Questions Cloud

Correct to increase reserve credit assuming margin : Gregg just settled with Darigold at $130,000 cash plus $15,000 in credit. Is it correct to increase reserve $10K for the 70% cost of $15,000 credit assuming a 30% margin?

Effective salespeople are more than just order-takers : 1. Explain the meaning of the statement, "Effective salespeople are more than just order-takers." Your essay response must be a minimum of 200 words in length, not counting references listed at the end or repeating of the question. All sources used, ..

Differential analysis involving opportunity costs : Differential analysis involving opportunity costs On August 1, Matrix Stores Inc. is considering leasing a building and purchasing the necessary equipment to operate a retail store. Alternatively, the company could use the funds to invest in $150,000..

Why should we study travel and tourism from a marketing : Why should we study travel and tourism from a marketing approach? Explain why the marketing approach is the best or least important approach? Your response should be a minimum of 200 words in length. You are required to use at least your textbook as ..

Using a five –week moving average : 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 thir..

Describe a control procedure that would have pretended : Assume that Corey Jones, account payable clerk for Matthew Davidson Computers, stole $59,456 by paying fictitious invoices for goods that were never received. The clerk set up accounts in the manes of the fictitious companies and cashed the checks at..

Operating leverage analysis-determine how much profits : Using an operating leverage analysis, determine how much profits would increase for each company if each experienced a 10% increase in sales.

Tell us about the organization : Based on content requirements of your project 4, post a brief (4-5 slides) PowerPoint presentation describing your project 4. Tell us about the organization (maintaining confidentiality), the focal problem you are investigating, causes of the proble..

Percentage completion on profit-weighted average method : Understanding the impact of percentage completion on profit - weighted average method. Gary stevens and mary james are production managers in the consumer electronics division of GE company, which has dozens of plants throughout the world. What perce..

User Account

All Pages