Spreadsheet and Essay Help

profiledfaert
ch08_virtualworksavingsmodel.xlsx

Virtual Work Analysis

Virtual Work Savings Model
Calculating the Effects of Implementing Virtual Work
Variables
# of FT employees 200
% of employees who will be eligible for virtual work (percent) 50%
Average number of days per week employees will work from home 1
Approximate number of work weeks per year 49
Average miles for commute (both ways) 30
Price of gasoline/per gallon $ 2.65
Average mile per gallon for employees' vehicles 24
Average cost per commute $ 3.31
Conclusions
Number of virtual workers 100
Number of virtual workdays per virtual worker 49
Total number of employee virtual workdays 4,900
Number of commuting miles saved per year 147,000
Total savings in gasoline per year $ 16,231
Gasoline savings per virtual worker per year $ 162.31

Sheet3