Financial Model: Beef Rearing Business

Background to Assignment

We already developed a financial model for 'beef fattening' - this is a straight forward business of buying steers, fattening them over a set period of time and selling for slaughter - see attached model sample titled 'beef fattening template V1 7-1-13. We are happy with this model and would like you to use this format as the template in terms of the new model. We are now seeking to develop a 'beef rearing' model which includes the development of a breeding herd and cattle fattening operations.

Scope of Work

Using the assumption sheet 'beef rearing assumptions 7-1-13' i'd like you to quote on completing the following tasks:

1) scheduling (linear programming i think) of breeding herd according to assumption inputs so that the revenues and costs in the rest of the model are driven by this. This will require following a certain logic which is a little complex but explained below. This logic along with the rest of the logic to be added below assumption see line 235 and onward;

2) Find and correct error in spreadsheet where cells do not automatically update when data is changed - see lines 69 and 70;

3) Link the assumptions into a series of sheets (estate capex, estate revenues, funds required, financials, highlights summary - no need for headoffice capex or headoffice revenues sheet so leave these out of this model) in the same format as the 'beef fattening template' provided.

Logic of Cattle Breading Model

Because we are establishing a herd from scratch we will need to purchase cows from the market for the first three or so years. Thereafter from the calves born we will use the heifers to replace the cull cows (old cows that are no longer viable for breeding) taken out of the herd.

Basically cows are in either of the following modes - resting waiting to come into season, ready for breeding, pregnant, lactating with calf, resting post weaning. All of these operate within a financial quarter with cows that finish lactating (i.e. calves are weaned) starting the cycle again.

Calves are separated into three uses: 1) replacement heifers (kept for future breeding either increasing size of herd or replacing cull cows); 2) Vealers (kept until 9 months and sold for slaughter) & 3) 18 month finishing (mostly steers) which are fattened out ready for slaughter.

In addition the business we buy from local villagers young steers and fatten these out for slaughter.

Breeding bulls are kept for a set period of time to service the breeding cows. After they finish their productive cycle them are sold for slaughter.

So in summary breeding cows either get pregnant which triggers off a chain of event or they don't and remain ready for breeding.

Any questions please let me know. happy to answer any questions just list them out in a PM.

Looking to assign project on Saturday Morning Dubai time

Kemahiran: Pemprosesan Data, Excel, Pengaturcaraan Linear

Lihat lagi: beef linear programming model, model beef fattening, where i find programming tasks, three d model, project scheduling template, programming model, programming in excel 2013, programming development cycle, on line business scope, linear programming project, linear programming model, linear programming in excel, linear programming in business, get financial, find 3 d model, event driven programming, data processing costs, data driven programming, buying and selling on line, buy business project, buy 3 d model, business programming, business on line, business in on line, background of the business sample

Tentang Majikan:
( 37 ulasan ) Perth, Australia

ID Projek: #4110565

7 pekerja bebas membida secara purata $417 untuk pekerjaan ini


See your PMB

$350 USD dalam 5 hari
(18 Ulasan)

Salam Alaikum! Greetings! I have created over 285 business plans, financial and marketing reports and Private Placement Memorandums in the past 10 years and additionally have raised debt and equity totaling $220 mi Lagi

$720 USD dalam 5 hari
(3 Ulasan)

Hi I have more than 15 years of real financial experience and have developed many complicated financial models. Pls see PMB

$300 USD dalam 5 hari
(15 Ulasan)

Hi, I have the experience and professional qualification to deliver this task for you. Please check your inbox for details and sample.

$600 USD dalam 7 hari
(2 Ulasan)

i am ready to do your task and your project

$350 USD dalam 15 hari
(0 Ulasan)

Dear Hiring Manager, I have a long academic experience in financial management and modeling.

$250 USD dalam 3 hari
(0 Ulasan)

Dear Sir..I am qualified Chartered Accountant ( CA ), Company Secretary ( CS ), Cost and Management Accountant ( CMA )and also an IT- Engineer..I have in depth knowledge of all OPERATION RESEARCH techniques like Linear Lagi

$350 USD dalam 7 hari
(1 Ulasan)