Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 7.3, Problem 11P
Summary Introduction
To study: The sensitivity of the optimal solution to the capacity level.
Non-linear programming (NLP):
Non-linear programming (NLP) is used in complex optimization problems where the objectives or constraints or sometimes both are non-linear functions of the decision variables. A model can be termed as non-linear for more than one reason.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web
site construction is estimated to be $169,000. Variable processing costs are estimated to be $9 per book. The publisher plans to sell single-user access to the book for $42.
Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand -4,000-6p, where p is
the price of the e-book.
(a) Construct an appropriate spreadsheet model for calculating the profit/loss at a given single-user access price taking into account the above demand function. What is the profit
estimated by your model for the given costs and single user access price (in dollars).
s
(b) Use Goal Seek to calculate the price (in dollars) that results in breakeven. (Round your answer to the nearest cent.)
(c) Use a data table that varies price…
gohotels.ph, a property of Robinson's Land, began test marketing its value hotel in May 2010 at its building along Edsa beside Robinson's Pioneer Street. It has about 200 rooms in the Edsa site but has chosen to have 60 to 100 rooms in each of their subsequent sites in the provincial areas. Its pricing is unique because it utilizes the revenue management model of the airline industry where prices would Ivary depending on demand, in this case, occupancy numbers. Thus, a 16 to 22 square meter room can command a price as low as P388 plus value added tax (VAT), or as high as P3,000 plus VAT, averaging about P1,550 plus VAT per room per night booked via internet. While the prices are low, the room boasts of a comfortable bed with two types of pillows (hypoallergenic and chiropractic), a clean private bathroom with rain shower, free wifi, LCD TV, convenient location with safe surroundings secured by CCTV and safety cabinet.
On its first month of its test market and despite using mostly…
Eastan Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $150,000.
Variable processing costs are estimated to be $7 per book. The publisher plans to sell single-user access to the book for $49.
Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4,000 - 6p, where p is the price of the e-book.
(a) Build a spreadsheet model to calculate the profit/loss for a given demand. What is the demand?
(b) Use Goal Seek to calculate the price that results in breakeven. If required, round your answer to two decimal places.
(c) Use a data table that varies price from $50 to $400 in increments of $25 to find the price that maximizes profit.
If Eastman sells the single-user access to the electronic book at a price of S
it will earn…
Chapter 7 Solutions
Practical Management Science
Ch. 7.3 - Prob. 1PCh. 7.3 - Prob. 2PCh. 7.3 - Pricing Decisions at Madison The Madison Company...Ch. 7.3 - Prob. 4PCh. 7.3 - Prob. 5PCh. 7.3 - Prob. 6PCh. 7.3 - Prob. 7PCh. 7.3 - Prob. 8PCh. 7.3 - Prob. 9PCh. 7.3 - Prob. 10P
Ch. 7.3 - Prob. 11PCh. 7.3 - Prob. 12PCh. 7.3 - Prob. 13PCh. 7.3 - PRICING SUITS AT SULLIVANS Sullivans is a retailer...Ch. 7.3 - Prob. 15PCh. 7.4 - Prob. 16PCh. 7.4 - Prob. 17PCh. 7.4 - Prob. 18PCh. 7.4 - Prob. 19PCh. 7.4 - Prob. 20PCh. 7.4 - Prob. 21PCh. 7.4 - Prob. 22PCh. 7.4 - Prob. 23PCh. 7.5 - Prob. 24PCh. 7.5 - Prob. 25PCh. 7.5 - Prob. 26PCh. 7.5 - Prob. 27PCh. 7.6 - Prob. 28PCh. 7.6 - Prob. 29PCh. 7.6 - Prob. 30PCh. 7.6 - Prob. 31PCh. 7.6 - Prob. 32PCh. 7.6 - Prob. 33PCh. 7.6 - The method for rating teams in Example 7.8 is...Ch. 7.7 - Prob. 35PCh. 7.7 - Prob. 36PCh. 7.7 - Prob. 37PCh. 7.7 - The stocks in Example 7.9 are all positively...Ch. 7.7 - Prob. 39PCh. 7.7 - Prob. 40PCh. 7.7 - Prob. 41PCh. 7.7 - Prob. 42PCh. 7.8 - Given the data in the file Stock Beta.xlsx,...Ch. 7.8 - Prob. 44PCh. 7 - Prob. 45PCh. 7 - Prob. 46PCh. 7 - Another way to derive a demand function is to...Ch. 7 - Prob. 48PCh. 7 - If a monopolist produces q units, she can charge...Ch. 7 - Prob. 50PCh. 7 - Prob. 51PCh. 7 - Prob. 52PCh. 7 - Prob. 53PCh. 7 - Prob. 54PCh. 7 - Prob. 55PCh. 7 - Prob. 56PCh. 7 - A beer company has divided Bloomington into two...Ch. 7 - Prob. 58PCh. 7 - Prob. 59PCh. 7 - Prob. 60PCh. 7 - Prob. 61PCh. 7 - Prob. 62PCh. 7 - Prob. 63PCh. 7 - You have 50,000 to invest in three stocks. Let Ri...Ch. 7 - Prob. 65PCh. 7 - Prob. 66PCh. 7 - Prob. 67PCh. 7 - Prob. 68PCh. 7 - Prob. 69PCh. 7 - Prob. 70PCh. 7 - Based on Grossman and Hart (1983). A salesperson...Ch. 7 - Prob. 73PCh. 7 - Prob. 74PCh. 7 - Prob. 75PCh. 7 - Prob. 76PCh. 7 - Prob. 77PCh. 7 - Prob. 78PCh. 7 - Prob. 79PCh. 7 - Prob. 80PCh. 7 - Prob. 81PCh. 7 - Prob. 82PCh. 7 - Prob. 83PCh. 7 - Prob. 84PCh. 7 - Prob. 85PCh. 7 - Prob. 86PCh. 7 - Prob. 1.1CCh. 7 - Prob. 1.2CCh. 7 - Prob. 1.3CCh. 7 - Prob. 1.4C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?arrow_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardBenetton is studying two alternative contracts with a retailer for a seasonal product, Revenue-Sharing contract and Quantity Flexibility contract. Attributes and terms of the two contracts are presented below. Profit Sharing Contract: Benetton production cost is $20, and it charges the retailer a low wholesale price of $25. The retailer prices to the customers at $55 per unit. The retailer forecasts demand to be normally distributed, with a mean of 4,000 and standard deviation of 1,600. Any unsold product are discounted to $15, and all sell at this price. The retailer will share 30% of the revenue with Bennetton, keeping 70% for itself. Quantity Flexibility Contract: If the retailer orders O units, Benneton is willing to provide up to another 35% if needed. Benetton's production cost is $20, and it charges the retailer a wholesale price of $36. The retailer prices to the customers at $55 per unit. Any unsold units can be sold by the retailer at a salvage value of $25. Bennetton can…arrow_forward
- Due to inflation in Australia in December 2019, the price for petrol increased from AUD1.35 to AUD 1.45. This caused petrol consumption to decrease from 2500 liters to2450 liters at a 7-Eleven Petrol Station in Sydney.Also, when the price for Hyundai 7.5kW Inverter Split System Air Conditioner (ReverseCycle) increased from AUD 950.00 to AUD 990.00; demand for these air conditionersfell from 2500 units to 2000 units.Following this condition, answer the questions below.i. Using the mid-point formula calculate the price elasticity of demand for petroland Hyundai 7.5kW Inverter Split System Air Conditioner (Reverse Cycle).ii. Is the price elasticity of demand: elastic, unit elastic, or inelastic for eachcommodity (petrol and Hyundai 7.5kW Inverter Split System Air Conditioner(Reverse Cycle)? iii. Suppose the government decides to increase tax for petrol and Hyundai 7.5kWInverter Split System Air Conditioner (Reverse Cycle). Use two diagrams toexplain the incidence of the tax increase for…arrow_forwardHair Zone manufactures a brand of hair-styling gel. It is considering adding a modifiedversion of the product—a foam that provides stronger hold. Hair Zone’s variable costs and prices to wholesalers are: Current Hair Gel New Foam Product Unit selling price 2.00 2.25 Unit variable costs . 85 1.25Hair Zone expects to sell 1 million units of the new styling foam in the first year after introduction, but it expects that 60% of those sales will come from buyers who normally purchase Hair Zone’s styling gel. Hair Zone estimates that it would sell 1.5 million units of the gel if it did not introduce the foam. If the fixed cost of launching the new foam will be $100,000 during the first year, should Hair Zone add the newproduct to its line? Why or why not?arrow_forwardYour answer is partially correct. An independent contractor for a transportation company needs to determine whether she should upgrade the vehicle she currently owns or trade her vehicle in to lease a new vehicle. If she keeps her vehicle, she will need to invest in immediate upgrades that cost $5,200 and it will cost $1,300 per year to operate at the end of year that follows. She will keep the vehicle for 5 years; at the end of this period, the upgraded vehicle will have a salvage value of $3,800. Alternatively, she could trade in her vehicle to lease a new vehicle. She estimates that her current vehicle has a trade-in value of $9,800 and that there will be $4,100 due at lease signing. She further estimates that it will cost $2,900 per year to lease and operate the vehicle. The independent contractor's MARR is 11%. Compute the EUAC of both the upgrade and lease alternatives using the insider perspective. Click here to access the TVM Factor Table Calculator. 1943.56 EUAC(keep): $…arrow_forward
- A borrower took out a $1,450,000 30-year fully amortizing conforming adjustable rate mortgage loan with an index of the one year U.S. Treasury and a 2.5% margin from the Wells Fargo Bank to buy a condo in Park City, Utah. The loan has a teaser rate of 1.5% for the first year, after which the interest rate resets annually with 2% annual and 6% lifetime interest rate increase caps, and the lender charges a one point loan origination fee and an additional $540 in closing costs to the borrower that are deducted from the loan proceeds at closing. On the first reset date, the one year U.S. Treasury rate was 4.75%. What would be the monthly payment for the second loan year? $6,511.15 $5,004.25 $6,337.97 $6,461.99arrow_forwardA borrower took out a $1,450,000 30-year fully amortizing conforming adjustable rate mortgage loan with an index of the one year U.S. Treasury and a 2.5% margin from the Wells Fargo Bank to buy a condo in Park City, Utah. The loan has a teaser rate of 1.5% for the first year, after which the interest rate resets annually with 2% annual and 6% lifetime interest rate increase caps, and the lender charges a one point loan origination fee and an additional $540 in closing costs to the borrower that are deducted from the loan proceeds at closing. At the time of loan origination, the one year U.S. Treasury rate is 1.25%. What would be the monthly payment for the first loan year? $5,004.24 $6,715.18 $5,259.25 $4,832.15arrow_forwardRefer to the slides on buy-back contracts to answer this question. A publisher sells books to Borders at $12 each. The marginal production cost for the publisher is $1 per book. Borders prices the book to its customers at $24 and expects demand over the next two months to be normally distributed, with a mean of $20,000 and a standard deviation of $5000. Borders places a single order with the publisher for delivery at the beginning of the two-month period. Currently, Borders discounts any unsold books at the end of the two months down to $3, and any books that did not sell at full price sell at this price. How many books should Borders order? What is the expected profit? How many books does it expect to sell at a discount? What is the profit that the publisher makes given Borders’ actions? A plan under discussion is for the publisher to refund Borders $5 per book that does not sell during the two-month period. As before, Borders will discount them to $3 and sell any that remain.…arrow_forward
- The village board of Park City, Utah, arranges for the clearing of all snow in city streets. Weekly snowfall during the winter is normally distributed with a mean of 10 inches and a standard deviation of 4 inches. The board is considering a long term contract with a snow removal company. The long- term contract costs $1000 per truck per week. Thus, if the board signs a long-term contract for 12 inches, they pay $12,000 per week whether the trucks are used or not. Each truck is capable of clearing 1 inch of snow per week. If snowfall in a week exceeds the quantity that can be handled by the trucks included in the long term lease, the board must make emergency arrangements at a cost of $2,500 for each additional truck brought in. For how many trucks should the board sign a long term contract?arrow_forwardDaily demand for a type of sandwich sold at DoorRed Cafe (DRC) is normally distributed with a mean of 65 and a standard deviation of 27. DRC orders the sandwiches from a wholesaler (everyday morning before 5:30 AM) at a wholesale price of $4 per sandwich and sells them at a retail price of $7 per sandwich. Pursuant to the contract between DRC and its wholesaler, the transportation cost is currently borne by the wholesaler. The wholesaler does not take back any unsold sandwiches. However, DRC can sell any unsold inventory at a discounted price of $3 after 5:00 PM every day. d) Now suppose that the contract between DRC and its wholesaler expires and pursuant to the new contract, if DRC orders more than 56 sandwiches (anything more than or equal to 57), the transportation cost is no longer borne by the wholesaler and DRC will have to pay $30 for transportation. If DRC orders less than or equal to 56, the transportation cost for DRC is still zero. What is DRC’s optimal order quantity for…arrow_forwardCentral State College (CSC) is a state-supported college with a large business school. The business school offers an undergraduate degree and training programs for a local manufacturer. The state does not support the training programs, which are paid for by the manufacturer under a fixed-price contract. The college president has asked the dean of the business school for a breakdown of costs by program. The president will be meeting with state legislators asking for an increase in support for the college's programs. The dean has assigned you to lead the team that will develop the costs by program. The business school's computer lab is a major cost item. The lab is used during the day for the undergraduate program and in the evening for the training program. Required a. How will you recommend that the cost of the computer lab be allocated to the two programs? Be explicit in your description of the allocation base. b. The dean tells you that the training program should not be allocated…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning