please help me with the case have included the remaining part of the question like...Daily sales log, customer database. Only the Expenses log can be upload too long. I which it's set up in a way to upload all the questions together at a time.

Case Questions: P AA Either In a separate excel tab (or MS Word Document) create a report format layout answering the following questions. (Must provide the Excel Spreadsheet with ALL Calculations shown). Embedded MS Excel Tab IGNORE INVENTORY ISSUES - EVERYTHING BOUGHT IS SOLD IN THE SAME MONTH. Points Calculations Required: (Show ALL your work in Excel - Answers provided with no Excel Calculations will get a Zero) 132 1. Complete the Case QB Income Statements Tab 2. Identify the variable, fixed costs, direct costs, and indirect costs. Using a Vlookups, filters and pivot tables calculate the following - show your work 3. a) Who is the customer who purchased the most in 2018? 2019? 2020? b) Who is the customer who purchased the least in 2018? 2019? 2020? 4. What products does the store sell? What is the price of each? What is the cost of each? What is the gross margin and gross margin ratio of each? 5. Which product line contributed the most to the profit in 2018? 2019? 2020? 6. a) Which month was the stores biggest sales month? b) Which month was the stores lowest sales month? 7. Which year was the stores biggest sales year? Use an Excel Graph to show the yearly comparison. 8. Rank the product lines from the best seller to the least? Analysis Section: 9. After reviewing the data calculated above, identify and explain 5 actions would you suggest to increase profits? 10. What are 3 trends impacting the retail industry? And how could this store deal with them? 11. a) As the store manager, how would you suggest to pay your sales staff? b) How would you suggest to pay your office/admin staff? c) and explain why? BONUS: 12. If you were required to allocate the expenses across the various product lines (in Case QB Income Statements) how would you do this? On what basis? 225 Your assignment MUST have at least: a. TWO PIVOT TABLES b. One EXCEL GRAPH c. One Filtered List d. TWO VLOOKUPS (Hint for one of them: Customers Name & Customer Number) Daily S ... Business Overview Case QA Questions Support Videos Case QB Income Statements