Which combination (with two housing types removed) has the highest utilization?

When preparing for your response to the activity, it is recommended that you read it several times.
Read it the first time to familiarize yourself with the scenario.
On the second reading, consider your assigned role in the situation, and let that guide your perspective. Look deeper at the details: facts, problems, organizational goals, objectives, policies, strategies.
Next, consider the concepts, theories, tools, and research you need to use to address the issues presented.
Then, complete any research, analysis, calculations, or graphing to support your decisions and make recommendations.
This assignment focuses on the setup time portion of a process. While not all processes have setup times, those that do require careful analysis. Setup time takes away from an organization’s production rate (or throughput). The goal of this activity is to allow you to select and justify your selection of a setup time process strategy.
This activity addresses the following Module Outcome:
Assess multi step processes utilizing a variety of parameters such as bottleneck, capacity, utilization, flow rate, rework, and cycle time. (CO#1, CO#4)
Aquatica makes underwater camera housings for divers. The process begins with a solid rectangular block of aluminum, which is used to make a single housing. A Computer Numerically Controlled (CNC) machine drills into the block to make the metal “frame” of the housing. Each block requires 15 minutes of drilling. The frame is then chemically treated in a series of baths. There is ample capacity in the treating stage. Finally, a worker must manually attach the various buttons and components to the metal housing. This assembly takes 120 minutes per housing per worker and Aquatica has 6 workers trained to do this task. The CNC machine requires a 30-minute setup time before the production of a batch can begin.
Aquatica actually makes 5 different housings. As already mentioned, the CNC machine must be setup whenever production switches from one housing to the other. In each case the setup time is 30 minutes and it takes 15 minutes to drill the block for each type of housing. Demands for the housings are given in the table below.

Housing type Demand rate (housings per hour)
D7000 0.4
5DS Mark III 0.5
AN5n 0.6
D300 0.7
T2i 0.8
Demands for Housing
In a memo to the Process Improvement Officer, complete the following:
Aquatica’s Process Improvement Officer has recommended reducing the variety of housing types.
If you remove two varieties, what is the revised utilization (as a percentage)?
Select four (4) different combinations of varieties to analyze (so for each combination you will remove two (2) housing types and recalculate the utilization (as a percentage)). Report results in a table format.
Create a graph of Variety versus Utilization for the four combinations you have selected.
Which combination (with two housing types removed) has the highest utilization?
Could you have determined this (which combination would have the highest utilization) without doing calculations? If so, how?
What additional supply chain strategies could you utilize to improve Aquatica’s ability to serve its customers? And why?
Cachon and Terwiesch (2017) stated, “The advantage of a fast processing time can outweigh the disadvantage of the setup” (p. 194). Explain this concept utilizing Aquatica’s process as an example.
Compose your work using a word processor (or other software as appropriate) and save it frequently to your computer. Be sure to check your work and correct any spelling or grammatical errors before you upload it. When you are ready to submit your work, click “Browse My Computer” and find your file. Once you have located your file, click “Open” and, if successful, the file name will appear under the Attached files heading. Scroll to the bottom of the page and click “Submit.”