Kelly Foods has two plants and ships canned vegetables to customers in four cities. The cost of shipping one case from a plant to a customer is given in the accompanying table. The plant in Akron has a capacity of 3,700 cases per week, and the Evansville plant canproduce 4,200 cases per week. Customer orders for the next week are as follows: Chicago: 1,100 cases; Cincinnati: 1,900 cases; Indianapolis: 2,600 cases; Pittsburgh: 1,300 cases. Find the minimum-cost shipping plan.Click here to view the cost of shipping data.Complete the table below to indicate the number of cases sent from each plant to each customer to minimize the cost, and then give the total cost.(Type integers or decimals. Do not round.)ChicagoPlant/CustomerAkronEvansvilleTotal cost = $||Cincinnati|Indianapolis||■Pittsburgh8||Cost of Shipping DataPlant/Customer ChicagoAkronEvansville$1.67$1.93Cincinnati$2.26$2.32PrintIndianapolis Pittsburgh 0$2.45$2.14$1.64$2.92DoneX

Plant/CustomerChicagoCincinnatiIndianapolisPittsburghCapacityAkron1.672.262.452.143700Evansville1.93…

Answered: Kelly Foods has two plants and ships…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 30 percent capacity cushion is best. Time Standard Demand Forecast Setup (hr/lot) Lot Size Processing (hr/unit) Component Pessimistic Expected Optimistic (units/lot) A 0.05 1.0 50 16,000 16,000 27,000 В 0.30 4.6 80 11,000 12,000 17,000 C 0.05 8.3 100 16,000 23,000 35,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up…
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best. D Demand Forecast Component A B C Time Standard Processing Setup (hr/unit) (hr/lot) 0.04 1.0 0.20 4.4 0.05 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected Optimistic Pessimistic 16,000 10,000 18,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next…
R. C. Coleman distributes a variety of food products that are sold through grocery store and supermarket outlets. The company receives orders directly from the individual outlets, with a typical order requesting the delivery of several cases of anywhere from 20 to 50 different products. Under the company’s current warehouse operation, warehouse clerks dispatch order-picking personnel to fill each order and have the goods moved to the warehouse shipping area Because of the high labor costs and relatively low productivity of hand order picking, management has decided to automate the warehouse operation by installing a computer-controlled order-picking system along with a conveyor system for moving goods from storage to the warehouse shipping area. R. C. Coleman’s director of material management has been named the project manager in charge of the automated warehouse system. After consulting with members of the engineering staff and warehouse management personnel, the director compiled a…
Jingani Pottery Company is a small crafts operation run by a Native American tribal council. The company employs skilled artisans to produce clay bowls and mugs with authentic North American designs and colors. The two primary resources used by the company are special pottery clay and skilled labor. Given these limited resources, the company desires to know how many bowls and mugs to produce each day in order to maximize profit. The two products have the following resource requirements for production and profit per item produced.
A large business process outsourcing company operates 5 days a week (Monday to Friday). The manager estimates that the minimum number of agents requires, a combined on-site and work-from-home (WFH) setup, to provide prompt service: 20 for Monday, 18 for Tuesday, 23 for Wednesday, 28 for Thursday, and 32 for Friday. Labor rules state that each agent must work for 3 days a week on-site. and 2 days in WFH setup. For example. an agent who works on-site Monday to Wednesday must be on WFH setup during Thursday and Friday. Also. the company wants at least 60% of the workforce daily to report on-site. Formulate the appropriate LP model for this problem to minimize the number of agents to be hired.
iEx transports products from their three processing plants directly to three warehouses. The products are processed in plants located in Athlone, Ballinasloe and Cavan. The warehouses are located in Kilkenny, Limerick, and Mayo. In line with the research supporting a shorter working week and higher productivity, the plants and warehouses operate on a FOUR-day week basis. Supply and demand are as follows: Athlone can supply 120 units/week; Ballinasloe can supply 80 units/week; and Cavan can supply 20 units/week. Demand is 60 units/week at Kilkenny, 120 units/week at Limerick and 40 units/week at Mayo. Daily Per unit shipping costs (in Euro) from the processing plants to each of the warehouses are displayed in the table below. To Kilkenny Limerick Mayo From Athlone 4 8 Ballinasloe 6 3 7 Cavan 9 5 Formulate the linear programming model of the iEx transportation problem to minimize the daily total shipping cost.
iEx transports products from their three processing plants directly to three warehouses. The products are processed in plants located in Athlone, Ballinasloe and Cavan. The warehouses are located in Kilkenny, Limerick, and Mayo. In line with the research supporting a shorter working week and higher productivity, the plants and warehouses operate on a FOUR-day week basis. Supply and demand are as follows: Athlone can supply 120 units/week; Ballinasloe can supply 80 units/week; and Cavan can supply 20 units/week. Demand is 60 units/week at Kilkenny, 120 units/week at Limerick and 40 units/week at Mayo. Daily Per unit shipping costs (in Euro) from the processing plants to each of the warehouses are displayed in the table below. To Kilkenny Limerick Мayo From Athlone 4 8 Ballinasloe 6 3 7 Cavan 9 5 2 Show the network representation of the iEx transportation problem to minimize the daily total shipping cost.
A machine shop is tasked with processing five different products in four workstations, and operates 40 hours per week. Part-mix ratios, batch quantities, part routings, machines, servers, and production times are given in the table below for the five part styles produced in the shop. Part production times include an allowance for setup time that is based on the batch quantity for each part style. Production records indicate that the average nonproductive time associated with each operation is 10 hrs. Operation sequence for each part style is in the order of station number. Part styles are identified by letter and stations are identified by number. Determine the average lead time for all four part styles (hours, 2 decimal points). Part style (j) A B D Part mix ( p;) 0.25 0.20 0.10 0.20 0.25 Batch quantity ( Qb) 25 19 19 20 27 Stations (i) Servers ( s;) ТрА (hr) Трв (hr) Трс (hr) Tро (hr) ТРЕ (hr) 1 1 0.27 0.36 0.14 0.17 2 1 0.46 0.45 0.26 0.11 3 1 0.44 0.17 0.17 0.25 4 1 0.28 0.13 0.26…
Jeff Sowing Shop Jeff Sowing Shop was established in 2002 in downtown Kingston. The company currently employs one thousand five hundred (1,500) employees. In order to meet the Christmas demand, the company is considering employing an additional five hundred and fifty (550) workers and establishing a shift system. The first shift will work from 8 a.m. to 3 p.m. and the second shift from 3. p.m. to 11 p.m. Management took a decision not to pay a shift premium but told the workers in a meeting that they will be given a bonus at the end of the year providing the set targets are achieved. The workers were unhappy with the outcome of the meeting and decided to discuss the matter with their trade union. A delegation from the union met with management and the meeting ended in a stalemate. A second meeting was set to resolve the conflict. Prior to that meeting, management met and agreed that their position is right and they are not going to change. At the second meeting, both teams held their…
Assuming the following: Warehouse 1 has outbound goods volume - 2,500 units Warehouse 2 has outbound goods volume - 1,300 units Warehouse 3 has outbound goods volume - 5,000 units Given the assumptions and grid coordinates above, the following: d1x= 200, d2x= 300, d3x= 100, d1y= 50, d2y= 100, d3y= 150 And V1= 2,500, V2= 1,300, V3= 5,000 Which is equal to: Cx= (200 x 2,500) + (300 x 1,300) + (100 x 5,000) / (2,500 + 1,300 + 5,000) = 158 Cy= (50 x 2,500) + (100 x 1,300) + (150 x 5,000) / (2,500 + 1,300 + 5,000) = 114 Use the numerical example set up above to demonstrate how the centre of gravity location technique is used.
Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. What is the objective function? Group of answer choices Max Z = $3AD + $3AE + $4BD + $3BE + $5CD + $3CE + $4DF + $4DG + $4DH + $10EF + $9EG + $8EH Min Z = $3AD + $3AE + $4BD + $3BE + $5CD + $3CE + $4DF + $4DG + $4DH + $10EF + $9EG + $8EH Min Z = $3AD + $3BE + $5CD + $3CE…
Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. Set up the solution in Excel and solve with Solver. What are total costs?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS