You are the owner of the Airport Caf.You want to make a major cash expenditure (expansion and a completely new kitchen) in 12 months' time and you have researched the situation to help you make a knowledgeable decision.Your work has led you to make the following assumptions:
- You have obtained the history of airport passengers for the past 57 months
- The number customers at your Caf for the past 57 months
- The amount customers have spent in your Caf for the past 57 months
- The cost to operate your Caf for the past 57 months
Airport Passengers Customer Data Airport Customers Date Date Date Passengers Cafe Customers Date Spend Cafe Costs 03/01/13 2,644,539 03/01/13 14.491 03/01/13 $334,763 03/01/13 $218,820 04/01/13 2,359,800 04/01/13 13,180 04/01/13 $236,540 04/01/13 $222,870 05/01/13 2,925,918 05/01/13 12,297 05/01/13 $260,386 05/01/13 $173,341 06/01/13 3,024,973 06/01/13 14,782 06/01/13 $285,138 06/01/13 $189,779 07/01/13 3,177,100 07/01/13 15,792 07/01/13 $264,315 07/01/13 $249,715 08/01/13 3,419,595 08/01/13 14,668 08/01/13 $302,591 08/01/13 $224,639 09/01/13 3,649,702 09/01/13 17,277 09/01/13 $373,779 09/01/13 $234,530 10/01/13 3,650,668 10/01/13 18,631 10/01/13 $383,962 10/01/13 $263,367 11/01/13 3,191,526 11/01/13 15,062 11/01/13 $262,343 11/01/13 $205,852 12/01/13 3,249,428 12/01/13 18,213 12/01/13 $342,214 12/01/13 $257,169 01/01/14 2,971,484 01/01/14 15,234 01/01/14 $328,743 01/01/14 $206,468 02/01/14 3,074,209 02/01/14 17,028 02/01/14 $303,430 02/01/14 $259,277 03/01/14 2,785,466 03/01/14 14,066 03/01/14 $285,988 03/01/14 $255,320 04/01/14 2,515,361 04/01/14 13,692 04/01/14 $273,448 04/01/14 $189,474 05/01/14 3,105,958 05/01/14 14,024 05/01/14 $280,189 05/01/14 $206,720 06/01/14 3,139,059 06/01/14 18,788 06/01/14 $415,995 06/01/14 $280,493 07/01/14 3,380,355 07/01/14 17,810 07/01/14 $393,517 07/01/14 $278,491 08/01/14 3,612,886 08/01/14 14,979 08/01/14 $306,493 08/01/14 $229,533 09/01/14 3,765,824 09/01/14 19,795 09/01/14 $366,270 09/01/14 $312,178 10/01/14 3,771,842 10/01/14 20,449 10/01/14 $363,228 10/01/14 $303,405 11/01/14 3,356,365 11/01/14 18,303 11/01/14 $335,565 11/01/14 $231,429 12/01/14 3,490,100 12/01/14 17,762 12/01/14 $335,106 12/01/14 $237,420 01/01/15 3,163,659 01/01/15 16,155 01/01/15 $337,073 01/01/15 $236,019 02/01/15 3,167,124 02/01/15 16,543 02/01/15 $356,842 02/01/15 $283,579 03/01/15 2,883,810 03/01/15 15,965 03/01/15 $304,549 03/01/15 $297,765 04/01/15 2,610,667 04/01/15 11,827 04/01/15 $194,474 04/01/15 $174,870 05/01/15 3,129,205 05/01/15 14,992 05/01/15 $285,657 05/01/15 $276,934 06/01/15 3,200,527 06/01/15 17,993 06/01/15 $330,273 06/01/15 $256,361 07/01/15 3,547,804 07/01/15 18,821 07/01/15 $384,693 07/01/15 $231,890 08/01/15 3,766,323 08/01/15 22,547 08/01/15 $429,892 08/01/15 $331,845 09/01/15 3,935,589 09/01/15 17,205 09/01/15 $299,114 09/01/15 $275,337 10/01/15 3,917,884 10/01/15 18,210 10/01/15 $411,528 10/01/15 $255,570 11/01/15 3,564,970 11/01/15 16,876 11/01/1: $345,664 11/01/15 $271,291 12/01/15 3,602,455 12/01/15 15,764 12/01/15 $319,294 12/01/15 $207,913 01/01/16 3,326,859 01/01/16 16,365 01/01/16 $306,142 01/01/16 $264,548 02/01/16 3,441,693 02/01/16 20,868 02/01/16 $423,271 02/01/16 $292,665 03/01/16 3,211,600 03/01/16 15,784 03/01/16 $323,368 03/01/16 $214,287 04/01/16 2,998, 119 04/01/16 15,421 04/01/16 $354,638 04/01/16 $252,457 05/01/16 3,472,440 05/01/16 17,861 05/01/16 $359,500 05/01/16 $288,503 06/01/16 3,563,007 06/01/16 16,199 06/01/16 $313,594 06/01/16 $270,109 07/01/16 3,820,570 07/01/16 21,466 07/01/16 $369,328 07/01/16 $328,499 08/01/16 4,107,195 08/01/16 20,308 08/01/16 $348,259 08/01/16 $289,807 09/01/16 4,284,443 09/01/16 19,743 09/01/16 $374,512 09/01/16 $320,629 10/01/16 4,356,216 10/01/16 20,901 10/01/16 $416,852 10/01/16 $292,756 11/01/16 3,819,379 11/01/16 20,713 11/01/16 $465,487 11/01/16 $325,101 12/01/16 3,844,987 12/01/16 17,948 12/01/16 $335,364 12/01/16 $261,130 01/01/17 3,478,890 01/01/17 17,165 01/01/17 $233,390 01/01/17 $238,912 02/01/17 3,443,039 02/01/17 14,833 02/01/17 $328,824 02/01/17 $226,438 03/01/17 3,204,637 03/01/17 15,667 03/01/17 $344,788 03/01/17 $256,608 04/01/17 2,966,477 04/01/17 14,869 04/01/17 $309,291 04/01/17 $220,317 05/01/17 3,593,364 05/01/17 18,708 05/01/17 $376,874 05/01/17 $237,208 06/01/17 3,604,104 06/01/17 17,062 06/01/17 $396,540 06/01/17 $278,334 07/01/17 3,933,016 07/01/17 21.440 07/01/17 $358,707 07/01/17 $278,601 08/01/17 4,146,797 08/01/17 18.849 08/01/17 $321,063 08/01/17 $253,320 09/01/17 4,176,486 09/01/17 21,592 09/01/17 $294,370 09/01/17 $248,752 10/01/17 4,347,059 10/01/17 19,819 10/01/17 $379,068 10/01/17 $325,637 11/30/17 3,781,168 11/30/17 16,212 11/30/17 $337,055 11/30/17 $235,121Airport Passengers Customer Data Airport Customers Date Date Date Passengers Cafe Customers Date Spend Cafe Costs 03/01/13 2,644,539 03/01/13 14.491 03/01/13 $334,763 03/01/13 $218,820 04/01/13 2,359,800 04/01/13 13,180 04/01/13 $236,540 04/01/13 $222,870 05/01/13 2,925,918 05/01/13 12,297 05/01/13 $260,386 05/01/13 $173,341 06/01/13 3,024,973 06/01/13 14,782 06/01/13 $285,138 06/01/13 $189,779 07/01/13 3,177,100 07/01/13 15,792 07/01/13 $264,315 07/01/13 $249,715 08/01/13 3,419,595 08/01/13 14,668 08/01/13 $302,591 08/01/13 $224,639 09/01/13 3,649,702 09/01/13 17,277 09/01/13 $373,779 09/01/13 $234,530 10/01/13 3,650,668 10/01/13 18,631 10/01/13 $383,962 10/01/13 $263,367 11/01/13 3,191,526 11/01/13 15,062 11/01/13 $262,343 11/01/13 $205,852 12/01/13 3,249,428 12/01/13 18,213 12/01/13 $342,214 12/01/13 $257,169 01/01/14 2,971,484 01/01/14 15,234 01/01/14 $328,743 01/01/14 $206,468 02/01/14 3,074,209 02/01/14 17,028 02/01/14 $303,430 02/01/14 $259,277 03/01/14 2,785,466 03/01/14 14,066 03/01/14 $285,988 03/01/14 $255,320 04/01/14 2,515,361 04/01/14 13,692 04/01/14 $273,448 04/01/14 $189,474 05/01/14 3,105,958 05/01/14 14,024 05/01/14 $280,189 05/01/14 $206,720 06/01/14 3,139,059 06/01/14 18,788 06/01/14 $415,995 06/01/14 $280,493 07/01/14 3,380,355 07/01/14 17,810 07/01/14 $393,517 07/01/14 $278,491 08/01/14 3,612,886 08/01/14 14,979 08/01/14 $306,493 08/01/14 $229,533 09/01/14 3,765,824 09/01/14 19,795 09/01/14 $366,270 09/01/14 $312,178 10/01/14 3,771,842 10/01/14 20,449 10/01/14 $363,228 10/01/14 $303,405 11/01/14 3,356,365 11/01/14 18,303 11/01/14 $335,565 11/01/14 $231,429 12/01/14 3,490,100 12/01/14 17,762 12/01/14 $335,106 12/01/14 $237,420 01/01/15 3,163,659 01/01/15 16,155 01/01/15 $337,073 01/01/15 $236,019 02/01/15 3,167,124 02/01/15 16,543 02/01/15 $356,842 02/01/15 $283,579 03/01/15 2,883,810 03/01/15 15,965 03/01/15 $304,549 03/01/15 $297,765 04/01/15 2,610,667 04/01/15 11,827 04/01/15 $194,474 04/01/15 $174,870 05/01/15 3,129,205 05/01/15 14,992 05/01/15 $285,657 05/01/15 $276,934 06/01/15 3,200,527 06/01/15 17,993 06/01/15 $330,273 06/01/15 $256,361 07/01/15 3,547,804 07/01/15 18,821 07/01/15 $384,693 07/01/15 $231,890 08/01/15 3,766,323 08/01/15 22,547 08/01/15 $429,892 08/01/15 $331,845 09/01/15 3,935,589 09/01/15 17,205 09/01/15 $299,114 09/01/15 $275,337 10/01/15 3,917,884 10/01/15 18,210 10/01/15 $411,528 10/01/15 $255,570 11/01/15 3,564,970 11/01/15 16,876 11/01/1: $345,664 11/01/15 $271,291 12/01/15 3,602,455 12/01/15 15,764 12/01/15 $319,294 12/01/15 $207,913 01/01/16 3,326,859 01/01/16 16,365 01/01/16 $306,142 01/01/16 $264,548 02/01/16 3,441,693 02/01/16 20,868 02/01/16 $423,271 02/01/16 $292,665 03/01/16 3,211,600 03/01/16 15,784 03/01/16 $323,368 03/01/16 $214,287 04/01/16 2,998, 119 04/01/16 15,421 04/01/16 $354,638 04/01/16 $252,457 05/01/16 3,472,440 05/01/16 17,861 05/01/16 $359,500 05/01/16 $288,503 06/01/16 3,563,007 06/01/16 16,199 06/01/16 $313,594 06/01/16 $270,109 07/01/16 3,820,570 07/01/16 21,466 07/01/16 $369,328 07/01/16 $328,499 08/01/16 4,107,195 08/01/16 20,308 08/01/16 $348,259 08/01/16 $289,807 09/01/16 4,284,443 09/01/16 19,743 09/01/16 $374,512 09/01/16 $320,629 10/01/16 4,356,216 10/01/16 20,901 10/01/16 $416,852 10/01/16 $292,756 11/01/16 3,819,379 11/01/16 20,713 11/01/16 $465,487 11/01/16 $325,101 12/01/16 3,844,987 12/01/16 17,948 12/01/16 $335,364 12/01/16 $261,130 01/01/17 3,478,890 01/01/17 17,165 01/01/17 $233,390 01/01/17 $238,912 02/01/17 3,443,039 02/01/17 14,833 02/01/17 $328,824 02/01/17 $226,438 03/01/17 3,204,637 03/01/17 15,667 03/01/17 $344,788 03/01/17 $256,608 04/01/17 2,966,477 04/01/17 14,869 04/01/17 $309,291 04/01/17 $220,317 05/01/17 3,593,364 05/01/17 18,708 05/01/17 $376,874 05/01/17 $237,208 06/01/17 3,604,104 06/01/17 17,062 06/01/17 $396,540 06/01/17 $278,334 07/01/17 3,933,016 07/01/17 21.440 07/01/17 $358,707 07/01/17 $278,601 08/01/17 4,146,797 08/01/17 18.849 08/01/17 $321,063 08/01/17 $253,320 09/01/17 4,176,486 09/01/17 21,592 09/01/17 $294,370 09/01/17 $248,752 10/01/17 4,347,059 10/01/17 19,819 10/01/17 $379,068 10/01/17 $325,637 11/30/17 3,781,168 11/30/17 16,212 11/30/17 $337,055 11/30/17 $235,121
