Using an excel sheet construct a table as below:

1. A combine has a header that is 24 wide. How wide should the frame be?
2. After the straw spreader is disconnected. The combine moves forward and harvests. The combine stops and the frame is laid out at the back of the machine. The count is 180 loose beans and 80 beans in loose pods. What is the total crop loss?
3. In the standing crop, there is a count of 20 beans on the ground and 20 from loose pods on the ground. What is the preharvest loss?
4. What is the machine loss?
5. Assume a harvested yield of 93.5 bushels per acre, is this machine loss acceptable?
6. The combine is backed-up, just a few feet and the frame is placed directly in front of the header on the harvested ground. The count is extra 20 loose beans on the ground, and 80 beans in pods attached to cut stalks not taken in, 40 beans in lodged stalks and 20 beans attached to stubble. Calculate:

• Shatter loss
• Loose stalk loss
• Lodged stalk loss
• Stubble loss
• Cylinder and separation loss

7. Write a summary regarding the potential management of the situation.

Source of loss	Beans found in 10 square feet area	Number of beans = 1 bushel per Acre	Bean loss in bushels per acre	Bean Loss divided by Yield times 100%
Total crop loss		40
Preharvest loss		40
Machine loss		40
Gathering loss		40
Shatter loss		40
Loose stalk loss		40
Lodging loss		40
Stubble loss		40
Cylinder & Separation loss		40