Formulate the linear programming model for given problem

Assignment Help Engineering Mathematics
Reference no: EM13791535

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?

Please turning in two deliverables, a short writeup of the project and the spreadsheet or QM for Windows file showing your work.

Write up.

Your write up should introduce your solution to the project by describing the problem. Correctly identify what type of problem this is. For example, you should note if the problem is a maximization or minimization problem, as well as identify the resources that constrain the solution. Identify each variable and explain the criteria involved in setting up the model. This should be encapsulated in one (1) or two (2) succinct paragraphs.

After the introductory paragraph, write out the L.P. model for the problem. Include the objective function and all constraints, including any non-negativity constraints. Then, you should present the optimal solution, based on your work in Excel/QM for Windows. Explain what the results mean.

Finally, write a paragraph addressing the part of the problem pertaining to sensitivity analysis and shadow price.

Reference no: EM13791535

Questions Cloud

The evolution of social behavior and opportunities aris : The Evolution of Social Behavior and Opportunities Aris
Discuss your process in rewriting the story : Discuss your process in rewriting the story from a different point of view. What did you find most interesting and most challenging about this task?
Most severe effects of hypervitaminosis : The effects of OCAs depend upon four characteristics of the user. What are the four characteristics?
Would you like to work for a large firm or a small business : Would you like to work for a large firm or a small business? Private or public? In an office or out in the field? Give your reasons for each answer.
Formulate the linear programming model for given problem : Formulate the Linear Programming model for this problem. Solve the problem using Excel Solver or QM for Windows.
Current or future applications of nanotechnology : Provide at least three examples of real-world applications in use or in development with reliable references.
Analyzes the structure of the organization : Assesses the organization's competitive position and possibilities. Analyzes the structure of the organization and how this affects organizational performance
Forensic psychology and ethics and diversity : Forensic Psychology: Ethics and Diversity
Briefly discuss what practical factors : Topic After watching the resource videos for this week, briefly discuss what practical factors you would consider when using each of the methods for data visualization (bar chart, pie chart, histogram, boxplots etc.). Are there any situations in whic..

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  Prime number theorem

Dirichlet series

  Proof of bolzano-weierstrass to prove the intermediate value

Every convergent sequence contains either an increasing, or a decreasing subsequence.

  Antisymmetric relations

How many relations on A are both symmetric and antisymmetric?

  Distributed random variables

Daily Airlines fies from Amsterdam to London every day. The price of a ticket for this extremely popular flight route is $75. The aircraft has a passenger capacity of 150.

  Prepare a system of equations

How much money will Dave and Jane raise for charity

  Managing ashland multicomm services

This question is asking you to compare the likelihood of your getting 4 or more subscribers in a sample of 50 when the probability of a subscription has risen from 0.02 to 0.06.]  Talk about the comparison of probabilities in your explanation.

  Skew-symmetric matrices

Skew-symmetric matrices

  Type of taxes and rates in spokane wa

Describe the different type of taxes and their rates in Spokane WA.

  Stratified random sample

Suppose that in the four player game, the person who rolls the smallest number pays $5.00 to the person who rolls the largest number. Calculate each player's expected gain after one round.

  Find the probability density function

Find the probability density function.

  Develop a new linear programming for an aggregate production

Linear programming applied to Aggregate Production Planning of Flat Screen Monitor

  Discrete-time model for an economy

Discrete-time model for an economy

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd