Please set up a linear program and solve the problem using the Excel Solver. Thank you very much. 5. Freshly Baked Hub has 3 warehouses and 3 branches store. The following tableshows the shipping costs between each warehouses and store, the warehousecapabilities and store capacities.Branch StoreToCapabilitiesFromYAP 350P 400P 2807,000P 197P 510P 3708,000P 470P 630P 28512,000Сарacity6,00014,0007,00027,000Linear Program:Solver Solution:x1 x2 x3 x4x5x6x7x8 x9Decision:Constraints:TotalSign Capability1234Minimize C:WarehouseB.

Answered: Please set up a linear program and…

Business

Operations Management

Please set up a linear program and solve the problem using the Excel Solver. Thank you very much.

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

Simplex Method Example Maximize :P = 4x, + 3x, +2x3 |3x, + 2х, + 5х, < 23 2x, + x, + x, <8 X, + x, + 2x, s7 3x, +2x, +5x, +s, = 23 2x, + x, + X3 +S2 = 8 x, + X, +2x, +s, =7 (- 4x, – 3x, -2x, +P = 0 System: ST : X1, X2, X3 2 0 X2 X3 s, S2 s, P 1 0 0 0| 23 0 1 0 0 23 +3 = 7.6 8+2=(4) 3 2 5 s2 [2] 1 1 8 1 S3 1 2 0 0 1 0 7 7÷1= 7 Р(-4) -3 -2 0 о 01 - 3R, + R, → R, 1 Row Operations:R, → R, - R, + R, → R, and 4R, + R4 → R4 X2 X3 S2 S3 P [o 1/2 7/2 1 -3/2 0 0|11]11+(1/2) = 22 1/2 1/2 0 o 0| 4 4+ (1/2) = 8 X|1 s3 0 {1/2} 3/2 0 -1/2 1 0 3 3-(1/2) = 6 P0 (-1) o 0 X1 enters to become a basic variable, s2 exits to become a nonbasic variable (pivot column identifies the entering variable and pivot row identifies the exiting variable) 1/2 2 0 1 16 R, + R¸ → R, Row Operations: 2R, → R, and R3 + R2 → R, R, + R, → R4 S3 P 1 -1 -1 0 -1 0 X, X2 X3 S, S2 S0 0 Final Tableau x, 1 0 -1 0 2 8 1 1 2 0 6 2 1 22 X2 0 1 3 0 -1 PO 0 3 0 1 X2 enters to become a basic variable, s3 exits to become a nonbasic variable…
Opunul Corporation has two manufacturing departments--Molding and Finishing. The company used the following data at the beginning of the year to calculate predetermined overhead rates: Molding 6,500 $ 29,000 Finishing Total Estimated total machine-hours (MHs) 3,500 10,000 Estimated total fixed manufacturing overhead cost $ 6,000 $ 35,000 Estimated variable manufacturing overhead cost per MH 2$ 2.50 2$ 5.00 During the most recent month, the company started and completed two jobs-Job A and Job M. There were no beginning Inventories. Data concerning those two Jobs follow: Job A Job M Direct materials $17,200 $24,100 2,500 2,500 $10,900 $10,600 4,000 1,000 Direct labor cost Molding machine-hours Finishing machine-hours Assume that the company uses a plantwide predetermined manufacturing overhead rate based on machine-hours and uses a markup of 20% on manufacturing cost to establish selling prices. The calculated selling price for Job A is closest to: (Round your Intermedlate calculatlons…
No chatgpt used i will give 5 upvotes typing please
Describe what is meant by the assumption of linear programming?
Show that, simplex method provides a better solution in each iteration compared to its previous iteration in terms of optimization.
PLEASE USE SIMPLEX METHOD. Thank you! Suppose a company manufactures different electronic components for computers. Component A requires 2 hours of fabrication and an hour of assembly. Component B requires 3 hours of fabrication and an hour of assembly, and component C requires 2 hours of fabrication and 2 hours of assembly. The company has upto 1,000 labor-hours for fabrication, 800 labor-hours of assembly time each work. If the profit on each component A, B, and C is $7, $8, and $10 respectively, how many of each should be produced to maximize profit?
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…
WhAt is Integer Linear Optimization and how it is solved?
(Linear Objective Function and Optimization Application) On a special occasion, renowned electronic giant retailer Best Buy sold a variety of TVs at a discounted prices or on huge sales. Task-1: Write down an appropriate equation for the net profit function, P in order to account for the net profit made by Best Buy after selling: (i) x-number of televisions (TVs) that made $250 profit on the sale of each SONY TVs (ii) y-number of televisions that made $10,500 profit on the sale of each PHILIP TVs respectively, in that event. Task-2: Profit margin, P as discussed in Task-1 was subject to the following constraints applied to the products. a. Maximum cost price was $5000 to manufacture each piece of SONY TVs and $10,000 to manufacture each piece of PHILIP TVs respectively. All TVs were manufactured at a maximum cost of $10 x106 as given in Plot No 1: Plot No. 1: ($5000 x + $ 10000y) ≤ $10 million; Graph the Plot No. 1 up to the scale in a paper. b. 10 and 150 employees worked to…
The Mechanical Engineering department has a student team that is designing a formula car for national competition. The time required for the team to assemble the first car is 100 hours. Their improvement (or learning rate) is 0.8, which means that as output is doubled, their time to assemble a car is reduced by 20%. Use this information to determine: the time it will take the team to assemble the 10th car. Create an excel spreadsheet having the following table. You must show the formula used in the excel sheets to calculate values in the columns. Plot Number of Units vs Time (in hours) and Number of Units vs Cumulative Time (in hours) in the same plot. Use different colors to distinguish the data.
What is the difference between the analysis space and design space in an optimization process?