How to Calculate Throughput by Calendar Quarter

JustBambi

New Member
Joined
Aug 5, 2015
Messages
3
I need to calculate throughput by quarter for a project, based on units created.

For example:
There 432 total widgets needed;
22 widgets can be completed a week;
how many widgets can be completed by quarter until all 432 widgets are done
with a start date of 5/1/19.

Can someone help and provide me a formula?

Thank you!
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Maybe this can help you


Book1
ABCDEFGH
1Star Datewidgetswidgets per weekweeks per quarterquarter 1quarter 2quarter 3quarter 4
205/01/2019432221430812400
Hoja6
Cell Formulas
RangeFormula
E2=IF(C2*D2<=B2,C2*D2,B2)
F2=IF(E2+($C2*$D2)<$B2,$C2*$D2,$B2-E2)
G2=IF(E2+F2+G2+($C2*$D2)<$B2,$C2*$D2,$B2-(E2+F2+G2))
H2=IF(E2+F2+G2+($C2*$D2)<$B2,$C2*$D2,$B2-(E2+F2+G2))
 
Upvote 0

Forum statistics

Threads
1,215,049
Messages
6,122,864
Members
449,097
Latest member
dbomb1414

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