We are a small agricultural company looking for someone to design a database to handle the calculation and dissemination of pricing for our products. We are currently using an excel spreadsheet do this, which will be available to the designer to assist in development of the new database.
Information the database will need to contain:
Ingredients – including purchase price stored weekly, ability to add new items, inventory used in the current week (approximately 20 items)
Products – including product recipe, cost to manufacture, sale price (stored weekly if possible), amount sold in the current week, whether currently being sold or not, ability to add new items (approximately 60 items)
Customers – including company name, contact person, phone, email, fax, how they receive pricing (fax or email), what sales rep they work with, which products they receive prices on, ability to add new ones (approximately 60 items)
Sales Reps – Which customers they work with, what region they cover, contact info, (approximately 6 items)
Features we would like for the front end of the database:
Ability to track finances over time, i.e. store costs and sales prices for products each week
Ability to send pricing information as pdf’s to all customers via email and fax, integration with windows fax would be a plus
Easy to add customers, products, ingredients
Ability to compare prices and costs between 2 weeks
Worksheet to price prospective products without including in the database (essentially just pulling ingredient costs from the database)
We are open to suggestions on the database platform and how reports are generated and data entered. The current excel database is available upon request to aid in cost estimates.