Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 IG1...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 IG1 8000 0 9 1E+30 0.2 $D$4 TG1 15000 0 7 0.25 1E+30 $E$4 IG2 30000 0 8 0.2 1E+30 $F$4 TG2 8000 0 6 1E+30 0.25 Constraints Cell Name LHS Final Value $G$15 LHS Shadow Price 38000 9.714285714 Constraint Allowable Allowable R.H. Side Increase Decrease 38000 5250 1750 $G$16 LHS $G$9 Cutting 1 LHS 23000 46 8.142857143 23000 4200 1400 0 80 1E+30 34 $G$10 Cutting 2 LHS 54.28571429 0 80 1E+30 25.71428571 $G$11 Edging 1 LHS 80 -285.7142857 80 5.6 13.125 $G$12 Edging 2 LHS 80 -857.1428571 80 3.5 10.5 $G$13 Furnace 1 LHS $G$14 Furnace 2 LHS 45 0 80 1E+30 35 60 0 80 1E+30 20 Pre-Assignment Meeting #2 The first two problems are based on the Newfort Glass Co, which you tackled before our first meeting. You may want to revisit your formulation and make corrections (if necessary). You may also use my solutions as a starting point if you prefer. 1. Generate the Sensitivity Report in Excel for this LP problem. Based on that report, answer the following questions. Be as specific as possible (cite relevant numbers), but only short answers are needed. You may answer "Would need to resolve" where appropriate. Note: "1E+30" in Excel means infinity. A. How would adding four (4) hours in the edging department at Plant 1 affect costs? B. What if the furnace at Plant 1 was shut down for 30 hours. How would this affect costs? C. How would total costs change if you lost four (4) hours of the edging capacity in Plant 1, but gained two (2) hours of edging capacity in plant 2? D. Suppose both furnaces are shut down for 15 hours. How would this affect costs? E. Consider the objective function cost of IG at Plant 1. Would raising it $1 affect the optimal protection schedule? F. Consider the cost of IG at Plant 2. How would raising it $.5 per SQFT affect the optimal production schedule? G. Suppose you needed to eliminate four (4) hours from the edging department at both plants. How much would this impact your costs? H. Suppose you needed to eliminate one 8-hr shift in the edging department at both plants in the coming week. How much would this impact your costs? 1. Suppose the cost of glass increases by $.10 per SQFT for all four products. Would this affect your optimal production schedule? J. What happens if the cost of insulated (IG) glass decreases by $.15 per SQFT at Plant 1 but increases by $.15 per SQFT at Plant 2? K. Suppose the amount of IG glass needed this week increases by 1000 SQFT (via an emergency order). How much more does each additional SQFT of IG glass cost Newfort? How does this compare with the variable costs of IG glass (per SQFT) at each plant? Can you explain why this is the case? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 IG1 8000 0 9 1E+30 0.2 $D$4 TG1 15000 0 7 0.25 1E+30 $E$4 IG2 30000 0 8 0.2 1E+30 $F$4 TG2 8000 0 6 1E+30 0.25 Constraints Cell Name LHS Final Value $G$15 LHS Shadow Price 38000 9.714285714 Constraint Allowable Allowable R.H. Side Increase Decrease 38000 5250 1750 $G$16 LHS $G$9 Cutting 1 LHS 23000 46 8.142857143 23000 4200 1400 0 80 1E+30 34 $G$10 Cutting 2 LHS 54.28571429 0 80 1E+30 25.71428571 $G$11 Edging 1 LHS 80 -285.7142857 80 5.6 13.125 $G$12 Edging 2 LHS 80 -857.1428571 80 3.5 10.5 $G$13 Furnace 1 LHS $G$14 Furnace 2 LHS 45 0 80 1E+30 35 60 0 80 1E+30 20 Pre-Assignment Meeting #2 The first two problems are based on the Newfort Glass Co, which you tackled before our first meeting. You may want to revisit your formulation and make corrections (if necessary). You may also use my solutions as a starting point if you prefer. 1. Generate the Sensitivity Report in Excel for this LP problem. Based on that report, answer the following questions. Be as specific as possible (cite relevant numbers), but only short answers are needed. You may answer "Would need to resolve" where appropriate. Note: "1E+30" in Excel means infinity. A. How would adding four (4) hours in the edging department at Plant 1 affect costs? B. What if the furnace at Plant 1 was shut down for 30 hours. How would this affect costs? C. How would total costs change if you lost four (4) hours of the edging capacity in Plant 1, but gained two (2) hours of edging capacity in plant 2? D. Suppose both furnaces are shut down for 15 hours. How would this affect costs? E. Consider the objective function cost of IG at Plant 1. Would raising it $1 affect the optimal protection schedule? F. Consider the cost of IG at Plant 2. How would raising it $.5 per SQFT affect the optimal production schedule? G. Suppose you needed to eliminate four (4) hours from the edging department at both plants. How much would this impact your costs? H. Suppose you needed to eliminate one 8-hr shift in the edging department at both plants in the coming week. How much would this impact your costs? 1. Suppose the cost of glass increases by $.10 per SQFT for all four products. Would this affect your optimal production schedule? J. What happens if the cost of insulated (IG) glass decreases by $.15 per SQFT at Plant 1 but increases by $.15 per SQFT at Plant 2? K. Suppose the amount of IG glass needed this week increases by 1000 SQFT (via an emergency order). How much more does each additional SQFT of IG glass cost Newfort? How does this compare with the variable costs of IG glass (per SQFT) at each plant? Can you explain why this is the case?
Expert Answer:
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these accounting questions
-
Assume Hayworth corp. has an operating leverage of 2 . 4 8 and a financial leverage of 2 . 4 3 . How much would the EBIT of Hayworth corp. decrease if sales decreased by 0 . 2 3 ?
-
2. Suppose that a two-arm clinical trial is being designed to test if a new drug is equivalent to the existing drug in delaying terminally ill liver cancer patients. Suppose that two drugs will be...
-
Top executive officers of Preston Company, a merchandising firm, are preparing the next years budget. The controller has provided everyone with the current years projected income statement. Current...
-
The Postal Service is attempting to reduce the number of complaints made by the public against its workers. In order to facilitate this task, a staff analyst for the Service regresses the number of...
-
Winter Sportswear Inc. reported the following in its December 31, 2014, fi nancial statements. 2014 2013 Inventory...............................$55,600........$50,000 Accounts...
-
Mo Vaugh and Associates is a medium-sized company located near a large metropolitan area in the Midwest. The company manufactures cabinets of mahogany, oak, and other fine woods for use in expensive...
-
(a) What is the present value of $10,000 due 8 periods from now, discounted at 10%? (b) What is the present value of $20,000 to be received at the end of each of 6 periods, discounted at 8%?
-
19. O at points | Previous Answers LarTrig9 2.3.036 My Hartes Find all solutions of the equation in the interval [0, 2). (Enter your answers as a comma-separated list. If there is no solution, enter...
-
Identify one of the two products that is expected in the following Cannizzaro reaction H 1. KOH 2. -0 A) O B) HO O D) HO
-
Compare and contrast containerization technologies (e.g., Docker, Kubernetes) with traditional virtualization approaches. What are the key differences in terms of resource isolation, performance, and...
-
The company called: "Restaurantes Tlaquepaque, SA de CV", with tax address at Calle Jurez, Number 88, Colonia Centro, San Pedro Tlaquepaque, Jalisco., and with RFC: RTA210225HM1, is a recently...
-
Wing Ltd acquired all the issued shares of Leg Ltd for cash consideration of $300 000. At the date of acquisition Leg Ltd had: - share capital $100 000. - retained earnings $100 000. - buildings:...
-
Now that you've completed your Westlaw Fundamentals Certification, you will learn about another type of legal research tool that is often used by small firms that either don't want to pay or don't...
-
At age 37 you invest $1,500 that earns 8 percent each year. At age 52 you invest $1,500 that earns 11 percent per year. In which case would you have more money at age 65?
-
The makers of "Cats Love It" cat litter are facing a serious problem. Retail customers are reporting that cartons of the firm's premium brand cat litter are leaking the product onto store shelves....
-
Show that, given a maximum flow in a network with m edges, a minimum cut of N can be computed in O(m) time.
-
The following extract is from Conceptual Framework for Financial Accounting and Reporting: Elements of Financial Statements and Their Measurement, FASB 3, December 1976. The benefits of achieving...
-
The following extract is from Comments of Leonard Spacek, in R.T. Sprouse and M. Moonitz, A Tentative Set of Broad Accounting Principles for Business Enterprises, Accounting Research Study No. 3,...
-
What factors should be considered in selecting an allocation base?
Study smarter with the SolutionInn App