help please
y alpine cupcakes data m x y data analytics alpine cu x y! modules of the alpine c x Search Results | Course x Alpine Cupcakes, Ze | C x Alpine Cupcakes, 2e * Alpine Cupcakes, Inc. | x | Transtutors:Upload Ass x | Alpine Cupcakes, Inc. R X + X C A cambridgepub.com/ereader/10130/?preview#page/10 1:: Apps 3 6p) HP Connected E Auto Zoom 10 Preface Acknowledgments ii Part 4: Accounts Receivable and Sales Analytics About the Authors iii In this part of your assignment, you will examine the Data Analytics Accounts Receivable Excel file. Please Case Assignments complete the following tasks using the Excel file: Q1. Analysis of sales. Using the 2021 and 2022 data included in the Excel file: a. Create a visualization to show an analysis of sales by month and by product line. Compare to the prior month and prior year data. b. What trends to you notice in sales? Q2. Late payments. Using the data from 2021 and 2022 provided in the Excel file, determine: a. Which customers had payments more than 30 days late in 2021 and 2022? b. Are there any customers you might recommend that management consider unreliable? What remedial action, if any, might you recommend for any customers you consider problematic? Q3. Three-way match. Using the data provided in the Excel file, answer the following questions: a. Perform a three-way match between sales order, shipping report and sales invoice (compare dollar amount and quantity). b. If you find any problems, explore the problem and see if you can determine what happened to cause the problem. Q4. Credit limits for customers: Using the data provided in the Excel file, answer the following questions: a. Compare customer credit limits to the accounts receivable (all corporate sales are on credit). Which companies have exceeded their official credit limit? Show the entries that are over the limit. b. Alpine Cupcakes is a small business and credit limits have been based on personal relationships with customers. In your opinion, how is that working for the company? Should some limits be extended, some restricted? Are certain customers problematic? Look at company payment patterns and in a few sentences, explain how you might advise management. Type here to search O X W e 9 10:16 PM 5/1/2020