CREATE BELOW DOCUMENT IN EXCEL AND ATTACH FINISHED EXCEL SHEET WITH FORMULAS

Create some sort of working document that includes 3 things; price list, herbicide budget, and chart. This document should calculate price per acre based on the use of different herbicides. Everything should update automatically as new information is available.

1. Your price list should include herbicide, company, and price. Although there are many different herbicides, you only have to use the ones I listed below. All herbicides should use the same volume of measurement. Convert everything to ounces. Keep reading to find out where you get your current prices. This price list should be included in your document so as prices change throughout the year, this price list can quickly be update which will in turn update your whole document.

2. The herbicide budget is the working part of this document. Give me at least 5 rows where I can put in a different herbicide and ounces used and it will give me a total on that row. As a producer we often use a combination of two to six different herbicides. We also use different volumes from 1 to 64+ ounces depending on what weed(s) we are trying to kill. The five rows allow me to put in different herbicides and different volumes and then calculate a total price per acre somewhere toward the bottom. This little table would allow me to formulate different concoctions as well as show me total cost. The prices from this part should bounce off of the price list you created.

3. The chart should be a chart of your choice that gives a visual representation of the overall budget. Use any chart you see fit but be sure it will update automatically as you put in different herbicide combinations.

Use formulas efficiently and utilize a hyperlink somewhere on your document that will connect you to current prices. Look for the document titled 2022 Chemical Weed Control to find current retail prices. This document is put out every year by KSU Research and Extension and is utilized by producers throughout the state. Utilizing tables (Ch. 26) for this document may not have much advantage but if you think it will then use it. Use any formulas that weve covered that will accomplish the tasks. Create something that is easy to understand and efficient to utilize. Your overall goal is to show how much different combinations will cost you per acre. Save as Herbicide Price List with your name and hand in through blackboard.

Herbicide Company Price

RangeStar

Rave

Lumax EZ

RT 3

Sharpen

Atrazine 4L

Callisto

Dual II Magnum

Ally Extra

Huskie

2,4-D LV Ester