Question

In: Math

MAXIMIZING PROFIT: CUSTOM GAMING PCs You are the owner of a mid-sized computer manufacturing and assembling...

MAXIMIZING PROFIT: CUSTOM GAMING PCs

You are the owner of a mid-sized computer manufacturing and assembling facility – what started as a small business building and customizing computers for friends and family has grown into a much larger operation, and you want to make sure you are using your labor hours in the most efficient way to maximize your profits. Your company manufactures and assembles three types of custom gaming PCs, and the amount of manufacturing and assembling times required for each model along with the profit you make on each unit are given below:

Model Name

Manufacturing Time (in hours)

Assembling Time (in hours)

Profit
(per unit sold)

Dendrite Ice

2

2

$280

Neuron Pro

3

2

$320

Axon Glacier Pro

2

4

$400

Your labor budget each week is 1,000 hours of total manufacturing time, and 1,600 hours of assembly time. How many of each type of custom gaming PC should you task your teams with creating each week to maximize your profit?

1. Provide the solution to your completed tableau, listing the values for each variable (including any slack variables) and the objective function. Finally, state the solution in terms of our original problem: how many of each type of custom gaming PC should your teams manufacture each week in order to maximize your profits?

Solutions

Expert Solution

We will help this problem with the help of Excel Solver.

We are given with the constraints and the function which is to be maximized.

Let us load the data into Excel which is as follows:

Model Name Manufacturing Time (in hours) Assembling Time (in hours) Profit (per unit sold) Limits
Dendrite Ice 2 2 $280
Neuron Pro 3 2 $320
Axon Glacier Pro 2 4 $400
Decision Variables Total
Maximize 1000 1600

Let us use the functions for the required profit with the help of the table below:

Model Name Manufacturing Time (in hours) Assembling Time (in hours) Profit (per unit sold) Limits Required Profit (per unit sold)
Dendrite Ice 2 2 $280 =SUMPRODUCT(B2:C2,B7:C7)
Neuron Pro 3 2 $320 =SUMPRODUCT(B3:C3,B7:C7)
Axon Glacier Pro 2 4 $400 =SUMPRODUCT(B4:C4,B7:C7)
Decision Variables 0 0 Total
Maximize 1000 1600 =SUMPRODUCT(B7:C7,B8:C8)

where B7:C7 is the cell of decision variable.

B2:C2 are manufacturing time and assembly time respectively.

Using Excel to solve the problem, we will do the steps as follows:

Go to Data>Solver.

Use the commands as below:

1. Provide the solution to your completed tableau, listing the values for each variable (including any slack variables) and the objective function. Finally, state the solution in terms of our original problem: how many of each type of custom gaming PC should your teams manufacture each week in order to maximize your profits?

We have to get the profit per unit from Dendrite Ice of $260 per unit and profit per unit from Neuron Pro of $320 per unit and profit per unit from Axon Glacier Pro of $400 per unit.

The objective function is to Maximize profit:

1000x1 + 1600x2

Thus, we have to use 60 manufacturing and 70 assembly units to get a maximum profit of $172,000.

Maximum Profit = 1000*60 + 1600*70 = $172,000.


Related Solutions

MAXIMIZING PROFIT: CUSTOM GAMING PCs You are the owner of a mid-sized computer manufacturing and assembling...
MAXIMIZING PROFIT: CUSTOM GAMING PCs You are the owner of a mid-sized computer manufacturing and assembling facility – what started as a small business building and customizing computers for friends and family has grown into a much larger operation, and you want to make sure you are using your labor hours in the most efficient way to maximize your profits. Your company manufactures and assembles three types of custom gaming PCs, and the amount of manufacturing and assembling times required...
You are a consultant to a mid-sized manufacturing corporation that is considering an investment project. The...
You are a consultant to a mid-sized manufacturing corporation that is considering an investment project. The project requires an initial investment of $100 million and will generate an after tax cash of $20 million in the first year and the cash flow will increase 5% thereafter every year (Please note that this is a constant growing cash flow).The project’s beta is 1.5. Assuming that rf=5% and E ( rM ) = 12%, Please answer the following questions. What is the...
You have just been hired as the payroll manager of a mid-sized manufacturing company. You notice...
You have just been hired as the payroll manager of a mid-sized manufacturing company. You notice that the time cards are paper documents that the employee submit at the end of the week into an open cardboard box outside of your office. The time cards contain the employee's name, pay rate, social security number, and division where he/she works. You ask the only employee currently in the payroll department, where the payroll files are and she points you to another...
The Wentworth Corporation is a mid-sized manufacturing company located in the metropolitan area of Atlanta, Georgia....
The Wentworth Corporation is a mid-sized manufacturing company located in the metropolitan area of Atlanta, Georgia. In business for ten (10) years, it has become one of the area’s largest producers of Widgets. James Henderson and three (3) associates founded the company, which has slowly grown to employ 500 employees, primarily production workers, in its three (3) existing facilities. Henderson is the President and CEO of the corporation, and Mike Johnson is the newly appointed Manager of Human Resources. Wentworth...
The Wentworth Corporation is a mid-sized manufacturing company located in the metropolitan area of Atlanta, Georgia....
The Wentworth Corporation is a mid-sized manufacturing company located in the metropolitan area of Atlanta, Georgia. In business for ten (10) years, it has become one of the area’s largest producers of Widgets. James Henderson and three (3) associates founded the company, which has slowly grown to employ 500 employees, primarily production workers, in its three (3) existing facilities. Henderson is the President and CEO of the corporation, and Mike Johnson is the newly appointed Manager of Human Resources. Wentworth...
You are the director of public relations for a mid-sized organization that is poised for rapid...
You are the director of public relations for a mid-sized organization that is poised for rapid growth within its industry. Your supervisor, the vice president for marketing, suggests that you outsource some of the public relations activities to free you up for some strategic planning. Your supervisor asks for your advice, but he/she will make the final decision. What would you tell him/her are the pros and cons of outsourcing? ANSWER MUST BE 20 LINES LONG
You are the governor of a mid-sized industrial state. You have just read this chapter and...
You are the governor of a mid-sized industrial state. You have just read this chapter and have decided that you want to make reforms to the health care and services delivery systems in your state to increase access to care for vulnerable populations. How would you proceed? Who would you have assist you. What is the time line for this charge?
Question 2 You are the new compensation and benefits manager for a mid sized organization. You...
Question 2 You are the new compensation and benefits manager for a mid sized organization. You study the system and find inequity in the pay packet amongst employees with similar skills sets. Discuss the theoretical frame work that you would apply to ensure fairness.  - (5 Marks ) subject Organizational Behaviour
In your initial post, suppose that you are a purchasing manager with a small or mid-sized...
In your initial post, suppose that you are a purchasing manager with a small or mid-sized company. You have been asked to transition the company from traditional/transactional purchasing to strategic sourcing and supplier relationship management. How would you begin this process? Once implemented, what competitive advantage does strategic sourcing give your organization over its competitors?
Module 2 Case Information   Zeller & Merkel, Inc. (ZM) is a mid-sized high-tech manufacturing firm that...
Module 2 Case Information   Zeller & Merkel, Inc. (ZM) is a mid-sized high-tech manufacturing firm that has taken you on as an intern. You are very thankful for this opportunity, especially as Tim Zeller and Christine Merkel are known for giving their interns opportunities to use their accounting knowledge by asking for the student’s evaluation of important scenarios in a live business. A good example is ZM’s current plan to raise money through a stock issue rather than a debt...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT