Western University
BUSINESS 257 Jaikumar Textiles.xlsx
1. Describe the problem that N. S. Kadiyala needs to solve on the first of each month. Why is the problem difficult?
2. Provide a detailed description of a conceptual model that will aid Kadiyala to solve the production plan problem each month. What are the strengths and weaknesses of
...[Show More]
1. Describe the problem that N. S. Kadiyala needs to solve on the first of each month. Why is the problem difficult?
2. Provide a detailed description of a conceptual model that will aid Kadiyala to solve the production plan problem each month. What are the strengths and weaknesses of the model you have described?
3. Implement your conceptual model in Excel.
A. Use Solver to identify the optimal decisions for the month of April. Does your production plan differ from Kadiyala’s April production plan?
B. Kadiyala and his colleagues spend a great deal of time during management meetings each month discussing the production minimums and production maximums. Based on your analysis of the April production model, should the production minimum or maximums be re-evaluated?
C. Extruder spinning group #5 is considering increasing its production capacity by 30 hours per month through the refurbishing of an older piece of equipment. Refurbishing would cost INR 500,000. What do you recommend regarding the decision to refurbish the older equipment?
D. Kadiaya and his colleagues often spend several days ensuring that the production schedule is “just right” in response to fluctuations in market prices. How robust is the production plan to variation in market prices for 15/1g and 84/21fd?
[Show Less]