Question: This needs to be solve in MS Excel using spreadsheets. Please help me by solving this asap. Thank you! Forbit Hospital nurses either work 9-hour

This needs to be solve in MS Excel using spreadsheets. Please help me by solving this asap. Thank you!

Forbit Hospital nurses either work 9-hour shifts or 8-hour shifts. Nurses with a 9-hour shift start work at 12 AM, 4 AM, or 8 AM with an hour break at 4 AM, 8 AM, or 12 PM, respectively. Nurses working 8-hour shifts start at either 12 PM or 4 PM and take an hour break at 4 PM or 7 PM, respectively. Forbit Hospital nurses earn $35 an hour. Breaks are unpaid. Nurses are paid an extra $7 per hour for hours worked between 10 PM to 6 AM. For example, a nurse working from 12 AM to 9 AM receives $35 (5 hours x $7) in premium pay. Forbit Hospital must schedule the number of nurses required for each 1- hour-block as shown below. Develop a simplex LP Solver model to determine how the hospital can minimize daily labor costs. Hour Starting At: 12:00 AM 1:00 AM 2:00 AM 3:00 AM 4:00 AM 5:00 AM 6:00 AM 7:00 AM 8:00 AM 9:00 AM 10:00 AM 11:00 AM 12:00 PM 1:00 PM 2:00 PM 3:00 PM 4:00 PM 5:00 PM 6:00 PM 7:00 PM 8:00 PM 9:00 PM 10:00 PM 11:00 PM Required 10 10 10 10 10 20 20 20 20 20 20 20 20 20 20 20 20 20 20 15 15 15 15 15

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

I don't know this question in Excel please help me in solving this 1. (5 points) A hospital in Brampton, Ontario needs to determine how many nurses to hire to cover a 24- hour period. The nurses must...

Why Hospitals Don't Learn from Failures: ORGANIZATIONAL AND PSYCHOLOGICAL DYNAMICS THAT INHIBIT SYSTEM CHANGE Anita L. Tucker Amy C. Edmondson T he importance of hospitals learning from their...

Educating Managers from an Evidence-Based Perspective Author(s): Denise M. Rousseau and Sharon Mccarthy Source: Academy of Management Learning & Education, Vol. 6, No. 1 (Mar., 2007), pp. 84101...

please write the objective + constraint also use excel to solve it using solver. but make sure the length is 12 18 30 45 60 Appendix A. Model A: Cutting Stock Problem (CSP) Decora Accessories...

Computer Organization and Networks Practicals 2021/22 October 9, 2021 Computer Organization and Networks Practicals 2021/22 b68495714b Contents Contents 0 Introduction 3 0.1 Registration . . . . . ....

Classroom Factors, Rational, Classroom Chacteristics, and Instructional Implications For the following paper Plattsmouth is a city located inCass CountyNebraska. Plattsmouth has a 2024 population of...

Please help solve this problem, Part A needs a worst case running time and an explanation on how you found it, B needs you to solve the recurrence relation to determine a function g(n) such that T(n)...

The number of calories K needed each day by a moderately active woman who weighs w pounds, is h inches tall, and is a years old can be estimated by the formula K = 917 + 6(w + h - a). Elaine is...

THIS PROBLEM NEEDS TO BE SOLVE OVER EXCEL KINDLY SHARE RELATED FORMULAS AND WORKING THROUGH FORMULAS. Investment Analysis Measures Bullock Gold Mining Ross, S. A., Westerfield, R. W., & Jordan, B. D....

Problem II Zapperi Blitz is an e - commerce consultant company that develops website platforms that ties up with supply chain management. It has six available consultants and eight client projects...

What is an organizations buying center? Describe the five main buying-center roles that have been identified.

Per capita income for fve western states is shown below Alaska........$44,205 California.......$42,578 Hawaii........$41,661 Oregon........$36,919 Washington.......$36,427 Alaska.........$44,205...

CAG Company is a company that operates to sell famiture. The financial year ends on 31 Dec. At the beginning of August, the beginning balance of accounts receivable is $70,000, which are related to...

What is an example of constructive feedback? provide reference