Question: Do not handwrite answer. i need it in excel and show all formulas ISM ISO 16. Excelsior Clay Works, a fictional manufacturer of a variety

Do not handwrite answer. i need it in excel and show all formulas
ISM ISO 16. Excelsior Clay Works, a fictional manufacturer of a variety of high-quality glazed clay roof tiles in Kerala, India, has the following composite demand forecasts (in hundreds of units): Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Work days 22 20 23 22 24 22 23 17 21 22 20 20 Forecast 200 300 350 600 450 150 190 260 360 490 340 160 60 490 340 Additional Planning Data Hiring cost: $400 per worker hired Firing cost: $200 per worker fired Regular time cost: $100 per worker per day Overtime cost: $150 per worker per day Idle time cost: $60 per worker per day Inventory carrying cost: $10 per hundred units per month Backorder cost: $20 per hundred units (based on shortages at Productivity rate: 100 units per worker per day Workforce size at the beginning of January: 20 workers Beginning inventory at the beginning of January: 0 units Develop a sales and operations plan using the following three strategies and find the total cost of each of the strategies: a. A level strategy of constant workforce with inventories the end of the month) and backorders to meet demand variations. b. A chase strategy with the options of hiring and firing workers. C. A mixed strategy keeping the workforce size constant at 20 and by using overtime and idle time to absorb changes in demand
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
