PRAC #1 (cont'd)
1.
Enter the following
data into a spreadsheet
|
CELL |
FORMULA |
COMMENT/FORMATTING |
|
B5 |
|
Format
as currency |
|
B9 |
=$B$3 |
Copies
number of workers available |
|
B10 |
=IF(B9>1,B9-1,0 |
Decides
if one less worker can be used. Copies to cell B11:B18 |
|
C9 |
=IF(B9>0,INT($B$2/$B$4/B9+1),0) |
Calculates
full days needed. Copy to cells C10:C18) |
|
D9 |
=IF(B9>0,B9*C9*$B$4*$B$5,0) |
Calculates
wages for full days used. Copy to cells D10:D18. Format as currency |
5. Use inputs 100 hours then
try inputs
6 employees of your
own
7 hours per
day
$20 per hour