Note: Download a QM for Windows or ExcelOM Software (available on the web free of charge) to solve LP problems. Check the Solved Problem Examples for more insight. Make sure you define the variables you use correctly. Be consistent.QM excel add in should be used to respond to each question. I have listed a link below for the QM excel if you don't have it (The book can also be found in the link)https://media.pearsoncmg.com/ph/bp/bridgepages/bp_render_bridgepage/qam_13e/index.htmlYou do not need to use different tabs to solve the different parts of the same problem. One is enough for each question (a, b, etc.). Label your responses carefully, or use different colors to identify your answers.5-1. The ABC Corporation manufactures four highly technical products that it supplies to aerospace firms that hold NASA contracts. Each of the products must pass through the following departments before they are shipped: Wiring, drilling, assembly, and inspection. The time requirement in hours for each unit produced and its corresponding profit value are summarized in the following table: DEPARTMENT PRODUCT WIRINGDRILLING ASSEMBLY INSPECTION A 0.5 0.30.2 0.5 B1.5141 C 1.5210.5 D 132 0.5 UNIT PROFITABC D ($) 9 12 15 11 The production available in each department each month, and the minimum monthly production requirement to fulfill contracts, are as follows:DEPARTMENT Capacity (hrs) Product Minimum Production Level Wiring 15,000 A 150 Drilling17,000B100Assembly 26,000C300Inspection 12,000D 400 The production manager has the responsibility of specifying production levels for each product for the coming month. REQUIRED:a. Formulate this as an LP problem.b. Solve using an LP software. Let me know what software you used.5-2. Graphically solve the following problem. You need not show the graph. However, you would need to draw one to solve the problem correctly. For Part (a), solve the problem mathematically to identify the intersection points. Maximize profit = 8 x1 + 5x2 Subject to: X1 + 2X2 <=162X1 + X2 <= 20x1, x2 >= 0(a). What is the optimal solution based on the graph? Identify all the corner points and the corresponding profit values. Compare that with the solution you get using the software.(Use QM for Windows or ExcelQM to answer b to e).(b). Change the right-hand side of constraint 1 to 17 (instead of 16) and resolve the problem. How much did the profit increase or decrease by as a result of this? What is the new solution?(c). Change the right-hand side of constraint 1 to 13 (instead of 16) and resolve the problem. How much did the profit decrease or increase by as a result? What would happen if the right-hand-side value were to go below 10?(d). Change the right-hand side of constraint 2 to 22 (instead of 20) and resolve the problem. How much did the profit decrease from the original amount as a result of this? Identify the new solution.(e). What happens to the optimal solution if profits from X1 are reduced to $6?(f). Examine the following output from QM. What is the dual price of constraint 1? What is the lower bound on this? Linear Programming Results Part (f) X1X2 RHSDual Maximize 85 Const 1 12 <= 160.67 Const 2 21 <= 20 3.67 Solution 84 84 Ranging Variable Value Reduced Original ValueLower Bound Upper Bound X1 8 0 8 2.5 10 X2 4 0 5 416 Constraint Dual ValueSlack/SurplusOriginal ValueLower BoundUpper Bound Constraint 1 0.670 16 1040 Constraint 2 3.670 20 832 (g). What conclusions can you draw from the results of this table regarding bounds of the right-hand-side values and the dual price? 5-3. Use Excel and/or Computer Software/QM.XYZ, Ltd., has plants in three locations and is currently working on three major construction projects, each located at a different site. The shipping cost per truckload of concrete, daily plant capacities, and daily project requirements are provided in the table below. FROM\TO Project AProject B Project C CAPACITY PLANT 1 $10$4$1170 PLANT 2 125 850 PLANT 39 7 630 REQUIREMENT 405060 REQUIRED:(a). Formulate this problem as a linear program problem to determine the least cost way to meet the requirements.(b). Then Solve the problem using any computer software, including Transportation Module from QM (and show the total cost). Specify exactly how the requirements were met.5-4. An Assignment Problem: In a job shop operations, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in the following table. The plant supervisor would like to assign jobs so that total time is minimized. MACHINE Jobwxyz A 10141613 B 1213 1512 C9 12 1211 D 141618 16(a). Formulate this problem as a linear program problems. There are examples in the book.(b). Find the best solution (using any LP software or any other method, such as the Hungarian Method). Which jobs should be assigned to which machines? What cost?To use the Hungarian Method, do the following:Select the lowest value in each row and subtract that from every other value in the row. Now each row would have a zero.Select the lowest value inn each column and subtract that from every other value in the column (if the column does not already have a zero). Now both the rows and columns would have zeros (at least one).Test for Optimality: Cross out all the zeros using minimum number of lines, drawing lines horizontally or vertically (not diagonally). If the number of lines you took to strike out the zeros is equal to the number of rows, optimality achieved. Assign the jobs focusing on the columns that have zeros. Remember: One to one assignment!If optimality not achieved: Take the lowest uncovered value, subtract that from all the uncovered values, add it to the intersection point, and strike out the zeros again. Check again if optimality is achieved.----------------------------------------------------------------------------Part 2Answer questions in a separate document

Week 2 - Discussion 1 Successful Business Communication [WLO: 1] [CLO: 1] Prior to beginning work on this discussion, read Chapter 4, Chapter 5, and Chapter 6 from your textbook; the Week 2 Weekly Lecture; and the article Business Etiquette Throughout the Organization. After reading Business Etiquette throughout the Organization, explain, through your own experience, why it is important to use the communication practices the author has described. In your response, address the following: Describe which of the top 10 “dos and don’ts” is most challenging for you.Explain why it would be important for you to improve any areas that you deem challenging, based on importance of effective business communications.Describe the benefits and include a minimum of one scholarly and/or credible source to support your response. Week 2 - Discussion 2 Write It Right [WLO: 1] [CLOs: 1, 4, 5] Prior to beginning work on this discussion, read Chapter 4, Chapter 5, and Chapter 6 from your textbook; the Week 2 Weekly Lecture; and Types of Writing (Links to an external site.). Then pick the type of writing relevant to your needs. Are you sure that readers perceive your written message as you intended it? If you want help revising a message you are writing, use Types of Writing (Links to an external site.). This section of the Ashford Writing Center can help you make a document that communicates to your audience clearly. It provides tips and examples for several formal documents, and position papers for business and academic environments. In your response, address the following: Explain the appropriate times to use first person and when to use third person, according to Types of Writing.Describe the three elements of “Academic Voice” and how you will incorporate these elements into your academic writing.Describe the goal of research writing and why it is important to “follow the evidence” and use the evidence to draw conclusions. Week 2 – Assignment Skills Inventory and Gap Analysis Prior to beginning work on this assignment, read Chapter 4, Chapter 5, Chapter 6, Chapter 18, and Chapter 19 from your textbook; the Week 2 Weekly Lecture; Making PowerPoint Slides: Avoiding the Pitfalls of Bad Slides PowerPoint presentation; the article The Challenge of Exceptional Communication; and the web page Self Assessment: Learn About Your Personality and Strengths (Links to an external site.). In preparation for the Final Paper as well as having real-world applicability, this week’s assignment is a PowerPoint presentation that will provide you an opportunity to create a career skills inventory and associated gap analysis. Using the article The Challenge of Exceptional Communication as a guide, the goal for this assignment is to professionally present your current skills and identifiable gaps in existing skills to promote yourself as an ideal candidate for the career of your choice. The information derived from this assignment should accurately reflect your existing skills. In your presentation, Describe the skills you possess that make you an ideal candidate for your chosen career.Identify any gaps in your existing skill set that an employer may require.Explain how you plan on honing these gaps in your existing skill set.Explain how you would effectively and persuasively communicate this gap in a manner that would still qualify you for your career choice. The Making PowerPoint Slides: Avoiding the Pitfalls of Bad Slides PowerPoint is a good resource to use for tips and guidelines for creating an effective PowerPoint presentation. The Skills Inventory and Gap Analysis presentation Must be five to six slides in length (not including title and references slides), formatted according to APA style as outlined in the Ashford Writing Center’s How to Make a PowerPoint Presentation (Links to an external site.) resource, and include substantial speaker notes (no less than 100 words per slide in the speaker notes).Must include a separate title slide with the following:Title of presentationStudent’s nameCourse name and numberInstructor’s nameDate submittedMust utilize academic voice. See the Academic Voice (Links to an external site.) resource for additional guidance.Must use at least two scholarly or credible sources in addition to the course text.The Scholarly, Peer-Reviewed, and Other Credible Sources (Links to an external site.) table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.To assist you in completing the research required for this assignment, view this Ashford University Library Quick ‘n’ Dirty (Links to an external site.) tutorial, which introduces the Ashford University Library and the research process, and provides some library search tips.Must document any information used from sources in APA style as outlined in the Ashford Writing Center’s Citing Within Your Paper (Links to an external site.) Must include a separate references slide that is formatted according to APA style as outlined in the Ashford Writing Center. See the Formatting Your References List (Links to an external site.) resource in the Ashford Writing Center for specifications.