Qty Calculator

biggunjay6

New Member
Joined
Sep 2, 2014
Messages
2
Okay my boss wants me to build a calculator (Excel) to compute the need qty of products to send out daily to meet a qty deadline. We now 51 days to election, (We are large commercial printer and this is not my normal field) effectively 50...in that time we need to send out 5 million of one piece and 15 million of another...so he wants the calculator to show what amount needs to go out daily to meet our obligation....so for right now we need to do approx. 92000 of product A and 288000 of product B.....we need to calculator to adjust those daily qty's based on what has shipped....so in other words if today we only ship 60000 of A and 200000 of B what will the needed daily qty be then for us to reach the goal....IDEAS?????? Thanks
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Sorry....but I can only see 2 messages...which I don't feel is excessive !
and cross posting can be a significant waste of time for others.
But ....lesson learned...(y)
 
Upvote 0

Forum statistics

Threads
1,214,376
Messages
6,119,174
Members
448,870
Latest member
max_pedreira

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top