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

ok i am working on it

 

Regards,

EhabTutor

Expert:  ehabtutor replied 7 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 and other Programming Specialists are ready to help you

Related Programming Questions