Solve the following problems using Excel Solver or R Studio.Figure 1 is a screen shot of TRANSPO A-I after EXCEL SOLVER was used to solve for the optimal solution. Analyze it and answerthe questions that follow. BEUNIT COST (in PhP)Dummy Supply (forecasted)P 150P 90P 783Dest XDest YDest ZP 80P 100P 1025 units 15 units 20 unitsP 215P 108P 68PO 20 unitsPO 15 unitsPO 10 units5 units4Source ASource BSource CDemand (forecasted)8OPTIMUM SOLUTIONDest XDummy Supply (prescribed)5 units 20 unitsO units 15 unitsO units 10 unitsDest Z10 unitsDest Y5 unitsO unitsO units5 units 10 unitsO units10Source ASource BSource CDemand (prescribed)11121310 unitsO units145 units15 units 20 units 5 units1516TOTAL COST (minimized) P4,020Figure 1. TRANSPO A-I2.567,

The question is related to Transportation Problem. We will analyze it by preparing the…

B E H 2 UNIT COST (in PhP) Dummy Supply (forecasted) P 150 P 90 P 78 5 units 3 Dest X Dest Y Dest Z PO 20 units PO 15 units PO 10 units Source A P 80 P 100 P 102 5 units 15 units 20 units P 215 P 108 P 68 4 Source B Source C Demand (forecasted) 8 OPTIMUM SOLUTION Dest X 5 units O units O units 5 units Dest z Dummy Supply (prescribed) 5 units 20 units O units 15 units O units 10 units Dest Y O units 10 10 units 5 units 10 units 10 units 11 Source A Source B Source C Demand (prescribed) 12 13 O units 14 15 units 20 units 5 units 15 16 TOTAL COST (minimized) P4,020 Figure 1. TRANSPO A-I 56 7,

B E H 2 UNIT COST (in PhP) Dummy Supply (forecasted) P 150 P 90 P 78 5 units 3 Dest X Dest Y Dest Z PO 20 units PO 15 units PO 10 units Source A P 80 P 100 P 102 5 units 15 units 20 units P 215 P 108 P 68 4 Source B Source C Demand (forecasted) 8 OPTIMUM SOLUTION Dest X 5 units O units O units 5 units Dest z Dummy Supply (prescribed) 5 units 20 units O units 15 units O units 10 units Dest Y O units 10 10 units 5 units 10 units 10 units 11 Source A Source B Source C Demand (prescribed) 12 13 O units 14 15 units 20 units 5 units 15 16 TOTAL COST (minimized) P4,020 Figure 1. TRANSPO A-I 56 7,

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Max −A + 2B s.t. -2A + 3B ≤ 8 (Constraint 1) 6A - 2B ≤ 5 (Constraint 2) A + B ≤ 5 (Constraint 3) A ≥ 1 (Constraint 4) A, B ≥ 0 SHOW ALL CALCULATION STEPS a) Solve the LP Model using the graphical method. Label your graph completely (and upload your graph as a jpg). State your optimal solution and objective function value. b) Calculate the Slack/Surplus for each constraint. c) Calculate the Shadow/dual Prices for each constraint.
Based on the following sensitivity report, what would be the change in the objective function value if the objective function coefficient for Product_2 increases to 24? Variable Cells Final Value Reduced Cost Objective Coefficient Allowable Increase Cell Name $B$2 Product 1 Allowable Decrease 1E+30 1 1E+30 $B$3 Product 2 $B$4 Product 3 Constraints Constraint R.H.Side Cell Name $H$9 Resource A 0 0 $H$10 Resource B 525 0 $H$11 Resource C 700 1.75 (Round your answer to the nearest whole number.) Change in the objective function value 0 175 0 Final Value -2 0 -1.5 Shadow Price 11 12 8 100 800 700 4 14 5 Allowable Increase 1E+30 1E+30 366.6666667 Allowable Decrease 100 275 700
Briefly discuss the Nine dot problem. How did they come up with a solution?
Mt. Kinley is a strategy consulting firm that divides its consultants intothree classes: associates, managers, and partners. The firm has been stable in size for the last 20years, ignoring growth opportunities in the 90s, but also not suffering from a need to downsize inthe recession at the beginning of the 21st century. Specifically, there have been—and areexpected to be—200 associates, 60 managers, and 20 partners.The work environment at Mt. Kinley is rather competitive. After four years of working as anassociate, a consultant goes “either up or out”; that is, becomes a manager or is dismissed fromthe company. Similarly, after six years, a manager either becomes a partner or is dismissed. Thecompany recruits MBAs as associate consultants; no hires are made at the manager or partnerlevel. A partner stays with the company for another 10 years (a total of 20 years with thecompany).A. How many new MBA graduates does Mt. Kinley have to hire every year?B. What are the odds that a new hire…
(A little sensitivity analysis.) You are given the final chart, with the optimal solution, for a transportation problem; note that the cell in the (4, 2) position is blank, i.e., the variable x42, with an objective coefficient (unit cost) of C42 = 18, is nonbasic. What range of values of c42 will keep the solution in the chart optimal? Hints: In this method, how do we tell that our latest solution is optimal? Temporarily replace the cost of 18 with C42. 10 (3 15 14 12 4 4 18 14 3 12 26 5 20
Consider the following linear programming problem Max. Z = 9X₁ + 16X₂ Subject to: C1: C2: C3: C4: C5: Variable Cells X₁ 2X₁ X₁ X₁ Microsoft Excel 16.0 Sensitivity Report Worksheet: [Question Sensitivity analysis.xlsx]Sheet2 Report Created: 10/24/2021 10:45:53 AM $B$5 Values x1 $C$5 Values x2 $D$10 C5Z $D$6 C1Z $D$7 C2Z $D$8 C3Z $D$9 CAZ X₂ This problem was solved using MS Solver of MS Excel. Following is the output of the solution. 3 6 3X₂ 0 0 X₂ Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease 6 3 24 9 3 Constraints Cell Name Value Price R.H. Side 05500 -5 5 15 3 0 0 0 3 24 10 0 Final Shadow Constraint Allowable Allowable Increase Decrease 1E+30 5 1E+30 24 10 6 3 3 1E+30 1E+30 7.5 3 18 1 3 1E+30 Write your report on the sensitivity analysis of constraints C2 and C3
Read the following passage and answer the question that follows Quincy Snodgrass Enterprises—Forecasting Quincy Snodgrass is an entrepreneur and a lover of the outdoors. He has worked for various companies since he graduated college with his business administration degree in management. Over the years, he has saved every extra penny and now has the starting capital he needs; consequently, he plans to open his own business. Quincy plans to open a landscaping business. The primary services he’ll offer are grass cutting, edging, and bush trimming. Obviously, this will only provide income in the spring, summer, and early fall. Therefore, he plans to offer snow removal in the winter. His goal is to continue to provide those baseline services and expand into actual landscaping work. Quincy’s initial challenge is to develop a forecast of how many customers he’ll have each month. This is essential to determine if he needs to hire any additional labor throughout the season. Unfortunately, none…
Answers questions C,D (Include your formulations, Solver files, and optimal solutions).
Dave F letcher, the general manager of NorthCarolina Engineering Corporation (NCEC), thinks that his firm'sengineering services contracted to highway construction firms aredirectly rela ted to the volume of highway construction businesscontracted with companies in his geographic area. He wondersif thjs is really so, and if it is, can this information help him planhjs operations better by forecasting the quantity of his engineeringservices required by construction firms in each quarter of theyear? The following table presents the sales of his services andtotal amounts of contracts for hjghway construction over the pasteight quarters:…
What is the difference between the analysis space and design space in an optimization process?