Local funiture company is making dheir reource placning and needs to find out how mny employees...

 

Transcribed Image Text:

Local funiture company is making dheir reource placning and needs to find out how mny employees they would need to have in the coming year, and how to prodace and ship the products in the most economic way. What would be your anwer, and what type of agregate planning stategy you used? Month Demnd Forecat Werking Days Jan Feb 5000 3000 3500 19 Mar 21 21 Apr May 2500 2500 22 21 22 21 21 22 Jun Jul 4000 5000 Ang Sep Ort 3000 3500 4000 Nov 3000 3500 21 Der 21 The company has eunntly 20 empleyers Producing furninure takes 2 hours The stock in the beginning of the year is 3000, and the company wats to keep i at 20s of corepontiag denand every moath Cost of holding inveatory is SAED per unit per mout Marginal cost for subcontracting SoAED per nit Hiring nad tnitang people a 2000AED and inyetis cost 3000AED per peson. Regular laber cost 60AED per hour and overtune SOAED per lhou Local funiture company is making dheir reource placning and needs to find out how mny employees they would need to have in the coming year, and how to prodace and ship the products in the most economic way. What would be your anwer, and what type of agregate planning stategy you used? Month Demnd Forecat Werking Days Jan Feb 5000 3000 3500 19 Mar 21 21 Apr May 2500 2500 22 21 22 21 21 22 Jun Jul 4000 5000 Ang Sep Ort 3000 3500 4000 Nov 3000 3500 21 Der 21 The company has eunntly 20 empleyers Producing furninure takes 2 hours The stock in the beginning of the year is 3000, and the company wats to keep i at 20s of corepontiag denand every moath Cost of holding inveatory is SAED per unit per mout Marginal cost for subcontracting SoAED per nit Hiring nad tnitang people a 2000AED and inyetis cost 3000AED per peson. Regular laber cost 60AED per hour and overtune SOAED per lhou

Answer rating: 100% (QA)

Answer Formulate Excel model as ... View the full answer