Computer Science and Engineering
Computer Science and Engineering
Excel
part3
Due at 11 a.m. on January 18th, New York time
Strictly according to the requirements of the picture materials, on time to me, strictly according to the time!
Store #
C
lose Open
Week
D
ays
Ends
1
01
00
1
00
1
3
00
8
0
6
00
00
5000 75
0
1
2
.9
2
900 2300
00
9
0
0
2
.8
900
2300 2400 60 10
50
560
900
1
1100
00
25 8 400
700 2200 900 2000
70 5 300
0 33
Wages
| Part-time per hour | $ 8.00 |
| Full-time per hour | $ 12.00 |
| Salaried per year | $ 31,000.00 |
JanitorialCosts
| Cleaning/Janitorial Services | |||
| Cleaned Monthly | Cleaned Weekly | Cleaned Quarterly | |
| Janitorial (per SF) | $ 0.12 | $ 0.025 | $ 0.050 |
MiscData
| Miscellaneous Data | |
| Number of Stores | |
| Part Time (Hrs per week for each Employee) | |
| Full-time (Hrs per week for each Employee) | |
| Weeks per Quarter | |
| Week per Year | |
| Weekdays per Week | |
| Weekend Days per Week | |
| Quarters per Year | |
| Number of Months per Year | |
| Yearly Property Taxes (per SF) | $ 0.20 |
1
2
3
4
5
6
A
B
C
D
Store #
Open
Close
Open
800
1900
1300
900
2300
900
11003
900
2100
1200
11004
900
1700
1100
11005
700
2200
900