Develop and implement a linear optimization model

Assignment Help Operation Management
Reference no: EM132190552

Q 1: Spreadsheet Modeling

A stockbroker calls on potential clients from referrals. For each call, there is a 10% chance that the client will decide to invest with the firm. Fifty-five percent of those interested are found not to be qualified, based on the brokerage firm's screening criteria.

The remaining are qualified. Of these, half will invest an average of $5,000, 25% will invest an average of $20,000, 15% will invest an average of $50,000, and the remainder will invest $100,000. The commission schedule is as follows:

Transaction Amount

Commission

Up to $25,000

$50 + 0.5% of the amount

$25,001 to $50,000

$75+0.4% of the amount

$50,001 to $100,000

$125+0.3% of the amount

a) What is the expected commission based on making 600 calls?

b) How will the commission change when the number of calls change? (Hint: use a data table)

2: Spreadsheet Modeling

You operate a luxury hotel that famous celebrities rent for extended periods. The daily price is per room is $1,950. Operating costs average $60,000 per day, regardless of the number of rooms rented. Construct a spreadsheet model to determine the profit if 60 rooms are rented.

The manager has observed that the number of rooms rented during any given day varies between 50 and 80 (the total number of rooms available).

a) Use data tables to evaluate the profit for this range of unit rentals.

b) Suppose the manager is considering lowering or increasing the daily price by $100. How will profit be affected? (Hint: use a two-way data table).

 Q3: Linear Optimization

OPRE 605.7BE Inc,, has three flagship products: Absolute Sling Chairs, Awesome Tables, and Unbeatable Hammocks. The unit profit for these products is $45, $90, and $95, respectively.

Each type of product requires manufacturing, transportation to warehouse, and marketing. The owners are very ambitious and can work 40 hours each week and so have 200 hours available each month.

However, they are unable to spend more than 60 hours on any one activity (manufacturing, transportation, and marketing) in a month. The products are in such high demand that they are easily sold each month.

It takes 30 minutes to manufacture one Absolute Sling Chairs. Transportation to warehouses takes 45 minutes and marketing takes 1 hour. Awesome tables take 2 hours for both the manufacturing and transportation phases, and marketing takes 1 hour. For Unbeatable Hammocks, manufacturing takes 0.4 hours; transportation takes 3 hours; and marketing also takes 1 hour. How many of each product should OPRE 605.7BE Inc. produce each month to maximize profit?

a) Develop and implement a linear optimization model and clearly explain the sensitivity report.

b) Suppose that OPRE 605.7BE Inc. shareholders voted to limit the number of Absolute sling chairs to at most 25. How will the solution from part (a) change?

c) Suppose that OPRE 605.7BE Inc. gets an intern for the summer and therefore can increase the available hours for each activity by 5 hours each month. How will the solution from part (a) change?

Hint: for b) and c), you will need to just change the limitations but save each in a separate tab.

Q4: Linear Regression

A national homebuilder builds single-family homes and condominium-style townhouses. The dataQuestion 4 Data(in the Excel file Final Data) provides information on the selling price, lot cost, type of home, and region of the country (Midwest, and South)for closings for one month.

a) Develop a multiple regression model for sales price as a function of lot cost and type of home without any interaction term.

b) Determine if an interaction exists between lot cost and type of home and find the best model. What is the predicted price for either a single-family home or a townhouse with a lot cost of $45,000? (Hint: remember to convert home type to numeric, setting Townhouse to 1 and Single Family to 0 before creating the interaction)

c) Determine if an interaction exists between lot cost and region and find the best model. (Hint: convert the region variable to numeric, setting Midwest to 1 and South to 0. The model in c should also include the independent variables in b)

d) What is the strongest predictor of selling price?

Q5: Linear Regression

The data Question 5 Data (in the Excel file Final Data) provides various data on professional football for one season.   

a) Construct a scatter diagram for Points/Game and Yards/Game in the Excel file. Does there appear to be a linear relationship?

a) Develop a regression model for predicting Points/Game as a function of Yards/Game. Explain the statistical significance of the model.

b) Draw conclusions about the validity of the regression analysis assumptions from the residual plot and standard residuals.

Q 6: Spreadsheet Modeling

OPRE 605.8B Experts (OBE) specializes in laser-assisted corrective eye surgery. Prospective patients need to be screened to ensure they would be suitable candidates for the procedure. if they are, a $250 charge is applied as a deposit for the actual procedure.

Each week, about 180 people sign up to screened, and about 8% of them patients fail to show up or cancel their exam at the last minute. Patients that do not show up are refunded the prescreening fee less a $45 processing fee.

OBE can handle 185 patients per week and is considering overbooking its appointments to reduce the lost revenue associated with cancellations. However, any patient that is overbooked may spread unfavorable comments about the company; thus, the overbooking cost is estimated to be $125.

a) Develop a spreadsheet model for calculating net revenue.

b) Find the net revenue and number overbooked if 170 through 190 appointments are taken.

Reference no: EM132190552

Questions Cloud

Coworker shared that supervisor was aware of conflict : The coworker shared that the supervisor was aware of the conflict, but did nothing to resolve.
Discuss different concepts presented in the articles : Read four (4) academically reviewed articles on Market Structure and Competition. Complete the following activities (700 words)
Prepare conceptual design for a wastewater treatment system : ENVT 0002 - Introduction to Environmental Engineering - prepare a conceptual design for a wastewater treatment system for the selected Wilayat
Steps in the process of supply chain network design : What are the steps in the process of supply chain network design? discuss differences and relationships between purchasing, procurement, and strategic sourcing.
Develop and implement a linear optimization model : A stockbroker calls on potential clients from referrals. For each call, there is a 10% chance that the client will decide to invest with the firm.
Prepare strategic position and action evaluation matrix : Prepare a Strategic Position and Action Evaluation (SPACE) Matrix for Starbucks.
Learn how to build in practical measures : Course Objective: Learn how to build in practical measures that will keep the organization on track.
How can you apply the conclusions of your assessment : How can you apply the conclusions of your assessment and analysis to leadership roles and responsibilities in your organization?
Progressive agreement for trans-pacific partnership : You are attending a discussion on an issue that involves Vietnam and the Comprehensive and Progressive Agreement for Trans-Pacific Partnership (CPTPP).

Reviews

Write a Review

 

Operation Management Questions & Answers

  Ongoing debate about whether unmanned aerial vehicles

There is an ongoing debate about whether unmanned aerial vehicles (drones) should be used to collect intelligence in the United States. Find two articles that have opposing views on this issue, and summarize each view.

  Guarantee success in marketing-advertising

Although no single approach can guarantee success in marketing and advertising, STP marketing should always be considered when consumers in a category have heterogeneous wants and needs. Think about a product that you have used in the past week and e..

  What is a balanced scorecard graphic

What is a balanced scorecard graphic. Design a balance scorecard and give an explanation of how your scorecard "works" and why it would be of value to a manager.

  Main components of decision support system

Discuss the main components of a decision support system and the issues facing an implementation of DSS.

  Minimize the flow time of the assembly line

which work station should each worker be assigned in order to minimize the flow time of the assembly line? What is the associated flow time?

  Define project management for the project team

Define project management for the project team. Explain to the team what project is and how working on a project is different from working in a functional area.

  Slide presentation in face-to-face organizational setting

List and discuss four factors that influence the delivery of an oral and slide presentation in a face-to-face organizational setting.

  Developing and providing base salaries for expatriates

Explain what you think is best practices when training, developing and providing base salaries for expatriates.

  Workplace dealing with socialization and commitment

How do you describe intervention in the workplace dealing with socialization, commitment, reward allocation?

  What should be observed when assessing the sensitivity

What should be observed when assessing the sensitivity of the expected value to changes in the input variables from a spider chart?

  What right does the government have to intrude

This being the case, what right does the government have to intrude and tell the two parties, "that's too bad- you still can't have it'?"

  Describe actionable tactics that will mitigate the hindering

Describe actionable tactics that will mitigate the hindering factors as well as leverage those factors likely to support the change.

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