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.
Graphing: Following are the expenses of Office A for the Year 2005Present the data in an appropriate graph.
(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
Operation research 1 answer the problem using an actual tableau not excel and not graphical
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
I need typing clear urjent no chatgpt use i will give 5 upvotes
Earth Friendly Babies has grown from an at-home business set up by a stay-at-home mom to a small mail-order company that sends out catalogs to 10 states, employs 5 people in addition to the business owner, and has office and warehouse space in an office park designed to encourage small businesses. The business has relied upon manual data collection methods for taking orders, billing, and managing inventory. The new IS will provide the support necessary for the company to expand to all 50 states with their mail-order campaign. None of the employees has worked with an IS system similar to the one designed. All employees need to be trained in all aspects of the new system, because the company at this point relies on its employees to work where needed, rather than at one job only. You need to provide training for inventory/warehouse and for order support. Each individual will require nine hours total of training, broken down into three three-hour modules, and two people can be released…
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…
A high-end restaurant wants to introduce a new gourmet dish to its menu. The dish's ingredient costs are $25 per plate, and the restaurant incurs an additional $10 per plate in overhead costs. The restaurant aims for a profit of $15 per plate. However, to maintain a competitive edge, the restaurant must also cover an additional 5% in marketing costs per dish sold. Using Goal Seek, calculate the new selling price per dish required to meet the profit target while covering the additional marketing costs.
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
Solve correct complete solutions with handwriting solutions okk
What is the difference between the analysis space and design space in an optimization process?