Make an Excel inventory monthly forecast template

Based on the information listed below, I need a inventory forecast template made, showing reordering point and how many of each item I will need to order.

Info available:

Previous year item sales exported in excel (total 120 SKU, total 8000 transactions)

Date of each transaction for previous year

In transit quantity for each SKU

Production lead time 45 days

In production item quantity for each SKU

Currently stock count

You can simply create template with 10 SKU and we will plug in the rest.

Need one forward demand shown per weeks, one shown per month, for the next 12 months.

Beceriler: Excel, Envanter Yönetimi

Daha fazlasını gör: i need to make production create, year make, sku inventory, forecast, excel inventory, create template, create an excel, excel inventory demand template, forecast order template, excel sales management, excel count, point excel, stock excel, excel inventory sales template, monthly inventory sales excel, create inventory excel, excel monthly inventory, stock count excel, stock inventory information excel, excel stock count, excel template inventory, stock inventory management, excel template inventory sales, inventory stock excel, inventory stock management excel

İşveren Hakkında:
( 13 değerlendirme ) Rancho Cucamonga, United States

Proje NO: #6498638



Hi! It is my pleasure to help your project. I know very well Inventory management and excel automation. It is my pleasure to complete that project less than a day after review of your project. Please contact me for Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 50%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)

16 freelancers are bidding on average $135 for this job


Dear Sir/Madam, I'm happy to help you on this task. I'm an expert in advanced excel features and have a strong financial background. Further, I have already developed such models for various business, and if you are c Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(119 Değerlendirme)

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on business analysis, excel and VBA in my job a Daha Fazla

in %bids___i_period_sub_35% gün içinde94%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)

Propunerea nu a fost încă furnizată

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)

Greetings! I can make perfect tool for you. Thank you

in %bids___i_period_sub_35% gün içinde130%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my excel reviews and chat with me. Greetings.

in %bids___i_period_sub_35% gün içinde83%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)

Hello Sir, I can create excel model for Inventory forecast (weekly, monthly and yearly) provide me the with past records to have an idea about keeping stocks and frequency of ordering inventory and which are slow mo Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Hello, I'd be very happy to help you with this project, which allows me to combine my Excel knowledge, my skills of being a forecasting manager, and the knowledge on ROP, EOQ, etc from my MBA. Best regards, Tom

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

hi, I am very knowledgeable in ms excel and I can do customized templates according to your needs. Please contact me to discuss. Thanks.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)

Dear, The character of my degree course has prepared me for this Project. It involved a great deal of independent or sovereign research, requiring initiative, self-motivation and wide range of the skills. I’m a f Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

we are 5 members and we are best in MS EXCEL and we are the expert in doing work like this because we are student of computer science and love working with the people [url removed, login to view] doubt we are new to freelancer but we can as Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hello I am a Practicing Chartered Accountant in mumbai. i believe in work. My success is fully on my hard work. Provide me opportunity to explore my talent.

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi, I'm very much interested to do your work. Because this is my first bid and I have confident I'll do good. Please contact me. Thanks Latha

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Ainda não foi fornecida uma proposta

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I have a big experience with database-Excell, Oracle DBA, Access. I can work under presure wihout problem. I will work strictly and corectly

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I had developed a similar forecasting model for a manufacturing unit in India. Wherein I analysed the past 12 months data and prepared an excel based model to forecast the next 3 years sale. The excel model is re Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi I would like to work on your project . With my in-depth knowledge of accounting , I would deliver excellent output for your satisfaction . I have 25+ years of post qualification ( Finance ) experience in Daha Fazla

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)