Given a certain product code, the spreadsheet should be able to check the type of
product the shopper purchases (e.g. bakery, poultry, fish, etc.). The spreadsheet should
be able to accept the number of items the shopper would want to buy. If the user
however wants more than the current stock of the grocery, the system should be able
to alert the user of insufficient stock. The shopper should be able to see the summary
of his transaction at the end of the spreadsheet, as well as the necessary information
and breakdown of all the user's purchases.
On a separate worksheet, create a master list with the items, prices, and stock of the
grocery. The grocery should be able to change the prices and the stock, and this should
reflect accordingly on the other worksheet with the user’s purchases.
Lastly, create a summary of all the items and transactions of the grocery. It should
output which items are already out of stock, how many items are available, and what
was the item that sold the most among others.
Hi! My name is Eliot. I can help you arranging your spreadsheet. Please let me know if interested, to discuss and clarify details. I will be glad to help. Regards, Eliot.