Reference no: EM131228707
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.
|
Organization that sells weight training sets
: Mr. Beautiful, an organization that sells weight training sets, has an ordering cost of $35 for the BB-1 set (BB-1 stands for Body Beautiful Number 1). The carrying cost for BB-1 is $18 per set per year. To meet demand, Mr. Beautiful orders large qua..
|
|
General utilitarianism-public and act utilitarianism
: General Utilitarianism,Public Utilitarianism, Act Utilitarianism, Preference Utilitarianism,Expressionism Utilitarianism, Rule Utilitarianism, Ideal Utilitarianism, Trump Utilitarianism, What most people prefer is what is considered intrinsically goo..
|
|
Explain the sarbanes-oxley act
: For this essay, you will conduct research in order to contrast agency theory and stewardship theory in corporate governance. Explain the Sarbanes-Oxley Act and its impact on corporate governance. How has it changed the way leaders do business in the ..
|
|
What coaching techniques can be used with the team
: How is the Scrum Master role similar and different than a project manager role? What “coaching” techniques can be used with the team?
|
|
About the dvd sales
: 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: Hans needs your help in calculating his maximum profit. First, he would l..
|
|
Identify all outstanding security interests in the aircraft
: You are in the market to buy an aircraft and have identified one that appears that it would meet your needs and is in your price range. determine who owns the aircraft, identify all outstanding security interests in the aircraft,
|
|
Create a risk register for the project
: Tony and his team identified some risks during the first month of the Recreation and Wellness Intranet Project. However, all they did was document the risks in a list. They never ranked the risks or developed any response strategies. Create a risk r..
|
|
Facing interesting strategic issues
: Select either a publicly-held corporation or a private company (where the financial data is accessible) that is facing interesting strategic issues. The use of a publicly-held firm rather than one that is closely-held may be important to ensure adequ..
|
|
What are the basic elements of outbacks plan
: Write a brief assessment (two pages) of the Outback Steakhouse case found in the text. Pay particular attention to the following questions: What are the basic elements of Outback's plan for going international? What do you see as the strengths and we..
|