Use EXCEL to answer the question. See the excel file and solve the Q4 sheet.

Q4. OLD CITY PHOTOGRAPHICS (30 points, 10 for each part) Hint: It might be helpful to review section 3.6 of Chapter 3 of CT before attempting this question. Old City Photographics. (OCP) specializes in the processing of the traditional 35mm negative film, a once dominant photographic medium now in decline due to the popularity of digital photography. OCP offers three packages to their customers. With the standard package, the customer gets a set of 6 " x4 prints for $19.99. The deluxe package adds to the standard package a CD-ROM of highresolution scans of the pictures for $29.99. Finally, the $39.99 pro package is similar to the deluxe package in that it comes with a CD-ROM, although the customer gets a contact print rather than a set of prints. (A contact print is an 810 sheet of photographic paper that has all pictures on the roll of film printed next to each other at reduced dimensions and is used as an index.) The workflow for OCP is shown below ( s=standard,d=deluxe,p=pro ): OCP is operated by one person at every station. On average, OCP receive 13 jobs per hour consisted of 30% standard, 51% deluxe and 19% pro. (a). Which of the following statements best describes OCP's process? Justify your answer by showing all calculations. i. The process is demand-constrained. ii. The process is capacity-constrained and "process film" is the bottleneck. iii. The process is capacity-constrained and "scan film" is the bottleneck. iv. The process is capacity-constrained and "make 6" 4 " prints" is the bottleneck. v. The process is capacity-constrained and "make contact print" is the bottleneck. (b). What is the utilization at each step? (c). If the relative proportions of standard, deluxe, and pro jobs remain unchanged, what is the largest number of jobs per hour that OCP can handle? \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline 1 & Step & Processing Time & Hourly Capacity & Flow Rate at Step & Utilization & \\ \hline 2 & Process Film & 2 & & & & \\ \hline 3 & Scan Film & 5 & & & & \\ \hline 4 & Make 64 Prints & 4 & & & & \\ \hline 5 & Make Contact Print & 10 & & & & \\ \hline 6 & & & & & & \\ \hline 7 & a. Indicate your choice here & & & & & \\ \hline & b. Use Column E to calculate & dtilization at each st & & & & \\ \hline 9 & c. Largest number of jobs per & hour that OCP can h & handle & & & \\ \hline 10 & & & & & & \\ \hline \end{tabular}