How much space will be left unused

Assignment Help Operation Management

Reference no: EM13753466

Assignment: Linear Programming Case Study

A beauty salon tries to determine how many bottles of fire red nail polish, bright red nail polish, basil green nail polish, and basic pink nail polish to stock. The profits for each nail polish; assumming that every piece stocked will be sold, are as follows: $100 per bottle of fire red nail polish, $120 per bottle of bright red nail polish, $150 per bottle of basil green nail polish, and $125 per bottle of basic pink nail polish. The display space and set up time requirements are listed in the table. Note that green nail polish does not require any time to prepare its display.

Display requirements	fire red	bright red	basil green	basic pink	available
Display space (units)	1	2	2	2	108
Time to set up a display (minutes)	3	5		1	120

The maximum demand combined for fire red and green polish is 25 bottles, while the minimum demand combined for bright red, green and pink nail polish bottles is at least 50 bottles.

a) Formulate the Linear Programming model for this problem

b) Solve the problem using Excel Solver or QM for Windows

c) How many bottles of fire red nail polish, bright red nail polish, basil green polish and pink nail polish should be stocked?

d) What is the maximum profit?

e) How much space will be left unused?

f) How many minutes of idle time remaining for setting up the display?

g) To what value can the per bottle profit on fire red nail polish drop before the solution would change?

h) By how much can the per bottle profit on green basil nail polish increase before the solution would change?

i) Is it possible for saloon to increase the profit by getting more display space or using more time for setting up the displays?

Reference no: EM13753466

Questions Cloud

Explain how cost-volume-profit analysis : Review the Chapter opener. Johnny Cupcakes, launched by entrepreneur John Earle, produces t-shirts in unique styles and limited quantities. Selling prices typically range from $40 per shirt to $70 per shirt. Identify at least two fixed costs that wi..

What would be the sales budget for march of fantastic futons : Finished goods inventory at the end of 2013 was 10,000 units. On average, 25% of the futons to be sold in the next month are produced and kept as ending balance in finished goods inventory. The planned selling price is $150 per unit. What would be th..

What are the benefits of learning about non-us opinion : What are the benefits of learning about non-US opinion about and influence upon the United States? What are the challenges?

Consider financial aspects of digital thermometer project : Consider the financial aspects of the digital thermometer project. The project cost is estimated at $10,000. The total manufacturing cost of the digital thermometer, as called for in the specifications, total $150 (that is, $95 parts plus $40 labor p..

How much space will be left unused : How much space will be left unused AND How many minutes of idle time remaining for setting up the display

Transactions on the taxable business income : Discuss business with Joe during this visit, but Joe wants to maintain good relations to encourage additional business next year - Determine the effect of each of the transactions on the taxable business income.

Financial ratios for the assigned company : Calculate the financial ratios for the assigned company's financial statements, and then interpret those results against company historical data as well as industry benchmarks:

What is explains the lack of cholera outbreaks in japan : explains the lack of cholera outbreaks in Japan? The most important factor in the British conquest of India during the eighteenth century was the.

Amount credited to flaxs capital account : Chase and Hatch are partners and share equally in income or loss. Chase's current capital balance is $186,000 and Hatch's is $162,500. Chase and Hatch agree to accept Flax with a 30% interest in the partnership. Flax invests $166,000 in the partnersh..

User Account

All Pages