month 1 2 3 4 5 6
forcasted demand 6 7 12 13 8 5
hiring cost = $586 per person
Wages= $1107 per month
layoff cost = $118 per person
the cost of the staffingg plan for the first 2 month only incliding the cost of reuglar wages, hiring, layoffs using a chase strategy with hiring and layoffs but no overtime or undertime is
Expert Answer
https://d2vlcm61l7u1fs.cloudfront.net/media%2F10f%2F10faa63d-ea79-4e9b-85e4-9e2c15a4f7b7%2FphpIRbEOb.png
Formula:
C5 =B5+C9-C10
C6 =MAX(0,C5-C4)
C7 =MAX(0,MIN(C4-C5,C5*0.2))
C8 =C5-C6+C7
C12 =C8*1107
C15 =C9*586
C16 =C10*118
C18 =SUM(C12:C16)
Use fill handle to copy these fomulas upto column H.
the cost of the staffingg plan for the first 2 month only incliding the cost of reuglar wages, hiring, layoffs using a chase strategy with hiring and layoffs but no
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured