Office Upd To keep up-to-diate with security updates, fixes, and improvements, choseCheck for Updates 1. Calculating the costs in the "House Financials" sheet 2. Write appropriate formula in the 2 row of columns, Then copy these formulas for all the houses, Calcu late all the required variables as per Table 2 3. Write farmulas for calaing the minimum, maximum, average and standard deviation. In the sheet "House Financials", calculate the minimun, maxirmun, averageand standard deviatian House Stats for the variab es 4. Format all results appropriately (two dec mal places, dollar sien). S. You might want to use the vfreeze pane" option lunder "Window'') to keep set af raw and/or columns visible, and enhance readability, c.g. in the "House Financials sheet, you can freeze calumn A and row 1 the headers) so that you can know what the cells contain as you scroll through the sheet. 3 House Rent Price Hydro Cast(51 Pub, Trans ansl Foot(Mrs) 1200 TABLE 2 INSTRUCTIONS FOR CALCULATION FOR EACH VARIABLE 1500 $1900 1 130 1 230 VARIABLE FORMULA MoNT PAYMENT PriceHydro CostsTransportation Cost Grocery Delivery Cost COST PER SoF TRANSPORTATION Plcase refer to the below 11 House 5 12 Houss De 13 Hausz 10 14 Hous2 11 Monthly Payments/Area GROCERY DELIVERY $1 030 Please refer to the belovw 6 House 13 17 Hause 14 House L3 $1000 1100 The Transportation Costs As a part af their financial repart, les and Jim calculated the expected transportatian costs. After discussion, they found camplex criteria for the transpartatian costs 1. f the time ta school on fuat is lawer than 20 mins, they will commute to schaal on foot. It will cast $0. 2. If the time to school on foot is higher than 30 mins, and the time to school by public transportation is ower than 60, they will commute to school by the public transportation. It will cost $100 for two people MGCR 331-Winter 2015 Poge 3 of TO 3. f the time to school on faat is higher than 30 mins, and the time to school by public transportation is higher than 60, they will commute to school by car. It will cast $500 per a manth for two peaple. Key Parameters House Into House Financials House Report Renovation Reno Lc + Office Upd To keep up-to-diate with security updates, fixes, and improvements, choseCheck for Updates 1. Calculating the costs in the "House Financials" sheet 2. Write appropriate formula in the 2 row of columns, Then copy these formulas for all the houses, Calcu late all the required variables as per Table 2 3. Write farmulas for calaing the minimum, maximum, average and standard deviation. In the sheet "House Financials", calculate the minimun, maxirmun, averageand standard deviatian House Stats for the variab es 4. Format all results appropriately (two dec mal places, dollar sien). S. You might want to use the vfreeze pane" option lunder "Window'') to keep set af raw and/or columns visible, and enhance readability, c.g. in the "House Financials sheet, you can freeze calumn A and row 1 the headers) so that you can know what the cells contain as you scroll through the sheet. 3 House Rent Price Hydro Cast(51 Pub, Trans ansl Foot(Mrs) 1200 TABLE 2 INSTRUCTIONS FOR CALCULATION FOR EACH VARIABLE 1500 $1900 1 130 1 230 VARIABLE FORMULA MoNT PAYMENT PriceHydro CostsTransportation Cost Grocery Delivery Cost COST PER SoF TRANSPORTATION Plcase refer to the below 11 House 5 12 Houss De 13 Hausz 10 14 Hous2 11 Monthly Payments/Area GROCERY DELIVERY $1 030 Please refer to the belovw 6 House 13 17 Hause 14 House L3 $1000 1100 The Transportation Costs As a part af their financial repart, les and Jim calculated the expected transportatian costs. After discussion, they found camplex criteria for the transpartatian costs 1. f the time ta school on fuat is lawer than 20 mins, they will commute to schaal on foot. It will cast $0. 2. If the time to school on foot is higher than 30 mins, and the time to school by public transportation is ower than 60, they will commute to school by the public transportation. It will cost $100 for two people MGCR 331-Winter 2015 Poge 3 of TO 3. f the time to school on faat is higher than 30 mins, and the time to school by public transportation is higher than 60, they will commute to school by car. It will cast $500 per a manth for two peaple. Key Parameters House Into House Financials House Report Renovation Reno Lc +
