Excel expert

Job ID: 33917565

Budget: $1,500 – $3,000 USD

Hello,

This project has 2 parts, one is to generate a file that has total items sold at total/district/individual location level, and the second larger part is creating a dashboard that will upload two files: inventory (downloaded from Microsoft forms) and sales (file from part 1)). Then using the information from those two files, create restocking orders and create the ability quickly view inventories with color coding to let us know if stock is low at a particular location/item.

Part 1: Is to convert a daily downloaded file from bundles to the Individual components of that bundle. Count all the components and present them in an easy format. The bundles must be editable as the components change on occasion. And we must be able to take away or add new components. The downloaded file comes in excel but the numbers are in text format so will need to be converted to numbers to apply math correctly.

The components then must be attributed to the specific locations they were sold from, and each location is part of a district. The district also needs to be editable as to which location are attributed to it and the locations sometimes are removed/added, so these must be easily editable as well. This information is in the downloaded file.

The components sold need to start with the cumulative total then be able to be broken down to the individual district then finally to the individual location. Then a file exported that can showcase whatever is needed (Total and Total for each district, totals for all locations in a district, totals for a specific location).

Part 2 - Dashboard

This will have a dashboard page that will show all the districts and allow each district to be extrapolated into each location that is in it. Locations in a district will need to be editable, along with the ability to add/remove locations.

This will showcase current inventory levels at each location (imported from Microsoft forms excel file), then also import part 1 sales file. It will then subtract the sales from the inventory and compare that to the individual locations item par (this should also be editable) to generate an estimated restock for that location, finally each location should have a toggle for if they are live or paused, a turn back on date and space to type a reason.

For generating orders this should be able to select an individual location or a group of locations.

Color coding should be added to the districts and locations so it's very easy to see at a high level if there is a location in a district that is paused, low/out of stock so we can drive down quickly to view it.

Deadline to have part 1 completed is within 1 month, and part 2 within 3 months.
Related categories: Visual Basic Data Processing Excel