Operating cash flow is a concern for the management of Fabrikam. To encourage early payment, management...

Transcribed Image Text:

Operating cash flow is a concern for the management of Fabrikam. To encourage early payment, management offers a discount to all customers. Management has asked you to identify the customers that do and do not take advantage of the discount and prepare a report identifying the extent to which the discounts were taken and not taken. Exclude customers who have no year-to-date sales. You may see the unique IDs of classmates; however, none should have a discount associated with them. some of your Required Export to Excel and submit your work to get credit. Customer Name Total Sales YTD Total Discounts Taken YTD Percent Discounts Taken Print a report showing the information requested and answer the question that follows based on your report. Your report should use the format shown below, including the columns. Sort the report to show the largest Percent Discounts Taken to the smallest. Hint: Use SmartList Customers folder and use Search to restrict Total Sales YTD to more than 0. You may have to calculate one of the columns in Excel How successful is Fabrikam's discount policy? Operating cash flow is a concern for the management of Fabrikam. To encourage early payment, management offers a discount to all customers. Management has asked you to identify the customers that do and do not take advantage of the discount and prepare a report identifying the extent to which the discounts were taken and not taken. Exclude customers who have no year-to-date sales. You may see the unique IDs of classmates; however, none should have a discount associated with them. some of your Required Export to Excel and submit your work to get credit. Customer Name Total Sales YTD Total Discounts Taken YTD Percent Discounts Taken Print a report showing the information requested and answer the question that follows based on your report. Your report should use the format shown below, including the columns. Sort the report to show the largest Percent Discounts Taken to the smallest. Hint: Use SmartList Customers folder and use Search to restrict Total Sales YTD to more than 0. You may have to calculate one of the columns in Excel How successful is Fabrikam's discount policy?

Answer rating: 100% (QA)

To identify the customers that take advantage of the discount and prepare a report with the requeste... View the full answer