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
$30-250 USD
Geschlossen
Veröffentlicht vor fast 11 Jahren
$30-250 USD
Bezahlt bei Lieferung
Hi
I run a small wine business in New Zealand.
[login to view URL]
My background is at:
[login to view URL](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)
Packing costs
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.
thx
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.
Dear Sir, I am an MBA from one of the top ranked schools in Europe. I currently work as a financial analyst in a leading hedge fund. I have never done a free lance project till now but have built more than 100 financial models (cost & predictive) for my firm.
I would like to take up this project.
Thanks
Valsala
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
Dear Sir/Madam,
I am a member of the Institute of Chartered Accountants in Australia, and have 7+ years of finance experience encompassing feasibility analyses, decision-modelling and scenario forecasting. My clients have included small-to-medium family run enterprises, up to ASX-listed organisations.
I would be happy to supply an extract of a sample model for your consideration, and look forward to hearing from you.
Yours Faithfully,
David
Manager - Strategic Accounting Services
Dear Mark and Team at Terrasancta, I am an experienced Finance professional with over 10 years experience in helping businesses make financial decisions. I have previously built pricing and profitability models for businesses that I have supported, which have been used in decision making. Please also see private message for an example of my work.
I have an MBA and I am a Certified Management Accouuntant. I have forty years experience in Manufacturing Accounting and am considered an expert in Cost Systems and Cost Accounting. Please contact me so that I may learn more about the scope of this project (for proper bidding) and so that you may learn more about me and my capabilities. References and Resume available upon request!