Reducing In-Process Inventorya. To provide a basis of comparison, begin by evaluating the status quo. Determine the expected amount of in-process inventory at the presses and at the inspection station. Then calculate the expected total cost per hour of the in-process inventory, the presses, and the inspector.b. What would be the effect of proposal 1? Why? Make specific comparisons to the results from part a. Explain this outcome to Jerry Carstairs.d. Make your recommendations for reducing the average level of in-process inventory at the inspection station and at the group of machines. Be specific in your recommendations, and support them with quantitative analysis like that done in part a. Make specific comparisons to the results from part a, and cite the improvements that your recommendations would yield. Pls include step by step solution using MS Excel Reducing In-Process Inventorywing section out of a sheet has an exponential distribution with a mean of one hour. When finished,the wing sections arrive randomly at an inspection station at the same mean rate as the metal sheetsJim Wells, vice president for manufacturing of the Northern Airplane Company, is exasperated.His walk through the company's most important plant this morning has left him in a foul mood.However, he now can vent his temper at Jerry Carstairs, the plant's production manager, who hasarrived at the presses (seven per hour). A single inspector has the full-time job of inspecting thesewing sections to make sure they meet specifications. Each inspection takes her 71/2 minutes, soshe can inspect eight wing sections per hour. This inspection rate has resulted in a substantialaverage amount of in-process inventory at the inspection station (i.e., the average number of wingsheets waiting to complete inspection is fairly large), in addition to that already found at the groupof machines.\just been summoned to Jim's office."Jerry, I just got back from walking through the plant, and I am very upset."The cost of this in-process inventory is estimated to be $16 per hour for each metal sheet at thepresses or each wing section at the inspection station. Therefore, Jerry Carstairs has made twoalternative proposals to reduce the average level of in-process inventory."What is the problem, Jim?""Well, you know how much I have been emphasizing the need to cut down on our in-processinventory.Proposal 1 is to use slightly less power for the presses (which would increase their average time toform a wing section to 1.2 hours), so that the inspector can keep up with their output better. Thisalso would reduce the cost for each machine (operating cost plus capital recovery cost) from $14to $13 per hour. (By contrast, increasing to maximum power would increase this cost to $15 perhour while decreasing the average time to form a wing section to 0.8 hours.)"Yes, we've been working hard on that," responds Jerry."Well, not hard enough!" Jim raises his voice even higher. "Do you know what I found by thepresses?"Proposal 2 is to substitute a certain younger inspector for this task. He is somewhat faster (albeitwith some variability in his inspection times because of less experience), so he should keep upbetter. (His inspection time would have a probability distribution with a mean of 7.2 minutes anda standard deviation of 5 minutes.) This inspector is in a job classification that calls for a totalcompensation (including benefits) of $38 per hour, whereas the current inspector is in a lower jobclassification where the compensation is $34 per hour. (The inspection times for each of theseinspectors are typical of those in the same job classifications.)"No.""Five metal sheets still waiting to be formed into wing sections. And then, right next door at theinspection station, 13 wing sections! The inspector was inspecting one of them, but the other 12were just sitting there. You know we have a couple hundred thousand dollars tied up in each ofthose wing sections. So between the presses and the inspection station, we have a few millionbucks' worth of terribly expensive metal just sitting there. We can't have that!"The chagrined Jerry Carstairs tries to respond. "Yes, Jim, I am.well aware. that that inspectionstation is a bottleneck. It usually isn't nearly as bad as you found it this morning, but it is abottleneck. Much less so for the presses. You really caught us on a bad morning."You are the management scientist on Jerry Carstair's staff who has been asked to analyze thisproblem. He wants you to "use the latest management science techniques to see how much eachproposal would cut down on in-process inventory and then make your recommendations.""I sure hope so," retorts Jim, "but you need to prevent anything nearly this bad happening evenoccasionally. What do you propose to do about it?"Jerry now brightens noticeably in his response. "Well, actually, I've already been working on thisproblem. I have a couple proposals on the table and I have asked a management scientist on mystaff to analyze these proposals and report back with recommendations.""Great," responds Jim, "glad to see you are on top of the problem. Give this your highest priorityand report back to me as soon as possible.""Will do," promises Jerry.Here is the problem that Jerry and his management scientist are addressing. Each of 10 identicalpresses is being used to form wing sections out of large sheets of specially processed metal. Thesheets arrive randomly at a mean rate of seven per hour. The time required by a press to form a

Question

Reducing In-Process Inventorya. To provide a basis of comparison, begin by evaluating the status quo. Determine the expected amount of in-process inventory at the presses and at the inspection station. Then calculate the expected total cost per hour of the in-process inventory, the presses, and the inspector.b. What would be the effect of proposal 1? Why? Make specific comparisons to the results from part a. Explain this outcome to Jerry Carstairs.d. Make your recommendations for reducing the average level of in-process inventory at the inspection station and at the group of machines. Be specific in your recommendations, and support them with quantitative analysis like that done in part a. Make specific comparisons to the results from part a, and cite the improvements that your recommendations would yield. Pls include step by step solution using MS Excel Reducing In-Process Inventorywing section out of a sheet has an exponential distribution with a mean of one hour. When finished,the wing sections arrive randomly at an inspection station at the same mean rate as the metal sheetsJim Wells, vice president for manufacturing of the Northern Airplane Company, is exasperated.His walk through the company's most important plant this morning has left him in a foul mood.However, he now can vent his temper at Jerry Carstairs, the plant's production manager, who hasarrived at the presses (seven per hour). A single inspector has the full-time job of inspecting thesewing sections to make sure they meet specifications. Each inspection takes her 71/2 minutes, soshe can inspect eight wing sections per hour. This inspection rate has resulted in a substantialaverage amount of in-process inventory at the inspection station (i.e., the average number of wingsheets waiting to complete inspection is fairly large), in addition to that already found at the groupof machines.\just been summoned to Jim's office.&#34;Jerry, I just got back from walking through the plant, and I am very upset.&#34;The cost of this in-process inventory is estimated to be $16 per hour for each metal sheet at thepresses or each wing section at the inspection station. Therefore, Jerry Carstairs has made twoalternative proposals to reduce the average level of in-process inventory.&#34;What is the problem, Jim?&#34;&#34;Well, you know how much I have been emphasizing the need to cut down on our in-processinventory.Proposal 1 is to use slightly less power for the presses (which would increase their average time toform a wing section to 1.2 hours), so that the inspector can keep up with their output better. Thisalso would reduce the cost for each machine (operating cost plus capital recovery cost) from $14to $13 per hour. (By contrast, increasing to maximum power would increase this cost to $15 perhour while decreasing the average time to form a wing section to 0.8 hours.)&#34;Yes, we've been working hard on that,&#34; responds Jerry.&#34;Well, not hard enough!&#34; Jim raises his voice even higher. &#34;Do you know what I found by thepresses?&#34;Proposal 2 is to substitute a certain younger inspector for this task. He is somewhat faster (albeitwith some variability in his inspection times because of less experience), so he should keep upbetter. (His inspection time would have a probability distribution with a mean of 7.2 minutes anda standard deviation of 5 minutes.) This inspector is in a job classification that calls for a totalcompensation (including benefits) of $38 per hour, whereas the current inspector is in a lower jobclassification where the compensation is $34 per hour. (The inspection times for each of theseinspectors are typical of those in the same job classifications.)&#34;No.&#34;&#34;Five metal sheets still waiting to be formed into wing sections. And then, right next door at theinspection station, 13 wing sections! The inspector was inspecting one of them, but the other 12were just sitting there. You know we have a couple hundred thousand dollars tied up in each ofthose wing sections. So between the presses and the inspection station, we have a few millionbucks' worth of terribly expensive metal just sitting there. We can't have that!&#34;The chagrined Jerry Carstairs tries to respond. &#34;Yes, Jim, I am.well aware. that that inspectionstation is a bottleneck. It usually isn't nearly as bad as you found it this morning, but it is abottleneck. Much less so for the presses. You really caught us on a bad morning.&#34;You are the management scientist on Jerry Carstair's staff who has been asked to analyze thisproblem. He wants you to &#34;use the latest management science techniques to see how much eachproposal would cut down on in-process inventory and then make your recommendations.&#34;&#34;I sure hope so,&#34; retorts Jim, &#34;but you need to prevent anything nearly this bad happening evenoccasionally. What do you propose to do about it?&#34;Jerry now brightens noticeably in his response. &#34;Well, actually, I've already been working on thisproblem. I have a couple proposals on the table and I have asked a management scientist on mystaff to analyze these proposals and report back with recommendations.&#34;&#34;Great,&#34; responds Jim, &#34;glad to see you are on top of the problem. Give this your highest priorityand report back to me as soon as possible.&#34;&#34;Will do,&#34; promises Jerry.Here is the problem that Jerry and his management scientist are addressing. Each of 10 identicalpresses is being used to form wing sections out of large sheets of specially processed metal. Thesheets arrive randomly at a mean rate of seven per hour. The time required by a press to form a

Accepted Answer

The norm at the presses and review station to ascertain expected measure of in-process inventory is…