Excel Bite 2 - STATISTICAL AND IF FUNCTIONS-2-1

xlsx

School

University of Maryland *

*We aren’t endorsed by this school

Course

301

Subject

Business

Date

Feb 20, 2024

Type

xlsx

Pages

2

Uploaded by ChefSalmonMaster1046

Report
Smith Deli & Restaurant 2/17/2024 January February March April May June Total Sales/City Projected Total Ranking Stay Open College Park, MD $ 93,886.00 $ 12,456.00 $ 12,405.00 $ 11,029.00 $ 13,059.00 $ 15,059.00 $ 157,894.00 $31,578.80 Miami $ 11,244.00 $ 15,050.00 $ 12,029.00 $ 14,255.00 $ 12,987.00 $ 15,678.00 $ 81,243.00 $16,248.60 Houston $ 13,403.00 $ 14,007.00 $ 13,087.00 $ 12,355.00 $ 18,565.00 $ 14,086.00 $ 85,503.00 $17,100.60 San Fransisco $ 25,098.00 $ 23,575.00 $ 22,436.00 $ 27,899.00 $ 23,556.00 $ 22,221.00 $ 144,785.00 $28,957.00 Washington DC $ 32,098.00 $ 24,354.00 $ 25,080.00 $ 28,009.00 $ 31,093.00 $ 39,409.00 $ 180,043.00 $36,008.60 Annapolis, MD $ 10,866.00 $ 14,087.00 $ 19,038.00 $ 18,239.00 $ 19,484.00 $ 20,001.00 $ 101,715.00 $20,343.00 Los Angelos $ 25,049.00 $ 29,039.00 $ 23,993.00 $ 27,309.00 $ 22,398.00 $ 21,029.00 $ 148,817.00 $29,763.40 Total Sales/Month $ 211,644.00 $ 132,568.00 $ 128,068.00 $ 139,095.00 $ 141,142.00 $ 147,483.00 $ 900,000.00 $180,000.00 Rankings Analysis Total Rank Average of all totals $ 150,000.00 Less than or = $ 100,000.00 Poor Minimum of all totals $ 128,068.00 Less than or = $ 120,000.00 Average Maximum of all totals $ 211,644.00 Less than or = $ 150,000.00 Good Percent Increase 20% More than $ 150,000.00 Excellent 1. Name Sheet 1 Sales 2. Use the =Sum built-in function to compute total sales by City and by Month 3. Compute the Avrage, Maxiumun and Minimum of Total Sales by month using the appropriate buil-in functions 4. Use a defined function to compute the Projected increase in Column I 5. Find the month with the third largest sale for Houston 6. Compute the Projected Total in Column J 7. Rank the different locations in Column K 8. If a location is ranked "Poor", a decision will me made to close it; find which locations will be kept open and which ones will close in Column L Projected Increase
This Exercise was created by Dr. Karake for the use of students at the Quick Analysis tool The Quick Analysis tool appears at the lower-right corner of any selected tabl conditional formats, creating a chart or pivot table, totaling values in rows or thanks to Excel’s Live Preview, you can see how your table data would appear this feature is not availbale for the Mac users.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

MUSEUM VISIT TO MBA updated.docx
Wk 1 forum.docx
RealEstateFirm_Scenario.docx
DMAIC Table Assignment.docx
LEC - Supply Chain Management Assignment.docx
Blog discussion 7.pdf
BUS8510- - Practical Lab 4 - Food and Beverage Metrics.xlsx
HUSS125 Week 3 Essay Tamara Phairr.docx
Case Study 1 - Moncton Security & Sprinkler.docx
Field Activity- Organization, Activity Summary, Role, Project, Timeline Assignment.docx
Kelsey Tiberi_MBA 504 Module Two PowerPoint Template.pptx
Kelsey Tiberi MBA 504 Final Project 9-1.pptx
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
SEE MORE TEXTBOOKS