Question: Please use Microsoft Excel to solve this linear programming. A small company produces two products, I and II, at three facilities, A, B, and C.

Please use "Microsoft Excel" to solve this linear programming.

Please use "Microsoft Excel" to solve this linear

A small company produces two products, I and II, at three facilities, A, B, and C. It has orders for 1200 of product I and 700 of product II. The production capacities and costs per week to operate the three facilities are summarized in the following table. A 200 200 $3000 200 100 $1000 400 100 $4000 II Cost/week How many weeks should each facility operate to fill the company's orders at a minimum cost, and what is the minimum cost? A small company produces two products, I and II, at three facilities, A, B, and C. It has orders for 1200 of product I and 700 of product II. The production capacities and costs per week to operate the three facilities are summarized in the following table. A 200 200 $3000 200 100 $1000 400 100 $4000 II Cost/week How many weeks should each facility operate to fill the company's orders at a minimum cost, and what is the minimum cost

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!