Business, 19.03.2021 18:00 RayeK168

A picture frame company produces four types of frames. Each type requires a certain amount of skilled labor, metal, and glass as shown in the table below. The unit selling price of each type is also shown in the table. During the coming week, the company can purchase up to 4,000 hours of skilled labor, 6,000 ounces of metal, and 10,000 ounces of glass. The unit costs are $8 per labor hour, $0.5 per ounce of metal, $0.75 per ounce of glass. Also, market constraints are such that it is impossible to sell more than 1000 type 1 frames, 2000 type 2 frames, 500 type 3 frames, and 1000 type 4 frames. a) Formulate a linear programming model that maximizes the company’s weekly profit and put it in standard format. (clearly define any decision variables and constraints).
b) Solve the problem using Excel solver to find the optimal solution
c) Based on your solution and sensitivity analysis, if you need to drop one of the products, which one would it be and why
d) Based on your solution and sensitivity analysis, what is the most valuable resource and why
Skilled Labor Metal Glass Selling Price
Frame 1 2 4 6 $ 28.50
Frame 2 1 2 2 $ 12.50
Frame 3 3 1 1 $ 29.25
Frame 4 2 2 2 $ 21.50

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 06:00

Transactions on april 1 of the current year, andrea byrd established a business to manage rental property. she completed the following transactions during april: opened a business bank account with a deposit of $45,000 from personal funds. purchased office supplies on account, $2,000. received cash from fees earned for managing rental property, $8,500. paid rent on office and equipment for the month, $5,000. paid creditors on account, $1,375. billed customers for fees earned for managing rental property, $11,250. paid automobile expenses for month, $840, and miscellaneous expenses, $900. paid office salaries, $3,600. determined that the cost of supplies on hand was $550; therefore, the cost of supplies used was $1,450. withdrew cash for personal use, $2,000. required: 1. indicate the effect of each transaction and the balances after each transaction: for those boxes in which no entry is required, leave the box blank. for those boxes in which you must enter subtractive or negative numbers use a minus sign. (example: -300)

Answers: 1

Answer

Business, 22.06.2019 12:10

Which of the following is not part of the mission statement of the department of homeland security? lead the unified national effort to secure america protect against and respond to threats and hazards to the nation ensure safe and secure borders coordinate intelligence operations against terrorists in other countries

Answers: 1

Answer

Business, 22.06.2019 16:10

The following are line items from the horizontal analysis of an income statement:increase/ (decrease) increase/ (decrease) 2017 2016 amount percent fees earned $120,000 $100,000 $20,000 20% wages expense 50,000 40,000 10,000 25 supplies expense 2,000 1,700 300 15 which of the items is stated incorrectly? a. fees earned b. supplies expense c. none of these choices are correct. d. wages expense

Answers: 3

Answer

Business, 22.06.2019 20:20

An economic theory that calls for workers to take control of factories is .

Answers: 3

Answer

You know the right answer?

A picture frame company produces four types of frames. Each type requires a certain amount of skille...

Questions