![]() I am also able to enter sales for each sales period, and the spreadsheet calculates and tracks units sold, revenue, cost of goods sold, and profit. With the system I am able to enter products through forms into the spreadsheet. This became necessary to get all the information I needed and wanted. The system I built grew beyond the original scope I had set in my proposal. They are sufficient to demonstrate the functionality, and are indicative of the type of numbers I see in tracking the machine. As a note, I used fictional numbers for the spreadsheet I uploaded. This project provided an opportunity to organize that information into a spreadsheet and automate the spreadsheet to a level where I can get all the information I am looking for. So far, I have just written down in a notebook the items that are sold each collection period, and so I had no effective way of keeping track of what I have sold in the past, for how much, how much profit I have made, what is currently in the machine, and when I need to restock. We own a snack and drink vending machine, and I stock it, set prices, collect money, and choose which products will be sold. ![]() ![]() The business problem I addressed with this project was how to track and analyze sales at a vending machine that my Dad and I operate.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |