Question: Format Requirements Complete information requested by inserting rows if necessary below the section instructions. Do not put information or tables or charts beyond column M

Format Requirements
Complete information requested by inserting rows if necessary below the section instructions.
Do not put information or tables or charts beyond column M
Demand Forecast
Use excel formulas and cell references to calculate all information.
The forecast for the following days is based on the trend line from the first 50 days PLUS the information
given in the two (2) explanations about the simulation. Enter the point forecast
for a day, and the 3 standard deviation upper and lower bound limits.
To do this you have to estimate the standard deviation and determine how many you will use.
Confidence Limits
DAY Point Forecast Sigma(\sigma ) Lower Bound Upper Bound actual value used to calculate capacity requirements; this will be a number between the lower and upper bound

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!