business information systems course

structions alculating the effects of a virtual work program requires making many assumptions about gas prices, commuting distances; roductivity gains or losses, and other factors. For this e-project, you will create an Excel spreadsheet that models the effects of nplementing virtual work for a hypothetical organization. Download the Excel file called Ch08_VirtualWorkSavingsModel. - 8-30. How does the model calculate the gasoline savings per virtual worker per year? Click on cell B21, and press F2 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.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 ($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? - 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 (regardles5 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 averagenumber of days per week that employees will work from home goes up to three? D Cho8_VirtualWorkSavings. 49.97kat