A Case Study Mexican Wire Works

Powerful Essays
Mexican Wire Works Case Study

Abstract

Mexican Wire Works is a producer of wire windings used in making electrical transformers. This company has the good fortune of booking more orders then they can fill. The company has ordered new equipment to help in the long term, but they still have a short term issue. In addition, the company is refinancing long term debt and needs profits to be as high as possible to counteract the effects of this refinance. The problem is to select the orders that will make the company the most profitable for the month, while keeping customers happy by filling their minimum requirements.

Introduction Mexicana, a subsidiary of Westover Wire Works, a Texas firm, is a medium-sized producer of
…show more content…
Using Linear Programming an QM for Windows software, Ron has found that the maximum profits of $59,900 can be achieved from the manufacturing 1,100 units of W0075C , 250 units of W0033C , and 600 units of W0007X . The result also suggests not to produce W0005C product. Looking at the need for additional temporary workers in the drawing department. Ron determined that by adding more headcounts in the drawing department, it is going to reduce the labor time yet it increases the labor cost up to 32%. The quantity of the product will still be the same but will decrease the profit to $53,653 due to no increase in the pricing but burdened by the increased in production cost. Ron 's recommendation should be to produce 1,100 units of W0075C , 250 units of W0033C , and 600 units of W0007X to increase the company 's profit margin. Company must turn down the orders to produce 1,510 units of W0005X because it is better for the company not to increase the number of employee in the drawing department in order to keep the cost down.

References
Render, B., Stair, R., & Hanna, M. (2012). Mexicana Wire Works. Quantitative Analysis for Management,

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Henry Clements Car rental

    • 453 Words
    • 4 Pages

    From this data, as well as the data given on manufacturing methods and hours per method, a solution could be found utilizing the linear programming method of analysis. To analyze the data, the actual profit on each material was first calculated. This was done by taking the selling price and subtracting each cost associated with the given material. The results are $34.00 for the 75C, $30.00 for the 33C, $60.00 for the 5X, and $25.00 for the 7X. The next step was to determine how many constraints would be part of the analysis. There was determined to be 10 constraints in the analysis, 4 for the April orders, 4 for the manufacturing methods and 2 for the minimum orders promised by Vivian. With this data, the amount of each product to be produced to maximize profit for April could be determined. The results can be seen in Table 3.…

    • 453 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    JGT Task 2

    • 1850 Words
    • 6 Pages

    Alistair Wu has requested that I look at what the lowest shipping schedule and cost can be based on data that he has provided. He wants to know what the lowest possible cost of shipping will can be. Mr. Wu is also considering increasing production at the Shanghai factory from 1,300 to 2,800 units, and wants to ensure that this growth will be an affordable choice. The first chart that was given lists the factory capacity and what each warehouse demand is. The second chart lists the price of shipping from each factory to each warehouse. The chart looks at the demand in the warehouses as well as the cost to ship there from each factory. It then generates a cost effective shipping plan to ship products to the warehouse with least shipping expense and fills those warehouses first. It then allocates additional products to other warehouses that have higher shipping prices. This is evident with Shuzworld H and Shuzworld F, the program ships the most products to the lower priced warehouses 1 and 3. Warehouse 1 need 2,500 units but Shuzworld F only produces 2,200 units. That means Warehouse 1 will take all off the units from Shuzworld F and still have a demand of 300 units. Warehouse needs 1,800 units and Shuzworld H produces 2,300 units. This means Warehouse 3 will receive all of its units from Shuzworld H and Shuzworld H will still have an excess of 500 units.…

    • 1850 Words
    • 6 Pages
    Good Essays
  • Good Essays

    Rock "N" Rap

    • 597 Words
    • 3 Pages

    Find out how many CDs the company should make of each type next month to maximize its profit. It should make 5 and five ninths of each CD to maximize profit. I know this because this is the highest point in the feasible region.…

    • 597 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Employment and Wage Rate

    • 670 Words
    • 3 Pages

    Sam owns a candy factory and hires workers in a competitive labor market to case the bags of candy. His company's weekly output of cases of candy varies with the number of workers hired, as shown in the table:…

    • 670 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Direct Labour

    • 844 Words
    • 4 Pages

    Examine the data you have computed in (1) and (2) above. How would you allocate the 130,000 direct labor hours of capacity to Gen Toy Company’s various products?…

    • 844 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    EXCEL SOLVER TUTORIAL

    • 460 Words
    • 3 Pages

    Many firms face the problem of how to best use multiple scarce resources. Linear programming is designed to help find the product mix that maximizes profits in the short run when multiple constraints exist. While linear programming can be solved as a mathematical problem using pencil and paper, it is much more efficient to use Excel Solver. The key to using Excel Solver is to make certain you have modeled the problem correctly and then interpreted the results appropriately. In this problem we will practice the use of Solver.…

    • 460 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    1.(Tco a)

    • 380 Words
    • 2 Pages

    Increase the production levels more than increasing the price as now you can generate incremental net profit at same pricing. If the price of a substitute good increases, then demand for your product should increase.…

    • 380 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    MIS 304 first assignment

    • 372 Words
    • 2 Pages

    Clickr Q: A new accounting system is being deployed to the accounting department, 10 employees at $20/h + $10/h in benefits ea. require 20 hours of training. To offset this, 100 hours of overtime will be required, assume OT at Time-and-a-half, with benefits are still $10 an hour. What is the real labor cost of this training?…

    • 372 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    ECW Case Study Essay

    • 1323 Words
    • 6 Pages

    Hines recognized that using a digital decal computer system to print the decals on CPs would be a nice attempt. The usage of the system will replace Hines by an unskilled worker who would be trained only several times. This will not only reduce Hines working time and increase the production capacity also control the whole production and design processes completely. If so, Hines can concentrate on working on butter chum lamps which will generate $210.00 profit ($350*0.6) for each week two to three additional units. However, the fixed cost of purchasing decal equipment will be $6600. If ECW wants to fulfill the order of 3000 CPs in coming year, the total variable cost will be $35,070.00. The profit will be $33,330.00 by subtracting $41,670(fixed cost + variable cost) from $75,000.00. But Hines concerned about the negative impacts by using decal computer system because she claimed that her pieces were “hand painted” and…

    • 1323 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    Mile High Cycle Essay

    • 447 Words
    • 2 Pages

    If he can sell all the extra production, the impact in total cost would be reduced in approximately $500k. See reconciliation below:…

    • 447 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The Martinez Company has decided to introduce a new product and would like to evaluate the costs of manufacturing through capital intensive and labor intensive manufacturing methods to determine which of the two methods to employ. The values to be used in the evaluation for capital intensive manufacturing are direct materials at $5 per unit, direct labor at $6 per unit, a variable overhead of $3 per unit, and fixed manufacturing costs of $2,508,000. The values for material, labor, and overhead are summed to find the total variable cost of $14. The labor intensive values are direct materials at $5.50 per unit, direct labor at $8 per unit, a variable overhead of $4.50 per unit, and fixed manufacturing costs of $1,538,000. The research department of Martinez recommended an introductory price unit sales price of $30. Incremental selling expenses are estimated to be $502,000 annually plus $2 for each unit sold regardless of the method used to manufacture.…

    • 605 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Exam 2: Pre-Test Questions

    • 4437 Words
    • 18 Pages

    33. The following data have been recorded for recently completed Job 674 on its job cost sheet. Direct materials cost was $2,039. A total of 32 direct labor-hours and 175 machine-hours were worked on the job. The direct labor wage rate is $14 per labor-hour. The company applies manufacturing overhead on the basis of machine-hours. The predetermined overhead rate is $15 per machine-hour. The total cost for the job on its job cost sheet would be:…

    • 4437 Words
    • 18 Pages
    Satisfactory Essays
  • Good Essays

    5. Estimate the ABC-based cost and profitability of Wilkerson’s three product lines by estimating the various activity cost driver rates using the manufacturing overhead amount and actual total usage data of the various activity cost drivers in March 2000 provided in Exhibit 4. Why are these costs and profits different from the product costs reported in Exhibit 2? What causes any shifts in cost and profitability?…

    • 585 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Thicket Wood Inc

    • 2852 Words
    • 12 Pages

    Thicket Wood Ltd. produces high-quality custom and handcrafted kitchen cabinets. They have a forecasted demand of two thousand kitchen cabinets this upcoming year. To meet this demand Mark Taylor operations manager must purchase a new or used CNC router machine and re-arrange his employees. Mark needs to re-arrange his employees to maximize the benefit of the CNC routing machine and meet the required demand of cabinets. There are six employees to re-arrange if he were to purchase the new CNC routing machine and seven employees to re-arrange if he choose to purchase the used CNC routing machine. To determine which machine he should invest in we have calculated the payback period for each option. It was determined that the new CNC routing machines payback period is three years, equivalent to the three years it is covered under warranty. The used CNC routing machine has a payback period of one year and eight months witch exceeds the warranty of one year. Mark decides to go with the new CNC routing machine form High Tech Inc. do to these calculations. We have also determined how many cabinets the production line can produce per year with the re-arranged line of six workers and the new CNC router machine. We know that working at maximum capacity is unrealistic therefore we have also determined how many cabinets we can produce at a lower production capacity. These calculations also help solve the second part of the main problem Thicket Wood is facing, meeting the demand of two thousand cabinets for the upcoming year. There are also sub problems which Thicket Wood will possibly face such as bottlenecks in the production line. As well as the implementation of the new CNC router machine which would then reclassify their product and require them to restructure their sales pitch.…

    • 2852 Words
    • 12 Pages
    Powerful Essays
  • Good Essays

    Costs and Location

    • 1204 Words
    • 5 Pages

    5. Suppose that you are the manager of a production department that uses 400 boxes of rivets per year. The supplier quotes you a price of $8.50 per box for an order size of 199 boxes or less, a price of $8.00 per box for orders of 200 to 999 boxes, and a price of $7.50 per box for an order of 1,000 or more boxes. You assign a holding cost of 20 percent of the price to this inventory. What order quantity would you use if the objective is to minimize total annual costs…

    • 1204 Words
    • 5 Pages
    Good Essays