Assignment 3- LP A+ Start Assignment Due Monday by 11:59pm Points 100 Submitting a file upload Available Mar 2 at 4pm - Mar 7 at 11:59pm 5 days Assignment 3(A)- LP.docx Assignment 3 (B) LP.pdf Pl. answer the Problem given in Assignment 3(A) and Pr. B.25 in Assignment 3 (B). You should upload ONE excel document- the problems should be done on different sheets I should be able to see your formulae on the excel sheet and the solver dialog box must be populated when I open it. Due: Monday, March 7 Assignment 3- Linear Programming Libby Temple Manufacturing has three factories (1, 2, & 3) and three warehouses (A, B, & C). The following table shows the shipping costs between each factory and warehouse, the factory manufacturing capabilities (in thousands) and the warehouse capacities (in thousands). Management would like to keep the warehouses filled to capacity in order to generate demand. a. Write the objective function and the constraint equations. Let Xia= 1000s of units shipped from factory to warehouse A, and so on. b. Solve using Solver You must submit one Excel File. On Sheet 1 you must answer (a) and set up the problem. You must then use Solver to solve it. Once the Solver is executed, you must obtain the Answer Report. Pl. note that when I open your excel file and then solver, the solver dialog box must be populated and I should be able to execute solver. Warehouse A $6 From Factory 1 Factory 2 Factory 3 Capacity Warehouse B $ 5 $ 10 $ 14 12 Warehouse $3 $8 $ 18 5 Production Capability 6 8 10 $ 8 $ 11 7 PROBLEMS 717 .) What is the optimal solution 2) Does the optimal sobition change if the prodit per unit of Xchanges to $4.502 c) What happens if the profit function should have been 53X, $IX,? 1.22 Solve the following linear programming problem pratically Mini 4X, 5X, Subject: X, +24,280 XX,275 Pc B.23 Thompace Distributors packages and distributes industrial supplies. A standard shipment can be packaged in a class A continet, a class container, or a comer A single chis Acontainer yields a profit of a class container, a profit of 5% and classicoterapelit of Sis. Each shipment prepared requires acer tain amount of packing material and certain amount of time Resources Needed per Standard Shipment PALING CLASS Or CONTAINER MATRACONDS) PACKING TIME HOMES ex 3.24 X B.25 Total amount of available each work 130 pounds 24 hours Jason Thompson, head of the firm, must decide the optimal somber of each class of container to pack each week. He is bound by the previously mentioned restrictions but also decides that he must keep his 6 full-time packers emplnyed all 240 hours 6 worx 60 hours each week Formulate and solve this probleming to Using the data from Problem B.7 page 714 and Part a) Determine the range within which the profit contribution of an air conditioner must fall for the current solution to remain optimal b) What is the shadow price for the wiring costi The Denver advertising agency promoting the recen dishwashing detergent wants to get the best expo sure possible for the product within the $100,000 voting badge ceiling placed on it. To do so, the agency needs to decide how much of the budget to spend an each oft effective media (1) televisie spots during the atmoon hour and (2) lages in the city's Sunday newspaper. Each television spot costs $3,000 each Sunday newspaper and costs $1.250. The expected exposure based on industry nating, is 35,000 views for each TV commercial and 20,000 readers for each newspaper advertisement. The agency director, Deborah Kellore knows from experience that it is important to use both media in order to reach the broadest spectrum of potential Broom customers. She decides that at least but no more than 25 television spots should be ordered, and that at least to newspaper de sold be contacter low many times should each of the two medis be used to obtain maximum exposure while staying within the budget? Use the graphical method to solve Libby Temple Manufacturing has three facto 1.2.and) and three watches (A, B, and C). The follow ing table shows the shipping costs between rechy and house, the factory manufacturing capabilities in thousand), and the warehouses in the ans) >> Write the objective function and the constant is option. La XA2.000 of units shipped from factory! to warehouse A, and so on ) Solve by computer TO WA ROWSE WASHION PRODUCTION FROM A CAPABILITY FACTORY 1 $6 55 $) 6 FACTORY 53 STO SK 3 FACTORY $11 514 315 10 CAPACITY 7 12 5 8.26