Please answer!!
A B C D E F G H 1 J K L M Input Section Verification: Total Rental Cost $ 1,200.00 Number of Nights 3 Rental Per Night 400.00 Base Night Person 30.00 Enter Yes if staying that night: Cost Per Night Per Person B Name Thursday Friday Saturday Sunday Thursday Friday Saturday Sunday Additional Totals 9 Kyle Peterson Yes Yes Yes Yes #DIV/01 $ 30.00 $ 30.00 $ 30.00 #DIV/0! #DIV/0! 10 lan Matheson Yes Yes Yes Yes #DIV/0! $ 30.00 $ 30.00 $ 30.00 #DIV/0 #DIV/01 11 Isaac Pearson Yes Yes Yes Yes #DIV/0! $ 30.00 $ 30.00 $ 30.00 #DIV/0! #DIV/0! 12 Daryl Davenport Yes Yes Yes Yes #VALUE! $ 30.00 $ 30.00 $ 30.00 #DIV/0! #VALUE! 13 Nick Johnson Yes Yes Yes Yes #VALUE! $ 30.00 $ 30.00 30.00 #VALUE! 14 James Wilson Yes Yes Yes $ 30.00 $ 30.00 $ 30.00 $ 90.00 15 Body Rogers Yes Yes Yes $ 30.00 $ 30.00 $ 30.00 90.00 16 Troy Henderson Yes Yes $ 30.00 $ 30.00 $ 60.00 17 Hector Martinez Yes Yes $ 30.00 $ 30.00 $ 60.00 18 Rob Tumer Yes Yes $ 30.00 $ 30.00 $ 60.00 19 20 # Staying 0 0 0 0 0 Totals Short Total Paid 21 Total Paid #DIV/O! $ 210.00 $ 300.00 $ 300.00 #DIV/O! #DIV/O! #DIV/O! 22 Total Cost $ 400.00 $ 400.00 $ 400.00 $ 400.00 $ 23 24 25 Assumptions and Calculation Notes Those who spend Thursday night split the nightly rental cost evenly. 27 Each person pays $30 per night stayed Friday, Saturday, and Sunday. 28 Kyle, lan, Isaac, and Daryl agreed to pay any difference in the total paid and the total rental cost. 29 Cells B20:E20 should count the number of cells containing "Yes" per night. 30 Cells G20:J20 should count the number of cells containing values per night. 31 The two sets of counts should be consistent. 32 Cells G21:J21 should add the total paid per night. G22:J22 should echo the Rental Per Night cost. 33 Cells K21:K22 should total their respective total cells. 34 Cells L9:L12 should contain a logical test to determine if the first four guys will pay any shortfall in amount collected from the entire group. 35 Cell L21 should total the additional amount the four guys paid. Cell M21 should total the total amount paid in column M. 36 The calculated value in cell M21 should be match the total rental value in cell B2, K22, and the sum of K21:L21. 37 38A B C D E F G H K L M N O P Blue Canadian Skies Airlines 2 Aircraft Capacity: 70 Daily Flight Information Flight Info Sunday Monday Tuesday Wednesday Thursday Friday Saturday Flight # Destination # Pass % Full # Pass % Full # Pass % Full # Pass %% Full # Pass % Full # Pass %% Full # Pass % Full 6 4520 YEG 60 65 55 65 62 50 7 3240 YYC 35 57 60 55 425 YDA 50 70 48 66 68 55 345 YMM 69 70 61 66 70 68 67 10 3340 YWG 45 61 64 45 48 66 11 418 YZF 65 67 58 66 55 69 66 12 4526 YYZ 68 70 58 63 70 68 13 300 YXE 70 70 61 70 59 14 322 YOW 70 60 48 65 68 69 15 349 YMX 70 64 67 66 70 55 16 17 Daily Statistics 18 Total # of Passengers 19 Averages 20 Medians 21 Least Full Flights 22 Most Full Flights 23 # of Flights per Day 24 25A B C D m F G H K Townsend Mortgage Company N LU Input Area Today's Date: Pmts Per Year: 12 6 Down Amount Mortgage Rate Per # of Pmt % Date Payoff Loan # House Cost Payment Financed Rate Period Years Periods Financed Financed Year 452786 400,000 $ 80,000 3.625% 25 2011-05-01 453000 350,000 60,000 3.940% 30 2011-11-03 10 453025 175,500 S 30,000 3.550%% 25 2012-04-10 11 452600 265,950 58,000 2.500%% 15 2012-10-14 12 452638 329,750 65,000 3.250% 30 2013-02-04 13 14 Summary Statistics Down Amount 15 Statistics House Cost Payment Financed 16 Total 17 Average 18 Median 19 Lowest 20 Highest 21 # of Mortgages 22
