Zacks Bike Hut
Level II 1st Web-Based
Edition
Transactions For
June 24-30
and the
Bank Reconciliation
Answer key
June 24
Cash
101 15,000.00
Notes Payable
203
15,000.00
Invoice: NTPAY
June 26
Accounts Receivable
Sales
Sales Tax Payable
Invoice: Z1611
105 1

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

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

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

Zacks Bike Hut
Level II 1st Web-Based
Edition
MID PROJECT EVALUATION
Answer Key
Score: 20
Question
Your
Number
Answer
-1. What was the correct balance of the Cash account
$34,323.39
at the close of business on June 4?
2. What invoice was paid in full (che

Zacks Bike Hut
Level II 1st Web-Based
Edition
Transactions For
June 3-9
Answer key
June 3 Cash
Service Fees Earned
Sales Tax Payable
101
82.93
411
77.50
205
5.43
Invoice: Z1604
June 3 Store Equipment
Store and Shop Supplies
Accounts Payable
131
246.00
127

Zacks Bike Hut
Level II 1st Web-Based
Edition
Final PROJECT EVALUATION
Answer Key
Score: 30
Question
Your
Number
Answer
-1. Which customer has the largest outstanding
10325
balance on June 30 (Identify by customer number)?
2. Is the balance of Doris Highl

Zacks Bike Hut
Level II 1st Web-Based
Edition
Transactions For
June 10-16
Answer key
June 10
Cash
101 2,064.08
Credit Card Expense
607
80.42
Accounts Rec. - Credit Card Co. 107
2,144.50
Invoice: CC411
June 11
Accounts Payable
201
Store and Shop Supplies
I

Zacks Bike Hut
Level II 1st Web-Based
Edition
Adjusting & Closing Entries
Answer key
June 30
Insurance Expense
622 2,925.00
Prepaid Insurance
121
2,925.00
Adjusting Entry
June 30
Store and Shop Supplies Exp.
602
Store and Shop Supplies
498.85
127
498.85
A

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