The goal was to develop an improved Excel system for monitoring milling products and to follow up production, sales and orders. The client was planning to create a family of new products to be uploaded in the software. It was also requested to deliver an Income Statement chart using Microsoft Excel, which contributed to finding cost saving opportunities.
The excel system is redesigned to suit the client’s goal. In addition, the family of new products were made, which includes the stock table to sales, production and deliveries. Finally, an income statement chart was created, which will help the client in analyzing the cost saving opportunities.
There are a number of outcomes that are obtained from this project. The first outcome would be the new excel system which is used for monitoring products that are linked to the production, sales and order. Then, a family of new products and an income statement was also created.