computer

profileDjeneba11
NP_EX_5-3.xlsx
Home>Computer Science homework help>computer

Documentation

Tibetan Grill
Author
Date
Purpose To report on the monthly sales, cost of sales, payroll costs, and prime costs for Tibetan Grill franchises.

Region Report

Tibetan Grill
All Regions Monthly Sales and Expense Report
SALES Region 1 Region 2 Region 3 Region 4 Region 5
Food Sales
Beverage Sales
TOTAL SALES
COST OF GOODS SOLD
Food Costs
Beverage Costs
TOTAL COST OF GOODS SOLD
PAYROLL COSTS
Wages
Employee Benefits
Payroll Tax
TOTAL PAYROLL COSTS
PRIME COSTS

Grill5-01

Tibetan Grill
G5-01 Monthly Sales and Expenses
SALES Percent of Sales Region 5
Food Sales $ 447,631 82.2% Franchise Number G5-01
Beverage Sales 96,923 17.8% Franchise Manager April Molinero
TOTAL SALES 544,554 100.0% Franchise Location 563 Mack Street Chicago, IL 60623
COST OF GOODS SOLD
Food Costs 139,164 31.1% Contact Number (773) 555-2061
Beverage Costs 27,068 27.9%
TOTAL COST OF GOODS SOLD 166,232 30.5%
PAYROLL COSTS
Wages 145,000 26.6%
Employee Benefits 34,500 6.3%
Payroll Tax 18,404 3.4%
TOTAL PAYROLL COSTS 197,904 36.3%
PRIME COSTS 364,136 66.9%

Grill5-02

Tibetan Grill
G5-02 Monthly Sales and Expenses
SALES Percent of Sales Region 5
Food Sales $ 148,668 84.3% Franchise Number G5-02
Beverage Sales 27,676 15.7% Franchise Manager Ramón Suarez
TOTAL SALES 176,344 100.0% Franchise Location 340 Lotus Street Des Moines, IA 50312
COST OF GOODS SOLD
Food Costs 43,037 28.9% Contact Number (515) 555-3686
Beverage Costs 9,126 33.0%
TOTAL COST OF GOODS SOLD 52,163 29.6%
PAYROLL COSTS
Wages 46,875 26.6%
Employee Benefits 10,875 6.2%
Payroll Tax 6,048 3.4%
TOTAL PAYROLL COSTS 63,798 36.2%
PRIME COSTS 115,961 65.8%

Grill5-03

Tibetan Grill
G5-03 Monthly Sales and Expenses
SALES Percent of Sales Region 5
Food Sales $ 446,752 81.8% Franchise Number G5-03
Beverage Sales 99,643 18.2% Franchise Manager Sajja Adulet
TOTAL SALES 546,395 100.0% Franchise Location 423 South Canfield Avenue Chicago, IL 60607
COST OF GOODS SOLD
Food Costs 144,617 32.4% Contact Number (312) 555-8817
Beverage Costs 30,502 30.6%
TOTAL COST OF GOODS SOLD 175,119 32.0%
PAYROLL COSTS
Wages 143,813 26.3%
Employee Benefits 33,438 6.1%
Payroll Tax 22,872 4.2%
TOTAL PAYROLL COSTS 200,123 36.6%
PRIME COSTS 375,242 68.7%

Grill5-04

Tibetan Grill
G5-04 Monthly Sales and Expenses
SALES Percent of Sales Region 5
Food Sales $ 87,532 81.3% Franchise Number G5-04
Beverage Sales 20,138 18.7% Franchise Manager Travon Hughes
TOTAL SALES 107,670 100.0% Franchise Location 122 Henke Street Rockford, IL 61101
COST OF GOODS SOLD
Food Costs 25,990 29.7% Contact Number (815) 555-8275
Beverage Costs 6,533 32.4%
TOTAL COST OF GOODS SOLD 32,523 30.2%
PAYROLL COSTS
Wages 35,442 32.9%
Employee Benefits 7,010 6.5%
Payroll Tax 3,848 3.6%
TOTAL PAYROLL COSTS 46,300 43.0%
PRIME COSTS 78,823 73.2%

Grill5-05

Tibetan Grill
G5-05 Monthly Sales and Expenses
SALES Percent of Sales Region 5
Food Sales $ 100,108 81.5% Franchise Number G5-05
Beverage Sales 22,721 18.5% Franchise Manager Tami Brooks
TOTAL SALES 122,829 100.0% Franchise Location 14 Clark Court Iowa City, IA 52246
COST OF GOODS SOLD
Food Costs 32,623 32.6% Contact Number (319) 555-8954
Beverage Costs 7,101 31.3%
TOTAL COST OF GOODS SOLD 39,724 32.3%
PAYROLL COSTS
Wages 34,617 28.2%
Employee Benefits 6,688 5.4%
Payroll Tax 2,892 2.4%
TOTAL PAYROLL COSTS 44,197 36.0%
PRIME COSTS 83,921 68.3%

Grill5-06

Tibetan Grill
G5-06 Monthly Sales and Expenses
SALES Percent of Sales Region 5
Food Sales $ 244,310 81.5% Franchise Number G5-06
Beverage Sales 55,370 18.5% Franchise Manager Julie Mahoney
TOTAL SALES 299,680 100.0% Franchise Location 22 West Maple Street Springfield, IL 62704
COST OF GOODS SOLD
Food Costs 72,795 29.8% Contact Number (217) 555-0022
Beverage Costs 16,552 29.9%
TOTAL COST OF GOODS SOLD 89,347 29.8%
PAYROLL COSTS
Wages 87,063 29.1%
Employee Benefits 14,673 4.9%
Payroll Tax 6,052 2.0%
TOTAL PAYROLL COSTS 107,788 36.0%
PRIME COSTS 197,135 65.8%

Grill5-07

Tibetan Grill
G5-07 Monthly Sales and Expenses
SALES Percent of Sales Region 5
Food Sales $ 133,119 82.4% Franchise Number G5-07
Beverage Sales 28,486 17.6% Franchise Manager Michael Cooper
TOTAL SALES 161,605 100.0% Franchise Location 582 Corbett Avenue Urbana, IL 61802
COST OF GOODS SOLD
Food Costs 42,720 32.1% Contact Number (217) 555-7203
Beverage Costs 7,624 26.8%
TOTAL COST OF GOODS SOLD 50,344 31.2%
PAYROLL COSTS
Wages 45,438 28.1%
Employee Benefits 10,417 6.4%
Payroll Tax 5,349 3.3%
TOTAL PAYROLL COSTS 61,204 37.9%
PRIME COSTS 111,548 69.0%