Calculating the effects of a virtual work program requires making many assumptions about gas prices, commuting distances, productivity gains or losses, and other factors. For this e$-$project, you will create an Excel spreadsheet that models the effects of implementing virtual work for a hypothetical organization.

Download the Excel file called Ch$08\_$VirtualWorkSavingsModel.

$-8-30.$How does the model calculate the gasoline savings per virtual worker per year? Click on cell B$21,$ and press F$2$ to display the variables used in the calculations.

$-8-31.$Using the assumptions in the model, how much would each virtual worker save in gasoline each year?

$-8-32.$If the leadership decides to implement a smaller pilot program in which those eligible work at home just one day every two weeks $(0\mathrm{.}5$ day per week$),$ what would be an employee's average savings on gas per year?

$-8-33.$Add more variables to the model to show:

a$.$ a$.$ Average cost per square foot per year $(\backslash$$$200)$

b$.$ b$.$ Average square foot per person in an office $(80$ square feet$)$

$-8-34.$Add the conclusion "Average cost per office per year," and enter the formula to compute this. What is the average cost per office per year?

$-8-35.$Assume that the company can eliminate an office for every $200$ virtual workdays per year $($regardless of who is not there$).$ Add another conclusion, "Savings in real estate costs per year," and enter the formula that will compute it$.$

a$.$ How much could this organization save in real estate per year if it sticks with one virtual workday per eligible employee per week?

b$.$ How much could this organization save in real estate costs per year if the average number of days per week that employees will work from home goes up to three?