BUY ready-to-submit essays - 100% undetectable and plagiarism-free guaranteed!
Note: All our papers are written by real people, not generated by AI. They pass Turnitin, SafeAssign, and LopesWrite
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.
Need Help Writing an Essay?
Tell us about your essay and we will find the best writer for your paper. Thousands of students improved their grades with us.
Write My Essay For Me- 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.
| From Mills | To Markets | Supply (Tons) | ||||
| Market 1 | Market 2 | Market 3 | Market 4 | Market 5 | ||
| Mill 1 | $80 | $70 | $75 | $50 | $40 | 30000 |
| Mill 2 | $60 | $65 | $80 | $70 | $60 | 55000 |
| Mill 3 | $50 | $85 | $60 | $85 | $70 | 45000 |
| Mill 4 | $70 | $55 | $50 | $75 | $85 | 50000 |
| Demand (Tons) | 40000 | 30000 | 25000 | 35000 | 50000 | |
