1. Business
  2. Operations Management
  3. use excel andor computer softwareqm a the hardrock concrete company...

Question: use excel andor computer softwareqm a the hardrock concrete company...

Question details

Use Excel and/or Computer Software/QM.

A. The Hardrock Concrete Company has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping cost per truckload of concrete, daily plant capacities, and daily project requirements are provided in the table below.

FROM\TO Project A Project B Project C CAPACITY
PLANT 1 $10 $4 $11 70
PLANT 2 12 5 8 50
PLANT 3 9 7 6 30
REQUIREMENT 40 50 60


REQUIRED:

i. Formulate this as a linear program to determine the least cost way to meet the requirements.
ii. Then Solve the problem using any computer software (and show the total cost).  

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution