Closed

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

Hi

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)

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

Skills: Business Analysis, Finance

See more: www online business system, www online business in, wiki services, types of online business models, types of online business, types of costs in accounting, type of accounting system, true accounting services, total finance, spreadsheet design services, small business in online, simple online accounting, simple accounting spreadsheet, simple accounting for small business, print packing design, print design selling, people make business, pdf financial accounting, packing design page, online services for businesses, online related business, online making business, online financial analysis, online business types, online business pdf

About the Employer:
( 0 reviews ) New Zealand

Project ID: #4446902

20 freelancers are bidding on average $236 for this job

Pigo

I am an experienced financial analyst and, since 2005, CFA Charter-holder. Please read the PM to analyse my offer

$206 USD in 12 days
(17 Reviews)
4.9
DrFreelancer2012

more detials

$1575 USD in 33 days
(5 Reviews)
3.6
consultants2011

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.

$275 USD in 15 days
(9 Reviews)
3.5
KKFA

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

$200 USD in 20 days
(4 Reviews)
3.2
drevak

Dear friend, I can build this model. Check you PM please for further information.

$198 USD in 15 days
(1 Review)
1.6
PengYuanGuo

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 More

$220 USD in 7 days
(0 Reviews)
0.0
nishantkashyap23

Have advised a number of businesses on their most pressing problems - can definitely add a lot of value to this project.

$220 USD in 7 days
(0 Reviews)
0.0
jesseschenk

I can complete this project and happy to work on others, see my pm.

$165 USD in 1 day
(0 Reviews)
0.0
jharig

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 le More

$249 USD in 5 days
(0 Reviews)
0.0
peterjames84

Hi Mark, I'm interested. Details are in the private message.

$165 USD in 7 days
(0 Reviews)
0.0
millirpa

please see PMB

$550 USD in 10 days
(0 Reviews)
0.0
telfordm

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 bus More

$250 USD in 3 days
(0 Reviews)
0.0
BEBO24hours

ready to do it

$257 USD in 3 days
(0 Reviews)
0.0
gkrish

MBA Grad from a top 10 Univ, with experience in preparing financial models for multi-national companies.

$220 USD in 7 days
(0 Reviews)
0.0
walterjansen2013

puedo colaborar

$275 USD in 30 days
(0 Reviews)
0.0
StrategicAcctng

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 client More

$275 USD in 7 days
(0 Reviews)
0.0
CAVishrut89

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

$242 USD in 10 days
(0 Reviews)
0.0
basbas112

I can start and finish this for you please check PMB

$360 USD in 10 days
(0 Reviews)
0.0
bizpepdotcom

I have designed and developed a range of Excel based financial and business models. Some of these have been designed specifically to suit client requirements (such as yours) and some as generic business tools. Examples More

$218 USD in 7 days
(0 Reviews)
0.0
aliiqtedarshah

I am an MBA Grad and can deliver your project with excellence :) and would love to work ahead with you too.

$220 USD in 7 days
(0 Reviews)
0.0