Question

We are doing aggregate planning & we have to come up with formulas and we cannot find OT(overtime) hours allowed. for OT hours used we have =MAX(D25-D28*160,0) what formula would i use to get OT hours allowed? thanks!

Wrap Text B 1 U , :::, d , A, &Center, $ ,% , .00.0 Conditional Format Coll Insert Delete Format Sort 8 Filter 蛭恒 Merge 62 + Clear Formatting as Table Styles fir P28 Given Values Decision Cells → Formula Cells → (DO NOT CİLANGE You deeide what these values are.) (You create formulas to caleulate these values.) Row FAMILYA Hours Needed Workers Needed (No OT) Workers Needed (Max OT) Workers Employed OT Hours Total C Regulartime labor hours per worker per month Maxinsuna overtime hours per worker per math APP Template+

Answer 1

OT Hours allowed will be the maximum hours of OT that can be performed. As per given scenario, per labor maximum overtime can be 40 hours each month.

So, for X number of employees, OT hours allowed will be equal to 40*X.

From Given Excel screenshot,

OT Hours allowed = Number of Worker in Month*40