Question: As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items carried in the store.
1. Create a maximum 7-slide PowerPoint presentation. Present your case for upgrading to a database driven solution, from a spreadsheet method, for tracking sales and inventory to the store owners.
1. Include the following:
• How a system could improve efficiency
• How a system could improve accuracy
• How sales of individual items would be entered
• How the database would store the data compared to the current spreadsheet method
• How monitoring of inventory levels based on sales using the database would work
• What is the cost and what this upgrade would entail.
During your weekly trip to your convenience store, you purchase bread, milk, cold cereal, bananas, and ice cream. The purchase was made using a debit card.
2. Create an Excel spreadsheet listing at least seven data items collected in this transaction and how they are entered into the system. Use your own personal weekly grocery store receipt to see what is collected.
• Include this spreadsheet into your presentation. Do not copy and paste, nor link to a file on your computer, but insert the Excel spreadsheet. Use PowerPoint Help to understand how to insert the Excel spreadsheet.
3. Presentation should include title and references slides (does not count toward slide limit) and detailed speaker notes.