Question: Assignment 1 Use Excel & AMPL to solve the following problems. 1. A company has two plants and three warehouses. Plant P can produce at

Assignment 1 Use Excel & AMPL to solve the following problems. 1. A company has two plants and three warehouses. Plant P can produce at most 100 units and Plant P can produce at most 200 units of the same product. The sales potential at Warehouse W1 is 150, 200 at Warehouse W2, and 350 at Warehouse W3. The sales revenue per unit at the warehouses are: $12 in W, $14 in W, and $15 in W3. The cost of manufacturing one unit at P; and shipping it to Wj is given below: Find the optimal production plan. P 1 2 W 8 7 P P W 10 9 W W W3 W3 12 11

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

RIBUTAN ENGINEERING1 At 9 PM on a Friday evening. Orlando Phong was in his office returning e-mails from irate engineers at Ributan Engineering, who were frustrated with the annual engineering PC...

Transshipment Problem. The Macho Nacho Company decides to expand its product line and manufacture a guacamole - lined ski boot. The company has two plants, three warehouses and three customers. The...

-Transportation Model: Solve problem 1 using Excel or AMPL. Submit supporting work. 1. The Childfair Company has three plants producing child push chairs that are to be shipped to four distribution...

1. Use excel solver to solve for different scenarios shown by the questions at the end of the case. 2. You need to submit your work as a report addressing the questions. Assessment C, C+ F D . D D+ C...

A company has two plants, two warehouses, three distribution centers, and six stores. Plant 1 ships to warehouse 1 only, and plant 2 ships to warehouse 2 only. The warehouses ship to all distribution...

Solve using Excel or AMPL , Now handwritten solution please Solve problem 1 using Excel or AMPL. Submit supporting work. 1. The Childfair Company has three plants producing child push chairs that are...

Instructions: use excel solver to resolve the following problems. You are to submit an excel spreadsheetwith the solver modelsand solutions. Problem1:Steelcomanufactures three types of steel at...

Please help on my assignment, Please use excel as the following template. Majestic Mulch and Compost Company (MMCC) YEAR 0 $ $ 3 5,000 6,000 120.00 ### 14.29% 114,320 685,680 24.49% 195,920 489,760...

-Transportation Model: **Please, Show all the Excel steps clearly for this problem. Solve problem 1 using Excel or AMPL. Submit supporting work. 1. The Childfair Company has three plants producing...

Given that Er, t) = Re (Eexpljo]}, derive a method for determining if a wave is LHP and RHP in terms of E(r, t) and a(r, t).

How much can the client deduct on his tax return for the business and what items can he deduct? the equipment is New Commercial HVAC Unit value of the equipment? 55000 4 3D Printers valued at...

Which of the following is not o recognized sanction under antitrust low? Multple Choice Sechre and forfeiture of property owned in restrant of trade if tramporited interstate. Tretie damages payble...

plz solve Q29 in 10 mins i will thumb up Question 29 Niles Co. has the following data related to an item of inventory: Inventory, March 1 100 units @ $4.20 Purchase, March 7 350 units @ $4.40...