Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this project, you will work with sales data from Top't Corn, a popcorn company with an online store, multiple food trucks, and one store

image text in transcribed
image text in transcribed
In this project, you will work with sales data from Top't Corn, a popcorn company with an online store, multiple food trucks, and one store in a local shopping mall There are 4 food truck locations and Tyson's store in the mall. The New Truck tab shows data on whether they can afford a loan. Notice these calculations in the data: Calculated totals . Pie charts representing total units sold by location Column chart that represents sales by popcorn type Loan payment calculations for a new truck Review the Data, PivotTables, and PivotChart. Analyze the data so that you can report it out to an audience such as your work peers and your boss. You will develop a PowerPoint or Prezi presentation using the tools learned in your textbook, "Integrating Excel into Business Problem Solving". You will record this presentation using the Kaltura Blackboard Tool, or Jing, free download, to capture your screen to record what you are doing and record your narration. DIRECTIONS: In this final project presentation, you will answer questions below in a presentation format (PowerPoint, Prezi). You do not have to say the questions out loud, but you must discuss your data in terms of the questions below, as if you are reporting your data to your boss. Present your raw data, PivotTable(s), and PivotChart(s) by discussing answers to the questions below. a. What is the company name and what kind of data will you be presenting? b. What does the raw data show? c. What data does the PivotChart and/or PivotTables summarize? d. Why is this summarized data important? e. Find the top 10 sales dates and the average minimum and maximum sales. f. Explain some maximum and minimum data on your PivotTable/Chart

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Macroeconomics

Authors: Michael Parkin

10th Edition

013485330X, 978-0134853307

More Books

Students also viewed these Economics questions

Question

What does the Eurocurrency market consist of?

Answered: 1 week ago

Question

If the job involves a client load or caseload, what is it?

Answered: 1 week ago

Question

Word File Edit Answered: 1 week ago

Answered: 1 week ago