help on formula to estimate production date

%3CLINGO-SUB%20id%3D%22lingo-sub-962356%22%20slang%3D%22en-US%22%3Ehelp%20on%20formula%20to%20estimate%20production%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-962356%22%20slang%3D%22en-US%22%3E%3CP%3Eaim%3A%20to%20be%20able%20to%20create%20a%20forecast%2Festimate%20of%20delivery%20date%3C%2FP%3E%3CP%3ELet's%20say%20I%20have%2050%20cases%20sent%20for%20printing%20today%20(x%20days).%3C%2FP%3E%3CP%3Ebut%20the%20printer%20is%20only%20able%20to%20print%20only%2013%20per%20day.%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20first%2013%20cases%20will%20done%20(x%20%2B1%20day)%20while%20the%20next%2013%20will%20be%20done%20at%20(x%20%2B2)%20and%20the%20next%2013%20done%20and%20(x%20%2B3).%20then%20at%20x%20%2B4%20i%20have%20y%20number%20of%20cases%20to%20produce.%3C%2FP%3E%3CP%3Ethe%20production%20rate%20is%20constant%20but%20the%20number%20of%20cases%20for%20production%20varies%20on%20a%20daily%20basis.%3C%2FP%3E%3CP%3Ewhat%20functions%2Fformula%20do%20I%20use%20and%20also%20I%20need%20to%20include%20an%20actual%20date%20to%20the%20x%20%2B2%2C%20x%2B3%20days%3F%3C%2FP%3E%3CP%3EI%20am%20new%20to%20this%2C%20pls%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-962356%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

aim: to be able to create a forecast/estimate of delivery date

Let's say I have 50 cases sent for printing today (x days).

but the printer is only able to print only 13 per day. 

the first 13 cases will done (x +1 day) while the next 13 will be done at (x +2) and the next 13 done and (x +3). then at x +4 i have y number of cases to produce.

the production rate is constant but the number of cases for production varies on a daily basis.

what functions/formula do I use and also I need to include an actual date to the x +2, x+3 days?

I am new to this, pls help.

 

0 Replies