Using the Microsoft Excel worksheet and the assumptions provided, project the 2017 expected net earnings for Meakin Farms and Meakin Industrial for each of Meakin's three options and calculate the combined results. State all critical assumptions. show excel functions

					2016		2015		2014
					3,200		3,840		2,480
					acres		acres		acres
Revenue
	Crop Revenue
		Canola			557,637		705,164		220,456
		Wheat			158,068		341,946		526,282
		Peas			107,572		87,245		109,976
					823,277	*	1,134,355		856,714
Production Expenses
	Fertilizer, Seed, and Chemical				407,488		480,922		325,690
Gross Margin					415,789		653,433		531,024
Labour, Power, and Machinery Expenses
	Fuel, wages, insurance, and repairs				104,122		124,946		86,800
	Amortization				87,133		101,053		74,732
	Interest on equipment				40,321		52,679		35,789
	Office, professional fees, etc.				36,301		35,689		34,539
					267,877		314,367		231,860
Contribution Margin					147,912		339,066		299,164
Land, Buildings, Land Finance Expenses
	Land rent				127,600		184,080		114,000
	Interest on land				10,232		8,567		7,597
	Amortization				5,360		4,505		1,278
					143,192		197,152		122,875
Earnings from Operations					4,720		141,914		176,289
Income Taxes					1,180		35,479		44,072
Net Earnings					3,540		106,436		132,216
* Revenue in 2015 was below expectations due to hail damage on 640 acres.

					2016		2015		2014
Revenue
	Bin Hauling				72,357		74,992		165,006
	Grain Hauling				122,043		98,752		47,049
	Seed, Fertilizer, and Chemical Hauling				75,459		56,543		33,056
					269,859		230,287		245,111
Expenses
	Salaries, Wages, and Benefits				72,340		78,534		75,432
	Fuel and Repairs				41,078		40,587		46,893
	Equipment Leases				31,804		23,589		22,865
	Amortization				44,851		34,662		32,800
	Interest on Equipment				8,579		8,345		8,643
	Insurance				21,338		20,549		21,065
	Supplies, Office, and Other				8,533		8,465		7,449
					228,523		214,731		215,147
Earnings from Operations					41,336		15,556		29,964
Provision for Income Taxes					10,334		3,889		7,491
Net Earnings					31,002		11,667		22,473