Build a simple model to make choices, and understand costs, around dry goods, bottling run size, and other related variables for a boutqiue winery in New Zealand
This project received 23 bids from talented freelancers with an average bid price of $301 USD.Get free quotes for a project like this
I run a small wine business in New Zealand.
[url removed, login to view]
My background is at:
[url removed, login to view](New_Zealand)
In the wine business one of the hardest things to get our (very small) team to get right is making the right choices around "Dry Goods." These are all the things that comprise the finished wine (except the wine!).
The key things are:
Bottle costs (3 different types of bottles, with different per unit prices);
Label print costs (set up costs per run, print design changes, per unit costs per run);
Bottling costs (set up costs per run vary based on run size)
Labelling costs (depend on size of the run).
The determine the true economics of each wine we make, and to determine things like minimum efficient run size, as well as to understand the true cost of selling to different markets (US, Europe, NZ al have different statutory requirements on the back label), we need a good spreadsheet calculator.
The way I would see this is as having a "Control Panel" page, where people enter from a "menu" of choices (e.g. run size, bottle type, country of destination, etc). There is then an "assumptions page" that we update as prices change.
The spreadsheet would spit out (i) a per unit cost for each of the above steps; (ii) "total" for each of the above steps; (ii) total per unit costs; (iv) total costs in aggregate. There are some simple PDF files that outline the cost of the various items (bottles, caps, label set up) and services (bottling, labelling, packing, etc)
This is a relatively simple model to build.
Going forward, I am investing in a number of businesses, and would like to find a partner to help with building financial models.
We use Google docs not excel..can import but usually lose some formatting. Google is best for the business b/c it integrates with our online accounting system and inventory system, while MS does not.
Quote or other information appreciated.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online