2458) A manufacturing company produces two lines of designer gates, called model A and model B. Every gate requires blending a certain amount of steel and zinc; the company has a total of 25,000kg of steel and 6000kg of zinc. Each Model A gate requires a mixture of 125kg of steel and 20kg of zinc and yields a profit of $90. Each Model B gate requires 100kg of steel and 30kg of zinc and can be sold for a profit of $80. Write the objective equation and constraint equations. And set up an excel spreadsheet and use excel solver to find how many Model A and Model B gates should be made to produce max profits. (include the excel sheet and also the the solutions)

2458) A manufacturing company produces two lines of designer gates, called model A and model B. Every gate requires blending a certain amount of steel and zinc; the company has a total of 25,000kg of steel and 6000kg of zinc. Each Model A gate requires a mixture of 125kg of steel and 20kg of zinc and yields a profit of $90. Each Model B gate requires 100kg of steel and 30kg of zinc and can be sold for a profit of $80. Write the objective equation and constraint equations. And set up an excel spreadsheet and use excel solver to find how many Model A and Model B gates should be made to produce max profits. (include the excel sheet and also the the solutions)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section: Chapter Questions

Problem 47P

See similar textbooks

Similar questions

The formula to compute the Break-Even Analysis is QBE = F/ (SP - VC). Select one: True False
A manufacturer has a production facility that requires 10,237 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 6 days. The unit purchase cost is $31.4 per unit. The cost to place and process an order from the supplier is $168 per order. The unit inventory carrying cost per year is 12.2 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 1,053 units per order, what is the annual holding cost? Use at least 4 decimal places.
26) please help me!! Meritor, a company that makes muffler assemblies for the automotive industry, is committed to the use of kanban to pull material through its manufacturing cells. Meritor has designed each cell to fabricate a specific family of muffler products. Fabricating a muffler assembly involves cutting and bending pieces of pipe that are welded to a muffler and a catalytic converter. The mufflers and catalytic converters are pulled into the cell based on current demand. The catalytic converters are made in a specialized cell. Catalytic converters are made in batches of 15 units and are moved in special hand carts to the fabrication cells. The catalytic converter cell is designed so that different types of catalytic converters can be made with virtually no setup loss. Meritor hires a team of consultants. The consultants suggest a partial robotic automation, as well as an increase in safety stock to 8.5 percent. Meritor implements these suggestions. The result is an increase in…
5. Meg Jones, the CEO of Ajax Computer Company, and Brad Smith, its Director of Operations, had been discussing how to increase the firm’s production of the company’s flagship XR58. The XR58 was particularly important because it sold 12,500 of them in the most recent year for $950, at a gross margin of 55%. After a lot of discussion, they decided to pursue an incentive system designed to increase production by 12% in the next year. After Brad discussed this possible incentive with the production team, the team determined that it could increase production by this amount without adding any more people or equipment. They believed they could accomplish this improvement primarily through process redesign. To incent them to do the hard work of process improvement, Brad told the team that it would receive 25% of the increased profits if it met the new production goal. For this team of 20 people, this would mean an additional compensation of _________ for each team member, on average, for…
Non-inventory goods were purchased and delivered on June 15, 2010. Several security interests exist in these goods. Which of the following security interests has priority over the others? Group of answer choices purchase money security interest perfected June 24, 2010 Security interest perfected June 20, 2010 Security interest attached June 15, 2010 Security interest in future goods attached on June 10, 2010
The Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Orders: 1230 1155 1263 1159 1361 1273 1147 1250 1356 1155 Create tables to support your answer: a. Compute the monthly…
The Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Orders 145 70 115 85 120 54 82 141 123 94 Compute the…
The Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Orders 145 70 115 85 120 54 82 141 123 94 Compute the…
d) A company can produce three products A, B and C. the products yield a contribution of Kshs.8, 5 and 10 respectively. The products use a machine which has 400 hours capacity. Each unit of the product uses 2, 3 and 1 hour respectively of the machines capacity. There are only 150 units available in the period of a special component which is used singly in product A and C. Only 200kgs of a special alloy is available in the period. The usage of special alloy is 2kgs per unit and 4kgs per unit respectively. There is an agreement with a trade association to produce no more than 50 units of product B in the period. Advise the company on the production plan that will maximize contribution.
Reduces costs and their feasibility ranges are rooted in making changes in the right hand side of the constraint. Your answer: True False
A company owns a 5-year-old turret lathe that has a book value of $23,000. The present market value for the lathe is $18,000. The expected decline in market value is $1,700/year to a minimum market value of $4,080; maintenance plus operating costs for the lathe equal $4,470/year.A new turret lathe can be purchased for $46,000 and will have an expected life of 8 years. The market value for the turret lathe is expected to equal $46,000(0.70)k at the end of year k. Annual maintenance and operating cost is expected to equal $1,900. Based on a 12% MARR, should the old lathe be replaced now? Use an equivalent uniform annual cost comparison, a planning horizon of 7 years, and the cash flow approach.EUAC for keeping old turret lathe: $EUAC for replacing turret lathe: $
A manufacturing cell makes three models of a product – AKC1011, BC0001, and AC0102. The daily demand for the three products are as follows: 200 of AKC1011, 500 BC0001, and 300 of AC0102. Develop a balanced mixed-model sequence that should be repeated throughout the day in order to meet demand.