Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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:

  1. You have obtained the history of airport passengers for the past 57 months
  2. The number customers at your Caf for the past 57 months
  3. The amount customers have spent in your Caf for the past 57 months
  4. The cost to operate your Caf for the past 57 months

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: James Hall

9th Edition

1305465113, 9781305465114

More Books

Students also viewed these Accounting questions

Question

What background experience do you have?

Answered: 1 week ago