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).
|
Hydrogen storage and delivery system for automotive
: You have been asked by your supervisor, the Director of Engineering Development, to explore the possibility of using a hydrogen fuel cell in place of the batteries in an electric vehicle.
|
|
What if the new yorker pays cash for the machine
: How would these transactions show up in the balance of payments accounts of New York and New Jersey? What if the New Yorker pays cash for the machine?
|
|
How is possible that us received more foreign asset income
: Yet we saw in this chapter that the United States is a substantial net debtor to foreigners. How, then, is it possible that the United States received more foreign asset income than it paid out?
|
|
Present value plot for projects
: Given the following Present Value Plot for Projects A and B, which are mutually exclusive projects, answer the following questions:
|
|
Maximizes overall profits
: Using the structure you have created, the existing constraints and the MS Excel tools available, can you propose a new product mix that programmatically: Maximizes overall profits and Reduces overall cost (total cost of products in inventory)
|
|
Are technology startups typically able to get loans?
: Are technology startups typically able to get loans?
|
|
Journal entry of the baxter company
: Baxter Company began operations in 2006 and was profitable through 2009, during which time the tax rate was 30%. At the end of 2010, the company reported a pretax operating loss of $135,000 for both financial reporting and income taxes.
|
|
What are disadvantages of engaging in strategic trade policy
: What are the disadvantages of engaging in strategic trade policy even in cases in which it can be shown to yield an increase in a country's welfare?
|
|
Thesis on old vs. new world exchanges
: thesis on Old vs. New World Exchanges
|