(Answered) : 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 = $1

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