Minimum cost-amounts of flour sent from each mill to markets

Assignment Help Operation Management

Reference no: EM13964067

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. 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

Reference no: EM13964067

Questions Cloud

Compute the takt time for service system : Compute the takt time for a service system that intended to perform a standardized service. The system will have a total work time of 539 minutes per day, two 11-minute breaks, and an hour for lunch. The service system must process 74 jobs a day Takt..

What are the intended and unintended consequences of plan : What are the most important considerations for employers as they design compensation and benefits plans that are appealing to employees—and financially viable? Health care organizations are challenged to develop total compensation packages that appea..

Uses kanban cards to authorize movement of incoming parts : A JIT system uses kanban cards to authorize movement of incoming parts. In one portion of the system, a work center uses an average of 87 parts per hour while running. The manager has assigned an inefficiency factor of .28 to the center. Standard con..

Constraint line in a two-decision-variable LP model : If the 2nd constraint line in a two-decision-variable LP model is binding, then which one of the following statements is true?

Minimum cost-amounts of flour sent from each mill to markets : 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 giv..

Each group will develop a plan to train and reinforce skills : Learning and Development Many health care organizations view employee training as falling into two categories: One related to specific knowledge and skills for the individual’s particular job, and the other involving skills and behaviors required of ..

Describe the liability of the partnership : Fran, Joe, and Mike formed a general partnership to operate a flower shop called Fresher Flowers. One of Fran’s jobs is to make deliveries using the partnership truck. In one such delivery, Fran negligently ran a stop sign, striking a car driven by P..

Registered nurse has a full time job at hospital : A Registered Nurse has a full time job at Hospital A, where she works 40 hours per week on five 8-hour shifts. But she has fallen behind on her credit card payments and needs to earn more money. She applies to Nurse Locators, a temporary placement or..

The scatter-graph method : The scatter-graph method

User Account

All Pages