Data & Calculations
Sales & Operations Planning (S&OP) is an intermediate range planning to balance demand with supply of key resources.
Th dashboard shows consolidated demands in 12 months backward and 12 months forward. The consolidated demands include:
1. Budget: monthly revenue projection
2. Backlog: quoted orders, some of which are expected to close in the future.
3. Booking: closed customers orders in the past
4. Shipped: dollar amounts from actual shipped customer orders
5. To be Shipped: dollar amounts from open customer orders with firm delivery dates
6. Demand Plan: Forecast monthly demand, based on sales forecast and historical consumption.