How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask ehabtutor Your Own Question

ehabtutor
ehabtutor, Computer Software Engineer
Category: Programming
Satisfied Customers: 1256
Experience:  Bachelor of computer science, 5+ years experience in software development, software company owner
13535664
Type Your Programming Question Here...
ehabtutor is online now
A new question is answered every 9 seconds

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.
Please help!!!
Submitted: 5 years ago.
Category: Programming
Expert:  ehabtutor replied 5 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 5 years ago.
I am currently travelling will check your response and get back to you
Expert:  ehabtutor replied 5 years ago.

No problem, i hope my answer addresses what you want

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 5 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 5 years ago.

ok i am working on it

 

Regards,

EhabTutor

Expert:  ehabtutor replied 5 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: 1256
Experience: Bachelor of computer science, 5+ years experience in software development, software company owner
ehabtutor and other Programming Specialists are ready to help you

JustAnswer in the News:

 
 
 
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.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...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
< Last | 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
 
 
 

Meet The Experts:

 
 
 
  • ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Last | Next >
  • http://ww2.justanswer.com/uploads/SP/spatlanta2010/2011-6-23_12450_photo.64x64.gif ATLPROG's Avatar

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Computer Software Engineer

    Satisfied Customers:

    5603
    Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
  • http://ww2.justanswer.com/uploads/unvadim/2010-11-15_210218_avatar.jpg unvadim's Avatar

    unvadim

    Computer Software Engineer

    Satisfied Customers:

    1158
    Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.
  • http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

    lifesaver

    Computer Software Engineer

    Satisfied Customers:

    950
    Several years of intensive programming and application development experience in various platforms.
  • http://ww2.justanswer.com/uploads/EH/ehabtutor/2012-8-2_202016_1.64x64.jpg ehabtutor's Avatar

    ehabtutor

    Computer Software Engineer

    Satisfied Customers:

    864
    Bachelor of computer science, 5+ years experience in software development, software company owner
  • http://ww2.justanswer.com/uploads/RA/rajivsharma086/2012-6-6_17128_displaypic.64x64.jpg Raj's Avatar

    Raj

    Computer Engg.

    Satisfied Customers:

    860
    BE CS, 4+ Experience in Programming and Database (ERP)
  • http://ww2.justanswer.com/uploads/eljonis/2010-01-06_130406_eljon2.jpg Eljon's Avatar

    Eljon

    Consultant

    Satisfied Customers:

    590
    11 yrs of programming (PHP, WordPress, XSL, SQL, JavaScript)