27 Nov Provide the background of the problem you are attempting to resolve. 2) Create a mathematical equation for the problem on the first tab of your Excel Worksheet 3) Solve the problem usin
Requirements:
1) Provide the background of the problem you are attempting to resolve.
2) Create a mathematical equation for the problem on the first tab of your Excel Worksheet
3) Solve the problem using Solver (linear programming) on the second tab of your Excel Worksheet.
4) Provide a management report (discuss results, sensitivity analysis, and provide recommendations) for your findings in a Word Document. Students should use screenshots to insert both the Solver solution and the sensitivity analysis in the management report completed in Word.
5) Both the Solver Workbook and Word document should be submitted in Blackboard using the provided link.
6) A minimum of 8 – 10 pages written in APA (not including the title page and references) is required.
7) Students may use their own business problem; however, a comprehensive discussion on the background must be provided so that your approach to the solution and recommendations can easily be followed.
Please remember you must complete your case study using linear programming in Solver per the requirements listed above.
Case I – Electro-Poly Corporation
The Electro-Poly Corporation is the world’s leading manufacturer of slip rings. A slip ring is an electrical coupling device that allows current to pass through a spinning or rotating connection—such as a gun turret on a ship, aircraft, or tank. The company recently received a $750,000 order for various quantities of three types of slip rings. Each slip ring requires a certain amount of time to wire and harness.
The following table summarizes the requirements for the three models of slip rings.
Unfortunately, Electro-Poly does not have enough wiring and harnessing capacity to fill the order by its due date. The company has only 10,000 hours of wiring capacity and 5,000 hours of harnessing capacity available to devote to this order. However, the company can subcontract any portion of this order to one of its competitors. The unit costs of producing each model in-house and buying the finished products from a competitor are summarized in the following table:
image1.png
image2.png
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.