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
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…
It is summertime and your winter coat factory is trying to decide its production schedule and staffing level for the next season. You are forecasting a demand of 5000 coats in October, 8000 coats in November, 8000 coats in December, 12000 coats in January, 12000 coats in February, and 9000 coats in March. You want to manufacture these coats at the lowest cost possible/ The first decision you need to make is how many people to hire. Each employee will cost $2500 a month. You don’t want to hire or fire any employees mid-season in order to minimize disruptions in your factory floor. You can have employees idle if there isn’t sufficient work for them to do. Employees still need to be paid even if they are idle. An employee works 20 business days a month and takes half a day to produce one coat. The employees can also be asked to work overtime, in which case you need to pay them $70 per coat they produce. You don’t need to assume there is any capacity constraint on the number of overtime…
(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
OPERATIONS RESEARCH (UPVOTE WILL BE GIVEN. PLEASE WRITE THE COMPLETE SOLUTIONS/TABLES. GIVE SOME EXPLANATIONS. BOX THE FINAL ANSWERS)
Operation research 1 answer the problem using an actual tableau not excel and not graphical
I need typing clear urjent no chatgpt use i will give 5 upvotes
Kindly do this in excel please
P&G produces many different products for different product category markets (i.e., from tooth paste to deodorant to cough medicine). P&G also develops separate brands within the same product category (Tide, Cheer, Downy, Gain, etc., in the laundry detergent category). The most likely reason P&G would develop so many brands is because P&G: believes there are many segments across different product categories and the firm wants to reach as many of these different A segments in as many different product markets as it can in order to increase the firm's sales revenue. wants to increase the number of products it sells in order to discourage the competition from entering its markets. В wants to improve its R&D and promotional capabilities by always developing new products C has the financial resources to do so (i.e., D show it can ) to
Hi! How do you solve this qn using Excel Solver? The SurveyMonkey firm has been contracted to conduct a survey on the party preference in thecoming election. The firm must assign interviewers to conduct the survey. The interviews are to beconducted by telephone and in person. One person can conduct 80 telephone interviews or 40personal interviews in a single day. The following criteria have been established by the firm in orderto ensure a representative survey:• At least 3,000 interviews must be conducted.• At least 1,000 interviews must be by telephone.• At least 800 interviews must be personal. Due to urgency of the project, the interviews must be conducted within one day. An interviewerconducts only one type of interview on the day. The cost is $50 per day for a telephone interviewerand $70 per day for a personal interviewer. The firm wants to know the number of interviewers tohire in order to minimize the total cost of the survey. a) Formulate a linear programing model for this…
What is the difference between the analysis space and design space in an optimization process?