excel/ word assignment for computer class

profilewshna1
skills_ev1_grader_cap.xlsx
Home>Computer Science homework help>excel/ word assignment for computer class

Taxes

Aspen Falls Restaurants
3/31/12 6/30/12 9/30/12 12/30/12
Name Type Number of branches Taxes Taxes Taxes Taxes
Giorno's Italian 12 7498 7200 7981 7321
River Falls Inn American 24 2749 2239 2109 2839
Pizza Alforno Italian 9 9341 8341 8379 8540
Taco City Mexican 15 3210 3198 3335 3566

Revenue

Name Federal Taxes Local Taxes Revenue After-Tax Revenue by Branch
Giorno's Café $ 30,000.00 $ 1,512.00 $ 945,981.00
River Falls Inn $ 9,936.00 $ 647.00 $ 194,094.00
Pizza Alforno $ 34,601.00 $ 953.00 $ 745,209.00
Taco City $ 13,309.00 $ 800.00 $ 481,294.00

Meal Deal Sales Winners

Aspen Falls Restaurant Managers Bonus Award
Restaurant Shift Assignment Sales of "Meal Deals" Statistical Analysis
1 Tom Brennan Giorno's Café AM Shift 10
2 Sue Jenkins Giorno's Café Afternoon 6 Lowest sales number
3 Anne Hathaway Giorno's Café Afternoon 14 Total Sales of all restaurants
4 Nicolas Schwartz Giorno's Café Evening 18 Highest sales number
5 Sally Tompkins Giorno's Café AM Shift 6
6 George Hanson Giorno's Café Evening 9
7 Peter Johnson River Falls Inn Afternoon 26
8 David Lesix River Falls Inn Evening 22
9 Austin Winters River Falls Inn Evening 13
10 Samantha Holden River Falls Inn Morning 22
11 Amanda Gowen River Falls Inn AM Shift 20
12 Brian Peters River Falls Inn Afternoon 14
13 Paul Luther River Falls Inn Afternoon 25
14 Melissa Adams Pizza Alforno AM Shift 5
15 Mike McGraw Pizza Alforno Evening 7
16 Wyng Hu Pizza Alforno Afternoon 2
17 Audra Bolton Pizza Alforno Afternoon 9
18 Chantal Williams Taco City Evening 30
19 Nathan Edge Taco City Evening 34
20 Bob Guitmeier Taco City AM Shift 14
21 Elliot Podolsky Taco City AM Shift 22
22 Leon Eddings Taco City Afternoon 28