$$ Using the document titled planter information, your employer has asked you to organize the data. She first wants a breakdown of the information that shows make, model, year, condition, price, date acquired and location in an easier to read format $($use text functions not text to column$).$

$$ As part of the marketing plan, she wants to focus on getting rid of older planters, getting rid of planters not specific to the John Deere brand and offering $15\%$ sales discount on higher priced planters.

$$ In your spreadsheet using a different formula for each criterion, show which planters;

o are not John Deere specific $($CNH$)$

o we$$ve had at our locations longer than five years $($use $1/1/18$ as cut$-$off date$)$

o that have a purchase price of $$110,000$ or more $($these planters qualify for a $15\%$ discount$).$ Also calculate the new discounted price.

$$ In your spreadsheet create a column that shows which planters $($make$,$ model and year$)$ would need to be listed if they qualify for one or more of the criteria from the previous bullet.

$$ Your employer also wants to know which planters are located at dealerships in our state. Along with the above information, your employer wants to know how many days each machine has been on the lot, not including weekends.