Question: Solve using excel, Please show all functions and formulas used in excel Alfred Muller &Co. produces wheat flour for large bakeries. It has four mills

Solve using excel, Please show all functions and formulas used in excel
Alfred Muller &Co. produces wheat flour for large bakeries. It has four mills and five markets. The capacities of each mill, demands from each market and transportation cost of sending a ton of flour from a mill to a market are given in the table given below. The company seeks to develop a plan to minimize the transportation costs. a) Determine the objective function and constraints. b) Find the minimum cost and the amounts of flour sent from each mill to the markets using Excel Solver. Market 4 $50 From Mills Mill 1 Mill 2 Mill 3 Mill 4 Demand (Tons) Market 1 $80 $60 $50 $70 40000 Market 2 $70 $65 $85 $55 30000 To Markets Market 3 $75 $80 $60 $50 25000 Supply (Tons) 30000 55000 45000 50000 Market 5 $40 $60 $70 $85 50000 $70 $85 $75 35000Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
