Below is a scenario that you will discuss with your group members and submit a report answering all three questions. You can use your group's general discussion board to communicate with your group members. I will monitor your group conversation on the group discussion board if there is an issue with group participation. Keep in mind that at the end of the semester everyone will have a chance to submit a peer evaluation of group effort which is when you are going to assess yourself and your group member performances. Therefore, as stated in the course syllabus, your overall group discussion question grade could be 90, but your total individual discussion question grade could be a mere 60 because of the peer evaluations of your individual contribution. Your group responses are to be 1-2 pages long, type-written, 12 points font single-spaced, one-inch margins using citing of any outside references (if needed). Only one group member needs to submit your group report. Responses will be graded based on effort, completeness as well as correctness. The scenario to be discussed: Arnoff Enterprises manufactures the central processing unit (CPU) for a line of personal computers. The CPUs are manufactured in Seattle, Columbus, and New York and shipped to warehouses in Pittsburgh, Mobile, Denver, Los Angeles, and Washington, DC for further distribution. The data below show the number of CPUs available at each plant and the number of CPUs required by each warehouse (these data are available in the Excel worksheet Group Discussion #4. Dataset.xlsx). The shipping costs (dollars per unit) are also shown. Warehouse Plant Pittsburgh Mobile Denver Los Angeles Washington Supply Seattle $10 $20 $5 $9 $10 9,000 Columbus $2 $10 $8 $30 $6 4,000 New York $1 $20 $7 $10 $4 3000 Demand 5000 4000 3000 6000 8,000 . Click here to download: Group Discussion #4 - Dataset.xlsx determine the number ofcous that should be shimandi fram 4. (10 points) The Pittsburgh warehouse has just increased its order by 1.000 units, and Arnoff has authorized the Columbus plant to indrease its production by 1,000 units. Do you expect this development to lead to an increase or a decrease in the total transportation cost? Solve for the new optimal solution and provide the screenshot of Excel Solver's results to support your statement. Next Previous Excel File Edit View Insert Format Tools Data Window Help Group Discussion #4 - Dataset Home Insert Draw Page Layout Formulas Data Review View Cut General Wire Ter Calibri (Body - 11 Copy $ - Merge & Counter %) Paste Conditional Format Cell Formatting as Table Styles Format 020 Anal Enterprise $10.00 9.00 51.00 3000 Com New York Demand $300 $10.00 5000 5000 Supply 9000 1000 2000 Los Angeles Win 59.00 $10.00 $30.00 510.00 54.00 6000 3000 58.00 $200 4000 Model M Los Angeles Whington Cam Search Der an Supply Contre Amount Shipped from 13 11 Declan wallet 14 12 th Column 14 New Yor 15 1036 2017 Puthur Mo Los Angeles Washington Demand Consts Amped to Total 19 20 23 24 26 27 25 30 31 32 95 36 37 34 Below is a scenario that you will discuss with your group members and submit a report answering all three questions. You can use your group's general discussion board to communicate with your group members. I will monitor your group conversation on the group discussion board if there is an issue with group participation. Keep in mind that at the end of the semester everyone will have a chance to submit a peer evaluation of group effort which is when you are going to assess yourself and your group member performances. Therefore, as stated in the course syllabus, your overall group discussion question grade could be 90, but your total individual discussion question grade could be a mere 60 because of the peer evaluations of your individual contribution. Your group responses are to be 1-2 pages long, type-written, 12 points font single-spaced, one-inch margins using citing of any outside references (if needed). Only one group member needs to submit your group report. Responses will be graded based on effort, completeness as well as correctness. The scenario to be discussed: Arnoff Enterprises manufactures the central processing unit (CPU) for a line of personal computers. The CPUs are manufactured in Seattle, Columbus, and New York and shipped to warehouses in Pittsburgh, Mobile, Denver, Los Angeles, and Washington, DC for further distribution. The data below show the number of CPUs available at each plant and the number of CPUs required by each warehouse (these data are available in the Excel worksheet Group Discussion #4. Dataset.xlsx). The shipping costs (dollars per unit) are also shown. Warehouse Plant Pittsburgh Mobile Denver Los Angeles Washington Supply Seattle $10 $20 $5 $9 $10 9,000 Columbus $2 $10 $8 $30 $6 4,000 New York $1 $20 $7 $10 $4 3000 Demand 5000 4000 3000 6000 8,000 . Click here to download: Group Discussion #4 - Dataset.xlsx determine the number ofcous that should be shimandi fram 4. (10 points) The Pittsburgh warehouse has just increased its order by 1.000 units, and Arnoff has authorized the Columbus plant to indrease its production by 1,000 units. Do you expect this development to lead to an increase or a decrease in the total transportation cost? Solve for the new optimal solution and provide the screenshot of Excel Solver's results to support your statement. Next Previous Excel File Edit View Insert Format Tools Data Window Help Group Discussion #4 - Dataset Home Insert Draw Page Layout Formulas Data Review View Cut General Wire Ter Calibri (Body - 11 Copy $ - Merge & Counter %) Paste Conditional Format Cell Formatting as Table Styles Format 020 Anal Enterprise $10.00 9.00 51.00 3000 Com New York Demand $300 $10.00 5000 5000 Supply 9000 1000 2000 Los Angeles Win 59.00 $10.00 $30.00 510.00 54.00 6000 3000 58.00 $200 4000 Model M Los Angeles Whington Cam Search Der an Supply Contre Amount Shipped from 13 11 Declan wallet 14 12 th Column 14 New Yor 15 1036 2017 Puthur Mo Los Angeles Washington Demand Consts Amped to Total 19 20 23 24 26 27 25 30 31 32 95 36 37 34