Development of an Excel file for inventory accounting

Project Meta
It is necessary to develop a user-friendly Excel file for managing the inventory of solar equipment.
Currently, one manager will be working with the file, entering purchases, reservations, and sales of goods.
The file should automatically calculate the remaining stock of goods, their cost price, the value of inventory, and the profit from sales.