Consider the following LP problem developed at Zafar Malik's Carbondale, Illiois, optical scanning firm: The cost...

Transcribed Image Text:

Consider the following LP problem developed at Zafar Malik's Carbondale, Illiois, optical scanning firm: The cost to produce an unit of OCR sytem is $95.00 and the cost to produce an unit of ASCII system is $1 Within a day, Zafar Malik must produce at least 60 units of OCR and 40 units of ASCII system; however, the total units (OCR + ASCII) have to be more than 140. OCR System ASCII System Total Production Cost per unit to produce $95.00 $105.00 Minimum volume required 60 40 140 1. Plot a graph to show graphical representation of constraints (using intercepts method) (2%) 2. Based on the graph you produced, the lowest cost to this $95X + $105Y cost function is (2% (show your work, i.e., when I click on cell B16, I need to see the formula) There are two points on the graph. You just need to show the lowest cost. Not both of them. Your answer: 3. Using solver to solve this problem. You must show your formula and Solver model (i.e., wh on solver, I need to see the model you build) (2%) (watch out unit. If it is quantity, it should not have a $ sign. If it is cost, it should have a $ sign OCR System ASCII Systen Sum Production Cost per unit to produce Minimum volume required $95.00 60 $105.00 40 140 4. If the OCR system minimum volume required decreases to 40 units a day, all other constraint remain intact, what happens to the optimum lowest cost? A: it can go up or down B: it will drop C: it will increase D: it remains same E: it goes up first then remains same but eventually will go Answer: (2%) Consider the following LP problem developed at Zafar Malik's Carbondale, Illiois, optical scanning firm: The cost to produce an unit of OCR sytem is $95.00 and the cost to produce an unit of ASCII system is $1 Within a day, Zafar Malik must produce at least 60 units of OCR and 40 units of ASCII system; however, the total units (OCR + ASCII) have to be more than 140. OCR System ASCII System Total Production Cost per unit to produce $95.00 $105.00 Minimum volume required 60 40 140 1. Plot a graph to show graphical representation of constraints (using intercepts method) (2%) 2. Based on the graph you produced, the lowest cost to this $95X + $105Y cost function is (2% (show your work, i.e., when I click on cell B16, I need to see the formula) There are two points on the graph. You just need to show the lowest cost. Not both of them. Your answer: 3. Using solver to solve this problem. You must show your formula and Solver model (i.e., wh on solver, I need to see the model you build) (2%) (watch out unit. If it is quantity, it should not have a $ sign. If it is cost, it should have a $ sign OCR System ASCII Systen Sum Production Cost per unit to produce Minimum volume required $95.00 60 $105.00 40 140 4. If the OCR system minimum volume required decreases to 40 units a day, all other constraint remain intact, what happens to the optimum lowest cost? A: it can go up or down B: it will drop C: it will increase D: it remains same E: it goes up first then remains same but eventually will go Answer: (2%)