Transportation Models Please Use Excel Solver in an excel document to solve. Please show work

Question 2:The Hardrock Concrete Company has plants in 3 locations an dis currently working on 3 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:Formulate a linear program to determine the least-cost way to meet the requirements. Solve using any computer software

From/To	Proj A	Proj B	Proj C	Capacity
Plant 1	$10	$4	$11	70
Plant 2	$12	$5	$8	50
Plant 3	$9	$7	$6	30
Requirements	40	50	60

Question 4: Roscoe Davis, chairman of a college's business department, has decided to apply a new method in assigning professors to courses next semester. As a criterion for judging who should teach each course, Professor Davis reviews the past two years' teaching evaluations (which were filled out by students). Since each of the 4 professors taught each of the 4 courses at one time or another during the 2-year period. Davis is able to record a course rating for each instructor. These ratings are shown in the following table. Find the best assignment of professors to courses to maximize the overall teaching rating.

Professor	Statistics	Management	Finance	Econ
Ander	90	65	95	40
Sween	70	60	80	75
Williams	85	40	80	60
McKinnney	55	80	65	55