Dvd sales hans hultgren the sales manager for dvd sales, Ask an Expert

Management Studies

DVD Sales Hans Hultgren, the sales manager for DVD Sales, wants to maximize his profit on the sale of portable DVD players. He already has two portable models he plans to sell:

Products Retail Price Wholesale Cost

Panasonic DVD–LS50 $349.95 $192.47

Mintek MDP–1810 $199.95 $109.99

Hans needs your help in calculating his maximum profit. First, he would like you to use the Web to locate the retail price of two other portable DVD players not listed in the table above. The wholesale price of each unit is 55 percent of the retail price for both units you find. Hans has two constraints:

1. Hans has $200,000 to purchase new DVD players. The total wholesale cost of the four types of DVD units must be less than $200,000.

2. Hans must purchase a minimum of 100 units of each player from his wholesaler.

You want to use Excel Solver to maximize the total profit for Hans with the constraints mentioned above and limiting the number of units to positive integers.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M91984611

Have any Question?Write your Review or question?

Related Questions in Operation Management

1 if a normal random variable has a mean and a standard

1. If a normal random variable has a mean = _____ and a standard deviation = _____, it is called a standard normal distribution. a. 1;0 b. 1;1 c. 0;0 d. 0;1 2. The _____ distribution models the time between randomly occu ...

Your chemical facility consumes significant amounts of

Your chemical facility consumes significant amounts of water. Six samples of 15 observations have been taken with the results shown here: Sample Mean Range 1 478,550 1,222 2 491,008 1,442 3 471,119 958 4 486,533 1,173 5 ...

A well-written report would contain the following elements

A well-written report would contain the following elements: required to develop a Risk management plan or contingency plan to manage risk effectively in an organization. You may choose to work on any one of the following ...

1 prepare a brief maximum 500 - 750 word report that

1. Prepare a brief (maximum 500 - 750 word) report that examines whether, how, and why strategic management is/could/should be relevant and important for human resource management. 2. Based on the product mix diagram bel ...

A town in california is broke the city had been warned

A town in California is broke. The city had been warned several times over the last few years that it did not have enough money to pay out future pensioners. There is a law that says the town must pay promised benefits. ...

1 earnings before interest taxes depreciation and

1. Earnings before interest, taxes depreciation and amortization provides a measure of the company's free cash flow. True or False? 2. A public company would rather have zero depreciation so that it does not have to pay ...

Scenariomr con fused has been an employee at regional

Scenario Mr. Con Fused has been an employee at Regional Hospital for the past five years. His employment there was recently terminated. The reason for the termination was: Inability to follow instructions. However, Regio ...

1 safe patient handling and patient movement injuries 1 how

1. Safe Patient Handling and Patient Movement Injuries: 1. How can senior management be convinced that this is an important problem? 2. How can middle management be convinced that this is an important problem? 3. How can ...

1 burger kings plan states that the company intends to

1. Burger King's plan states that the company intends to improve profitability by 7 percent, reduce customer complaints, maintain the company's market share, and develop a new breakfast food. Which part of the plan is re ...

1 according to dixit and nalebuff the use of decision trees

1. According to dixit and Nalebuff the use of decision trees violates the natural logic of their rule :rule#1, of strategy i.e look ahead and reason back 2. An organization's potential competitive advantage can be found ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert