XYZ Corporation operates two plants, each of which has a capacity of 180 units per day. Each day, XYZ must ship their product to eachof four customers. Customers A, B, and C each have a demand of 15 units per day while customer D has a demand of 315 units perday. The cost of shipping one unit of each product from each of the two plants to each of the customers is shown in the table below.Customer ACustomer BCustomerCCustomer DPlant 115181019Plant 212161412a. How many units should XYZ ship from each plant to each customer? (Leave no cells blank-be certain to enter "0" whereverrequired. Round your answer to the nearest whole number.)Customer ACustomer BCustomer CCustomer DPlant 1Plant 2b. What is the least XYZ will spend on shipping each day? (Round your answers to 2 decimal places.)Least XYZ< Prev5 of 5Next

Optimization modeling It is a branch of mathematics that aims to find the best solution to a…

Answered: XYZ Corporation operates two plants,…

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

A grocery store has three open checkout counters. There is a single queue leading up to these three counters. On average, 45 shoppers arrive at this queue. The coefficient of variation of the interarrival time is equal to 1. The average service capacity of each of the three servers is 18 customers per hour, and the coefficient of variation of service time distribution for each server is 3. (a) (3 points) What is the percentage decrease in capacity utilization when one more checkout lane is added to the system? (b) (7 points) On average, how many customers are waiting in the queue?
A fast-food restaurant has a drive-thru window and during peak lunch times can handle a maximum of 60 cars per hour with one person taking orders, assembling them, and acting as cashier. The average sale per order is $9.50. A proposal has been made to add two workers and divide the tasks among the three. One will take orders, the second will assemble them, and the third will act as a cashier. With this system, it is estimated that 85 cars per hour can be serviced.
During the campus Spring Fling, the bumper car amusement attraction has a problem of cars becoming disabled and in need of repair. Repair personnel can be hired at the rate of $20 per hour, but they only work as one team. Thus, if one person is hired, he or she works alone; two or three people work together on the same repair. One repairer can fix cars in an average time of 30 minutes. Two repairers take 20 minutes, and three take 15 minutes. While these cars are down, lost income is $40 per hour. Cars tend to break down at the rate of two per hour. Management is trying to decide how many repair persons to hire, and has asked you for cost data. What is the total hourly cost with one repair person? multiple choice $60 $∞ $140 What is the total hourly cost with two repair persons? Note: Round your answer to the nearest dollar amount. What is the total hourly cost with three repair persons? Note: Round your answer to the nearest dollar amount. How many repairers…
A 3 year-old a computer-controlled fabric cutting machine, which had a $25,000 purchasing price, has a current market (trade-in) value of $10,000 and expected O&M costs of $4,000, increasing by 1,000 per year. The machine is required to have an immediate repair that costs $2,000. The estimated market values are expected to decline by 20% annually (going forward). The machine can be used for another 7 years at most. The new machine has a $40,000 purchasing price. The new machine's O&M cost is estimated to be $4,000 for the first year, decreasing at an annual rate of $100 thereafter. The firm's MARR is 10%. Assume a unique minimum AEC(10%) for both machines (both the current and replacement machine). Using the information above, determine the economic service life along with the optimum annual equivalent cost of the defender (This is an infinite Horizon decision problem). a) n=4 and AEC=Between $8,400 and $8,800 b) n=4 and AEC=Between $8,000 and $8,400 c) n=5 and AEC=Between $8,400 and…
Consider the table attached below:Assuming an M/M/1 setup, a service rate of 18 customers every 10 minutes, and a traffic intensity of 0.90.Assume a probability density function characterized by the exponential distribution.i). Compute the corresponding variates.ii). How robust is the above derived density function?
Rollmore, a non-union manufacturing company decides it needs input on improving its work processes and procedures and decides to create employee committees to provide general feedback about things such as work rules and organizational policies and practices in hopes of improving efficiency. Rollmore asks ten employees to serve on such committees. Rollmore asks these employees to bring to their meetings, which include management representatives, concerns and ideas from their coworkers. Rollmore schedules these committees to meet once a month for two hours and provides lunch and a conference room for the participants. Are these employee committees legal or illegal? Why or why not?

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