Advanced Business Statistic: PERT Method A typical business request is to submit a budget—this can include budgets for funding a project, a planned busines

Advanced Business Statistic: PERT Method A typical business request is to submit a budget—this can include budgets for funding a project, a planned business trip, and even operating costs for an office location. In the file “Budget.xlsx” a typical line item budget estimate is provided for a radiology department at a small hospital. Develop a forecasted budget using the PERT methodology (explained below) and compute the expense point where you are at least 95% sure that your expenses will not exceed this amount.Use the file: “Budget.xlsx” to get you started and the information below to help guide you through the PERT methods.Write a one-page paper summary of your findings and submit both the excel file and your document to Canvas. Your summary should include a written explanation of your “most likely” estimates, the type of value for each of the categories (deterministic vs probabilistic and why), and a written explanation of what the expense point means. Expense
Scans
Salaries
Medications
Film
Mammography
Specialists
Supplies
Travel
Equipment Lease
Dec-18
14551,85
13525,48
1843,23
4850,62
2586,35
582,07
4365,56
194,02
3216,93

Purchase answer to see full
attachment