A window blind company owner never knew how exactly how much material he needed for any single project. He would estimate the amount and put that figure into Excel. When he estimated too much, it cost him money for materials he didn’t use. When he estimated too little, it delayed the project’s completion because he had to get more material from his supplier. Plus, he used Excel as if it was just a paper chart.
Solution: Worksheet Creation
· Use Excel to create a worksheet for each order as part of a workbook for orders to his suppliers.
· After all the individual orders are entered in the workbook as worksheets, the new Excel workbook calculates how much material was needed for was needed for the entire group of orders.
· The worksheet should demonstrate savings for the company in time and money because the owner could order the right amount of material from his suppliers and allocate it correctly to the customers’ jobs.