SPREADSHEET ANALYSIS CH 2 HW 2 WEEK SALESLast document update: 1 year ago
The Red Bluff Golf Course & Pro Shop sells products ranging from golf clubs and accessories to clothing displaying the club logo. In addition, the Pro Shop collects fees for rounds of golf and services such as lessons from golf pro John Schilling. Manager Aleeta Herriott needs to track Pro Shop sales by category on a day-by-day basis. Sales, at least to some extent, are a reflection of traffic in the Pro Shop and can be used to help determine staffing requirements on different days of the week. In addition, summary sales data can be compared to inventory investments to determine whether the product mix is optimal, given the demands of the clientele. Each item or service at the time of sale is recorded in the Pro Shop point-of-sale (POS) system. At the end of each day, the POS system produces a cash register report with categorized sales for the day. This is the data source of each day’s sales for the worksheet. Aleeta has created an initial layout for a sales analysis workbook, but she needs you to finish it.
- COMPLETED - CHAPTER 2 HOMEWORK WEEK SALES (XLSX FILE)
- HOMEWORK DISCRIPTION INCLUDED!