Please show work in excel You are facing a labor strike. You need to redesign schedules accordingly given the fact some workers will not show up for work in the morning. You COO has advised you to work with some data she hasmanaged to collect showing minimum personnel required for different times of the day assuming workers are willing to work extended 9 hours shifts (once in, staff works 9 hours straight). Construct a LPproblem in Tab #8 so you can figure out:a) Minimum amount of employees you will need for each shiftb) These employees are all salary schedule to work 7 hours per day. Therefore, each will be working an extra 2 hours per day at a rate of $50/extra hour. How muchovertime will the hospital pay per day?Minimum StaffShiftNoon to 6PM6PM to MidnightMidnight to 6AM6AM to Noon20015050100

The shifts are of 6 hours and an employee will need to work for 9 hours. If we split the shifts into…

Answered: You are facing a labor strike. You need…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 111P

See similar textbooks

Similar questions

Scheduling is a key to Supply Chain Management. It pertains to establishing the timing of the use of specific resources of an organization. AS an example manufacturers must schedule production, which means developing schedules for workers, equipment, purchases, maintenance and so on. Give the scheduling components for one University and discuss the in detail each requirement. Which do you feel as a student fall short in the scheduling process and why?
Cost-based transfer price is the best transfer price because it is very easy to measure and understand. True or False 4.The use of market price in internal transfers, generally, provides managerial incentive and leads to better overall efficiency in operations. True or False When the selling division has no idle capacity, it is always best to negotiate a transfer price with the buying division if they will profit from the transfer. True or False When a buying division purchases from outside supplier because the minimum transfer price is higher than their maximum transfer price, there is suboptimization, as the entire company could have benefited if the internal transfer occurs. True or False The primary objective of a transfer pricing system/scheme/policy is to motivate segment managers to make decisions that are aligned with the overall goals of the company. True or False Transfer price is the price charged by the supplier to the customer True orFalse
Because of its labor contract, a company must hire enough labor for 100 units ofproduction per week on one shift or 200 units per week on two shifts. It cannot hire,lay off, or assign overtime. During the fourth week, workers will be available fromanother department to work part or all of an extra shift (up to 100 units). There is aplanned shutdown for maintenance in the second week, which will cut production tohalf. Develop a production plan. The opening inventory is 200 units, and the desiredending inventory is 300 units
In your own words, please briefly describe how scheduling in operations management contributes to managing inventories?
A 30,000-seat college football stadium is used 18 times for games, concerts, andgraduation ceremonies. Each event averages four hours and assumes the stadium isfull for each event.The stadium is available 365 days a year from 6 am to midnight. What is stadium(seat) utilization?Can you think of one or two other assets that have such low resource utilization?
In the first week in the game, you received the order from stallion apparel at the beginning of the game for 800 socks and you cut 800 flow units of cotton in 1280 minutes. During the time of 1280 minutes, your work-in-process inventory within the cutting resources was 400.50. What is the flow time?
When demand for future resources is expected to decrease, the company can start to plan ways to shed the capacity so that it will not be burdened with significant excess capacity in future quarters”. • Explain the scenario in the context of Resource Planning. How this will be reflected in Annual Operations plan.
In a one-page paper, list the advantages and disadvantages of using part-time employees to help meet demand.
You are in your last semester of college and have been looking for a job. You have registered with the placement office and posted your résumé online, but the jobs that are available leave a bit to be desired. In one of your classes you overhear a classmate, Max, talking about an interview he had last week. Max said that he really wanted the job but didn’t think his interview went particularly well. He is currently waiting to hear back from the employer. As Max was describing the position, you thought it sounded very interesting, but you wondered if it would be right for you to pursue the position since Max had found it first. Question: If you interview for the job, how would you respond if asked how you heard about the opening?
Suppose there are two inputs in the production function, labor and capital, and these two inputs are perfect substitutes. The existing technology permits one machine to do the work of three workers. The firm wants to produce 100 units of output. Suppose the price of capital is $750 per machine per week. What combination of inputs will the firm use if the weekly salary of each worker is $300? What combination of inputs will the firm use if the weekly salary of each worker is $225? What is the elasticity of labor demand as the wage falls from $300 to $225?
1. Rapid-Lube provides oil changes and lubes. The estimated number of oil changes for April and May are 3,600 and 4,000. Each oil change takes 12 minutes of direct labor. The wage rate is $10 per hour. Overhead is $3,700 per month and $2 per oil change. Budgeted overhead for May is $__________________. Budgeted overhead for April is $__________________. Budgeted direct labor for May is $__________________. Budgeted direct labor for April is $__________________. 2. You have decided to throw a party next weekend for 20 friends. The friends are going to bring health food, so all you have to have available are the drinks. You estimate that, on average, each person will drink four bottles of soft drinks. Three of your friends will drink only natural soda without unneeded color  so Sulo Ginger Ale should work well for them. For the others, you decide to buy Sulo Cola. Before going online, you check the refrigerator  you already have six bottles of Sulo Ginger Ale and 14 of Sulo Cola.…
Show what would happen if this plan were implemented. (If the answer is void please enter 0, do not leave any fields blank.) Plan 1 2 3 4 Number of clients Hour required Regular time hours Undertime hours

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS