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.
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
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
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
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
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.