Problem 2 A manufacturer has three plants with access production capacity. It can use this capacity...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem 2 A manufacturer has three plants with access production capacity. It can use this capacity to produce a product that comes in three sizes, Large, Medium, and Small. ◆ The profit from selling the product depends on its size. The forecast of sales for each product size is known to be 900, 1200, 750 units for the Large, Medium and Small products respectively, so production levels should not exceed these values. There is a limited daily storage available in each plant, which limits the production levels in each plant. • To prevent layoffs management wants the percent of the available capacity used for production be equal among all plants (for example, capacity in plant 1 is 750 units. If this plant produces 500 units, it uses 500/750 = .66 of its capacity. Then all plants should have the same percentage of their own capacities used) Observe some more required information. ♦ Capacity avail Storage avail Plant1 750 units 900 13000 sqft 12000 Profit/unit Storage/unit Plant2 Large $420 Medium Small 360 300 20 sq-ft 15 12 2.1 Write the linear programming model in the Answers sheet. Plant3 450 5000 The sensitivity report for this model is provided in the Answers sheet. Answer the following sensitivity questions. 2.2 How much the unit profit of the large size product produced in plant 1 can change, before the current production changes? a. Any change in the unit profit will change the optimal production plan b. From the sensitivity report the change is 888.88. c. Two coefficients are changing. (i) Plant 1= 750.; (ii) Large product = 750 0/750 + 55.55/750 < 1. No change in the coefficients. 2.3 How much should the company be willing to pay for 100 sq-ft of additional storage in each plant, when each addition is considered individually? a. The company should not pay any amount in plant 1, any amount in plant 2, and 291 dollars in plant 3. b. The company should pay any amount charged in plant 1, any amount charged in plant 2, and 291.67 dollars in plant 3. c. The company should not pay any amount in either plant 1 or plant 2, and 291.67 dollars in plant 3. d. The company should pay 888.88/100 dollars in plant 1, 1416.67/100 dollars in plant 2, and 2333.33/100 dollars in plant 3. 2.4 If all the sales estimates are too optimistic by 10%, the total profit must be inflated. Can oyu re-calculate the total profit without a re-run of the model? a. There is no need to re-run the model because no selling price is changing. b. We must re-run the model. The total demand for all the three products is inflated by 3*10% = 30%, and this is greater than any allowable increase. c. Three constraints are changing. We need to apply the SumRate rule. After applying it properly, the answer is "Yes". We do not have to re-run the model. Explanain in the answers sheet. d. Three constraints are changing. We need to apply the SumRate rule. After applying it properly, the answer is "Yes". We do not have to re-run the model. Explanain in the answers sheet. Problem 2 A manufacturer has three plants with access production capacity. It can use this capacity to produce a product that comes in three sizes, Large, Medium, and Small. ◆ The profit from selling the product depends on its size. The forecast of sales for each product size is known to be 900, 1200, 750 units for the Large, Medium and Small products respectively, so production levels should not exceed these values. There is a limited daily storage available in each plant, which limits the production levels in each plant. • To prevent layoffs management wants the percent of the available capacity used for production be equal among all plants (for example, capacity in plant 1 is 750 units. If this plant produces 500 units, it uses 500/750 = .66 of its capacity. Then all plants should have the same percentage of their own capacities used) Observe some more required information. ♦ Capacity avail Storage avail Plant1 750 units 900 13000 sqft 12000 Profit/unit Storage/unit Plant2 Large $420 Medium Small 360 300 20 sq-ft 15 12 2.1 Write the linear programming model in the Answers sheet. Plant3 450 5000 The sensitivity report for this model is provided in the Answers sheet. Answer the following sensitivity questions. 2.2 How much the unit profit of the large size product produced in plant 1 can change, before the current production changes? a. Any change in the unit profit will change the optimal production plan b. From the sensitivity report the change is 888.88. c. Two coefficients are changing. (i) Plant 1= 750.; (ii) Large product = 750 0/750 + 55.55/750 < 1. No change in the coefficients. 2.3 How much should the company be willing to pay for 100 sq-ft of additional storage in each plant, when each addition is considered individually? a. The company should not pay any amount in plant 1, any amount in plant 2, and 291 dollars in plant 3. b. The company should pay any amount charged in plant 1, any amount charged in plant 2, and 291.67 dollars in plant 3. c. The company should not pay any amount in either plant 1 or plant 2, and 291.67 dollars in plant 3. d. The company should pay 888.88/100 dollars in plant 1, 1416.67/100 dollars in plant 2, and 2333.33/100 dollars in plant 3. 2.4 If all the sales estimates are too optimistic by 10%, the total profit must be inflated. Can oyu re-calculate the total profit without a re-run of the model? a. There is no need to re-run the model because no selling price is changing. b. We must re-run the model. The total demand for all the three products is inflated by 3*10% = 30%, and this is greater than any allowable increase. c. Three constraints are changing. We need to apply the SumRate rule. After applying it properly, the answer is "Yes". We do not have to re-run the model. Explanain in the answers sheet. d. Three constraints are changing. We need to apply the SumRate rule. After applying it properly, the answer is "Yes". We do not have to re-run the model. Explanain in the answers sheet.
Expert Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these general management questions
-
You can use this class to display dialog boxes. a. JOptionPane b. BufferedReader c. InputStreamReader d. DialogBox
-
You can use this class to display dialog boxes. a. JOptionPan b. BufferedReader c. InputStreamReader d. DialogBox
-
Discuss how your personal core competencies help you create value for the business where you work, your life, your school, or your family. What can you do to expand or improve your core competencies?
-
Identify each of the following items as revenues, expenses, or withdrawals from the drop down provided. 1. Advertising expense 2. Consulting revenue 3. Rent expense 4. Rental income 5. Wages expense...
-
Frank and Karen Naples contracted with Keystone to build a new home for them for $620,500. The work was warranted by the contract. Soon after they moved into the home, major problems were noticed....
-
Among the most exciting aspects of a university professors life are the departmental meetings where such critical issues as the color of the walls will be painted and who gets a new desk are decided....
-
The octogenarian founders of X-Rite Inc. spend less time these days on the golf course and more with estate planners, thanks to an accounting standard introduced last year. This same accounting...
-
The following data pertain to the Vesuvius Tile Company for July. Work In process, July 1 (in units) .................................................................. 20,000 Units started during...
-
Please explain where I can find this information for TARGET in morning star.. 5. For the most recent year end and previous year end (that matches your financial statements), find or calculate the...
-
A girl has an age of x years. Her grandfather is aged y years. Write an expression for: a. Their combined age. b. The difference between their ages. c. The grandfathers age 10 years ago. d. The girls...
-
Suppose you have been hired as a financial consultant to Defense Electronics, Incorporated (DEI), a large, publicly traded firm that is the market share leader in radar detection systems (RDSs). The...
-
Consider the circuit shown. 10 nF 10 nF 20 nF 20 nF t Battery 01 45 V 15 nF (I) Find the total capacitance for this circuit. (II) Find the total charge stored. (III) Find the charge stored in the 20...
-
10-year Treasury note ($1,000 principal) with 5.000% annual coupon rate, paid semi-annually, is purchased 26 days after the last coupon payment. The current coupon period contains 184 days. Calculate...
-
If the cost of a private college education is about $30,000 per year now, what will it cost your children per year if costs go up 8% a year and your children go to college 18 years from now? If the...
-
A subject weighing 162 lbs wants to lose of her weight. If shewere to exercise for a total of 4 hours every week at an intensityof 31.4 mLkg -1 min -1 , how many weeks wouldit take her to lose this...
-
What type of algorithm would help you nd out what you might earn for a salary if you have different levels of college degrees in computer science
-
it is a good time to put what you have learned to use in an interpersonal relationship in your life. Please answer the following prompt: Write a letter to a friend or loved one about the relationship...
-
What types of inventory issues Starbucks might reflect upon at the end of each year? The mission of Starbucks is to inspire and nurture the human spiritone person, one cup, and one neighborhood at a...
-
Suppose that Winters method is used to forecast quarterly U.S. retail sales (in billions of dollars). At the end of the first quarter of 2010, the seasonal indexes are: quarter 1, 0.90; quarter 2,...
-
The file S12_57.xlsx consists of the monthly retail sales levels of U.S. gasoline service stations. a. Is there a seasonal pattern in these data? If so, how do you explain this seasonal pattern?...
-
Winters method assumes a multiplicative seasonality but an additive trend. For example, a trend of 5 means that the level will increase by five units per period. Suppose that there is actually a...
-
Question: The stock market crash of 1929 and the Great Depression that followed were caused in part because so many investors blindly put their money into stocks they knew nothing about. During the...
-
Question: Bill and Diane are hiking in the woods. Diane walks down a hill to fetch fresh water. Bill meets a stranger, who introduces herself as Katrina. Bill sells a kilo of cocaine to Katrina, who...
-
Strategy: Look at the ethics checklist. Citizens of China are stakeholders of American companies. Although it is legal to buy fabric from a company that is polluting overseas, this is surely...
Study smarter with the SolutionInn App