I want a quick and easy database where a customer can place an order for a new product.
The entry screen has fields for their details (name, email, phone numbers, country of origin, country target market,
Select product
Select Volume (volume determines price points, e.g 1000 units is US$16, 5000 is US$15)
Select custom artwork option (from $2 per box on 1000 units to free at 10,000 units
Select custom artwork on product (from $2 per unit on 1000 units to free at 10,000 units
Select when you want delivery (more urgent increases the price to ensure higher position on the production schedule)
Booking deposit (more urgent the higher it is from $500-$5000) is immediately required to secure a slot. Customer automatically gets a free sample.
If they do not pay booking fee they get added onto the end of the confirmed bookings and in order of volume and bid price
Production deposit required date(usually 30%) within one week to confirm order and maintain production slot. Failure to pay deposit will forfeit the booking deposit.
balance of funds on completion of order - if a customer does not have final balance ready the units will get transferred to next customer order for them to accept.
The sliding customer gets a 3% handling fee added and after 1 month the order is cancelled. The customer may get their deposit back less 5% handling fee
LC option handling deposit required (5% of order) if the order is large the customer might prefer LC, this is ok but handling fees are incurred 5%
required production days based on order (simple calc based on daily output and order size
Cumulative production (based on the orders) Currently production capacity is 30,000/day . Once we hit confirmed orders for 50 days we will automatically increase the production capacity 50%
This will reduce production days back to 33
Database will then email everyone to announce the change in production days as their orders will move up slightly.
The calculation will automatically adjust once the orders reach 50 days production
We will also get notified of the need to boost capacity on CONFIRMED ORDERS not just enquiries however we will be monitoring all volumes
System should be able to be on and offline in case internet connection is unavailable