Describe in general terms how you could use Excel’s functions and/or formula to fulfill the following task:

Every hour during the workday, your employee checks a constantly-updated spreadsheet that tracks how many items are sold; each hour of the workday, the total number of items for a column are entered as a negative number. At the end of each workday, the employee calculates the total remaining by adding the starting total stock (in row B) and the 12 rows representing sales—this is entered into a separate spreadsheet, the new total goes into row B, and the remaining data is cleared.

You want to set up a spreadsheet that, during that hourly check, lets the employee quickly look at a single cell for each of the five columns representing items you sell and see whether your remaining stock, after your deliveries for the sales that day, would be below 50 units, so you know whether to order more.

Your description of how this task can be solved doesn’t need explicit formulas, but you can include them if it helps explain you answer.