In Progress

Stock Forecasting

Based on 3 month's worth of sales and a seasonality factor based on previous year sales, forecast what stock is required to last for 10 weeks. Show if incoming stock levels take this over the 10 week level and by how much. This needs to be done on a national level and then by 3 states. The sheet is used to determine what stock needs to be ordered and what stock needs to be transferred to balance the individual warehouses.

Also, when I add in a new column to the stock movement spreadsheet, it throws out all of the linked cells in the stock verification spreadsheet - as you can see in the attached files. We also need to be able to add new stock lines as they become available.

This is currently done in excel, with a forecasting sheet linked to a sales, stock on hand and incoming stock spreadsheet. However, this often throws up inaccurate data. Is there a better technology that is more robust? We need something that will allow a non-technical person to be able to enter data and print reports that show what stock is required to be ordered to keep the stock levels within the 10 week parameter and how much over that parameter particular shipments might put the levels. This needs to be robust, allow for analysis (adding in and removing columns) without affecting the linked spreadsheet.

Skills: C Programming, Data Entry, Excel, Microsoft Access, Visual Basic

See more: excel add programming, technical data sheet, stock, forecast, data forecasting, add stock, visual basic week, stock spreadsheet excel, stock excel, excel print sheet, something visual, stock excel spreadsheet, excel stock sheet, stock excel reports, sales forecast, spreadsheet sales data, excel programming sales, forecasting excel, stock sales, excel balance sheet data, spreadsheet excel sales, level programming, excel based visual basic, excel balance sheet, sales forecasting excel

About the Employer:
( 0 reviews ) Mona Vale, Australia

Project ID: #1237638

Awarded to:

MDavidCrompton

Doing v. similar job in Australia now - see reference in PM. Please also see FEEDBACK. For a well written, strightforward job like this Excel can be stabalised and automated to provede a user proof interface. Access th More

$370 AUD in 4 days
(26 Reviews)
5.2

21 freelancers are bidding on average $480 for this job

vserv

I propose a solution based on Excel with the generation of the reports for movement calculation and stock transfers to be done by code. Please see your messages. Thanks

$500 AUD in 15 days
(70 Reviews)
5.8
winghei

Hi sdawsons, I am interested on the project you posted. I see your needs and would like to help you. Please see your private message for attachments and further discussion. Sherwin

$250 AUD in 7 days
(28 Reviews)
5.3
gshiels

I am a Management Accountant with 20 years experience, strong Excel skills and Inventory Management knowledge.

$700 AUD in 5 days
(12 Reviews)
5.1
ExactSystems

Please see robust solution on PMB. regards

$680 AUD in 20 days
(8 Reviews)
5.0
stacross

We'd like to bid on your "Stock Forecasting" project. Have a glance at PM.

$390 AUD in 0 days
(23 Reviews)
4.4
rakib062

Hi, I am a system developer with 7+ years of experience. I have done several product and inventory management systems for medicine center, physiotherapy center and textile industry. Plz check pmb for details. thanks

$400 AUD in 20 days
(10 Reviews)
4.4
jadinv

Hi, I have extensive financial forecasting experience with C++ -- both with security prices and general economic variables. I think that I have a very fast, reliable, robust solution for you. I am going to send More

$390 AUD in 8 days
(5 Reviews)
4.3
braghunath

Your requirement can be met with an application developed in MS Access. I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks B.Raghunath

$450 AUD in 10 days
(3 Reviews)
4.1
Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with coding more than 10 years. I have strong background in the field of replenishment of retail business. I am interested in the More

$450 AUD in 30 days
(14 Reviews)
4.0
SaraHailes

Uk qualified accountant with over twenty years Excel and inventory management skills. Please see PMB for further details of bod.

$650 AUD in 5 days
(3 Reviews)
3.6
programer22

Hi very interesting Project. You need so called "technical analyze" of stocks I guess. I might implement this with C++ stand alone application it will looks like your excel but allow more complex calculation. There mi More

$650 AUD in 21 days
(1 Review)
2.8
jpramirez

Hello, i would like to know more about this project of yours. I'm a QuickFix/Metatrader developer that is currently developing a tool to do forecast on stocks from unique and different source of input. So i think tha More

$500 AUD in 10 days
(0 Reviews)
0.0
LunarProductions

Extensive experience with Point of Sale and Inventory Management Applications

$300 AUD in 3 days
(0 Reviews)
0.0
GlobalTech2011

Hi, We are ready to work on this project with dedication and improvements. We will provide you the best in promised time. Best Regards GlobalTech

$750 AUD in 15 days
(0 Reviews)
0.0
JeeraDataService

your satisfaction is our quality

$440 AUD in 20 days
(0 Reviews)
0.0
emsinfo2010

Please see PMB

$450 AUD in 30 days
(0 Reviews)
0.0
jsuarezg

Hello, I'm a production and industrial engineer, and specialized in logistics. I have all the knowledge of stocks and shipping management. In addition I have expertise in excel, I know about formulas, macros, etc. I ca More

$550 AUD in 21 days
(0 Reviews)
0.0
rajeevv

Hi, Please have a look to my profile.I have 5+ yrs of exp with trading domain software as OMS design, Stratgy implementation, API integration, Forecasting and analysis software, charts and many more.

$700 AUD in 10 days
(0 Reviews)
0.0
preethaVijay

We would recommend you to continue in excel, considering the current usability factors.

$250 AUD in 4 days
(0 Reviews)
0.0
petarzashev

I have experience in creating models in finance department in a big company(including everyday sales report).I can create a model for you working with input area where someone who is not familiar with MS Excel can just More

$250 AUD in 15 days
(0 Reviews)
0.0