Customer Order analysis (Cubed Dimensions)
$250-750 AUD
Paid on delivery
Hi,
Looking for someone that has the skill set to develop the following.
Please read the requirements carefully to make sure you understand them
I want to create either in Excel or another application that can tell me based off my products dimensions that I can analyse by (customer order) the (cardboard box size) required to fill each order and how many boxes it will require to complete the order.
The objective is for me to add my (customer order) to the application based on Master data dimensions and the output tells me the box size required.
I would like to get to 3 standard box sizes for all orders? But if you can get to two or less even better?
I would also like to know the weight of the order and the cubed dimensions for shipping.
I am in the process of capturing the data but to get it going I would need you to add example data for it to work.
I'm guessing I will need the following information
Product number
Product description
UoM
Weight
Length
Width
Height
I'm assuming this will require either a very skilled VB person or code etc
If you have the skill set please enquire
Thanks
From Analysing my customer orders mix I'm looking for the average size box dimensions to fulfil my customer orders in the future. So perhaps 3 box sizes.
Project ID: #5914463
About the project
11 freelancers are bidding on average $470 for this job
Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n More
Hi Nikki. I have read and understood the project requirements. It is definitely a VBA based job and I have done a few very similar ones before. To get this done precisely, you shall need to have the product dimensions More
Hi: I need bit more clarification: I have two thoughts. Please let me know which is more aligned with your objective. Here's the first one: You need an Excel based app that will allow you predict the size of shipping b More
Hi Glen Hope I can do this for you ;-) happy to discuss the project details via email. Thanks Priyal ................................................................................................................. More
Hi Glen, I am confident I can tackle this. I have a couple of questions, I will send them along in an email. Cheers
Hi, This is Mandar. I am a Business Analyst with Tata Steel. Wish to help you out with the task. I Assure you to give the timely and best output.
Hello, I have Indstrial Engineering degree, over 15 years of Excel xp and 5 years of Visual basic and VBA. I am advanced in both. I had 3 years of part time employement at bosch factories, done lots of Excel & VB More