h

Creating Supporting Reports to Help Make Business Deelrions tarihip Chapter 5 Assignments 1 Creating Supporting Reports for Larry's Landscaping & Garden Supply Remember to include your name in the Extra Footer Line of all reports printed. Scott wants you to help him provide supporting reports. Create the reports Scott has requested, and write down the answers to the follow. ing questions a. Create and print a Customer Balance Summary as of 9/30/22. What is the amount of the largest customer receivable and what is the custom- er's name? What invoice supports that receivable? What was purchased on that invoice? Has the customer made any payments on that invoice? b. Create and print a collapsed A/R Aging Summary report as of 10/31/22. Describe all past due invoices greater than 90 days old. What was the date of each invoice? What was purchased on each invoice? c. Create and print an A/P Aging Summary report as of 4/30/22. What is the largest vendor liability? What bill makes up this liability? What is the nature of this bill? When was it due? d. Create and print an Inventory Valuation Summary as of 9/30/22 What is the item with the largest on-hand quantity? What was its cost and retail value? 2 Creating More Supporting Reports for Lurry Landscaping & Garden Supply Scott wants you to help him provide more supporting reports Create the reports he has requested, and write down the answers to the following questions a. Create and print a collapsed Customer Balance Summary as of 8/31/22 and examine the QuickZoom reports for David Lo, How much was this customer billed on 4/11/22? How much is owed on this invoice as of 8/31/222 b. Create and print a collapsed A/R Aging Summary report as of 7/31/22 and examine the QuickZoom reports for Edward Blackwell. What invoices are represented by this receivable? For what was Blackwell invoiced? What are the terms of these invoices? c. Create and print an A/P Aging Summary report as of 5/31/22 and examine the QuickZoom reports for Great Statewide Bank. What bill is represented by this payable? What was Larry's Landscape & Gardening Supply billed for? d. Create and print an Inventory Valuation Summary as of 8/31/22. How many pumps were on hand at that date? What was their average cost per unit? Creating Supporting Reports to Help Make Business Deelrions tarihip Chapter 5 Assignments 1 Creating Supporting Reports for Larry's Landscaping & Garden Supply Remember to include your name in the Extra Footer Line of all reports printed. Scott wants you to help him provide supporting reports. Create the reports Scott has requested, and write down the answers to the follow. ing questions a. Create and print a Customer Balance Summary as of 9/30/22. What is the amount of the largest customer receivable and what is the custom- er's name? What invoice supports that receivable? What was purchased on that invoice? Has the customer made any payments on that invoice? b. Create and print a collapsed A/R Aging Summary report as of 10/31/22. Describe all past due invoices greater than 90 days old. What was the date of each invoice? What was purchased on each invoice? c. Create and print an A/P Aging Summary report as of 4/30/22. What is the largest vendor liability? What bill makes up this liability? What is the nature of this bill? When was it due? d. Create and print an Inventory Valuation Summary as of 9/30/22 What is the item with the largest on-hand quantity? What was its cost and retail value? 2 Creating More Supporting Reports for Lurry Landscaping & Garden Supply Scott wants you to help him provide more supporting reports Create the reports he has requested, and write down the answers to the following questions a. Create and print a collapsed Customer Balance Summary as of 8/31/22 and examine the QuickZoom reports for David Lo, How much was this customer billed on 4/11/22? How much is owed on this invoice as of 8/31/222 b. Create and print a collapsed A/R Aging Summary report as of 7/31/22 and examine the QuickZoom reports for Edward Blackwell. What invoices are represented by this receivable? For what was Blackwell invoiced? What are the terms of these invoices? c. Create and print an A/P Aging Summary report as of 5/31/22 and examine the QuickZoom reports for Great Statewide Bank. What bill is represented by this payable? What was Larry's Landscape & Gardening Supply billed for? d. Create and print an Inventory Valuation Summary as of 8/31/22. How many pumps were on hand at that date? What was their average cost per unit