Reference no: EM13860582
Formulate a linear programming (LP) model that may be solved to identify the optimal production and procurement plan for the company in each time period.
Use the data from the "production.csv" file to estimate the average machining time, assembly time, finishing time, and cost per unit for each product type as estimates of the parameters tim, tia, tif, and CiP of the LP model.
Use the data from the "demand.csv" file to predict the demands Di in time period 53 for each product. Discuss the prediction method that you chose and justify your choice.
Solve the LP formulated in Task 1 using the procurement cost specified above and parameters estimated in Tasks 2 and3to determine the optimal plan for period 53.
Perform sensitivity analysis by changing one parameter at a time (leaving all other parameters fixed at the values used in Task 4) and answer the following questions.
(a) By how much does the total production cost change as the demand for each product type changes by 1 unit?
(b) At most how much should the company be willing to pay to
(i) Increase the availability of machining time by one hour during regular run?
(ii) Increase the availability of finishing time by one hour during regular run?
(iii) Increase the availability of assembly time by one hour during regular run?
Use the data from "quality.csv" to train and test a Classification Tree that predicts theQualityof a batch based on values of the featuresTest1, Test2, Test3, and Test4.