In the Base Model (with WIP= 4 units, Mean Daily production = 3.5, Maximum Variation Around...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In the Base Model (with WIP= 4 units, Mean Daily production = 3.5, Maximum Variation Around Mean =2.5 units at all operations), a bottleneck can be established by setting "Mean Daily Production" at 3 units and "Maximum Variation around Mean" at 1 unit for a specific operation (in Panel B). Create three scenarios by letting operation 1, operation 3, and operation 5 be the bottleneck operation in each scenario. Hit F9 few times. Copy and Paste Special your results from (Panel E) for "1000 Runs" for each of these three scenarios into the Scenario Output worksheet where you have already saved your results for the base model and variation related scenarios. Discuss the following questions: a) Discuss the impact of the location of the "constraint operation" on various system performance measures T, I, OE (including customer service, lead time, productivity, inventory turnover) shown and clearly defined in Panel E of the model. b) Discuss how these three scenarios (i.e., presence of a constraint) compare with those from (i) the base model, and (ii) change in variation model (you reported earlier and reproduced below). c) In general terms, discuss how these scenarios relates to what you have read in The Goal (specifically, The Hike, and the chapter on Capacity and Constraints Management you are reading in this module. In general terms, how do you think the concepts of (i) Design Capacity, (ii) effective capacity and actual output as discussed in this chapter relate to this Excel-Based Dice Game. d) Note that in each of these three scenarios, the net change in operating expenses is zero because the model assumes reduction in variation from 2.5 units to 1.0 is worth $600 (@ $200/0.5 unit reduction and reduction in capacity from 3.5 to 3.0 units is worth $600 (@$600/0.5 unit increased as shown in Cell C43 and C44 in Excel-based Model). Performance 1 16 70 24 62 $19,220 $20,150 $20,770 $54,539 $53,871 $53,567 $11,911 $12,630 $13,502 $7,309 $7,520 $7,268 13% 14% 14% Customer Service: 88.57% 92.86% Lead Time: 7.71 6.27 Productivity: 1.61 Inventory Turnover: 2.60 Starting WIP (Day 0) RM Released: Ending WIP: Quantity Shipped: Throughput: Inventory: Operating Expenses: Results from various scenarios (copied and pasted as "values" from the Excel-Model) Base Model Impact of Variability Impact of Constaint 4 units 2 1.5 2 Net Profit: ROI: 16 69 20 65 1.60 3.19 3 16 70 19 67 95.71% 5.60 1.54 3.57 4 5 6 7 8 9 10 Note: Copy and Paste Special (using"values" option) the system performance measures (Celle D47-D59) for each scenario Note: We will use this worksheet throughout the semester and fill the subsequent columns with more scenarios and compare and contrast them. In the Base Model (with WIP= 4 units, Mean Daily production = 3.5, Maximum Variation Around Mean =2.5 units at all operations), a bottleneck can be established by setting "Mean Daily Production" at 3 units and "Maximum Variation around Mean" at 1 unit for a specific operation (in Panel B). Create three scenarios by letting operation 1, operation 3, and operation 5 be the bottleneck operation in each scenario. Hit F9 few times. Copy and Paste Special your results from (Panel E) for "1000 Runs" for each of these three scenarios into the Scenario Output worksheet where you have already saved your results for the base model and variation related scenarios. Discuss the following questions: a) Discuss the impact of the location of the "constraint operation" on various system performance measures T, I, OE (including customer service, lead time, productivity, inventory turnover) shown and clearly defined in Panel E of the model. b) Discuss how these three scenarios (i.e., presence of a constraint) compare with those from (i) the base model, and (ii) change in variation model (you reported earlier and reproduced below). c) In general terms, discuss how these scenarios relates to what you have read in The Goal (specifically, The Hike, and the chapter on Capacity and Constraints Management you are reading in this module. In general terms, how do you think the concepts of (i) Design Capacity, (ii) effective capacity and actual output as discussed in this chapter relate to this Excel-Based Dice Game. d) Note that in each of these three scenarios, the net change in operating expenses is zero because the model assumes reduction in variation from 2.5 units to 1.0 is worth $600 (@ $200/0.5 unit reduction and reduction in capacity from 3.5 to 3.0 units is worth $600 (@$600/0.5 unit increased as shown in Cell C43 and C44 in Excel-based Model). Performance 1 16 70 24 62 $19,220 $20,150 $20,770 $54,539 $53,871 $53,567 $11,911 $12,630 $13,502 $7,309 $7,520 $7,268 13% 14% 14% Customer Service: 88.57% 92.86% Lead Time: 7.71 6.27 Productivity: 1.61 Inventory Turnover: 2.60 Starting WIP (Day 0) RM Released: Ending WIP: Quantity Shipped: Throughput: Inventory: Operating Expenses: Results from various scenarios (copied and pasted as "values" from the Excel-Model) Base Model Impact of Variability Impact of Constaint 4 units 2 1.5 2 Net Profit: ROI: 16 69 20 65 1.60 3.19 3 16 70 19 67 95.71% 5.60 1.54 3.57 4 5 6 7 8 9 10 Note: Copy and Paste Special (using"values" option) the system performance measures (Celle D47-D59) for each scenario Note: We will use this worksheet throughout the semester and fill the subsequent columns with more scenarios and compare and contrast them.
Expert Answer:
Related Book For
Project Management A Managerial Approach
ISBN: 978-0470533024
8th edition
Authors: Jack R. Meredith, Samuel J. Mantel Jr.
Posted Date:
Students also viewed these accounting questions
-
1. Scienter can be established by showing a defendant's motive to commit fraud. In the context of the Rand-Heart case, what act might have established motive on Dolan's part? 2. When Bank of America...
-
What is the shear capacity of the RC beam described below considering the steel reinforcement and using the formula: VRsyAw 2fyd cot 8/s The shear reinforcement in the beam is provided by sets of...
-
Discuss customer service level for an inventory system within the context of quality management.
-
Listed below are measured amounts of caffeine (mg per 12 oz of drink) obtained in one can from each of 20 brands (7-UP, A&W Root Beer, Cherry Coke, . . . , Tab). Are the statistics representative of...
-
In answer to the question, "When a plant grows, where does the material come from?" Aristotle hypothesized by logic that all material came from the soil. Do you consider his hypothesis to be correct,...
-
From the following Balance Sheet of JP International, prepare a Cash Flow Statement for the year ended 31st December, 2015 and 2016: Additional information available on 31.12.2016: (a) Accumulated...
-
Estimate the maximum mass flow rate of air that can be passed by the duct shown in Fig. P11.61 for \(\mu=4 \times 10^{-7} \mathrm{lb}\). \(\mathrm{s} / \mathrm{ft}^{2}\). Figure P11.61 Po 100 psia T...
-
Mollys Candle Shop has several retail stores in the coastal areas of North and South Carolina. Many of Mollys customers ask her to ship their purchases. The following chart shows the number of...
-
Describe a federal law that shapes discretionary benefits practices and identify the relevant employee benefits practices to which they apply. What are pros and cons of this law?
-
You are an Examiner for the Refund Integrity Program in the GST/HST Audit Division of the Canada Revenue Agency (CRA). Using sophisticated analytical tools, you are able to identify GST/HST returns...
-
Using naive Gauss Elimination, solve the following set of equations. Substitute results back into the original equations to check your answers. (This can be done in code OR by hand, scanned, and...
-
Explain three arguments in support of international law. Give one example justifying the importance of international law. Cite sources.?
-
Which sources of INTERNATIONAL LAW are the best in helping to control the covid 19, the pandemic. Give reasons and examples for the particular sources. (Sources of international law: Treaty,...
-
Treaties are an important element of international law give two reasons why this is the case when compared to other sources of international law
-
Argue why there is relationship of human right and international law. Integrate international law and human rights ties with divine providence in the argument.
-
Despite considerable emphasis by some international law scholars on court cases and precedents, can an argument be made that treaty law is the most important source of international law? Why?
-
1) As a systems analyst, you are preparing a new information system project proposal for management that require you to create a costs-benefits analysis prior to project presentation. Assume that the...
-
(a) Water flows through the nozzle of a garden hose. Find an expression for m in terms of line pressure P 1 , ambient pressure P 2 , inside hose diameter D 1 , and nozzle outlet diameter D 2 . Assume...
-
Describe how a risk matrix is constructed.
-
1. How did the laser cutter save Peerless Saw Company when it could not be justified on payback or ROI grounds? 2. Compare the decision Ted faces nowthe 1200-watt laser purchasewith the decision he...
-
Does this project sound like a mission impossible? In what regards?
-
What orientation of an electric dipole in a uniform electric field has the greatest electric potential energy? What orientation has the least? (Let the system comprise both the electric dipole and...
-
You release three balls simultaneously from the same height above the floor. The balls all carry the same quantity of surplus positive charge, but they have different masses: \(1 \mathrm{~kg}, 2...
-
A dipole carrying charges \(+q\) and \(-q\) separated by a distance \(d\) is rotated \(180^{\circ}\) in a uniform electric field (Figure P25.7). What is the change in electric potential energy...
Study smarter with the SolutionInn App