{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ScantronAssignment2-R07

ScantronAssignment2-R07 - MGMT 3100 HOMEWORK ASSIGNMENT#2...

This preview shows pages 1–2. Sign up to view the full content.

MGMT 3100 HOMEWORK ASSIGNMENT #2 NOTE1: Questions 1-50 = 2 points each, Questions 51-100 = 10 points each NOTE2: YOU ONLY NEED TO TURN IN YOUR SCANTRONS FOR THIS ONE PROBLEM 1 Consider problem 4.14 in the book (page 154). You need to find the number of full-timers and the number of part-timers in each shift. Hint : You need 7 variables, one for each possible shift: FT1 (full-timers 8-4 shift), FT2 (full-timers noon-8 shift), FT3 (full-timers 4-midnight shift), PT1 (part-timers 8am shift), PT2 (part-timers noon shift), PT3 (part-timers 4pm shift), PT4 (part-timers 8 pm shift). There are also 8 constraints. Use the “1s and 0s” method we will be covering in class. The constraint for the need of two Full-timers for every Part-timer should be set up as: Full-timers >= 2 * Part-timers To solve this problem set-up the Spreadsheet below and answer the following questions A B C D E F G H I J K 1 Schedule FT 1 FT 2 FT 3 PT 1 PT 2 PT 3 PT 4 Totals Needed 2 8 am – Noon coverage > = 6 3 Noon - 4 pm coverage > = 8 4 4 pm - 8 pm coverage > = 12 5 8 pm – Midnight coverage > = 6 6 8 am – noon Full Timers ? 7 Noon - 4 pm Full Timers ? 8 4 - 8 pm Full Timers ? 9 8 – midnight Full Timers ? 10 Wages per person 11 Solution: People on shift 1 1 1 1 1 1 1 *Question 1 . What goes in cell B10? a) 14 b) 12 c) 48 d) 112 e) None of the above *Question 2 . What goes in cell E10? a)

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 6

ScantronAssignment2-R07 - MGMT 3100 HOMEWORK ASSIGNMENT#2...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online