Q8. Network design Lonestar company produces a new product and plans to pass from its three...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Q8. Network design Lonestar company produces a new product and plans to pass from its three plants to the three warehouses in Dallas, Austin and Houston. The plant P1 has the capacity of 50,000 per week. Plant P2 has a capacity of 80,000 per week, and Plant P3 has a capacity of 60,000 per week. The demands at the three warehouses, Dallas, Austin and Houston are 40,000, 80,000, and 45,000 respectively, per week. Please find the optimal flow from each plant to each warehouse for Lonestar company: the total cost should be minimized, each warehouse's demand must be satisfied, and each plant's capacity cannot be exceeded. (Use Excel solver to get the result. Please attach the Excel file when you submit it) The unit distribution cost is shown as table below. Plants Warehouses Dallas Austin Houston P1 5 4 P2 2 5 P3 1 6 1 2 4 Q9. Inventory management (work-in-process products) ABC Company has two processes to produce X. The company is planning the inventory of work-in-process products. So far, we have known the following information: Processes Manufacturing Orders Processes 2 Process 2: Constant demand rate, daily demand: D =90 Q items per order: Order quantities are fixed, i.e., each time Process 2 places an order to Process 1, it is for Q items (this is what we need to determine). h = 0.3 dollars, inventory carrying cost for per item held for one day Planning horizon is long (infinite). Process 1: K = 5, fixed setup cost of Process 1 to start production, incurred every time when the Process 2 places an order. P = 300: production capacity in items in one day, i.e. production speed per day P Determine the optimal ordering quantity for the working-in- process products each time, ordering time interval, and maximum inventory level. (Show steps) Q8. Network design Lonestar company produces a new product and plans to pass from its three plants to the three warehouses in Dallas, Austin and Houston. The plant P1 has the capacity of 50,000 per week. Plant P2 has a capacity of 80,000 per week, and Plant P3 has a capacity of 60,000 per week. The demands at the three warehouses, Dallas, Austin and Houston are 40,000, 80,000, and 45,000 respectively, per week. Please find the optimal flow from each plant to each warehouse for Lonestar company: the total cost should be minimized, each warehouse's demand must be satisfied, and each plant's capacity cannot be exceeded. (Use Excel solver to get the result. Please attach the Excel file when you submit it) The unit distribution cost is shown as table below. Plants Warehouses Dallas Austin Houston P1 5 4 P2 2 5 P3 1 6 1 2 4 Q9. Inventory management (work-in-process products) ABC Company has two processes to produce X. The company is planning the inventory of work-in-process products. So far, we have known the following information: Processes Manufacturing Orders Processes 2 Process 2: Constant demand rate, daily demand: D =90 Q items per order: Order quantities are fixed, i.e., each time Process 2 places an order to Process 1, it is for Q items (this is what we need to determine). h = 0.3 dollars, inventory carrying cost for per item held for one day Planning horizon is long (infinite). Process 1: K = 5, fixed setup cost of Process 1 to start production, incurred every time when the Process 2 places an order. P = 300: production capacity in items in one day, i.e. production speed per day P Determine the optimal ordering quantity for the working-in- process products each time, ordering time interval, and maximum inventory level. (Show steps)
Expert Answer:
Related Book For
Operations management processes and supply chain
ISBN: 978-0136065760
9th edition
Authors: Lee J Krajewski, Larry P Ritzman, Manoj K Malhotra
Posted Date:
Students also viewed these general management questions
-
Northern Virginia Community College HOW MUCH FINANCIAL RISK SHOULD YOU TAKE? Mark D. D'Antonio Nova Southeastern University FORT LAUDERDALE, FLORIDA, U.S.A. Abstract A successful retirement...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
In Table 12. 1, when r = 0. 02, the present value of the cost rises for 68 years and then subsequently declines. Why? Table 12. 1 TABLE 12.1 Economic Harvesting Decision: Douglas Fir 10 20 30 40 50...
-
Big-Box Retail Corporation reported shareholders' equity on its balance sheet at December 31, 2017, as follows: Big-Box Retail Corporation Balance Sheet (Partial) December 31, 2017...
-
An exploratory drill hole was made in a stiff saturated clay having a moisture content of 29% and Gs = 2.68 (Figure 9.27). The sand layer underlying the clay Was observed to be under artesian...
-
What are the functions in executing and recording these two classes of transactions and custody of related assets?
-
Sam Farr is the president, founder, and majority owner of Galena Medical Corporation, an emerging medical technology products company. Galena is in dire need of additional capital to keep operating...
-
List and analyze the selection to demonstrate whether you agree or disagree with the list. Explain why or why not....
-
This week's homework relates to Chapter 19, "Financing International Trade," Chapter 20, "Short-Term Financing," and Chapter 21, "International Cash Management." Instructions Please respond to the...
-
5. Consider the inclined manometer below. Plot the change in differential pressure versus the change in differential length, &, of the mercury in the inclined section. SG=0.9 30 100 mm 50 mm Water 80...
-
A car is at position "O" with a speed of 50 ft/s when it begins to brake. The speed decreases at a constant rate of 1 ft/s. The car continues to brake at this rate as it travels from O to B. Assume...
-
The gear reduction unit and propeller of an outboard boat motor are shown in the following figure. This assembly is attached to the structure of the boat through the top "mounting Flange". The motor...
-
The results of the fatigue testing for a hip joint that your company has developed are depicted below. Walking normally places a load on the hip that is equal to about 2.5 times body weight. Jogging...
-
The figure shows a bolted lap joint that uses SAE grade 5 bolts. The members are made of cold-drawn AISI 1020 steel. Assume the bolt threads do not extend into the joint. The bolt diameter is 0.25...
-
P.s: please besides the code, also include a screenshot of code, and the output to confirm code doesn't get edited out and the output satisfies the problem!! SodaCanTester.java /** A class to...
-
The company manufactures three products: wooden chairs, tables and dressers. AFC started off as a 'Mom & Pop' shop but has grown rapidly. AFC uses one assembly line to build all three products,...
-
A personal computer manufacturer plans to locate its assembly plant in Taiwan and to ship its computers back to the United States through either Los Angeles or San Francisco. It has distribution...
-
1. Implementing Six Sigma programs takes considerable time and commitment from an organization. In terms of top-down commitment, measurement systems to track progress, tough goal setting, education,...
-
An end items demand forecasts for the next 6 weeks are 30 units, followed by forecasts of 25 units for weeks 7 though 10. The current on-hand inventory is 60 units. The order policy is to produce in...
-
A stock price is governed by \[\frac{\mathrm{d} S}{S}=\mu \mathrm{d} t+\sigma \mathrm{d} z\] where \(z\) is a standardized Wiener process. Interest is constant at rate \(r\). An investor wishes to...
-
At the beginning of April one year, the silver forward prices (in cents per troy ounce) were as follows: The carrying cost of silver is about 20 cents per ounce per year, paid at the beginning of...
-
Suppose that a forward contract on an asset is written at time zero and there are \(M\) periods until delivery. Suppose that the proportional carrying charge in period \(k\) is \(q S(k)\), where...
Study smarter with the SolutionInn App