Question
Build an excel spreadsheet for the month using the information below. The spreadsheet should have 1) total payment for the week and month, 2) what
Build an excel spreadsheet for the month using the information below. The spreadsheet should have 1) total payment for the week and month, 2) what we are billing the facility, and 3) profit margins
Anna Pay: reg hours: $205/hr OT: $235/hr (>40 hours/week) Housing: $170/night (nights worked only) FULL MONTH*
Kyle Pay: reg hours: $205/hr OT: $235/hr (>36 hours/week) Housing: $170/night (nights worked only) TWO WEEKS*
facility bill: reg hours $235/hr OT $270/hr Housing $170/night (nights worked only)
What would be the payout if Anna worked a total of 32 hours on week 1, 32 hours on week 2, 32 hours on week 3, and 32 hours on week 4. ?
What would be the pay out if Kyle worked 36.5 hours on week 1 and 37 hours on week 2?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started