【正文】
= $ * Max(Q–d, 0)Profit = Revenue – Cost + RefundStep 1 (Setup Spreadsheet)Walton Bookstore Simulation with Crystal Ball174。Step 3 (Define Forecast—., output)Select the cell that contains the output variable to forecast (F17):click on the “Define Forecast” button in toolbar (or in the Cell menu),and fill in the Define Forecast dialogue box.Step 4 (Choose Number of Trials)Click on the “Run Preferences” button in toolbar (or in the Run menu):and select the number of trials to run.Walton Bookstore Simulation with Crystal Ball174。 Fin. Plan—202530CDetermine Personnel Req.B152030DDesign FacilityA, C202842EConstruct FacilityD404866FSelect Personnel to MoveC121212GHire New EmployeesF202532HMove Key EmployeesF282828ITrain New PersonnelE, G, H101524Global Oil Simulation with Crystal Ball174。Step 3 (Define Forecast—., output)Cell J15 is the forecast cell: Step 4 (Choose Number of Trials)500 trials were run. In addition, Sensitivity Analysis was enabled in the Options of the Run Preferences dialogue box. This allows for the generation of sensitivity analysis results later.Step 5 (Run Simulation)Step 6 (View Results) Additional Results Available with Crystal Ball174。 to fit data to a distribution1. Select a spreadsheet cell.2. Choose Define Assumption.3. Click the Fit button, then select the source of the fitted data.4. Click the Next button, then select the distributions to try to fit.5. Click OK.Interarrival TimeService Time13 / 13