Bakery Distribution

The application is a fully integrated multi-user database. It helps to automate a Bakery business processes.

We created an unique worksheet for each day of the week for each customer account and automated the process. There are Standard customers whose orders are generally the same for each day of the week; any variation in their order for a given day is called or faxed to the Client. Otherwise, there’s a set order for the Standard customer. About 75% of Client’s customers are Special Order customers. Orders from each individual Special Order customer and changes from Standard customers are entered into the application as they come in, by an employee who goes into the application, pulls up that customer’s individual worksheet for that particular day and enters the order. The application then generates and prints out a group of reports’ in a date range format that literally are: The orders that will be placed with each one of Client’s suppliers, a report for each of the nine route drivers telling them exactly what products they’ll be picking up from each supplier that day and invoices for each driver that will be delivered to each customer with their order.

The application is able to generate any report that Client’s management needs. The System currently provides them with a Weekly Vendor Report that tells what they are going to be billed by there vendors – before they bill them. They also generate a Collection Totals Report that tells them how much is due in receivables by customer, by delivery route, by any date range or any other way they want to sort the data. Each driver is given a Daily Collection Sheet Report that tells the driver what amount is due from any given customer owes in addition to the invoice due for that day; some customers are delivered to on a COD basis. The Daily Sales Report/Profit Margin Report gives them a look at the percentages by any date range they choose, by customer or by route. They get a Bagel report to tell them how many Bagels are needed on any day. They get a Production Report to be sent to the Vendor for productions of the products as per the ship-date entered.