Assessment 3 OPS 910 Trimester 2 2023 OPS 910 Individual Report Case Study: MG Wire Winding Business report to be submitted on the Moodle site before the due date. , Due date: 30 June 2023, before 11:30pm. The Background Ron Smith felt good about his rst week as a management trainee at MG Wire Winding. He had not yet developed technical knowledge about the manufacturing process, but he had toured the facility and met many people in various areas of the operation. MG Wire Winding, a Queensland company, is a medium-sized producer of wire windings used in making electrical transformers. Joseph Lowes, the production control manager, described the windings to Ron as being of standardized design. Ron's tour of the plant, which is laid out by process type (See Figure I), followed the manufacturing sequence for the windings: drawing, extrusion, winding, inspection and packaging. After inspection, good product is packaged and sent to nished product storage; defective product is stored separately until it can be reworked. . . , Finished Product Office Wire Drawrng Storage Extrusion Rework Department Receiving and Raw Winding Material Storage Packaging Rejected Product Storage Inspection Figure 1 Plant Layout of NS Wire Vivian Napoli, MG's general manager, stopped by Ron's ofce and asked him to attend a staff meeting. \"Let's get started with the business at hand\Assessment 3 OPS 910 Trimester 2 2023 Ron was surprised and apprehensive to receive such an important task so early in his career. Recording quickly, he said \"Give me your data and let me work with it for a couple of days\". Having studied business management particularly supply chain management, Ron knew that a good business report is essential for communication with the management team and was keen to do a goodjob. Data 1. Next month orders Product Units ordered (units) W0075C 1 ,400 W0033C 250 WOOOSX 1 ,5 1 0 W0007X 1 ,1 1 6 Note: Vivian Napoli has given her word to a key customer that MG Wire will manufacture 600 units of product W0007X and 150 units of product W0075C for him next month. 2. Standard cost Product Material Labour Overhead Selling Price W0075C $33.00 $9.90 $23.10 $100.00 W0033C $25.00 $7.50 $17.50 $80.00 W0005X $35.00 $10.50 $24.50 $130.00 W0007X $75.00 $11.25 $64.75 $175.00 3. Selected operating data Average output per month 2,400 units Average machine utilization 63% Average percentage of production sent to 5% (mostly from Winding Department) Rework Department Average number of rejected units awaiting 850 (mostly from Winding Department) rework 4. Plant capacity (hours) Drawing Extrusion 4,000 4,200 Packaging I Winding 2,300 | 2,000 Note: Inspection capacity is not a problem: we can work overtime as necessary to accommodate any schedule. 5. Bill of resource {hours/u nit) Product Drawing Extrusion Winding Packaging W0075C 1.0 1.0 1.0 1.0 W0033C 2.0 1.0 3.0 0.0 W0005X 0.0 4.0 0.0 3.0 W0007X 1.0 1.0 0.0 2.0 Assessment 3 OPS 910 Trimester 2 2023 Business Report Suppose you are in Ron's position, please conduct relevant analysis and prepare a business report to Joseph and Vivian based on the scenario of MG Wire. The report should contain all aspects listed below. Please use section/subsection headings (which do not need to be the same as the list below) that are meaningll to the topic under discussion. 0 Introduction: Clearly dene the business problem for MG Wire. 0 Problem formulation and solution: Formulate and solve the problem, and report the results from the managerial perspective. 0 Explanation of assumptions, including: F List and justify all assumptions you have made to formulate and solve the problem. This includes all assumptions got directly from the case study description and all additional assumptions you needed to make. F Explain which assumptions are key for formulating and solving the problem. Briey discuss what conditions would make key assumptions invalid, and, if key assumptions are invalid, how the results could change if relevant. 0 Sensitivity analysis: If relevant, discuss the results from the sensitivity report, and identify relevant information that could be help with decision making in MG Wire. 0 Discussions and recommendations , including but not limited to: F Discuss MG Wire's options for next month. F Comment on the need for temporary workers in the drawing department. F Does this analysis help decide which department needs new equipment? If yes, please explain your answer. If not, please describe the appropriate analysis technique to answer the question about new equipment, and discuss what additional data is needed. F Make recommendations with justications. Important note: 0 To complete the report, you will need to solve one or more linear program problems andfor decision trees, interpret the results, and make use of the sensitivity analysis results. 0 You may make reasonable assumptions and informed judgements as needed, but make sure to state them clearly in your report. Do not make assumptions merely to by-pass the challenges faced. 0 You may not need all the given data to formulate the problem, but they may be helpll for your follow-on analysis and discussions. 0 This is a business report for your manager. Please write the report in a business setting and make it accessible and easy to understand for the management who may not know a lot about analytics