Network Diagram Model Evaluation
Based on the information in the case, use the "Operations Analytics Case Study Data" file, the "Operations Analytics Case Study Template," and the Excel drawing tools to create a task network diagram based on the "Production Steps" information in the case. To clarify this information, assume the following:
- The "Cover marketing created" task is a successor to the "First edit" task.
- The "Printer selection" task is a successor to the "Interior Layout (Pagination)" task.
- The "Project sent to printer" task is a successor to the "Printer selection" task.
Place your task network diagram in the "NetworkDiagram" sheet of the "Operations Analytics Case Study Template."
Using the "Operations Analytics Case Study Template" file as a starting point, 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 backup 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.
This is a Business Analytics question
Exhibit 8.2: Availability of Personnel for Different Processing Steps for the Sports Book Project Task Team Member Availability (Days) First Edit ME 4 Second Edit ME 5 Interior Design and Art AD 7 Cover Art AD 7 Interior Layout (Pagination) AAD 3 Final Proofreading AE 5 Cover Marketing Marketing 9 Dust Jacket Design AD 2 Printer Selection PM 2 Project Sent to Printer Printer 2 Galley Proof Creation Printer 8 (Estimated) Galley Proof/Edit 5 Printing and Shipping to Warehouse Printer 15 (Estimated) Shipping to Stores WM 10 AE Exhibit 8.1: General Processing Times for Various Book Projects Processing Time, Regular Task Book (Days) Standard Mean Deviation Processing Time, Small Book (Days) Processing Time with Interior Artwork (Days) Standard Mean Deviation 6.8 1.4 Standard Deviation Mean First Edit 5.1 0.8 4.4 1.1 4.9 0.8 4.5 1.1 6.3 1.5 6.6 1.1 1.1 5.6 1.4 3.6 3.7 6.5 1.1 1.1 3.4 1.1 2.8 0.9 2 0.9 14.9 1.4 5.1 0.8 4.4 1.1 7.4 1.6 9.1 0.8 9 0.9 8.9 0.9 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 1.5 0.5 1.5 0.5 1.5 0.5 1.5 0.5 1.5 1.5 1.5 0.5 0.5 1.5 0.5 0.5 0.5 1.7 0.8 7.7 1.7 7.5 6.5 1.7 1.9 1.5 10.3 6.6 17.6 10.5 1.1 3.1 4.9 11.5 10.5 15.1 10.7 2.3 2.2 2.3 2.3 2.3 Task Resource Predecessor Processing time Regular Book (days) Activity Time Finish Standard Deviation Start (days) Resource availability Expected to Cost of back Actual (days) be behind? up contractor Backup cost Mean (days) (days) Task Resource Predecessor Processing time Regular Book (days) Activity Time (days) Start (days) Finish (days) Resource availability Expected to Cost of back Actual Backup (days be behind?| up contractor cost $1,000 Mean Standard Deviation $500 $1,000 $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 ME ME AD AD AAD AE Marketing AD PM Printer Printer AE Printer WM 5.10 4.90 6.60 6.50 2.80 5.10 9.101 1.501 1.50 1.50 7.50 6.50 0.80 0.80 1.101 1.10 0.90 0.80 0.80 0.50 0.50 0.50 1.70 1.90 3.10 2.30 15.10 10.70 Exhibit 8.2: Availability of Personnel for Different Processing Steps for the Sports Book Project Task Team Member Availability (Days) First Edit ME 4 Second Edit ME 5 Interior Design and Art AD 7 Cover Art AD 7 Interior Layout (Pagination) AAD 3 Final Proofreading AE 5 Cover Marketing Marketing 9 Dust Jacket Design AD 2 Printer Selection PM 2 Project Sent to Printer Printer 2 Galley Proof Creation Printer 8 (Estimated) Galley Proof/Edit 5 Printing and Shipping to Warehouse Printer 15 (Estimated) Shipping to Stores WM 10 AE Exhibit 8.1: General Processing Times for Various Book Projects Processing Time, Regular Task Book (Days) Standard Mean Deviation Processing Time, Small Book (Days) Processing Time with Interior Artwork (Days) Standard Mean Deviation 6.8 1.4 Standard Deviation Mean First Edit 5.1 0.8 4.4 1.1 4.9 0.8 4.5 1.1 6.3 1.5 6.6 1.1 1.1 5.6 1.4 3.6 3.7 6.5 1.1 1.1 3.4 1.1 2.8 0.9 2 0.9 14.9 1.4 5.1 0.8 4.4 1.1 7.4 1.6 9.1 0.8 9 0.9 8.9 0.9 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 1.5 0.5 1.5 0.5 1.5 0.5 1.5 0.5 1.5 1.5 1.5 0.5 0.5 1.5 0.5 0.5 0.5 1.7 0.8 7.7 1.7 7.5 6.5 1.7 1.9 1.5 10.3 6.6 17.6 10.5 1.1 3.1 4.9 11.5 10.5 15.1 10.7 2.3 2.2 2.3 2.3 2.3 Task Resource Predecessor Processing time Regular Book (days) Activity Time Finish Standard Deviation Start (days) Resource availability Expected to Cost of back Actual (days) be behind? up contractor Backup cost Mean (days) (days) Task Resource Predecessor Processing time Regular Book (days) Activity Time (days) Start (days) Finish (days) Resource availability Expected to Cost of back Actual Backup (days be behind?| up contractor cost $1,000 Mean Standard Deviation $500 $1,000 $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 ME ME AD AD AAD AE Marketing AD PM Printer Printer AE Printer WM 5.10 4.90 6.60 6.50 2.80 5.10 9.101 1.501 1.50 1.50 7.50 6.50 0.80 0.80 1.101 1.10 0.90 0.80 0.80 0.50 0.50 0.50 1.70 1.90 3.10 2.30 15.10 10.70