Question: I need a step by step procedure to implement the following model in CPLEX on macbook air as cplex doesnt support importing xlsx file into

I need a step by step procedure to implement the following model in CPLEX on macbook air as cplex doesnt support importing xlsx file into it to solve the model .

K&L Designs is a home-based company that makes hand painted jewelry boxes for teenage girls. Forecasts of sales, production costs, and the inventory holding costs for the next 30 months are given in the following table. The company must rent some equipment for production. However, the equipment can be rented or returned each month, so if nothing is produced in a month, it make no sense to incur the rental cost. The fixed rental cost is also given in the following table. I need a step by step procedure to implement the following model How should production be planned over the 30 months to minimize the combined production and inventory- holding costs? The mathematical model for this problem is as follows. Indices and Parameters: : Index for month, {1,2,3, ... , } = Unit production cost in month i = Inventory holding cost in month = Demand in month = Fixed cost in month M: an arbitrary big number Decision Variables: : = Amount to produce in month : = Inventory at the end of month =Binary variable and equals 1 if > 0, 0 otherwise Objective Function: = ( + + ) =1 Constraints: Inventory balance for the first month: 1 1 = 1 Inventory balance after the first month: + 1 = {2,3, ... , } {1,2, ... , } (1 ) + 1 {1,2, ... , } , 0, {1,2, ... , }

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & \multicolumn{30}{|c|}{ Month } \\ \hline & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 & 12 & 13 & 14 & 15 & 16 & 17 & 18 & 19 & 20 & 21 & 22 & 23 & 24 & 25 & 26 & 27 & 28 & 29 & 30 \\ \hline Unit Production & \$11. & \$14. & $12. & $14. & $10. & $11. & $13. & $15. & $16. & $10. & $16. & $14. & \$14. & $16. & \$14. & $15. & $10. & \$12. & $10 & \$11. & $12. & \$11. & $12. & $16. & $17. & $10. & $15. & $16. & $14 & $11. \\ \hline Cost & 00 & 00 & 50 & 42 & 45 & 81 & 13 & 70 & 54 & 36 & 03 & 67 & 08 & 60 & 60 & 93 & 51 & 19 & 73 & 65 & 69 & 44 & 93 & 77 & 62 & 63 & 56 & 87 & 91 & 95 \\ \hline Unit Inventory & $1.1 & $1.6 & $3.6 & $2.9 & $3.2 & $3.6 & $1.7 & $3.8 & $1.1 & $1.6 & $1.8 & $1.7 & $2.5 & $2.9 & $1.0 & $1.2 & $1.3 & $2.0 & \begin{tabular}{|l|} $2.7 \\ \end{tabular} & $2.7 & $1.9 & $1.3 & $3.8 & \begin{tabular}{|l|} $3.7 \\ \end{tabular} & $ \$1.8 & $2.9 & $2.7 & $3.4 & & \begin{tabular}{|l|} $3.7 \\ \end{tabular} \\ \hline Holdin & 5 & 7 & 2 & 8 & 2 & 4 & 3 & 3 & 2 & 7 & 9 & 1 & 3 & 6 & 3 & 3 & 7 & 1 & 3 & 0 & 6 & 7 & 1 & 2 & 4 & 5 & 0 & 6 & 9 & 9 \\ \hline Jemand & 150 & 400 & 50 & 260 & 170 & 240 & 320 & 380 & 250 & 130 & 340 & 240 & 360 & 170 & 260 & 190 & 440 & 360 & 380 & 250 & 310 & 420 & 60 & 100 & 400 & 130 & 210 & 440 & 100 & 230 \\ \hline xed cost & 59 & 51 & 54 & 61 & 54 & 58 & 68 & 65 & 55 & 59 & 56 & 66 & 68 & 57 & 70 & 58 & 57 & 65 & 61 & 60 & 59 & 53 & 68 & 67 & 52 & 69 & 58 & 61 & 61 & 64 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!