Assignment: Automating Sales and Inventory
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.
Present your case for upgrading to a database driven solution for tracking sales and inventory to the store owners. They are concerned about the cost and want to know what this upgrade would entail.
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
Choose one of the following presentation deliverables:
• An 9 -narrated slide presentation, with appropriate graphic
• A written business proposal (approximately two pages)
Score guidelines
• whether you do a PowerPoint slide or a two-page business proposal, here is how you can earn points:
• How a system could improve efficiency (a PowerPoint slide or MS Word section called "Improving Efficiency")
• How a system could improve accuracy ("Improving Accuracy")
• How sales of individual items would be entered ("How Sales Entered into Database")
• How the database would store the data compared to the current spreadsheet method ("Database Storage") -- consider retrieval, too
• How monitoring of inventory levels based on sales using the database would work ("Inventory Monitoring")
Plus, for good editing/mechanics and clear presentation with clear slide headings or MS report section headings as noted above. Ideally you will integrate external research with APA citations and a Reference section.