Purchase Solution

Rental Car Analysis

Not what you're looking for?

Ask Custom Question

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 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 for week 11 by using a five -week moving average
b) Prepare a forecast for 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.

Purchase this Solution

Solution Summary

Solution depicts the steps to prepare a forecast by five-week moving average, 3-period weighted average and exponential smoothing methods.

Solution provided by:
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution


Free BrainMass Quizzes
Motivation

This tests some key elements of major motivation theories.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.