BUAC758G Accounting Analytics Spring 2020 Final Case: Superstore INTRODUCTION US Superstore has been very successful with sales increasing rapidly. Management has a desire to begin selling its products globally within the next five years. Revenue is recorded at the time of shipment (FOB shipping point) with company-offered discounts ranging from 0-20 percent, depending upon the products purchased and type of customer. Regular walk-in customers receive no discounts. However, corporate and home office customers receive the following discounts: chairs: 5 percent; tables: 10 percent; appliances: 20 percent. All discounts have a payment due date of 15 days. In order to secure a loan, management has requested your services to perform a financial audit for the 2014 year-end to provide the bank and potential investors with confidence in US Superstore's financial position. US Superstore's files from 201 1 onward are currently maintained in Excel worksheets. There are three worksheets available: order to cash, returns, and personnel. The company provides customers with three main categories of products: office furniture, office supplies, and technology. Customers are grouped into Consumers, Corporate, and Home Office. The geographical regions are Central, East, West, and South. The sales managers assigned to these regions include: Kelly Williams: Central; Chuck Magee: East; Cassandra Brandow: South; and Anna Andreadi: West. Customer sales data are available for the years 2011 through 2014. Exhibit 1 includes the list of products for US Superstore: EXHIBIT 1 US Superstore Products Furniture Office Supplies Technology Bookcases Appliances Art Accessories Chairs Binder Envelopes Copiers Furnishings Fasteners Label Tables Paper Storage Supplies The US Superstore Excel file has 23 columns (as listed in Exhibit 2) and 9,994 transaction lines that provide the data for order to cash information related to US Superstore's revenue. The file has two additional worksheets that include returns and sales staff and their regional responsibilities. Appendix A provides a data hierarchy of US Superstore's database and a