• 100% Satisfaction Guarantee

ehabtutor, Computer Software Engineer
Category: Programming
Satisfied Customers: 1327
Experience:  Bachelor of computer science, 5+ years experience in software development, software company owner
13535664
ehabtutor is online now

# Formular for calculating inventory cover required. Eg if forcast

### Resolved Question:

Formular for calculating inventory cover required.
Eg if forcast sales is 300units and I have 10 units in stock my cover in weeks would be 52/(300/10). However I want to know how many units I need to have a cover of 6 weeks.
Submitted: 6 years ago.
Category: Programming
Expert:  ehabtutor replied 6 years ago.

ok i really don't understand why are you using an if statement

All you need to do is use this formula to find out the number of units needed to cover x number of weeks

lets assume that the sales forcast is in cell B3 and the weeks to cover is in cell B9 then the number of units needed is

= (B3*B9) /52

I would also suggest rounding to the higher digit

so it would look like this:

=ROUNDUP((B3*B9)/52,0)

I am also attaching a sample file Here

If you need any further assistance just ask. A bonus is highly appreciated

Regards,

EhabTutor

Customer: replied 6 years ago.
I am currently travelling will check your response and get back to you
Expert:  ehabtutor replied 6 years ago.

If you need any further assistance don't hesitate to ask. Even after you accept i will still continue to help you

Regards,

EhabTutor

Customer: replied 6 years ago.
Hi Ehab,

Thank you for thatesponse but what I'm trying to get to is if I want 6 weeks cover and as a result of stock count I have stock for only 2 weeks how much do I need to order to make up my 6 week requirement. That's why I was trying to use the if statement.
Expert:  ehabtutor replied 6 years ago.

ok i am working on it

Regards,

EhabTutor

Expert:  ehabtutor replied 6 years ago.

ok here is your new formula:

=ROUNDUP(((B3*B9)/52)-(B3*F4/52),0)

You can find the sample here

you can now change all the factors and see how this applies to the number of units needed

If you need any further assistance don't hesitate to ask

Regards,

EhabTutor

ehabtutor, Computer Software Engineer
Category: Programming
Satisfied Customers: 1327
Experience: Bachelor of computer science, 5+ years experience in software development, software company owner

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
• Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland

• ### ATLPROG

#### Satisfied Customers:

7671
MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Last | Next >

### ATLPROG

#### Satisfied Customers:

7671
MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

### LogicPro

#### Satisfied Customers:

6535
Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

#### Satisfied Customers:

1168
Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

### lifesaver

#### Satisfied Customers:

950
Several years of intensive programming and application development experience in various platforms.

### ehabtutor

#### Satisfied Customers:

931
Bachelor of computer science, 5+ years experience in software development, software company owner

### TheDoctor

#### Satisfied Customers:

893
M.S. in Internet Information Systems