We are a woodware manufacturer in New Zealand and we focus on making ethnic flavoured giftware for the New Zealand souvenir market (see [login to view URL])
We have been in business for over 25 years and use a custom built excel spreadsheet to calculate initial and ongoing product costs and to assist with the setting of sell prices.
Our business has grown from 20 odd products to over 180 products and the spreadsheet is now cumbersome, easy to “corrupt” and difficult to navigate.
We seek a VBA expert to re-write our software to correct the above issues. ie standardised entry forms for stock, standard template for new product entry, time trial database & linking, labour cost analysis, projected profit analysis per item, ability to create components as stock items, linked navigation, etc.
As the spreadsheet is of an extremely commercially sensitive nature, I am reluctant to attach it here where anybody can access it. Instead I have attached some snapshots of the various portions to give you an over-view of the spreadsheet we wish to automate.
Please respond with why I should select you, your confidentiality agreement, hourly rate and cost estimate to complete this project (to the nearest NZD$250). I will shortlist likely candidates based on this response.