you own a furniture store and you are in the process of planning the production of wooden chairs for the next six months. your demand forecast for wooden chairs for the next six months is 150,100,200,300,50,200. you currently stock 50 chairs in stock. one of your customers informed you that they would be returning 50 additional chairs to you and you expect to receive these returns in month 2. you currently employ 10 skilled employees who work entirely making chairs. in the last six months they were able to make 900 chairs working full time. you are considering two alternative production plans: constant workforce level for the next six months and meet all demand on time. adjust your workforce level only once over the next six months after month 0. ( no still backlogging). hiring cost per employee=$1000 holding cost monthly per chair=$10 lay off cost per emloyee=$2000 payroll cost monthly per employee=$2000 implement each alternative to obtain the least total cost. solve this question with excel
you own a furniture store and you are in the process of planning the production of wooden chairs for the next six months. your demand
constant workforce level for the next six months and meet all demand on time.
adjust your workforce level only once over the next six months after month 0. ( no still backlogging).
hiring cost per employee=$1000
holding cost monthly per chair=$10
lay off cost per emloyee=$2000
payroll cost monthly per employee=$2000
implement each alternative to obtain the least total cost.
solve this question with excel
Step by step
Solved in 3 steps with 2 images