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 days PLUS the information
given in the two explanations about the simulation. Enter the point forecast
for a day, and the 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 Sigmasigma 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
