Warehouse Layout

Hi, Please read this carefully and understand the requirements. Looking for someone that has the following skill set based on the following requirements. I have the warehouse layout and all the data to complete the job 1. Can you make the design of the layout look any better? 2. Can you please tell me how many bins we have 3. Can you then tell me how many single (1) deep bins we have 4. Can you tell me how many 2 deep bins we have 5. Can you tell me how many 3 deep bins we have 6. Can you tell me how many 4 deep bins we have 7. From the SOH by location Tab can you tell me how many bins are being occupied. Bin location is in column (E) 8. Can you then tell me the number of bins that aren’t being occupied and which ones. 9. From the (Sku’s List volumes) Tab can you show me on the warehouse layout, where by bin location the Sku’s are located as well as conditional formatting the colour of the bins based on the following volume break points below. Please note one (1) bin location can occupy more than one Sku or one (1) sku can occupy more than 1 bin location. (There is no one sku to bin relationship) Please note the volume to stores figures in column B (Sku List volumes) tab are just made up for this exercise but when I do receive the actual numbers I want to be able to just cut and paste so the warehouse layout bins turn a certain colour based on the volume breaks. So the volumes may be less so I may need to change my range when I know the true volumes can you make the ranges dynamic for this to happen? But for the sake of this exercise here are the volume breaks. If you can think of better volume breaks as in less breaks please create your own range. 34,310 – 39,300 (Colour Green bins) 24,310 – 34,300 (Colour Orange Bins) 19,310 - 24,300 (Colour Yellow Bins) 14,310 - 19,300 (Colour Blue Bins) 9,310 – 14,300 (Colour Pink Bins) 4,310 - 9,300 (Colour light Purple bins) 5 - 4,300 (Colour Red Bins) All data tabs will be static for cut and paste for (SOH By location) tab and (Sku’s List Volumes) tab. Will also require a small dashboard for points 2-8 If you have the skill set please apply