Question: use excel andor computer softwareqm a the hardrock concrete company...
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|
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).