I need an excel expert to analyze small data
Budget: $30 – $250 USD
There are three tabs included on the workbook:
1. Purchase Orders
2. LY Cost
3. Savings
Purchase orders outlines the price we bought the item from and who we bought it from. There are two months of data included across two different items.
LY Cost gives you for a month the price paid for each item in the previous year
Savings gives you a framework to work with to understand how much we may or may not have saved TY vs LY
Ask: Fill out Savings tab and create recommendations based on the data. Any additional steps taken to demonstrate analytical skills would be an added bonus.
Please explain step by step what you did to come to the conclusions that you have. I don’t know how to work excel that well if you can explain how you did it it would be greatly appreciated.
1. Purchase Orders
2. LY Cost
3. Savings
Purchase orders outlines the price we bought the item from and who we bought it from. There are two months of data included across two different items.
LY Cost gives you for a month the price paid for each item in the previous year
Savings gives you a framework to work with to understand how much we may or may not have saved TY vs LY
Ask: Fill out Savings tab and create recommendations based on the data. Any additional steps taken to demonstrate analytical skills would be an added bonus.
Please explain step by step what you did to come to the conclusions that you have. I don’t know how to work excel that well if you can explain how you did it it would be greatly appreciated.