Explore BrainMass
Share

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 9, 2019, 11:43 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