ScantronAssignment2-R07

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

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

View Full Document Right Arrow Icon
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)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online