Dashboard Design For Dimsum 20 Sales Report Using Waterfall Model

Abstract

Dimsum 20 is a food and beverage business founded in early 2020. At Dimsum 20, 16 menus consist of 14 foods and two drinks. Since its opening, Dimsum 20 does not yet have a record of sales transactions and stock data. Starting from mid-2020, the Badan Pusat Statistik recorded a significant increase in the food and beverage business sales. This escalation resulted in many transactions so that the owner of Dimsum 20 could not control the stock and demand from customers. In managing stock, Dimsum 20 currently purchases raw materials when the supply of each product has run out. The Dimsum 20 only buys a stock when the stock runs out. Therefore, it will cause a lack and inefficiency in meeting customer demand. In addition, Dimsum 20 does not record every sale that occurs. Meanwhile, the sales records can be processed as new information and strategies for Dimsum 20. Dimsum 20 can do monitoring sales and stock reports efficiently if this business uses a web-based dashboard. Generally, a model is needed to build the required dashboard system in dashboard design. The Waterfall model is necessary to design the dashboard. The Waterfall model helps solve problems in detail because the model is created by identifying needs first to match the issues that occur. The dashboard can solve the Dimsum 20 problem by recording all transactions. Then, the dashboard will process the recorded transactions into a sales report. Besides, the dashboard provides real-time stock data so that Dimsum 20 owners can monitor to meet customer needs. Keywords: Knowledge Management System, Database, waterfall method, System