Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Start Time 10:30 AM 11:00 AM 12:00 PM 4:00 PM alul 5:00 PM 6:00 PM End Time 2:00 PM 3:00 PM 4:00 PM 8:00 PM 9:00 PM 10:30 PM Worked Employees 3.5 4 4 4 4 4.5 Employees Scheduled Employees Needed Surplus or (Shortage) Total Hours 2 8 sing Soonorio Manager 2 3 7 3 25 100.50 11:00 1 0 0 0 0 0 2 2 0 12:00 1 1 0 0 0 0 10 6 4 1:00 1 1 1 0 0 0 12 12 0 2:00 1 1 1 0 0 0 12 10 2 3:00 4:00 0 1 1 0 0 0 10 3 7 0 0 1 0 0 0 2 2 0 5:00 0 0 0 1 0 0 3 3 0 9. Keep the Solver Solution by generating an Answer Report. This w sheet titled Answer Report 2 Rename the sheet to Option 2 and chang Green.

Start Time 10:30 AM 11:00 AM 12:00 PM 4:00 PM alul 5:00 PM 6:00 PM End Time 2:00 PM 3:00 PM 4:00 PM 8:00 PM 9:00 PM 10:30 PM Worked Employees 3.5 4 4 4 4 4.5 Employees Scheduled Employees Needed Surplus or (Shortage) Total Hours 2 8 sing Soonorio Manager 2 3 7 3 25 100.50 11:00 1 0 0 0 0 0 2 2 0 12:00 1 1 0 0 0 0 10 6 4 1:00 1 1 1 0 0 0 12 12 0 2:00 1 1 1 0 0 0 12 10 2 3:00 4:00 0 1 1 0 0 0 10 3 7 0 0 1 0 0 0 2 2 0 5:00 0 0 0 1 0 0 3 3 0 9. Keep the Solver Solution by generating an Answer Report. This w sheet titled Answer Report 2 Rename the sheet to Option 2 and chang Green.

Practical Management Science
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
icon
Related questions
Question
Start Time 10:30 AM 11:00 AM 12:00 PM 4:00 PM 5:00 PM 6:00 PM End Time 2:00 PM 3:00 PM 4:00 PM 8:00 PM 9:00 PM 10:30 PM Hours Worked 3.5 4 4 4 4 4.5 ● Employees Scheduled Employees Needed Surplus or (Shortage) ● Total Hours Employees 11:00 2 1 8 0 2 3 7 3 25 100.50 0 0 0 0 2 2 0 12:00 12:00 1:00 2:00 1 1 1 1 0 0 0 0 10 6 4 1 0 0 0 12 12 0 1 1 1 0 0 0 12 10 2 sing Scenario Manager 1. Create a Scenario Summary for the two options: 3:00 0 1 1 0 0 0 4:00 0 0 1 0 0 0 10 2 3 2 7 0 4:00 5:00 0 0 0 1 0 0 3 9. Keep the Solver Solution by generating an Answer Report. This w sheet titled Answer Report 2 Rename the sheet to Option 2 and chang Green. 3 0 a. Name the first scenario as Option 1. b. Use D4:D9 as the changing cells. c. Do not change the values in Scenario Values fields. d. Click OK 6: e. Add another scenario. f. Name it Option 2. g. Use D4:D9 as the changing cells. h. Use the following values for each of the respective fields: • 2 8 2 3 . 7 3 i. Click OK j. Select Option 1 and click the Show Button. k. The total hours should be 100.50. 1. Select Option 2 and click the Show Button. m. The total hours should be 104.50 2. Create a Summary worksheet by clicking on the Summary works 3. Use D11:Q11, D16 for the Results Cells. NOTE, you will need to non-adjacent cell. Use the Ctrl Key for the PC and the Comm the MAC to select that field. 4. A worksheet will be created named Scenario Summary.
Transcribed Image Text:Start Time 10:30 AM 11:00 AM 12:00 PM 4:00 PM 5:00 PM 6:00 PM End Time 2:00 PM 3:00 PM 4:00 PM 8:00 PM 9:00 PM 10:30 PM Hours Worked 3.5 4 4 4 4 4.5 ● Employees Scheduled Employees Needed Surplus or (Shortage) ● Total Hours Employees 11:00 2 1 8 0 2 3 7 3 25 100.50 0 0 0 0 2 2 0 12:00 12:00 1:00 2:00 1 1 1 1 0 0 0 0 10 6 4 1 0 0 0 12 12 0 1 1 1 0 0 0 12 10 2 sing Scenario Manager 1. Create a Scenario Summary for the two options: 3:00 0 1 1 0 0 0 4:00 0 0 1 0 0 0 10 2 3 2 7 0 4:00 5:00 0 0 0 1 0 0 3 9. Keep the Solver Solution by generating an Answer Report. This w sheet titled Answer Report 2 Rename the sheet to Option 2 and chang Green. 3 0 a. Name the first scenario as Option 1. b. Use D4:D9 as the changing cells. c. Do not change the values in Scenario Values fields. d. Click OK 6: e. Add another scenario. f. Name it Option 2. g. Use D4:D9 as the changing cells. h. Use the following values for each of the respective fields: • 2 8 2 3 . 7 3 i. Click OK j. Select Option 1 and click the Show Button. k. The total hours should be 100.50. 1. Select Option 2 and click the Show Button. m. The total hours should be 104.50 2. Create a Summary worksheet by clicking on the Summary works 3. Use D11:Q11, D16 for the Results Cells. NOTE, you will need to non-adjacent cell. Use the Ctrl Key for the PC and the Comm the MAC to select that field. 4. A worksheet will be created named Scenario Summary.
Weekday Work Schedule Servers Hours Start Time End Time Worked Employees 11:00 10:30 AM 3.5 4 11:00 AM 4 4 12:00 PM 4 4 4:00 PM 4 4 5:00 PM 4 4 6:00 PM 4.5 4 2:00 PM 3:00 PM 4:00 PM 8:00 PM 9:00 PM 10:30 PM Employees Scheduled Employees Needed Surplus or (Shortage) Total Hours 24 10:30 11:00 12:00 96.00 1 0 0 0 0 0 4 2 2 - 1 1 0 0 0 0 8 6 2 12:00- 1:00 2:00 3:00 4:00 5:00 6:00-7:00- 3:00 4:00 5:00 6:00 1:00 2:00 1 1 1 0 0 0 12 12 0 1 1 1 0 0 0 12 10 2 0 1 1 0 0 0 8 3 min 5 - 0 1 0 0 0 st 4 2 2 0 0 1 0 0 4 3 1 0 0 0 1 1 0 8 8 0 7:00 8:00 0 0 0 1 1 1 12 12 0 0 0 0 1 1 1 12 12 0 8:00 - 9:00- 9:00 10:00 0 0 0 0 1 1 8 10 -2 0 0 0 0 0 1 4 3 1 10:00 - 10:30 0 0 0 0 0 1 4 2 2
Transcribed Image Text:Weekday Work Schedule Servers Hours Start Time End Time Worked Employees 11:00 10:30 AM 3.5 4 11:00 AM 4 4 12:00 PM 4 4 4:00 PM 4 4 5:00 PM 4 4 6:00 PM 4.5 4 2:00 PM 3:00 PM 4:00 PM 8:00 PM 9:00 PM 10:30 PM Employees Scheduled Employees Needed Surplus or (Shortage) Total Hours 24 10:30 11:00 12:00 96.00 1 0 0 0 0 0 4 2 2 - 1 1 0 0 0 0 8 6 2 12:00- 1:00 2:00 3:00 4:00 5:00 6:00-7:00- 3:00 4:00 5:00 6:00 1:00 2:00 1 1 1 0 0 0 12 12 0 1 1 1 0 0 0 12 10 2 0 1 1 0 0 0 8 3 min 5 - 0 1 0 0 0 st 4 2 2 0 0 1 0 0 4 3 1 0 0 0 1 1 0 8 8 0 7:00 8:00 0 0 0 1 1 1 12 12 0 0 0 0 1 1 1 12 12 0 8:00 - 9:00- 9:00 10:00 0 0 0 0 1 1 8 10 -2 0 0 0 0 0 1 4 3 1 10:00 - 10:30 0 0 0 0 0 1 4 2 2
Expert Solution
steps

Step by step

Solved in 2 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS