100 years of canola returns

Put together a Microsoft Excel worksheet to analyze 100 years of canola returns using the random number expression =rand between(X,Y). Yield is 28 – 40 bu/ac.

Price is $6 – $10/bu. Cost is $250 – $270/ac. Start with equity of $500/ac and track gains or losses over the 100 years. Graph cumulative profit and equity. Recalculate scenarios by hitting the key. Set up a table as follows:# Yield Price Sales Costs Profit Cum Profit Equity

Repeat 1 with costs $270 – $290.Repeat 1 with costs $240 – $260.2. Put together a Microsoft Excel worksheet to analyze 100 years of wheat returns.

Start with $500/acre equity. Put ranges around total operating costs per acre (+/-10%), total fixed costs per acre(+/- 2%), labour costs per acre (+/- 10%), price(+/- 20%) per bushel and yield in bushels per acre (+/- 20%). Using the random number expression =rand between(X,Y), calculate and track gains or losses over the100 years. Graph cumulative profit and equity. Recalculate scenarios by hitting the key. Set up a table as follows:# Yield Price Sales Costs Profit Cum Profit Equity

We help you get better grades, improve your productivity and get more fun out of college!!

Homework Answers Online

Free title page

Free reference page

Free formatting

Unlimited revisions

WhatsApp chat

How it works – it’s easy

i

Place your Order

Submit your requirements through our small easy order form. Be sure to include and attach any relevant materials.

Make a payment

The total price of your order is based on number of pages, academic level and deadline.

i

Writing process

We assign the assignment to the most qualified tutor. When the tutor completes the assignment, it is transferred to one of our professional editors to ensure that the assignment meets all of your requirements.

Once complete, we’ll send your assignment via the email provided on the order form.

 

 

Achieve academic success with the best online tutors