Get Instant Help From 5000+ Experts For

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

The results from the Excel worksheets. You need to follow the exact question sequence and copy and paste the necessary analyses (pivot tables, summary tables and graphs) from the Excel file into the report.

i.restaurants, areas and regions which are performing extremely well and/or poorly (if any) and what might be done to improve; and

ii.whether Festive Restaurants should spend more or less on advertising (e.g. in certain areas or regions)?

iii.the types of data quality issues the company might be experiencing from analysis of the provided dataset and how they might be overcome.

Note: you are looking for distinctive features or patterns in the data you have created in order to report meaningfully to Mr Feast. For example, you might consider how restaurants of like-size are performing relative to each other.

## Summary Report

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.

 Victoria NSW Queensland SA WA NT Tasmania ACT Total Annual Sales \$    7,61,68,595 \$   12,27,20,339 \$    5,10,33,306 \$    4,41,18,238 \$    3,88,94,552 \$    1,28,71,940 \$    1,07,13,373 \$    1,44,65,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 (years) 31.4 32.0 31.8 33.2 31.9 27.1 29.1 30.6 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
 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
 Small Medium Large Huge Total Annual Sales \$       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
 Q.4 Sum of Annual Sales (\$) Column Labels Row Labels ACT NSW NT QLD SA TAS VIC WA Grand Total Large 7026183 88690004 4226406 26621643 18486064 5022000 43213638 19883369 213169307 Grand Total 7026183 88690004 4226406 26621643 18486064 5022000 43213638 19883369 213169307
 Highest Sales by Region Column Labels Row Labels NSW Grand Total Large 88690004 88690004 Grand Total 88690004 88690004
 Lowest Sales by Region Column Labels Row Labels NT Grand Total Large 4226406 4226406 Grand Total 4226406 4226406
 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
 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
 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
 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
 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

 Q.4.i: Sum of Annual Sales (\$) Column Labels Row Labels TAS Grand Total Hobart Harbourside 2637013 2637013 Grand Total 2637013 2637013
 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 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

 Row Labels Sum of Annual Sales (\$) Sum of Restaurant Age (years) 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 Grand Total 122720339 1695.805613
 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
 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 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
 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

Conclusion

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 quality of service provided rather than extensive advertisement campaigning by business (Lisboa, Skarmeas & Saridakis, 2016).

However, the restaurants in Tasmania and other relatively low performing units should consider the utilization of the advertising campaigns in order to achieve the fullest utilization of its capacities.

The data quality issue that may arise from this particular analysis project is the availability of a common platform for the evaluation of the performance of the restaurants that belong to different regions. This means that in this study the performance of the restaurants have been analyzed on the basis of the revenue generated. However, increase in the number of restaurants will automatically increase the total revenue that has been derived by the region. On the other hand, the region having less number of restaurants will generate less revenue even if the resources are being optimally utilized. Therefore, a micro looks into the quality aspect of the restaurants belonging to different regions would have strengthened the quality of the results reflected by this report (Takata, 2016).

References

Bodie, Z., Kane, A., & Marcus, A. J. (2014). Investments, 10e. McGraw-Hill Education.

Grant, R.M., 2016. Contemporary strategy analysis: Text and cases edition. John Wiley & Sons.

Lisboa, A., Skarmeas, D., & Saridakis, C. (2016). Entrepreneurial orientation pathways to performance: A fuzzy-set analysis. Journal of business research, 69(4), 1319-1324.

Peregrine, V. G., Popp, J. B., Ishikawa, L., Furtado, J., Michaylov, S., Albright, R. L., ... & Zhu, T. (2015). U.S. Patent No. 9,183,529. Washington, DC: U.S. Patent and Trademark Office.

Pindado, J., & Requejo, I. (2015). Family business performance from a governance perspective: a review of empirical research. International Journal of Management Reviews, 17(3), 279-311.

Prajogo, D. I. (2016). The strategic fit between innovation strategies and business environment in delivering business performance. International Journal of Production Economics, 171, 241-249.

Rosemann, M., & vom Brocke, J. (2015). The six core elements of business process management. In Handbook on business process management 1 (pp. 105-122). Springer Berlin Heidelberg.

Schaltegger, S., & Wagner, M. (Eds.). (2017). Managing the business case for sustainability: The integration of social, environmental and economic performance. Routledge.

Skipworth, H., Godsell, J., Wong, C. Y., Saghiri, S., & Julien, D. (2015). Supply chain alignment for improved business performance: an empirical study. Supply Chain Management: An International Journal, 20(5), 511-533.

Takata, H. (2016). Effects of industry forces, market orientation, and marketing capabilities on business performance: An empirical analysis of Japanese manufacturers from 2009 to 2011. Journal of Business Research, 69(12), 5611-5619.

Cite This Work

"Performance Analysis And Recommendations For Festive Restaurants Essay.." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/itech1005-business-information-systems.

My Assignment Help (2020) Performance Analysis And Recommendations For Festive Restaurants Essay. [Online]. Available from: https://myassignmenthelp.com/free-samples/itech1005-business-information-systems
[Accessed 09 August 2024].

My Assignment Help. 'Performance Analysis And Recommendations For Festive Restaurants Essay.' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/itech1005-business-information-systems> accessed 09 August 2024.

My Assignment Help. Performance Analysis And Recommendations For Festive Restaurants Essay. [Internet]. My Assignment Help. 2020 [cited 09 August 2024]. Available from: https://myassignmenthelp.com/free-samples/itech1005-business-information-systems.

Get instant help from 5000+ experts for

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost