Explore BrainMass

# Development of a Forecasting Chart

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 1, 2020, 11:17 pm ad1c9bdddf
https://brainmass.com/statistics/multivariate-time-series-and-survival-analysis/forecasting-grad-level-question-265563

#### Solution Summary

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

\$2.19