Purchase Solution

Development of a Forecasting Chart

Not what you're looking for?

Ask Custom Question

I have tried several times and missing a step somewhere in the process.

Rosa's Italian restaurant wants to develop forecasts of daily demand for the next week. The restaurant is closed on Mondays and experiences a seasonal pattern for the other six days of the week. Mario, the manager has collected information on the number of customers served each day for the past two weeks. If Mario expects total demand for the week to be around 350, what is the forecast for each day of next week?

Number of Customers

Day------Week 1-----Week 2
Tuesday-- 52---------48
Wednes--- 36---------32
Thursday- 35---------30
Friday--- 89---------97
Saturday- 98---------99
Sunday--- 65---------69

Forecasting. Develop a forecasting chart, using MS Excel. Include the steps used in your forecast.

Purchase this Solution
Solution Summary

The solution provides the development of a forecasting chart in Excel.

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting and Forecasting Errors in Business

    What is a control chart, and what is the benefit to using them for forecasting errors?

  • Email upgrade-Project management

    Sequence Evaluation criteria // Vendor evaluation for a project management plan consists of selection of an evaluation criterion and development of a weighting chart to rate each criterion.

  • Time Series & Forecasting

    Show a trendline [First enlarge the chart by dragging at the right bottom corner. Right click on the chart¿s forecast series your produced in (c) above. Select add trendline. The default is linear. Click ok.]

  • Regression Analysis

    Using the data in the Excel file Demographics, determine if a linear relationship exists between unemployment rates and cost of living indexes by constructing a scatter chart and adding a trendline. What is the regression model and R1? 3.

  • Role of City-Pair-Analysis Chart & Graph

    The solution discusses the role the city-pair-analysis chart and graph play in a travel history analysis. for forecasting future needs.

  • Compariosn of forecasting methods

    (see chart in attached file) a. Calculate the simple three-month moving average for periods 10-12. b. Calculate the weighted three-month average using weights of 0.50, 0.30, and 0.20 for periods 10-12. c.

  • Use exponential smoothing to make the prediction

    Use a smoothing constant of ? = 0.4. (b) Plot the data, fit a trend line, display equation and R2 on the chart and discuss the strength of prediction of the regression model.

  • Gantt Chart Team Formation Duration

    416018 Gantt Chart Team Formation Duration I need help building a Gantt Chart in Excel. I want to be able to change the tasks names if I wish. (This is a pretend project, so the duration of the days is sort of a guide, it can change...

  • Project plan forecast

    Please evaluate and see if a rapid application development (RAD) tool might be an option for a Simulation based Project, the forecasting should evaluate the RAD alternative for possible impact on Simulation based Project success.

View More Related Solutions