# SSCF Tibetan Grill Excel Spreadsheet

User Generated

yhmabrzv

Seminole State College of Florida

## Description

You must use the SAM Start file below. Disregard any steps in the instructions that ask you to create a new file or to use a file from another location. Launch the module for instructions. Look forto begin the project andto submit it. I have created a Document with the book intruction.

### Unformatted Attachment Preview

Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

View attached explanation and answer. Let me know if you have any questions.Hi! All done. 😊 Attached here are the Graded Summary Report for your reference and the screenshot. I already logged off so you could check. 😀

Textbook

New Perspectives Excel 2019 | Module 5: Textbook Project

Luz Aguilar

SUBMISSION #1 | SCORE IS: 100 OUT OF 100

1. Working with Multiple Worksheets
To open the Peoria workbook
2. Non-graded - Viewing a Workbook in Multiple Windows
3. Working with Worksheet Groups
To edit the worksheet group
4. Writing 3-D References
To calculate total food sales using a 3-D cell reference
To calculate the totals for the rest of the worksheet
To change the food sales value in the Grill5-08 worksheet
To insert an external reference to the previous year's data
To insert internal references to more years of data
To edit the food sales value in the 2020 data source workbook
To create hyperlinks to the Prime Costs and Controllable Profits entries
7. Simplifying Formulas with Named Ranges
To define a named range using the Name box
To create formulas for the benchmark values
To apply defined names to existing formulas in the profit and loss worksheets
To replace cell references with the TOTAL_SALES defined name

GE ver. 9.0.0-rc0002

7/7

7/7
7/7
7/7
7/7
7/7
7/7
7/7
7/7
7/7
7/7
7/7
8/8
8/8

Tibetan Grill
Author
Date
Purpose

Luz Aguilar
10/17/2021
To consolidate profit and loss statements from Region
5 (Illinois and Iowa) Tibetan Grill franchises into a single
summary report and to compare each store's profit
and loss statement against industry benchmarks.

Tibetan Grill
Region 5: Illinois and Iowa Franchises
Annual Profit & Loss Statement ending March 31, 2021
SALES
Food Sales
Beverage Sales
TOTAL SALES

\$

2021
20,619,586 \$
4,502,242
25,121,828

2020
20,102,245 \$
4,472,844
24,575,089

2019
19,618,084
4,408,640
24,026,724

COST OF GOODS SOLD
Food Costs
Beverage Costs
TOTAL COST OF GOODS SOLD

6,428,829
1,335,278
7,764,107

6,258,741
1,323,674
7,582,415

6,177,207
1,297,238
7,474,445

6,893,950
1,514,696
840,785
9,249,431

6,615,979
1,493,458
821,174
8,930,611

6,425,500
1,469,018
812,383
8,706,901

17,013,538

16,513,026

16,181,346

519,550
982,183
581,253
546,250
503,155
3,132,391

514,692
967,814
576,940
547,117
497,688
3,104,251

499,286
944,864
564,392
532,353
491,588
3,032,483

4,975,899

4,957,812

4,812,895

1,318,075
711,020
526,002
2,555,096

1,317,573
708,352
524,736
2,550,661

1,297,008
699,697
512,620
2,509,325

777,214
429,725
1,206,939

767,568
422,800
1,190,368

749,987
414,500
1,164,487

1,213,864 \$

1,216,783 \$

1,139,083

PAYROLL COSTS
Wages
Employee Benefits
Payroll Tax
TOTAL PAYROLL COSTS

PRIME COSTS
OPERATING EXPENSES
Maintenance
Utilities
Marketing
Other Expenses
TOTAL OPERATING EXPENSES

CONTROLLABLE PROFIT
OCCUPANCY COSTS
Rent
Property Taxes
Insurance
TOTAL OCCUPANCY COSTS

INTEREST AND DEPRECIATION
Interest
Depreciation
TOTAL INTEREST AND DEPRECIATION

PRETAX PROFIT

\$

\$

2018
19,511,808 \$
4,396,538
23,908,346

6,135,222
1,309,206
7,444,428

5,930,337
1,245,023
7,175,360

6,353,000
1,483,474
812,659
8,649,133

6,232,500
1,408,403
791,944
8,432,847

16,093,561

\$

2017
18,871,3...

### Review

Anonymous
Very useful material for studying!

Studypool
4.7
Indeed
4.5
Sitejabber
4.4