Module 3

 Please complete the two attachments 

module 3 exercise (pages 134-178)

Module 3 case 2 (Pages 183-184)

Book log in info

Book website: brytewave.com

Book Name: New Perspectives Microsoft office

Username to access book:Jjohn459@eagles.nccu.edu

Password to access book: Eagles$1209

2

>Documentation

Capshaw Family Dentistry

Author

Date

Purpose

To project take-home pay for an employee at Capshaw Family Dentistry

Work Schedule

Capshaw Family Dentistry

Date

2

0%
0%
0%
0%
0%

8:00 AM

0%
0%
0%
0%
0%
0%
0%
0%

25.00%
25.00%

25%
25%
25%
25%
25%
25%
25%

8:00 AM

8:00 AM

Withholding
0
1
2
3
4
5
6
7
8
9
10

Single

0%
0%
0%
0%
0%

Total Hours

8:00 AM

0%
0%
0%
0%
0%

8:00 AM

0%
0%
0%
0%
0%

3:30 PM

Tax Rate

Social Security
Medicare
Take Home Pay

Estimate of	Take Home Pay
Personal Information	Working Schedule	Federal Tax Rate
Name	Clock In	Clock Out		Total Hours	Straight Time	Overtime	Payment		Withholding		0		1		3		4		5		6		7		8		9		10
Hourly Rate						8:00 AM		3:30 PM		Single	10.92%	7.88%	4.85%	2.76%	0.74%																													0%
Federal Marital Status	1:00 PM	Married	5.65%	3.62%	1.60%
State Marital Status	8:30 AM	5:00 PM	Supplemental			25.00%								25%
Withholding Allowances	10:30 AM
10:00 AM	7:00 PM	State & Local Tax Rate
Total Straight Time Hours	3:00 PM
Total Overtime Hours	11:30 AM	5:45 PM	4.34%	3.43%	2.52%	1.61%	0.77%	0.22%
6:30 PM	Married 1-working	3.77%	2.86%	1.95%	1.15%	0.52%	0.13%
Total Pay	2:30 PM	Married 2-working	4.43%	3.52%	2.61%	1.70%	0.80%	0.17%
10:45 AM
Deductions		Social Security	6.20%
Federal Income Tax		Medicare	1.45%
Georgia Income Tax
Total Deductions
Total Withholding Rate

&F &A &D

Documentation

Wingait Farm

Author

Date

Purpose

To calculate the yield and growth of a corn hybrid being grown on the farm

Yield

Wingait Farm

,

6

0

%

(acres)

5

Moisture Content

(lbs.)

Yield

Corn Yield Calculator
Total Corn Crop (acres)
Sample Plot	Agricultural Constants
Number of Rows	Square Feet in an Acre				43			5
Row Width (ft.)	Standard Corn	Moisture Content	15.						50
Row Length (ft.)	Pounds of Corn in a Bushel			56
	Sample Area	Market Price per Bushel	$3.		8
Corn Weight
Sample Weight (lbs.)
Dry Weight (lbs.)
	Market Weight
Sample	Bushels
Bushels per Acre
Total Yield (bushels)
Projected Market Revenue

Yield History

Wingait Farm

, what would become Wingait Farm was undergoing foreclosure. While a corn crop was harvested that year, a reliable estimate of the 2006 yield is not available.

172

2006

184

185

183

168

Corn Yield History
Summary	Year	Yield (Bushels/Acre)	Notes
Years	19		95	1									76	In	2006
Average Yield	1996	151
Minimum Yield	19	97		1							84
Maximum Yield	1998		1										72
Median Yield	1999	1							77
2000
2001	1		58
2002	1						74
2003		1				83
2004	1	44
2005	102
2007	1								69
2008		1							68
2009	1									70
2010		1						85
2011
2012	1							87
2013
2014	1							78
2015	1									79
2016
2017

Growth

Wingait Farm

Date

Dates

50

70

50

43
76

74

45
74

47

Stage
Day

56
68

Emergence
5

85

First Leaf
8

Summary

71

Pollination
72

First Grains

Yield

79

Solid Grains

80

56
70

Hybrid
Yield
Height
Maturity (GDD)

00

47
59

Good
Medium Tall

43
69

Medium

73

Very Good
Medium

62

Medium

76

Excellent
Tall

62

Excellent
Medium

63
78

Excellent
Medium

43
63

59

44
53

77

50
78

57
76

60
72

63

62
71

57
82

62
78

61
76

56
64

50
71

52
73

54
73

61
78

63
80

67
86

77

66
87

62
89

65
95

73

65
77

63
70

65
77

70
81

64
76

60
81

69
85

64
79

63
82

64

68
85

72
89

62
83

64
79

67
79

64
77

61
84

64
86

65
83

67
82

63
76

59
71

59
80

61
82

65
89

66
79

58
74

60
70

58
82

63
82

70
86

74
93

77
97

73
91

72
80

71
88

74
95

76
90

72
85

68
87

62
82

63
80

67
86

70
88

74
89

70
90

71
86

71
89

68
86

64
89

69
90

68
88

73
93

67
84

66
79

69
81

67
84

69
90

72
84

71
85

67
85

63
86

65
87

66
87

71
89

69
88

69
89

71
78

60
72

57
68

53
80

63
83

65
84

56
73

53
76

53
77

53
79

57
76

64
79

64
73

60
79

68
88

69
90

71
89

73
91

71
91

73
93

72

71
87

67
82

64
82

65
84

70

49
71

49
75

60
84

67
87

66
89

72
87

53
73

50
71

50
75

55
78

66
83

67
78

67
80

63
82

59
81

59
81

60
85

54
72

47
67

Corn Growth Calculator
Current Date	Farm	Day	Daily Low (°F)	Daily High (°F)	Tmin	Tmax		GDD	Cumulative GDD	Harvest Ready	Growing Temperatures
	45		52	Range	Temp (°F)
Estimated	Stage	42												64	Base Temp
Planting Date	38	Min Temp
	Emergence	Max Temp								86
	First Leaf				47
	Pollination	Stages of Corn Growth
	First Grains																71
	Solid Grains
							60
	Hybrid					61
Corn Hybrid								62								80						88
								65	106
Stalk	Height													67
	Maturity (GDD)	Corn Hybrids
						53			75
Harvesting							59												73	CS												63	Very	Good							Medium	Tall	2521
Harvest Date	CS63										89	2640
CS6403		Very Good	2725
		49	CS6478	2795
		54	CS6488				Excellent	27					90
				57	CS6489	2920
										82	CS6492	2768
CS6538	2847
39
41
					81
						66
			91
			93
94
	55

Explanation of Formulas

Wingait Farm

Sample Area

where

Market Weight

where

Bushels

GDD

where

Functions and Constants
Measures of Corn Yield
The size of the sample area (in acres) used to estimate corn yield is calculated as:
area = 2 * rows * length * width / 43560
			where	rows = number of corn rows in the sample area length= length of each row in feet width = width of each row in feet
Dry Weight of Corn	The dry weight (in pounds) is the weight of the corn kernels without the moisture content. Dry weight is calculated as:
dry weight = weight * (1 – moisture)
weight = weight of the corn in pounds moisture = percentage of the corn weight due to moisture
The market weight (in pounds) of corn used to determine the market price is calculated as:
standard weight = dry weight / (1 – 0.155)
dry weight = dry weight of the corn
To convert the standard weight of corn to bushels, use the formula:
bushels = standard weight / 56
Measures of Corn Growth
The Growing Degree Day or GDD measures the growth of a crop in response to changing temperature. GDD is calculated using the formula:
GDD = (Tmin + Tmax) / 2 – Base
Tmin = minimum daily temperature (°F) Tmax = maximum daily temperature (°F) base = baseline temperature (°F) for the crop
Note that Tmin and Tmax cannot be lower or higher than a set value. For corn, Tmin cannot be lower than 50 and Tmax cannot be higher than 86.