Assignment 2 To: ABIZ 1000 Due: 12 noon, Thursday September 25 2014 Worth: 1% of the grade for the course 1. Put together a Microsoft Excel worksheet...

Put together a Microsoft Excel worksheet to analyze 100 years of canola returnsusing the random number expression =randbetween(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 trackgains or losses over the 100 years. Graph cumulative profit and equity. Recalculatescenarios by hitting the <F9> key. Set up a table as follows:# Yield Price Sales Costs Profit Cum Profit EquityRepeat 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 randomnumber expression =randbetween(X,Y), calculate and track gains or losses over the100 years. Graph cumulative profit and equity. Recalculate scenarios by hitting the<F9> key. Set up a table as follows:# Yield Price Sales Costs Profit Cum Profit Equity