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...
-
The Energy Information Administration published a press release on September 26, 2005 (Paula Weir and Pedro Saavedra, Two Multi-Phase Surveys That Combine Overlapping Sample Cycles at Phase I). The...
-
The sketch graph shows the 13 successive ionisation energies of aluminium. a. Define the term 1st ionisation energy. b. How does the graph provide evidence for the existence of three electron shells...
-
Compare and contrast direct and indirect real estate investments.
-
The following misstatements are included in the accounting records of the Joyce Manufacturing Company: 1. A shipment to a customer was not billed because of the loss of the bill of lading. 2. A sales...
-
Modern portfolio theory sure seems out of date to me. Discuss why Modern portfolio theory is not really match with our current economic situation. please provide me a answer that is not PIagiarism.
-
Noah and Joan Arc live with their family in Dayton, OH. Noahs Social Security number is 434-11-3311. Noah was born on February 22, 1983, and Joan was born on July 1, 1984. Both enjoy good health and...
-
Statement of Cash Flows A summary of cash flows for Escape Travel Service for the year ended August 31, 2018, is shown below. Cash receipts: Cash received from customers Cash received from issuing...
-
Please respond to each post adding to the conversation with viable information. Post 1 -The state of North Carolina defines blood alcohol concentration (BAC) level as the measurement of the amount of...
-
Discuss the challenges of designing for privacy and data security in digital products and services.
-
Number of visits 8,000 9,000 10,000 11,000 12,000 Revenue per visit $40 Total revenues $320,000 $360,000 $400,000 $440,000 $480,000 Variable cost per visit $6 Total variable costs 48,000 54,000...
-
Luzadis Company makes furniture using the latest automated technology. The company uses a job-order costing system and applies manufacturing overhead cost to products based on machine-hours. The...
-
Total Cost of Quality. The Duquesne Motor Company makes and sells 95,000 motors a year. Their average cost per unit is Material - $2,000 Labor - $7,000 Total Production Cost $9,000 The units sell for...
-
At December 31, 2020, Sandhill Corporation has 2,500 shares of $104 par value, 8%, preferred stock outstanding and 110,000 shares of $10 par value common stock issued. Sandhill's net income for the...
-
Suppose that the laptop of Prob. 2.16 is placed in an insulating briefcase with a fully charged battery, but it does not go into sleep mode, and the battery discharges as if the laptop were in use....
-
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?
-
Assume that Microsoft Corporation acquired 90 percent of the outstanding common stock of Powerline Technologies for \($3,000,000\) cash plus 200,000 shares of Microsoft's \($10\) par value common...
-
Blue S.A., a French telecommunications company, acquired a 45 percent interest in E-Minus for 65,000,000. Blue consolidates E-Minus because it has special voting rights that allow it to control...
-
Consider the following data: Required Use the above data to prepare the operating cash flow section of a consolidated statement of cash flows, using the indirect method. Consolidated net income.......
Study smarter with the SolutionInn App