ID	Sport	Item	Day	Month	Year	Price	Category Code	Item Code	Stock code	Stay (days)	Discount	Adjusted Price	Tax	Sale Price
5107	Golf	Bag	28	11	2020	199.99	GOLF
4460	Golf	Cart	12	12	2020	########	GOLF
5846	Golf	Shoe	12	2	2021	89.99	GOLF
9922	Golf	Balls	21	11	2020	29.99	GOLF
7793	Golf	Glove	12	2	2021	47.85	GOLF
9819	Golf	GPS Watch	6	2	2021	350.97	GOLF

Column I (Item code): Item codes should also be 4-letter codes derived from item names in column C. They should also be formatted like category codes but in lower case. For example, Mouthguard should have the code mout, and Abdominal Guard should be encoded as abdg. It is acceptable if formulas written return 3-letter item codes for items with 3-letter words.

iii. Column J (Stock code): Stock codes should be a concatenation of IDs (column A), category codes (column H), and item codes (column I), with underscores between them. For example, stock code for the first item should be 5107_GOLF_bag.

iv. Column K (Stay): The Stay for each item should show the number of days that items have been in stock. They should be derived by calculating the number of days from the date of delivery in columns D, E, F to the present day. Use the Excel functions Days(), TODAY(), and DATE() to do the calculations.

v. Column L (Discount): Percentage discounts should be applied to various items according to their Stay in column K. Items that have been in stock for up to 30 days should have no (0%) discount. Items that have been in stock for over 30 and up to 60 days should have a 10% discount, while those that have stayed over 60 days should be given discounts of 20%. Use logic IF() function.

vi. Column M (Adjusted price): Calculate the price of all items after the application of the discount in column L. It should be .

vii. Column N (Tax): Sales tax on all items should be 13% of adjusted prices in column M.

viii. Column O (Sale price): Add an items adjusted price to the tax to obtain its sale price.