IF Function

[lento17]

here is the question and followed ill show you the work sheet, so you have any information you need

ps. Thank you for any help you can give me.

Q: Use an IF function to determine how many units need to be shipped to the retailer for each item. You must maintain a target of 4 weeks of supply for each item. If they inventory for any item is less than 4 weeks of supply, calculate the total units that must be shipped to the retailer. For example, if an item has 58 units in teh warehouse and the unit sales last week were 29, the current weeks of supply is 2. Therefore, you need to ship 58 units to bring the total inventory in the warehouse up to 4 weeks of supply.



(fraction of teh actual file)

Item Number Item Description Current Warehouse Inventory Units Unit Sales Last Week Weeks of Supply Ship Unit Quantity
535599 Item 1 58 29 0.5 4
891748 Item 2 4385 529 0.12063854
538729 Item 3 1901 2300 1.209889532
928914 Item 4 3743 1214 0.324338766
862160 Item 5 4229 418 0.098841334
667118 Item 6 4798 221 0.046060859
541086 Item 7 3665 2067 0.563983629
647148 Item 8 2716 1137 0.418630339

[broro183]

Gidday,

Please post a sample file with the layout, some examples of what you have tried so far*, and the required outcome. Sample files can be posted by clicking on the paperclip or the "manage attachments" button when you post.

*This looks quite like a homework assignment to me & although we are willing to help, I for one (see my signature ;-)) like to know that you have had a try yourself.

Rob