ScantronAssignment2-R07-Solutions

# ScantronAssignment2-R07-Solutions - MGMT 3100 HOMEWORK...

This preview shows pages 1–3. 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 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. 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 1 1 > = 6 3 Noon - 4 pm coverage 1 1 1 > = 8 4 4 pm - 8 pm coverage 1 1 1 > = 12 5 8 pm – Midnight coverage 1 1 > = 6 6 8 am – noon Full Timers 1 -2 > = 0 7 Noon - 4 pm Full Timers 1 1 -2 > = 0 8 4 - 8 pm Full Timers 1 1 -2 > = 0 9 8 – midnight Full Timers 1 -2 > = 0 10 Wages per person 11 2 11 2 112 48 48 48 48 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) 14 b) 12 c) 48 d) 112 e) None of the above *Question 3 . What goes in cell B2? a) 1 b) 0 or blank c) SUMPRODUCT (B2:H2,B11:H11) d) 14 e) None of the above *Question 4 . What goes in cell E2? a) 1 b) 0 or blank c) SUMPRODUCT (B2:H2,B11:H11) d) 12 e) None of the above *Question 5 . What goes in cell C2? a) 1 d) 14 2-1

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

View Full Document
b) 0 or blank e) None of the above c) SUMPRODUCT (B2:H2,B11:H11) *Question 6 . What goes in cell F2? a)
This is the end of the preview. Sign up to access the rest of the document.

## This homework help was uploaded on 04/17/2008 for the course MGMT 3100 taught by Professor Camateros during the Winter '08 term at CSU East Bay.

### Page1 / 6

ScantronAssignment2-R07-Solutions - MGMT 3100 HOMEWORK...

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

View Full Document
Ask a homework question - tutors are online