Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help please y alpine cupcakes data m x y data analytics alpine cu x y! modules of the alpine c x Search Results | Course

image text in transcribed

help please

image text in transcribed
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

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

Step: 3

blur-text-image

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

Intermediate Accounting

Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella

2nd edition

134730372, 134730370, 978-0134730370

More Books

Students also viewed these Accounting questions

Question

Food supply

Answered: 1 week ago

Question

Mortality rate

Answered: 1 week ago