Ian McDaniel
Lab 3
Microbial decomposition of organic material in soil
April 21, 2015
Introduction
Microbial activity report with grass alfalfa warm, alfalfa cold, wheat, and cold
Ian McDaniel
Description of audience is the common farmer that would use th

Ian McDaniel
2/3/2015
Soils lab survey
The location of the land is northeast part of Wellington, Kansas. The total area of the land is
336.3 acres. The current land use is for crop production. The client had recently inherited the
land. He or she had good

GENERAL INFORMATION:
Producer:
Date:
11/10/15
Address:
City, State:
Tillage:
Conventional
County:*
Region:
Irrigation:
*Must enter full county name.
Field ID
Years to build soil test:
No
4
*If field is no-till, alfalfa or grass lime incorp. should be set

AGEC 115 Decision Tools in Agricultural Economics and Agribusiness
Lab 7 Elasticity, Market Equilibrium, and Spin Buttons
Call the tab Elasticity
Finding and Showing Elasticity and Profit Maximization
The situation is as follows:
Demand is given by P = 25

Units Sold
Inputs
Units Sold
Price per Unit
Variable Cost per Unit
Fixed Costs
Start Units Sold
Incremental Units Sold
8,000
$31
$20
$80,000
0
1,000
Profit and Loss Statement
Total Revenue
$248,000
Variable Costs
$160,000
Contribution Margin
$168,000
Fixe

This is the
result you
need to obtain
Problem 1
Assumptions
Pv
Rate
Nper
Models
Future Value Equation
Problem 2
Assumptions
Fv
Rate
Nper
Models
Present Value Equation
Problem 3
Assumptions
Pv
Rate
Nper
Models
Payment Equation
Problem 4
Assumptions
Fv
Rate

AGEC 115 Decision Tools for Agricultural Economics and Agribusiness
Lab 3 Regression
Statistical Regression is used to (1) predict the value of a dependent variable based on
the value of at least one independent variable and (2) explain the impact of chan

AGEC 115 Decision Tools for Agricultural Economics and Agribusiness
Lab 2 Equations and Functions
Selecting Efficiently in Excel
Dragging the mouse is probably not the most efficient way of selecting a range in Excel. If you
select a small range, it may b

AGEC 115 Decision Tools for Agricultural Economics and Agribusiness
Lab 2 Equations and Functions
Selecting Efficiently in Excel
Dragging the mouse is probably not the most efficient way of selecting a range in Excel. If you
select a small range, it may b

Line or Scatter Chart?
Year
Quantity
Price
2009
1708
3.55
2010
1128
5.18
2011
989
6.22
2012
821
6.89
2013
1146
4.65
Line Chart
In the line chart, quantity and price (vertical axes) are
displayed as two separate data points that are evenly
distributed alon

1
2
3
4
5
Relative Cell Reference
x
12
=
x
12
=
x
12
=
x
12
=
x
12
=
12
24
36
48
60
F2 key edits the active cell and positions the insertion point at the end of the cell
Use Control + U on Mac
1
2
3
4
5
Absolute Cell Reference
x
Cell F9
=
x
Cell F9
=
x
Ce

The "IF" function is composed of three parts
separated by commas: a condition, what to display if
the condition is met, and what to display if the
condition isn't met.
Using the IF Function (with text)
If my driving speed is greater than 70 mph, then "I a

Time Value of Money
Do you want to receive $1 today or $1 one year from now?
Today's Value
(Present Value)
Receive $1 today
$1.00
Receive an amount one
year from now
Value in 1 Year
(Future Value)
$1.10
Annual Simple Interest
Rate
Which do you prefer?
10%

Time
Vacation
Half-Day
Full Day
Two Days
One Week
One Month
Hourly Wage =
where Y =
and X =
The Equation of a Line
Hourly Wage Rate
X
Hours Worked
0
4
8
16
40
180
Slope
Dependent Variable
Independent Variable
The equation of a straight line is written as

WE MOVE OUR CHEESE CO.
One Pound of Cheddar Cheese
Selling Price per unit
Total Cost of Ingredients/unit
Total Cost of Packaging/ unit
Shipping & Transportation/ unit
Sales Commissions/ unit
Advertising/Unit
Overhead/ unit
Other Costs / unit
Warehousing/

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
A
B
C
NPV RULE FOR CAPITAL BUDGETING
D
E
F
G
H
Choose a project if it costs less than the PV of its cash flows. More generally:
take a project if its Net Present Value is positive.
EXAMPLE
Cost of C

First Name and Last Name Here
Item
Price
Spice rack
$19.99
Stationery
$5.49
Gift basket
$25.99
Cutting board
$24.99
Landscape painting
$35.99
Greeting card
$4.99
T-shirt
$15.49
Scarf
$29.99
Coffee mug
$8.99
Tea set
$16.99
Serving bowl
$12.99
Wrapping pape

Demand is the quantity "Q" of a good or service a market would
buy for every possible price "P" of the good or service.
The demand function is Price = a - b x Quantity, "a" is the intercept
where quantity demanded is zero and "b" is the slope of the
deman

Part 1
Calculate Net Present Value using the Formula 1/(1+interest rate)^Year
Discount (cost of capital) for Part 1 >
Year (Time)
0
1
2
3
Sum
Part 2
Cash Flow
-$145.00
$50.00
$50.00
$50.00
xxxxx
Present Value
Factor
98%
96%
94%
xxxxxx
0.02
Present Value
4