Customer Order analysis (Cubed Dimensions)

Cancelled Posted May 8, 2014 Paid on delivery
Cancelled 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.

Business Analysis Excel Finance Software Development Visual Basic

Project ID: #5914463

About the project

11 proposals Remote project Active May 9, 2014

11 freelancers are bidding on average $470 for this job

jaylancer43

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

$611 AUD in 10 days
(579 Reviews)
8.2
maverick44000

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

$500 AUD in 3 days
(88 Reviews)
7.0
aarifakhtar

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

$300 AUD in 7 days
(157 Reviews)
7.2
priyal1997

Hi Glen Hope I can do this for you ;-) happy to discuss the project details via email. Thanks Priyal ................................................................................................................. More

$600 AUD in 5 days
(227 Reviews)
6.8
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$400 AUD in 10 days
(121 Reviews)
6.3
d2imatrix

Hi Nikki, This seems to be a problem of optiomization. This can be done in Excel. However would like some prior information (or available data) with dimention of products and number of 'boxes used' variable. This woul More

$450 AUD in 3 days
(24 Reviews)
5.2
williammatheson

Hi Glen, I am confident I can tackle this. I have a couple of questions, I will send them along in an email. Cheers

$500 AUD in 10 days
(5 Reviews)
3.9
miyagivw

Hi Nikki, This a very interesting idea. Im not sure if it can be done though, will do some reading first. If you look at my profile this is the sort of job Im after. My first thought would be that we would nee More

$666 AUD in 10 days
(1 Review)
0.9
mandy1185

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.

$555 AUD in 10 days
(0 Reviews)
0.0
altugguven

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

$333 AUD in 3 days
(0 Reviews)
0.0