Analyzing Restaurant Performance Across Regions in Australia

The analysis reveals that Tasmanian restaurants underperform due to limited infrastructure and fewer establishments, rather than poor operational efficiency. The study highlights the importance of enhancing service quality over relying solely on advertisements for success. For Tasmania's growth, increasing both restaurant numbers and capacity is crucial. Additionally, a deeper evaluation method beyond revenue generation could offer more comprehensive insights into regional restaurant performance.

Running head: BUSINESS INFORMATION SYSTEM
Business Information System
Name of the Student:
Name of the University:
Author’s Note:

1BUSINESS INFORMATION SYSTEMS
Introduction:
The case that has been provided in the question is that Feastive restaurant is a full
service casual themed restaurant across Australia. Being the vice operational president of the
restaurant, it has been asked to provide an analysis in regards to the performance of the
restaurant. The analysis has been carried out with the help of the spreadsheets. The utilization
of the spreadsheets for carrying out the essential performance report of the restaurant has
proved to be quite efficient. The computations like the average annual sales and average
restaurant age has been easy to calculate due to the facilitation of the different mathematical
functions by the spreadsheets.
Summary Report:
Summary by Area:
Victor
ia
NSW
Queen
sland
SA WA NT
Tasma
nia
ACT
Total Annual
Sales
$
7,61,6
8,595
$
12,27,
20,339
$
5,10,3
3,306
$
4,41,1
8,238
$
3,88,9
4,552
$
1,28,7
1,940
$
1,07,1
3,373
$
1,44,6
5,808
Total number of
Seats 7373 11043 5038 4208 4173 1374 1187 1425
Average Annual
Sales
$
21,76,
246
$
23,15,
478
$
21,26,
388
$
21,00,
868
$
18,52,
122
$
18,38,
849
$
17,85,
562
$
20,66,
544
Average
Restaurant Age
31.4 32.0 31.8 33.2 31.9 27.1 29.1 30.6

2BUSINESS INFORMATION SYSTEMS
(years)
Total number of
Restaurants 35 53 24 21 21 7 6 7
Total number of
advertising
Restaurants 32 43 18 19 13 3 4 6
Summary by Area:
City Metro Country
Total Annual Sales
$
6,32,86,529
$
12,81,57,025
$
17,95,42,597
Total number of Seats 6014 11663 18144
Average Annual Sales
$
21,82,294
$
22,48,369
$
20,40,257
Average Restaurant Age (years) 31.6 31.5 31.7
Total number of Restaurants 29 57 88
Total number of advertising Restaurants 20 47 71
Summary by Restaurant Size:
Small Medium Large Huge
Total Annual Sales $ $ $ $

3BUSINESS INFORMATION SYSTEMS
19,38,327 12,71,41,957 21,31,69,307 2,87,36,560
Total number of Seats 411 15140 18473 1797
Average Annual Sales
$
6,46,109
$
17,41,671
$
23,95,161
$
31,92,951
Average Restaurant Age (years) 30.7 31.3 31.8 32.2
Total number of Restaurants 3 73 89 9
Total number of advertising
Restaurants 1 51 79 7
Outcomes of the Analysis:
Q.4
Sum of Annual
Sales ($)
Column
Labels
Row Labels ACT NSW NT QLD SA TAS VIC WA
Grand
Total
Large 7026183
88690
004
4226
406
26621
643
18486
064
5022
000
43213
638
19883
369
213169
307
Grand Total 7026183
88690
004
4226
406
26621
643
18486
064
5022
000
43213
638
19883
369
213169
307
The region, which has the highest ‘Annual Sales’ for ‘Large’ size restaurants is NSW.
Highest Sales by Region Column Labels
Row Labels NSW Grand Total
Large 88690004 88690004
Grand Total 88690004 88690004
The region, which has the lowest ‘Annual Sales’ for ‘Large’ size restaurants is NT
Lowest Sales by Region Column Labels

4BUSINESS INFORMATION SYSTEMS
Row Labels NT Grand Total
Large 4226406 4226406
Grand Total 4226406 4226406
The region, which has the best ‘Average Profit’ for ‘Small’ size restaurant is TAS
Average of Profit ($) Column Labels
Row Labels TAS WA Grand Total
Small 114786.0575 220922.13 185543.4392
Grand Total 114786.0575 220922.13 185543.4392
The region, which has the worst ‘Average Profit’ for ‘Small’ size restaurant is WA
Average of Profit ($) Column Labels
Row Labels TAS WA Grand Total
Small 114786.0575 220922.13 185543.4392
Grand Total 114786.0575 220922.13 185543.4392
The area, which has the lowest Profit per square meter for ‘Medium’ size restaurant is
Country
Row Labels Max of Profit per square metre ($)
Small 45.60431367
Country 45.60431367
Metro 37.59114904
Grand Total 45.60431367
The area, which has the highest Profit per square meter for ‘Medium’ size restaurant
is Metro
Row Labels Min of Profit per square metre ($)
Small 35.9882448
Country 45.60431367
Metro 35.9882448
Grand Total 35.9882448

5BUSINESS INFORMATION SYSTEMS
The total number of seats for ‘Medium’ size restaurant in the region with the highest
total ‘Annual Sales’ is VIC
Q.4.g:
Column Labels
Sum of Annual
Sales ($)
Sum of Seats per
Restaurant
Total Sum of
Annual Sales ($)
Total Sum of Seats per
Restaurant
Row
Labels Medium Medium
VIC 26289778 3217 26289778 3217
Grand
Total 26289778 3217 26289778 3217
The average floorspace for ‘Huge’ size restaurants in the region with highest ‘Annual
Sales’ is NSW
Q.4.h:
Column
Labels
Huge
Total Max of
Annual Sales ($)
Total Average of Square
Metres per Restaurant
Row
Labels
Max of Annual
Sales ($)
Average of Square Metres per
Restaurant
NSW 3579194 5955 3579194 5955
Grand
Total 3579194 5955 3579194 5955
The restaurant with the best 'Annual Sales' at the worst region is Hobart Harbourside
Q.4.i:
Sum of Annual Sales ($) Column Labels
Row Labels TAS Grand Total
Hobart Harbourside 2637013 2637013
Grand Total 2637013 2637013
The restaurant with the worst 'Annual Sales' in the best region is Richmond
Q.4.j:
Row Labels Sum of Profit ($) Sum of Annual Sales ($)
NSW 26753285.29 122720339
Richmond 306818.19 1461039
Dubbo 251030.60 1540065
Bankstown 402222.60 1547010
Nowra 323828.40 1619142
Albury 364798.50 1658175

6BUSINESS INFORMATION SYSTEMS
Camden 436447.96 1678646
Broken Hill 297391.37 1749361
Orange 297841.53 1752009
Hornsby 412672.44 1794228
Watsons Bay 379042.23 1804963
Kiama 317467.18 1867454
Wagga Wagga 412701.30 1875915
Newcastle Beach 355044.89 1983491
Coogee 496857.75 1987431
Cronulla 505681.50 2022726
Batesmans Bay 426529.74 2031094
Armidale 431104.09 2062699
Palm Beach 549049.02 2111727
Campbelltown 550907.50 2118875
Grafton 335401.29 2122793
Bathhurst 444890.78 2128664
Griffith 472267.40 2146670
Bondi Junction 513988.38 2150579
Forbes 444820.91 2191236
Leeton 372365.62 2216462
Sydney City George Street 342472.95 2283153
Cootamundra 457518.80 2287594
Surry Hills 573485.00 2293940
North Sydney 577421.28 2405922
Randwick 607321.25 2429285
Lismore 415501.61 2429834
Sutherland 633860.24 2437924
Wollongong 512907.57 2442417
Bondi Beach 590640.96 2461004
Sydney City Darling Harbour 386086.13 2467004
Hurstville 605403.58 2471035
Newcastle City 473522.99 2485685
Penrith Riverfront 635595.84 2604901
Yass 508705.08 2608744
Chatwswood 637132.13 2627349
Narooma 486162.77 2671224
Sydenham 655231.44 2730131
Manly 707732.50 2830930
Blacktown 711694.81 2863963
North Sydney Bridge 690797.52 2878323
Penrith 695487.68 2885841
Ryde 699538.66 2926940
Parramatta City 721540.93 2945065
Sydney City Wooloomooloo 511696.44 2949259
Parramatta Racecourse 727407.94 2969012
Sydney City Circular Quay 543803.22 3021129
Byron Bay 684438.26 3111083
Pymble 859006.56 3579194
Grand Total 26753285.29 122720339
The restaurant with the lowest 'Age' in the highest ‘Annual Sales’ area is Bondi Beach

7BUSINESS INFORMATION SYSTEMS
Row Labels
Sum of Annual Sales
($)
Sum of Restaurant Age
(years)

8BUSINESS INFORMATION SYSTEMS
NSW 122720339 1695.805613
Bondi Beach 2461004 28.61875428
Hornsby 1794228 28.89801506
Blacktown 2863963 28.92539357
Palm Beach 2111727 29.02121834
Manly 2830930 29.02121834
Wollongong 2442417 29.30595483
Campbelltown 2118875 29.42368241
Chatwswood 2627349 29.44284736
Cronulla 2022726 29.57700205
Bankstown 1547010 29.57700205
Hurstville 2471035 29.74948665
Richmond 1461039 29.86173854
Sydney City Darling Harbour 2467004 29.94113621
Albury 1658175 29.99863107
Sydney City George Street 2283153 30.01779603
Watsons Bay 1804963 30.19028063
Camden 1678646 30.2477755
Coogee 1987431 30.72689938
Narooma 2671224 31.12936345
Ryde 2926940 31.12936345
Lismore 2429834 31.18685832
North Sydney 2405922 31.20602327
Penrith 2885841 31.321013
Grafton 2122793 31.35934292
Randwick 2429285 31.37850787
Sydney City Circular Quay 3021129 31.57015743
Byron Bay 3111083 31.60848734
Batesmans Bay 2031094 31.62765229
Leeton 2216462 31.78097194
Bondi Junction 2150579 31.8384668
Bathhurst 2128664 32.10677618
Kiama 1867454 32.18069815
Sydenham 2730131 32.20260096
Newcastle City 2485685 32.37508556
Armidale 2062699 32.58590007
Surry Hills 2293940 32.79123888
Sutherland 2437924 32.85420945
Yass 2608744 32.91170431
Broken Hill 1749361 33.00752909
Wagga Wagga 1875915 33.10335387
North Sydney Bridge 2878323 33.12251882
Newcastle Beach 1983491 33.18275154
Parramatta City 2945065 33.29774127
Parramatta Racecourse 2969012 33.40999316
Penrith Riverfront 2604901 33.96577687
Pymble 3579194 34.65297741
Orange 1752009 34.71868583
Forbes 2191236 34.85831622
Cootamundra 2287594 35.10746064
Griffith 2146670 37.44832307
Dubbo 1540065 38.13552361
Sydney City Wooloomooloo 2949259 38.68856947
Nowra 1619142 39.41683778

9BUSINESS INFORMATION SYSTEMS
Grand Total 122720339 1695.805613
The restaurant with the highest 'Age' in the lowest ‘Annual Sales’ area is Launceston
Row Labels
Sum of Annual Sales
($)
Sum of Restaurant Age
(years)
TAS 10713373 174.3052704
Launceston 1789855 35.18685832
Hobart City 1469960 30.80355921
Burnie 1832153 30.64750171
Hobart Harbourside 2637013 29.65366188
Richmond 2384987 29.61533196
Strahan 599405 18.39835729
Grand Total 10713373 174.3052704
The most profitable restaurant with no advertising expenditure is Broome
Row Labels
Sum of Advertising
(% sales) Sum of Profit ($)
Broome 0 729221.82
Byron Bay 0 684438.26
Sutherland 0 633860.24
Sunshine Coast Beach 0 557419.52
Campbelltown 0 550907.50
Palm Beach 0 549049.02
Sydney City Circular Quay 0 543803.22
Geelong City 0 534801.54
Darwin Beach 0 506220.84
Alice Springs City 0 504555.60
Rockhampton 0 501454.08
North Canberra 0 493476.51
Melbourne City West 0 488491.68
Port Hedland 0 477080.16
Griffith 0 472267.40
Bundaberg 0 471578.40
Katherine 0 467517.78
Geraldton 0 448471.37
Camden 0 436447.96
Mt Gambier 0 433445.58
Wagga Wagga 0 412701.30
Cairns 0 410646.24
Ballarat 0 406657.44
Perth City River 0 404207.50
Bankstown 0 402222.60
Perth City North 0 372684.75
Albury 0 364798.50
Brisbane City 0 362357.20
Launceston 0 357971.00
Port Pirie 0 350563.70

10BUSINESS INFORMATION SYSTEMS
Gold Coast Esplanade 0 335093.76
Perth City East 0 311925.00
Hobart City 0 293992.00
Darwin City 0 280516.95
Joondalup 0 225734.85
Manjimup 0 216109.41
Grand Total 0 15992690.67
The least profitable restaurant with no advertising expenditure is Manjimup
Q.4.n:
Row Labels
Sum of Advertising (%
sales) Sum of Profit ($)
Manjimup 0 216109.41
Joondalup 0 225734.85
Darwin City 0 280516.95
Hobart City 0 293992.00
Perth City East 0 311925.00
Gold Coast Esplanade 0 335093.76
Port Pirie 0 350563.70
Launceston 0 357971.00
Brisbane City 0 362357.20
Albury 0 364798.50
Perth City North 0 372684.75
Bankstown 0 402222.60
Perth City River 0 404207.50
Ballarat 0 406657.44
Cairns 0 410646.24
Wagga Wagga 0 412701.30
Mt Gambier 0 433445.58
Camden 0 436447.96
Geraldton 0 448471.37
Katherine 0 467517.78
Bundaberg 0 471578.40
Griffith 0 472267.40
Port Hedland 0 477080.16
Melbourne City West 0 488491.68
North Canberra 0 493476.51
Rockhampton 0 501454.08
Alice Springs City 0 504555.60
Darwin Beach 0 506220.84
Geelong City 0 534801.54
Sydney City Circular Quay 0 543803.22
Palm Beach 0 549049.02
Campbelltown 0 550907.50
Sunshine Coast Beach 0 557419.52
Sutherland 0 633860.24
Byron Bay 0 684438.26
Broome 0 729221.82
Grand Total 0 15992690.67
Recommendation and Conclusion

11BUSINESS INFORMATION SYSTEMS
The analysis that has been conducted by the evaluation of the collected data reveals
the areas or regions where the business restaurant has been doing well and the particular areas
where the revenues earned by the restaurants have not been satisfactory. The different
facilities provided by the spreadsheet have made the entire analytical process easy to execute
and understand. The pivot tables that have been used in the study help in the proper
extraction of the data from a pool of information and facilitate the presentation of the data in
the required format so that it can be interpreted and analyzed by the user efficiently (Bodie,
Kane & Marcus, 2014).
The region that has obtained the highest amount of revenue in terms of sales is NSW.
However, the region that has obtained the lowest amount of revenue in terms of sales is
Tasmania. However, it should be noted here that the total number of seats in the restaurant
that has been placed in NSW is 11043, while the total number of seats in the lowest revenue-
generating restaurant is 1187. This means that the poor performance by the unit in Tasmania
is not only due to the fact that the restaurant in Tasmania has not been functioning efficiently
but also that the infrastructure or the capacity of the restaurant is very less. Thus, in order to
increase the revenue generation by the Tasmanian unit the number of seats should be
increased. Moreover, the number of restaurants in Tasmania has also been the lowest
signifying the fact that the number of restaurants in Tasmania should also increase (Grant,
2016).
Another important observation that arises from the analysis is that the number of
restaurants that engage in advertisements in NSW is 43 out of a total, of 53. However, the
number of advertising restaurants in comparison to the total number of restaurants in the
other regions has been high. This particular phenomenon indicates that the success of the
restaurants do not depend on extensive advertisement campaigns but on the quality service
provided by the facility. It is highly recommended that the business units focus more on the