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.
WRITE THIS ESSAY FOR ME
Tell us about your assignment and we will find the best writer for your paper.
Get Help Now!| 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 | |
Introducing our Online Essay Writing Services Agency, where you can confidently place orders for a wide range of academic assignments. Our reputable homework writing company specializes in crafting essays, term papers, research papers, capstone projects, movie reviews, presentations, annotated bibliographies, reaction papers, research proposals, discussions, and various other assignments. Rest assured, our content is guaranteed to be 100% original, as every piece is meticulously written from scratch. Say goodbye to concerns about plagiarism and trust us to deliver authentic and high-quality work.
WRITE MY ESSAY NOW
