Maximizes overall profits

Assignment Help Other Subject
Reference no: EM13868725

The CEO of Burke Electronics, a well-establishedsingle store small business in Northern Virginia, is implementing a program to increase its overall top line and enhance the profitabilityof the concern. BE (Burke electronics) has hired you as a consultant for your expertise in managing multi-product companies and solving their issues through the use of linear programming and related Excel tools.
BE currently carries 4 product lines:

• PCs (Sony, Toshiba, HP etc.),
• Tablets (Ipad, Nexus etc.)
• Phones (Both Ios and Android)
• Chargers & Interface devices

BE's unique business model allows it to sell all products in each product lines at a fixed rate. It sells all PC's at an unit price of $ 450, Tablets at an unit price of $ 540, Phones at an unit price of $ 400 and Chargers & Interface devices at $ 35 apiece.

As with any small business, BE has some real constraints as well. BE cannot offermore than 900 Tablets and Phones (together);BE can only offer a maximum of 500 PCs. Additionally, BE has to offer a minimum of 1200 Chargers and Interface devices. The maximum and minimum total products that the store can carry are: 5000 and 2300 respectively. It also has to offer a minimum of 250 phones in its store.

1. Setup a solving structure in MS Excel for BE to get the correct product mix such that BE can maximize its revenue

2. To make it a sustainable and meaningful solution, what additional constraints would you add.

BE has also recently established that the average costs for each product line are as follows:

• PCs (Sony, Toshiba, HP etc.) - $ 375
• Tablets (Ipad, Nexus etc.) - $ 250
• Phones (Both Ios and Android) - $ 235
• Chargers & Interface devices - $ 30

Using the structure you have created, the existing constraints and the MS Excel tools available, can you propose a new product mix that programmatically:

3. Maximizes overall profits

4. Reduces overall cost (total cost of products in inventory).

Reference no: EM13868725

Description sociodemographic and geographical characteristic

Post 3-4 pages- a description of a community that you chose to assess in this course for your Scholar-Practitioner Project. Include in your description sociodemographic and

Define the terms direct democracy

Define the terms "direct democracy" and "representative democracy." Why is the government of the United States of America considered a republic in the context of a "constit

What innate tendency should be released in patrick

In order for Patrick to experience personal growth, which three characteristics or elements will be essential in the therapeutic environment? What innate tendency should be

What is major difference between hedonism and utilitarianism

Where do Platos universal forms reside? What is the major difference between hedonism and utilitarianism? Why would John Mill say that lying is immoral according to Utilitaria

Discuss overarching duty of the health care governing board

Discuss the overarching duties of the health care governing board in mitigating the effects of medical non-compliance, as they apply to the rules of practice set forth in th

Describe concept of a temperature elasticity of ice cream

Describe the concept of a "temperature elasticity of ice cream." Calculate the temperature elasticity of demand for ice cream using the information provided. Determine in what

Explain what are the harmful impacts of the pollution

What are the harmful impacts of the pollution? Describe impacts to both humans and to ecosystem structure and function. What steps are in place to eliminate the pollutant or t

How you would facilitate care of patient with patients care

Explain how you would facilitate the care of the patient with the patient's care team. Explain how the factor you selected might impact the pathophysiology of the disorde


Write a Review

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