XYZ Corporation operates two plants, each of which has a capacity of 170 units per day. Each day, XYZ must ship their product to eachof four customers. Customers A, B, and C each have a demand of 12 units per day while customer D has a demand of 304 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 BCustomer CCustomer DPlant 120151424Plant 225252319a. How many units should XYZ ship from each plant to each customer? (Leave no cells blank-be certain to enter "O" whereverrequired. Round your answer to the nearest whole number.)Customer ACustomer BCustomer CCustomer DPlant 1Plant 2 b. What is the least XYZ will spend on shipping each day? (Round your answers to 2 decimal places.)Least XYZ

[A] Customer A Customer B Customer C Customer D Plant 1 12 12 12 134…

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

Rosaliz has been working for ten years in a food and institutional product distribution company that provides services in Puerto Rico and the Caribbean. The company supplies groceries, frozen foods, dairy products, beverages, paper, disposable products and public hygiene items to hotels, restaurants, fast food establishments and public and private institutions. After many years of effort and long hours of work, two years ago she was appointed Sales Manager and, since then, she has been in charge of 15 vendors around the island.Rosaliz holds meetings with the Sales group every Monday at 8:00 a.m. m. In these meetings, the priorities of the week are discussed in terms of sales, delivery routes of purchase orders and particularities that affect customers. She is very dexterous and has shown the ability to deal with all the situations that come her way on a daily basis. After finishing today's meeting, Alan, her supervisor, calls her into the office to discuss various issues related to the…
Solve the question below using the attached excel templates with formulas for renting both slow and fast copies (labeled in the excel tabs). Question: The Decision Sciences Department is trying to determine whether to rent a slow or a fast copier. The department believes that an employee’s time is worth $15 per hour. The slow copier rents for $4 per hour, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15 per hour, and it takes an employee an average of six minutes to complete copying. On average, four employees per hour need to use the copying machine. (Assume the copying times and interarrival times to the copying machine are exponentially distributed.) Which machine should the department rent to minimize expected total cost per hour?
A small-size cargo company in Dubai has been operating since the year 2000. The total workforce comprises ten employees, out of which five are in sales, three are in operations, one is handling legal and accounts matters, and one manager is also the owner of the company. Total annual turnover is enough to run the company smoothly. Recently another director has joined who brought large investment to the company. The Board of directors has decided to expand the business in other cities and establish offices overseas in potential locations. This expansion policy will directly be linked to the new manpower needs. Therefore, the board has decided to open an HR department with one HR manager and three staff to look after HR operations. The new HR manager has noticed that the company has a very convenient way of recording the data, where all transactions are recorded on excel documents. “this may not work in the new setup with many branches around the world”, he mentioned in the BOD meeting.…
A supplier ships goods from Richmond, VA to three market places in 3 cities (Chicago, IL; Athens, GA; St. Luis, MO). The supplier can ship every day, every other day, or every third day. There is a penalty of $0.30/cwt for each day delayed. Consolidating shipments allows for lower transportation costs from larger loads, but incurs penalty costs due to the delay. Transportation Rate (S/cwt) Shipment City Weight/day LTL 50,000 lb 50000 lb Chicago, IL 18,000 lb (180 cwt) 1.50 1.25 Athens, GA 15,000 lb (150 cwt) 1.35 1.00 St. Luis, MO 12,000 lb (120 cwt) 2.00 1.50 Total 45,000 Ib = 450 cwt Find what is the cost for the following: Shipping Every Day Shipping on the alternate Day (every two days) Shipping every three Day
The Dahlia Medical Center has 31 labor rooms, 18 combination labor and delivery rooms, and 5 delivery rooms. All of these facilities operate around the clock. Time spent in labor rooms varies from hours to days, with an average of about a day. The average uncomplicated delivery requires about one hour in the delivery room. The average time in a combination labor-delivery room is about 24 hours. During an exceptionally busy three-day period, 109 healthy babies were born at Dahlia Medical Center. 60 babies were born in separate labor and delivery rooms and 49 were born in combined labor and delivery rooms. Which of the facilities (labor rooms, combination labor and delivery rooms, or delivery rooms) had the greatest utilization rate? had the highest utilization rate of %. (Enter your response as a percent rounded to two decimal places.) The combination labor and delivery rooms labor rooms delivery rooms
The following data relates to the number of passengers the Mussina border post between Zimbabwe and South Africa can process:Maximum passengers that can be processed per day based on all the equipment and personnel = 5000 trucksCurrent number of passengers being processed = 4000 passengers per dayActual number of passengers processed yesterday = 3600Calculate the current utilisation level of the border post passenger processing system A. 18% B. 50% C. 80% D. 72% E. 90%
Solve the question below using the attached excel templates with formulas for renting both slow and fast copies (labeled in the excel tabs). Question: The Decision Sciences Department is trying to determine whether to rent a slow or a fast copier. The department believes that an employee’s time is worth $15 per hour. The slow copier rents for $4 per hour, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15 per hour, and it takes an employee an average of six minutes to complete copying. On average, four employees per hour need to use the copying machine. (Assume the copying times and interarrival times to the copying machine are exponentially distributed.) Which machine should the department rent to minimize expected total cost per hour?
Chris has three different workstations: one for drip coffee, one for espresso drinks, and one to prepare food. During the morning rush, Chris has 5 people working: one person at the drip coffee station, two at the espresso station, and two at the food prep station. These employees are not cross-trained, and thus must stay at their station. On average, it takes the person at the drip coffee station 1 minute to make the coffee. On average, it takes one person working at the espresso station 3 minutes to make one espresso drink. On average, it takes one person working at the food station 4.5 minutes to prepare the food for one customer. The customer mix is as follows. 10% order just a drip coffee, 30% order a drip coffee and food, 35% order just an espresso drink, and 25% order an espresso drink plus food. A total of 40 customers/ hour frequent Chris'. What is the implied utilization at the espresso station? Provide your answer in decimal form, and round to 4 decimal places. (So, if your…
The cost infomation of an old process unit that has a capacity of 5,400 ft'/hr and a total cost of $8,500,000 is used to find the cost of a new unit that has a capacity of 8,500 t'hr. Assuming the total cost of the new unit is $12,000,000 you are required to state: 1. The method and equation that you will use to find that cost, 2. The value of the corresponding factor, 3. Is the value calculated in (2) within the accepted range?
You operate a process with three workstations; the cycle times are given below. A regular batch is 52 units and your production line runs 5 hours per day. Calculate how many hours lead time is required to ship a batch, assuming there are no orders ahead in the queue and there is no inventory to fill the order. Workstation 1 has a cycle time of 2 minutes per unit Workstation 2 has a cycle time of 3 minutes per unit Workstation 3 has a cycle time of 3 minutes per unit Select one: a. 1560.00 b. 8.00 c. 1560.00 d. 90.00 e. 2340.00
The Dahlia Medical Center has 35 labor rooms, 18 combination labor and delivery rooms, and 2 delivery rooms. All of these facilities operate around the clock. Time spent in labor rooms varies from hours to days, with an average of about a day. The average uncomplicated delivery requires about one hour in the delivery room. The average time in a combination labor-delivery room is about 24 hours. During an exceptionally busy three-day period,109 healthy babies were born at Dahlia Medical Center. 57babies were born in separate labor and delivery rooms and 52 were born in combined labor and delivery rooms. Which of the facilities (labor rooms, combination labor and delivery rooms, or delivery rooms) had the greatest utilization rate? The ________________% had the highest utilization rate of_____________% (Enter your response as a percent rounded to two decimal places.)
A bank is trying to determine which of two machinesshould be rented to process checks. Machine 1 rents for$10,000 per year and processes 1,000 checks per hour.Machine 2 rents for $15,000 per year and processes 1,600checks per hour. Assume that the machines work 8 hours aday, 5 days a week, 50 weeks a year. The bank must processan average of 800 checks per hour, and the average checkprocessed is for $100. Assume an annual interest rate of20%. Then determine the cost to the bank (in lost interest)for each hour that a check spends waiting for and undergoingprocessing. Assuming that interarrival times and servicetimes are exponential, which machine should the bank rent?

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