The Excel worksheet form that appears below is to be used to recreate the Review Problem pertaining to Codington Corporation. The workbook, and instructions on how to complete the file, can be found in Connect.

You should proceed to the requirements below only after completing your worksheet.

Required:

1. Check your worksheet by changing the wait time in cell B4 to 5.8 hours and the queue time in cell B8 to 8.6 hours. The throughput time should now be 15.8 hours. The manufacturing cycle efficiency (MCE) should now be 0.14, and the delivery cycle time should now be 21.6 hours. If you do not get these answers, find the errors in your worksheet and correct them. Explain why the throughput time and delivery cycle time both decreased. Why did the manufacturing cycle efficiency (MCE) increase?

2. Revise the data in your worksheet as follows:

Data
Wait time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.0 hours
Process time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.2 hours
Inspection time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  0.2 hours
Move time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  0.8 hours
Queue time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 0.6 hours

a. What is the throughput time?

b. What is the manufacturing cycle efficiency (MCE)?

c. What is the delivery cycle time?

Transcribed Image Text:

A B C 1 Chapter 12: Applying Excel 2 3 Data 4 Wait time 5 Process time 6 Inspection time 7 Move time 20.8 hours 2.2 hours 0.2 hours 4.8 hours 8 Queue time 18.6 hours 9. 10 Enter a formula into each of the cells marked with a ? below 11 Review Problem: Operating Performance Measures 12 13 Compute the Following Operating Performance Measures: 14 Throughput time 15 Manufacturing cycle efficiency (MCE) 16 Delivery cycle time ? hours ? ? hours 17 18 Chapter 12 Form Filled in Chapter 12 Form Chapter 12 Form +) ...