Some solutions for A04 - A04 Due Saturday 1/31 at midnight...

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

View Full Document Right Arrow Icon
A04 Due Saturday 1/31 at midnight This assignment is worth 20 points. It must be done in your pre-assigned team. 3.22 3.33 4.7 4.10 Please submit work in ONE Excel file. Name your file A04_TeamName. (TeamName is shown in Group Pages folder.) Examples: A04_Blue A04_Maize A04_Red. One submission per team. In the upper left hand corner of the first tab of the Excel file: List the name(s) of each team member. List the percent contributions of each team member. Submissions without names or percent contributions will be scored. However, individual scores will not be assigned until percent contributions are received. 10% reduction per day overdue.
Background image of page 1

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

View Full DocumentRight Arrow Icon
3.22 Oxbridge University Computer Center Student Staffing Wage Maximum work hours by day of week Minimum Operators Rate Mon Tues Wed Thur Fri Hours KC $10.00 6 0 6 0 6 8 DH $10.10 0 6 0 6 0 8 HB $9.90 4 8 4 0 4 8 SC $9.80 5 5 5 0 5 8 KS $10.80 3 0 3 8 0 7 NK $11.30 0 0 0 6 2 7 Operating hours: 8:00 AM - 10:00 PM M-F; Saturday and Sunday operated by regular staff Required: Assign at least one person during weekday operating hours. Wage Scheduled hours Operators Rate Mon Tues Wed Thur Fri Assigned KC $10.00 2 0 3 0 4 9 DH $10.10 0 2 0 6 0 8 HB $9.90 4 7 4 0 4 19 SC $9.80 5 5 5 0 5 20 KS $10.80 3 0 2 2 0 7 NK $11.30 0 0 0 6 1 7 Covered 14 14 14 14 14 = = = = = 14 14 14 14 14
Background image of page 2
Cells Assigned I18:I23 Covered D24:H24 Hourly_rates C6:C11 Max_daily_hours D6:H11 Min_coverage D26:H26 Min_required K18:K23 Schedule D18:H23 Total_wages K26 Minimum Hours >= 8 >= 8 >= 8 >= 8 >= 7 >= 7 #VALUE! Total wages
Background image of page 3

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

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

Page1 / 15

Some solutions for A04 - A04 Due Saturday 1/31 at midnight...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online