Operations Management Work X 3 See Attached

Operations Management Work X 3 See Attached
INSTRUCTIONS 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. BACKGROUND INFORMATION 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 multistep processes utilizing a variety of parameters such as bottleneck, capacity, utilization, flow rate, rework, and cycle time. (CO#1, CO#4) PROMPT 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 AN­5n 0.6 D300 0.7 T2i 0.8 Demands for Housing TASKS 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.”
Operations Management Work X 3 See Attached
TASKS Create a Learning Curve Calculator similar to the one shown from the video Learning Curve Calculator. Create a graph of Unit Cost versus Learning Rate for an initial unit cost of $100 and a production run of 1,000 units. Learning rate should vary from 0 to 100% and should use increments of 5%. Ensure you label the x- and y-axis and provide a graph title. The graph should be in its own worksheet. For help with moving the graph to a new sheet, go to How to Move a Chart onto a New Sheet in Excel. Using the same data from question 2 (above), graph the Unit Number versus Cumulative Total Cost. Select two learning rates (Option A and Option B). Answer the following questions: If each 5% increment of learning rate costs $1000, which option (A or B) would result in a low cost (Cumulative cost for 1,000 unit run added to the learning rate cost)? Does your answer change if you do 50 runs in a year and the learning rate cost is a one-time cost? Explain why or why not. Explain how you could use the PDCA cycle to reduce the Cumulative Total Cost. What are the tradeoffs to reducing Cumulative Total Costs?