Get Instant Help From 5000+ Experts For
question

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

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave

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.

Discussion of your observations and your recommendations for Festive Restaurants. In your report include discussion of:

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

To export a reference to this article please select a referencing stye below:

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

"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 01 March 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 01 March 2024.

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

Get instant help from 5000+ experts for
question

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

Editing: Proofread your work by experts and improve grade at Lowest cost

loader
250 words
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Other Similar Samples

support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close