Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In the Sales Report sheet add and calculate the following: Add the remaining months of Sales per Company Name-July, August, Sept, Oct, Nov, Dec-make up
In the Sales Report sheet add and calculate the following:
- Add the remaining months of Sales per Company Name-July, August, Sept, Oct, Nov, Dec-make up the numbers.
- Add Total Sales per month, total per quarter, total per entire year, total by name (example Petersen) You must show the formula for all.
- Calculate the total of sales for the month, for the first three companies and then the last three companies. Identify who has the best sales per year, per quarter and per month. Identify which month has the best sales.
- Calculate All sales less Rizzos for month 2,4,6,8 and 10. Show formula.
- Provide five Charts describing what you are showing, any combination of different information but you must explain in 25 words or more what they mean.
In the Food Sales Sheet add Morning Sales based on type, add any you would like at the top.
- Calculate how many beverages are sold for all three meals, and deserts per meal.
- Calculate the sales if this was for 7 months, (same numbers per month) show formula.
- Calculate all totals less deserts for 12 months.
- Create three charts of any information in this sheet, explain in 25 words.
- Create a pivot table of any information with a pivot chart.
Add another spread sheet for Paper Products
- Add the following:
- Plates
- Cups
- Bowls
- Platters
- Forks, knives, spoons
- Add columns by quarter, so there are four quarters in a year. Add 1467 plates sold per quarter, 2301 cups per quarter, 1209 bowls per quarter, 490 platters and 1456 sets of cutleries per quarter.
Create five charts to include:
How many plates were sold for the entire year, how many cups were sold for two quarters, how many bowls were sold for three quarters, how many platters were sold for the year and how many cutlery sets were sold every month?
- What was the total of all products sold in six months?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started