Question: 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 this project, you will work with sales data from Top't
Corn, a popcorn company with an online store, multiple food trucks, and

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!