Checkout
checkout
view
Your Cart Your Cart: item(s)
View Details $1.99 Download Add to Cart

Multistep problem involving stock options and profit. Solutions in MS Excel. Complete with Limit, Sensitivity and Answer reports.

The linear programming (LP) problem whose output follows determines how many necklaces (x1), bracelets (x2), rings (x3), and earrings (x4) a jewelry store should stock. The objective function measures profit; it is assumed that every piece stocked will be sold. Constraint 1 measures display space in units, constraint 2 measures time to set up the display in minutes. Constraints 3 and 4 are marketing restrictions. LINEAR PROGRAMMING PROBLEM Max 100X1 + 120X2 + 150X3 + 125X4 s.t. 1) X1 + 2X2 + 2X3 + 2X4 < 108 2) 3X1 + 5X2 + X4 < 120 3) X1 + X3 < 25 4) X2 + X3 + X4 > 50 ... click for more

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

1252

OTA ID:

102309

View Details $1.99 Download Add to Cart

Profit maximization using a linear programming model. Attachments in MS Word and Excel.

Three employees are to be assigned to three tasks. Each employee receives one task and all tasks must be accomplished. There is a known profit for each assignment. Formulate a linear programming model to maximize the total profit of the assignments. See attached file for table.

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

1253

OTA ID:

102157

View Details $1.99 Download Add to Cart

Defining variables, minimizing total cost and finding constraints. Attachments in MS Word and Excel.

The Westfall Company has a contract to produce 10,000 garden hoses for a large discount chain. Westfall has four different machines that can produce this kind of hose. Because these machines are from different manufacturers and use differing technologies, their specifications are not the same. a. This problem requires two different kinds of decision variables. Clearly define each kind. b. The company wants to minimize total cost. Give the objective function. c. Give the constraints for the problem. See attached file for table.

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

1254

OTA ID:

102157

View Details $1.99 Download Add to Cart

Achieving a pre-determined profit in profit maximization using linear programming. Attachments in MS Word and Excel.

Durham Designs manufactures home furnishings for department stores. Planning is underway for the production of items in the "Wildflower" fabric pattern during the next production period. Inventory of the Wildflower fabric is 3000 yards. Five hundred hours of production time have been scheduled. Four hundred units of packaging material are available. Each of these values can be adjusted through overtime or extra purchases. Durham would like to achieve a profit of $3200, avoid purchasing more fabric or packaging material, and use all of the hours scheduled (overtime is allowed). See attached file for additional information and table.

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

1255

OTA ID:

102309

View Details $1.99 Download Add to Cart

Finding the preferred choice using a weighted evaluation. Attachments in MS Word and Excel.

Mr. and Mrs. Brinkly are interested in purchasing condominium property in Naples, Florida. The three most preferred condominiums are listed along with criteria weights and rating information. Which condominium is preferred? See attached file for additional information.

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

1256

OTA ID:

102157

Page generated in 0.3008 seconds

About Us ·  Contact Us ·  Samples ·  Solutions ·  Legal Terms and Conditions ·  Privacy Policy

©2008 SolutionLibrary.com

Search for Solutions About Us Samples