The Excely way to | Adjustablecer Raduced Cos -0.00 Cell SO SDS2 SES23 Final Valer 000 10.00 2018 Name WESTERN OLD ENGLISH COLONIAL ve Coeficient $4.00 $10.00 $8.00 Alle lace $2.00 S. $12.00 Alle De 16.30 56.00 50.00 COM Allerle Constant RHN Adewale The SF$25 SI56 SFS27 SFS2 Name PINE SPRE CUTTING PRESSINI 120 90 50 30 Shadon Free 50.00 50.00 52.00 52:00 LOE 30 10410 30 525 80 30 ps What is the prison for each type of pig 3 Whil profit Zyl will be obtained the optimal solo simplemented 3 How much pounds of care available! 1 How much scd pressing hours are available? 6 How much would the profit need to change for the Westem pancing would be produced? Would the change in profit hunden! Ein why 12 A recent marketing and has found at Old Englah puting is under preked. The report recommend the profs be changed from 10ks S15 pesheet. Using only the information from the sitivity analysis in what the new one is value and primulque would be in this recommend were to spend Provide a detailed explanation on how you mind yourse 12 Craft Schce sa local andar that can supply additional cutting and penghunifeeded Each additical bour of cutting can be purchased for S1.75 pet bou. Due the settim for the paguching the cost varies according the the number of hospedd The first 10 hours of presenti incura cost of 2.10 per hour. Adical presing hours beyond the first 10 cost $1.55 per her. Ifly one increase can be made which addre cutting spring. If any should be secure and how many bosstould be obtained and what wosld be the total increase in pratit from this dein Show your calculation of hoch options Month Regular Production Capacity Overtime Production Capacity SCO 400 Variable Names for Regular Time RI September October November December Variable for Overtime 01 02 03 04 3,800 2.500 3.000 3.500 R2 Variable Names for Inventory 11 12 B 14 R3 R4 800 pis. 10 Write the objective function for this problem 40 Write all relevant constraints Extra Credit - Use solver and provide the Z value and quantities for all of the decsion variables (5 pts) RI- 0 R2- 02 Total/Z 03 R4 04 14 = 12 = 1- The Exceletsitivity analysis shown below: Metable C Cell Reduced Cau -53.00 50.000 SA Allah lace $2.00 Nam WESTERN OLD ENGLISH COLONIAL jective Cofil 54.00 $10.00 SU Allere Der 1:30 0.00 100 20:00 SDS) 555 SINO 53.00 Allere There CONNES hisal Shadow Cl Nam S2S PINE 120 SPRINT 90 50.00 S527 CUTTING 501 20 PRESSING HO ST ps 9 What is the prima che for each typing RH Side 200 160 SB b Allah I TERSE LOE 30 LE30 30 5 What profit Zvic) will be belofte optimal oled! 1 How much used pounds edpine are available 1 How much ist be available! How much would the profit need to change before the Westem pancing would be produced World the change in profitant to nic or dech Explam wtry 12 A recent marketing analyses has found that the Old English pateig is inderpriced. The report recomandate polithe changed from S10 Spetsheet Using only the info from the sales determine what the new chiective in value and optimal miles would be this wee plemented Provide a detailed explanation on how you determined you 12 Crah Sekce a local vendor supply additional cunog and peesong hon receded. Each additional boar cutting can be purchased for $1.75 pet bos. Due to the setup time for the posing machine, the cost arcu according the the number of honedod. The fint 10 houn of resim incur a cost of 52.10 per hour. Additional reading hours beyond the line 10 cost $1.55 per hou only one increase can be made, which additional or cukang cering if any, should be wewed and many should be obtained and two lo he he stali protit from this show your calculated hochote Month Regular Production Capacity Variables for Overtime Variable Names for Inventory September October November December 3.800 2.500 3.000 3.500 Overtime Production Capacity SOG 400 600 800 Variable Names for Regular Time RI R2 R3 R4 01 02 03 04 12 13 14 10 Write the objective function for this problem 40 Write all relevant constraints Extra Credit - Use solver and provide the Z value and quantities for all of the decision variables (5 pr.) R3 R4 Total Z RI- 01 - Il R2- 02- 12 - 03 - 04- 14 The Excely way to | Adjustablecer Raduced Cos -0.00 Cell SO SDS2 SES23 Final Valer 000 10.00 2018 Name WESTERN OLD ENGLISH COLONIAL ve Coeficient $4.00 $10.00 $8.00 Alle lace $2.00 S. $12.00 Alle De 16.30 56.00 50.00 COM Allerle Constant RHN Adewale The SF$25 SI56 SFS27 SFS2 Name PINE SPRE CUTTING PRESSINI 120 90 50 30 Shadon Free 50.00 50.00 52.00 52:00 LOE 30 10410 30 525 80 30 ps What is the prison for each type of pig 3 Whil profit Zyl will be obtained the optimal solo simplemented 3 How much pounds of care available! 1 How much scd pressing hours are available? 6 How much would the profit need to change for the Westem pancing would be produced? Would the change in profit hunden! Ein why 12 A recent marketing and has found at Old Englah puting is under preked. The report recommend the profs be changed from 10ks S15 pesheet. Using only the information from the sitivity analysis in what the new one is value and primulque would be in this recommend were to spend Provide a detailed explanation on how you mind yourse 12 Craft Schce sa local andar that can supply additional cutting and penghunifeeded Each additical bour of cutting can be purchased for S1.75 pet bou. Due the settim for the paguching the cost varies according the the number of hospedd The first 10 hours of presenti incura cost of 2.10 per hour. Adical presing hours beyond the first 10 cost $1.55 per her. Ifly one increase can be made which addre cutting spring. If any should be secure and how many bosstould be obtained and what wosld be the total increase in pratit from this dein Show your calculation of hoch options Month Regular Production Capacity Overtime Production Capacity SCO 400 Variable Names for Regular Time RI September October November December Variable for Overtime 01 02 03 04 3,800 2.500 3.000 3.500 R2 Variable Names for Inventory 11 12 B 14 R3 R4 800 pis. 10 Write the objective function for this problem 40 Write all relevant constraints Extra Credit - Use solver and provide the Z value and quantities for all of the decsion variables (5 pts) RI- 0 R2- 02 Total/Z 03 R4 04 14 = 12 = 1- The Exceletsitivity analysis shown below: Metable C Cell Reduced Cau -53.00 50.000 SA Allah lace $2.00 Nam WESTERN OLD ENGLISH COLONIAL jective Cofil 54.00 $10.00 SU Allere Der 1:30 0.00 100 20:00 SDS) 555 SINO 53.00 Allere There CONNES hisal Shadow Cl Nam S2S PINE 120 SPRINT 90 50.00 S527 CUTTING 501 20 PRESSING HO ST ps 9 What is the prima che for each typing RH Side 200 160 SB b Allah I TERSE LOE 30 LE30 30 5 What profit Zvic) will be belofte optimal oled! 1 How much used pounds edpine are available 1 How much ist be available! How much would the profit need to change before the Westem pancing would be produced World the change in profitant to nic or dech Explam wtry 12 A recent marketing analyses has found that the Old English pateig is inderpriced. The report recomandate polithe changed from S10 Spetsheet Using only the info from the sales determine what the new chiective in value and optimal miles would be this wee plemented Provide a detailed explanation on how you determined you 12 Crah Sekce a local vendor supply additional cunog and peesong hon receded. Each additional boar cutting can be purchased for $1.75 pet bos. Due to the setup time for the posing machine, the cost arcu according the the number of honedod. The fint 10 houn of resim incur a cost of 52.10 per hour. Additional reading hours beyond the line 10 cost $1.55 per hou only one increase can be made, which additional or cukang cering if any, should be wewed and many should be obtained and two lo he he stali protit from this show your calculated hochote Month Regular Production Capacity Variables for Overtime Variable Names for Inventory September October November December 3.800 2.500 3.000 3.500 Overtime Production Capacity SOG 400 600 800 Variable Names for Regular Time RI R2 R3 R4 01 02 03 04 12 13 14 10 Write the objective function for this problem 40 Write all relevant constraints Extra Credit - Use solver and provide the Z value and quantities for all of the decision variables (5 pr.) R3 R4 Total Z RI- 01 - Il R2- 02- 12 - 03 - 04- 14