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.
20 freelancers are bidding on average $236 for this job
Being a Financial Analyst with more than 2 years of quality experience, I can ensure accurate modeling for your business. Kindly refer to inbox for a detailed proposal.
I am an Economist graduaded from Athens University of Business and Economics with 4+years experience in accounting , business and financial analysis.I would be glad to have a chat with pm for furhter [url removed, login to view] you
Hello, sir, nice to meet [url removed, login to view] name is Guo pengyuan, and an accountant, there are five years of accounting experience. I am financial manager for a chemical plant . I am very interested in your work. This company main Daha fazlası
Hello Sir, I will able to do this job for preparation of sound and workable financial module that will generate enough MIS reports to meet up to your requirement. For details please check your PM Inbox