Answer I’m excell please Problem 1 The R& D division of the Progressive company has been developing 4 possibleproduct lines. Management must make a decision on which of the 4 products will be produced andat what levels to maximize the profit. The start-up cost and marginal revenue for each product isgiven in the following table:Product13Start-up cost$50,000 $40,000 $70,000 $60,000Marginal revenue$ 70$ 60$ 90$ 80Let continuous variables x1, x2, X3, X4 be the production levels of product 1,2,3 and 4, respec-tively, and let binary variables y1, Y2, Y3, Y4 control whether or not each product is produced at all.Suppose the manager has imposed the following constraints:• No more than two types of the products can be produced.• If neither product 1 nor product 2 is produced, then neither product 3 nor product 4 can beproduced.• Either 5x1 + 3.x2 + 6x3 + 4x4 < 6000 or 4x1 + 6x2 +3x3 +5x4 < 6000.1. Formulate an integer programming model for the problem.2. Solve this model in Excel or Python.

Answered: Image /qna-images/answer/9cb5af3f-d529-46ab-a71a-7c6a279cfcc4.jpg

Answered: Problem 1 The R& D division of the…

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?
Determine which factor of production is needed in the following problem. 1.The ABM manufacturing Co.hired a gardener.He uses a lawn mower for landscaping.Which factor of production would you consider this machine? 2.The owner of the company withdrew cash for the salaries of thw employees.which factor of production would you consider cash on hand? 3.The top manager of the firm said "the great ideas,consepts and emotional determination of a person to produce something that consumers want to buy" is very important for the company.What factor of production describes the ability to create great ideas? 4.The farmers planted pineapple cutting in the vacant area located in their locality.Which factor of production would you consider a pineapple plantation?
WebTech Development of Austin, Texas, is considering thepossible introduction of a new product proposed by itsresearch and development staff. The firm’s marketing directorestimates the product can be marketed at a price of $70. Totalfixed cost is $278,000, and average variable cost is calculatedat $48.a. What is the breakeven point in units for the proposedproduct?b. The firm’s CEO has suggested a target profit return of$214,000 for the proposed product. How many units mustbe sold to both breakeven and achieve this target return?
3.3 BriteSmile brand of teeth whitening products is considering adding a modified ver- sion of the product-a gel product in addition to its regular paste product. Variable costs and prices to wholesalers are: Unit selling price Unit variable costs Current paste product $5.00 $1.50 New gel product $6.50 $3.25 BriteSmile expects to sell 2 million units of the new gel product in the first year after introduction, but it estimates that only 30% of those sales will come from buyers who do not already purchase the company's paste product (that is, new customers). BriteSmile estimates that it would sell 3 million units of the current paste product if it did not introduce the gel. If the fixed costs of launching the new gel product will be $300,000 during the first year, should BriteSmile add the new gel product to its line? Why or why not?
Lakewood Fashions must decide how many lots of assorted ski wear to order for its three stores. Information on pricing, sales, and inventory costs has led to the following payoff table, in thousands. Order size 2 lots 1 lot 1 lot 3 lots (a) Show a regret table. Order size 2 lots 3 lots Low 13 9 6 Low Demand Medium 16 23 38 High 16 38 61 Demand Medium (b) What decision should be made by the optimist? O 1 lot O2 lots O 3 lots (c) What decision should be made by the conservative? O 1 lot O 2 lots O3 lots (d) What decision should be made using minimax regret? O 1 lot O2 lots O 3 lots High Maximum Regret
Sarah Smith is the marketing manager for Activa. She decides to run a sales promotion to boost the brand's business and is interested in evaluating the success of the promotion. The following is key information for her review. Brand price to retailer: Brand price to consumer: Brand gross profit per case: S 3.87 Brand Marginal contribution: Sales forecast for November 2019: 24,600 cases Sales during November 2019 promotion period: 32,150 cases $ 9.50 per case $ 1.29 per 8 oz. package 23% Describe how the marketing manager will determine the "promotion lift" for the brand and indicate what the "lift" will be based on the information provided above. Show your work for this problem's answer.
3. A company has a linear total cost function and has determined that over the next three months it can produce 1,000 units at a total cost of $300,000. This same manufacturer can produce 2,000 units at a total cost of $400,000. The units sell for $180 each. Find (i) fixted cost (ii) marginal cost, (iii) the break-even point and (iv) construct the break-even chart.
3. A toy manufacturer makes stuffed kittens and puppies which have relatively lifelike motions. There are three different mechanisms that can be installed in these "pets." These toys will sell for the same price regardless of the mechanism installed, but each mechanism has its own variable cost and setup cost. Profit, therefore, is dependent upon the choice of mechanism and upon the level of demand. The manufacturer has in hand a forecast of demand that suggests a 0.2 probability of light demand, a 0.45 probability of moderate demand, and a probability of 0.35 of heavy demand. Payoffs for each mechanism-demand combination appear in the table below. Wind-up action Pneumatic action Electronic action Demand Light Moderate $250,000 $90,000 -$100,000 400,000 440,000 400,000 Heavy 650,000 740,000 780,000 Construct the appropriate decision tree to analyze this problem. Use standard symbols for the tree. Analyze the tree to select the optimal decision for the manufacturer.
A summary of total charges from a small café’s natural gas bills is provided below: Month kJ Cost October 14 $187 November 17 187 December 30 230 January 35 264 February 33 270 March 20 200 Using regression analysis, the expected cost at 40 kJ would be Question 5Answer a. $296 b. $285 c. $102 d. $162
Demonstrate the steps to solve this question: Advanced Electronics manufactures DVDs and sells them directly to retailers who typically sell them for $20. Retailers take a 40 percent margin based on the retail selling price. Advanced’s cost information is as follows:DVD package and disc €2.50/DVDRoyalties €2.25/DVDAdvertising and promotion €500,000Overhead €200,000 Calculate the break-even volume in DVD units and euros.

SEE MORE QUESTIONS

Recommended textbooks for you

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

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

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

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

SEE MORE TEXTBOOKS