Create a Microsoft Excel Sheets to manage daily deliveries and set purchase limits, ensuring smooth operations with customized alerts (colours and blocking message will be fine) and notifications.
Objectives
Efficiently manage scheduled deliveries with clear tracking and adherence to customer limits.
Scope of Services
- Develop an Excel sheets to manage 50 deliveries per day- Set (30 by daty 20 by night) delivery and purchase limits per customer- Implement alert notifications and color coding for limit breaches
Each customer has his own daily and weekly limit
There are just 100 customers
We can deliver 3 customers at one time (capacity) we work from Saturday to Thursday