Decision variables and constraints for optimization problem

Assignment Help Operation Management
Reference no: EM131145919

Howie Jones owns and operates Blue Ridge Hot Tubs, a company that sells two models of hot tubs: the Aqua-Spa and the Hydro-Lux. Howie purchases prefabricated fiberglass hot tub shells and installs common water pumps and the appropriate amount of tubing into each hot tub. Every Aqua-Spa requires a pump, 12 hours of labor and 16 feet of tubing; every Hydro-Lux requires 2 pumps, 16 hours of labor and 8 feet of tubing. Demand for these products is such that each Aqua-Spa produced can be sold to generate a profit of $275, and each Hydro-Lux produced can be sold to generate a profit of $250. The company expects to have 450 pumps, 91 workers, and 3,080 feet of tubing available during the next week’s production cycle. Determine the optimal number of Aqua-Spas and Hydro-Luxes to produce to maximize profit assuming all employees work their 40 hours with no overtime.

a. What are the objective function, decision variables, and constraints for this optimization problem? (Just put into words)

b. Develop an Excel spreadsheet and use Excel-Solver to find an optimal solution for this problem.

(for part b, you have to turn in two separate printouts of your spreadsheets. First, use the “Print Screen” key to copy the image displayed on the monitor of your spreadsheet with the optimal solution and the Solver dialog box and paste it into MS WORD. Second, turn on the formula display option in Excel (use the key combination “Ctrl” and “~” together) and then repeat the first step for this new view of the spreadsheet. Examples of the two types of screen shots are given below. You should save a copy of your spreadsheets for future reference.)

c. Describe the optimal solution in words.

Reference no: EM131145919

Questions Cloud

Technical communication seeks : Which statement below is LEAST accurate? possibly plagiarize each other’s work. All of the following are examples of social or psychological constraint EXCEPT: Of the following statements, which is NOT accurate? Technical communication seeks to:
Reworking findings to make them more useful or appealing : Reworking findings to make them more useful or appealing: When others offer an opposing view, try to: Documents that focus on what people need to learn, do, or decide are:
Effective technical documents : Your audience will have preferences about all of the following EXCEPT: Effective technical documents: The preferred strategy for connecting with an audience is: A claim can be a statement that:
Development production facilities outside : In the past, Harley Davidson avoided development production facilities outside the United States. More recently and in accordance with their annual report, they developed a production facility in India. Why in your opinion and preferably supported by..
Decision variables and constraints for optimization problem : Howie Jones owns and operates Blue Ridge Hot Tubs, a company that sells two models of hot tubs: the Aqua-Spa and the Hydro-Lux. Howie purchases prefabricated fiberglass hot tub shells and installs common water pumps and the appropriate amount of tubi..
Principal of the only comprehensive high school : Jane Smith has been a new principal of the only comprehensive high school in a small mid-western town for just the past ten months of school. It is the last two months of school, Jane and her staff are preparing for the senior graduation ceremony. ho..
Explain the court systems child benefit theory : Explain the court systems’ child benefit theory” when it comes to the legality of aid to parochial and other sectarian schools through government entitlements such as Title I or Chapter II Funding programs. Your essay should cite several key early ca..
Use the medium or the method of interpolation method : With the data (number of cars parked at the University of Turabo - Campus Gurabo in 12 days) prepare a bloxplot. For this purpose you can use the medium or the method of interpolation method. After making a sketch, indicate whether the data has outli..
Variety of levels including race-ethnicity-gender and age : When it comes to discrimination, the workplace today is a far cry from what it was even two decades ago. Activists, companies and legislators have taken many steps to curb discrimination at a variety of levels including race, ethnicity, gender and ag..

Reviews

Write a Review

 

Operation Management Questions & Answers

  Information about an infinite source waiting line system

A manager assembled the following information about an infinite source waiting line system: one server, an arrival of 8 per hour, and a service time of 6 minutes, Determine each of the following:

  Analyse the issue regarding going digital

John is a manager in the Gardening department at ABC Hardware. Last week the general manager was fired for incompetence. The chief executive officer appointed John to be the new general manager. Analyse the issue regarding "going digital" and explain..

  Conduct an internal strategic management audit

Explain how you would conduct an internal strategic management audit and competitive strength assessment. As a business leader, explain how you would organize a strategic internal information scanning system.

  Most significant differences in delivering a presentation

What are the most significant differences in delivering a presentation in person versus online? What are the most significant differences in watching a presentation in person versus online? How does the desired effect on the audience influence your c..

  How are project stakeholders managed

What are some ways to handle conflict in a project team. How are project stakeholders managed

  What is the total annual purchasing and transportation cost

What is the probability that all three suppliers will be disrupted using option 1. What is the probability that all three suppliers will be disrupted using option

  Identify any issue that may occur if manager lacks integrity

Please provide a 1-page reflection paper on why you feel integrity is an important value for a manager to have. Give an example of how a manager with integrity can help a team. Identify any issues that may occur if a manager lacks integrity.

  Global customers-purchase the same goods and services

Some companies believe that teenagers in industrial nations (about 27 nations) are becoming ‘global customers.’ That is, these teenagers all want and purchase the same goods and services. Do you agree or disagree with this statement? Explain your pos..

  Key environmental concerns for humans

Read the chapter on environmental ethics in the text and select one of the key environmental concerns for humans that were outlined: global warming, ozone depletion, waste disposal and pollution, wilderness preservation, or international environmenta..

  What is the optimal weekly profit

Profits for light beer are $2 per bottle, and profits for dark beer are $1 per bottle. What is the optimal weekly profit?

  Regarding the possibility of racial egalitarianism

Reflect upon race relations in South Africa, Brazil, and the United States. Select a particular issue discussed in the course material and compare/contrast across cases. How are the racial histories similar and different? How has each country respond..

  Change situation that you have participated in or observed

Describe a change situation that you have participated in or observed. What lasting images do you have both good and bad that may be useful in this course? Using the cases described in chapter 1 of the textbook as a reference, describe why there are ..

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