Linear programming model by using microsoft excel

Assignment Help Operation Management

Reference no: EM13756719

Solve the following linear programming model by using Microsoft Excel:

minimize Z = 3x1 + 6x2

subject to 7x1 + 3x2 ? 40 x1, x2 ? 0 and integer

A jeweler and her apprentice make silver pins and necklaces by hand. Each week, they have 80 hours of labor and 36 ounces of silver available. It requires 8 hours of labor and 2 ounces of silver to make a pin and 10 hours of labor and 6 ounces of silver to make a necklace. Each pin also contains a small gem of some kind. The demand for pins is no more than six per week. A pin earns the jeweler $400 in profit, and a necklace earns $100. The jeweler wants to know how many of each item to make each week to maximize profit. Formulate an integer programming model for this problem. Solve the linear programming model that you formulated. Compare this solution with the solution without integer restrictions and indicate whether the rounded-down solution would have been optimal.

Reference no: EM13756719

Questions Cloud

In addition to improved employee retention : In addition to improved employee retention, what are some other areas of potential economic benefit to the organization from having a human resource department? What calculations would you do to prove such benefits?

Measure the realization of the business strategy : Describe the action steps utilized by Google to implement a business strategy. And describe the objectives utilized by Google to measure the realization of the business strategy.

What is the minimum gas price : 1. Current MSRP of Toyota Prius is $24,200 and the MSRP for Corolla is $16,950. Both cars share the same size and features, and the only difference is fuel economy. If you are planning on purchasing one of the two cars and keeping it for 6 years, wha..

Identify the organizational theory : Analyze how functions within the company are organized differently and identify the organizational theory that drives organizational design changes in response to industry changes.

Linear programming model by using microsoft excel : Solve the following linear programming model by using Microsoft Excel: A jeweler and her apprentice make silver pins and necklaces by hand. Each week, they have 80 hours of labor and 36 ounces of silver available. It requires 8 hours of labor and 2 o..

Characteristics that effective standardized work instruction : What are some of the characteristics that effective standardized work instructions have? What are the benefits that organizations can enjoy by implementing them after close of a project?

Information from the perspective of the quality life cycle : Analyze the information from the perspective of the quality life cycle and Figure 11.1. Determine when St. Luke’s made the transition from one stage to the next and submit your response.

Minimum wage increase-minimum wage issue guide web page : In 2009 the Federal minimum wage was increased to $7.25 per hour. Select any one of the facts listed on the Fact Sheet for 2009 Minimum Wage Increase—Minimum Wage Issue Guide Web page published by The Economic Policy Institute, linked in the Resource..

Explain how a customer relationship management system : Information technology and management information systems allow organizations, regardless of size, to communicate, collaborate, share information, make data driven decisions, and monitor all aspects of performance. Explain how a customer relationship..

User Account

All Pages