13. A large manufacturing company is closing three of its existing plants and intends to transfer someof its more skilled employees to three plants that will remain open. The number of employeesavailable for transfer from each closing plant is as follows:Closing Plant123TotalTransferableEmployeesOpen PlantsABCTotal6010570235The following number of employees can be accommodated at the three plants remaining open:EmployeesDemanded459035170 Each transferred employee will increase product output per day at each plant, as shown in thefollowing table:ToFrom A15213107(employees)B896C6128The company wants to transfer employees to ensure the maximum increase in product output.Solve this problem by using the computer.

The above question is of allocation problem. It can be solved using the following way

Answered: The company wants to transfer employees…

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

i need answer please asap
A manufacturing system is used to produce a product.Each unit of product must be processed sequentially through workstations.V -----> W -----> X -----> Y The processing time on each workstation are as follows:Workstation V, 11 minutes per unit,Workstation W, 6 minutes per unit,Workstation X, 19 minutes per unit,Workstation Y, 19 minutes per unit. The raw material is always available in the front of workstation V. The manufacturing system can produce __________ units in 27 hours. Use at least 4 decimals.You must show your calculation steps and brief explanation on your Excel spreadsheets.
The first station can process a unit in 10 minutes First Station capacity = 60/10 = 6 units per hour As the second station has 2 identical machines in parallel, each of which can process a unit in 12 minutes. Each unit needs to be processed on one of the two machines. Second Station Capacity = 60 x 2/12 = 10 units per hour The third station can process a unit in 8 minutes Third Station capacity = 60/8 = 7.5 units per hour What is the hourly capacity of this production line?
Recently, while eating lunch with your family at a local cafeteria, you observe a practice that is somewhat unusual. As you reach the end of the cafeteria line, an adding machine operator asks how many persons are in your party. He then totals the food purchase on the trays for all of your family and writes the number of persons included in the group on the adding machine tape. He hands you the tape and asks you to pay when you finish eating. Near the end of the meal, you decide you want a piece of pie and coffee so you return to the line, select your food, and again go through the line. The adding machine operator goes through the same procedures, but this time he staples the second tape to the original and returns it to you. When you leave the cafeteria, you hand the stapled adding machine tapes to the cash register operator, who totals the two tapes, takes your money, and puts the tapes on a spindle. a. What internal controls has the cafeteria instituted for its operations? b. How…
A custom motor cycle shop is experiencing high demand from its customers for its services. The owner performs all tasks relating to customization. Assume each customer brings one motor cycle for customization. The owner needs to determine if he needs to add more help to meet customer demand. A week has 40 hours (maximum amount of time available for the owner to work) . The maximum number of customizations that can be done per week is 8 bikes ( if there is no wasted time ). The following is the data collected from observations for a typical week: Every Friday the shop is cleaned by the owner. This takes 5 hours 15 % of the customization needs rework which takes 75 % more time than regular customization 15 % of the customers will be called by the owner to reschedule completion by the owner. This takes 2 hours per customer. Determine OEE. How should the owner handle the business ? Show all formulas, calculations and results.
Neil and Joan a brother and sister duo own a small dry cleaning business NeJoWe Cleaners. It provides several services to its customers. They currently have 5 locations across the capital city, with the sixth location being that of the main office where most of the cleaning and laundry is carried out. NeJoWe believe that personal contact with customers, operational efficiency, fast and quality work has given them the edge in building the business. A key feature of their customer service is soliciting feedback from customers about their service quality, this they were able to do in person on their daily deliveries as one or the other travelled around to each location on a daily basis. These trips would also give them the opportunity to physically check on what was happening in each location and have formal and informal talks with the staff. However, a number of issues are emerging for the young entrepreneurs, there is a city-wide water shortage and water lock-off therefore, the laundry…
The maintenance department of an Oil and Gas Company has 6 large drilling equipment waiting for repairs. These are labelled A, B, C, D, E and F. The respective repair times (in days) and the remaining days before the due date are given in the table below.
The Mechanical Engineering department has a student team that is designing a formula car for national competition. The time required for the team to assemble the first car is 100 hours. Their improvement (or learning rate) is 0.8, which means that as output is doubled, their time to assemble a car is reduced by 20%. Use this information to determine: the time it will take the team to assemble the 10th car. Create an excel spreadsheet having the following table. You must show the formula used in the excel sheets to calculate values in the columns. Plot Number of Units vs Time (in hours) and Number of Units vs Cumulative Time (in hours) in the same plot. Use different colors to distinguish the data.

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

The company wants to transfer employees to ensure the maximum increase in product output. Solve this problem by using the computer.