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: programming technology c++, excel add in programming, what is technical analysis, technical data sheet, technical analysis stock, stock, forecast, data forecasting, BALANCE SHEET ANALYSIS, analysis excel spreadsheet, add stock, analysis sheet excel, visual basic week, stock spreadsheet excel, stock excel, excel print sheet, visual basic technical analysis, stock analysis spreadsheet, technical analysis programming, stock analysis programming, something visual, excel stock analysis spreadsheet, month month excel sales spreadsheet, stock excel spreadsheet, data analysis excel spreadsheet

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

Project ID: #1237638

Awarded to:


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)

21 freelancers are bidding on average $480 for this job


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)

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)

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

$700 AUD in 5 days
(12 Reviews)

Please see robust solution on PMB. regards

$680 AUD in 20 days
(8 Reviews)

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

$390 AUD in 0 days
(23 Reviews)

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)

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)

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 [url removed, login to view]

$450 AUD in 10 days
(3 Reviews)

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)

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)

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)

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)

Extensive experience with Point of Sale and Inventory Management Applications

$300 AUD in 3 days
(0 Reviews)

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)

your satisfaction is our quality

$440 AUD in 20 days
(0 Reviews)

Please see PMB

$450 AUD in 30 days
(0 Reviews)

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)

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)

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

$250 AUD in 4 days
(0 Reviews)

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)