create Excel formulas for the following cells for each task: Activity time (days) Start (days) Finish (days) Resource availability (days) Expected to be behind? Cost of back up contractor Actual backup cost

For Tasks 3, 4, 6, and 8-10 in the spreadsheet, assume that the "Activity Times (Days)" will be the stated Mean times.

For Tasks 1, 2, 5, 7, and 11-14 in the spreadsheet, assume that each of these "Activity Times" can vary by 50% of their mean values and that they each follow a Uniform Distribution (i.e., each value has an equal chance of occurring). Using Microsoft Excel's "Spin Button" in the "Developer" tab, create spin buttons to vary the Activity Times accordingly for each of these tasks. Ensure that your model includes calculations for "Process Completion Time" and "Total Actual Backup Cost." Your model should approximate what factors could cause the "Total Actual Backup Cost" to exceed $3,000.00.

Task Resource Predecessor Processing time Regular Book (days) Activity Time (days) Start (days) Finish (days) Resource availability (days) Expected to Cost of back Actual Backup be behind? up contractor cost $1,000 ME ME AD S500 $1,000 AD $700 First Edit Second Edit Interior Design and Art Cover Art Interior Layout (Pagination) Final Proofreading Cover Marketing Dust Jacket Design Printer Selection Project Sent to Printer Galley Proof Creation Galley Proof/Edit Printing and Shipping to Warehouse Shipping to Stores AAD AE Marketing AD PM Printer Printer AE Printer WM Mean Standard Deviation 5.10 0.80 4.90 0.80 6.60 1.10 6.50 1.10 2.80 0.90 5.10 0.80 9.10 0.80 1.50 0.50 1.50 0.50 1.50 0.50 7.50 1.70 6.50 1.90 15.10 3.10 10.70 2.30 Task Resource Predecessor Processing time Regular Book (days) Activity Time (days) Start (days) Finish (days) Resource availability (days) Expected to Cost of back Actual Backup be behind? up contractor cost $1,000 ME ME AD S500 $1,000 AD $700 First Edit Second Edit Interior Design and Art Cover Art Interior Layout (Pagination) Final Proofreading Cover Marketing Dust Jacket Design Printer Selection Project Sent to Printer Galley Proof Creation Galley Proof/Edit Printing and Shipping to Warehouse Shipping to Stores AAD AE Marketing AD PM Printer Printer AE Printer WM Mean Standard Deviation 5.10 0.80 4.90 0.80 6.60 1.10 6.50 1.10 2.80 0.90 5.10 0.80 9.10 0.80 1.50 0.50 1.50 0.50 1.50 0.50 7.50 1.70 6.50 1.90 15.10 3.10 10.70 2.30