Question

Find the production mix of Toy A and Toy B that maximizes profit using solver excel

The company makes 2 types of toys, Toy A and Toy B. Toy A requires 0.25 hours of assembly and 0.1 hours of packing for each toy. Toy B requires 0.20 hours of assembly and 0.15 hours of packing for each toy. The maximum assembly hours is 200 and the maximum packing hours is 100. Toy A sells for $3 and Toy B sells for $5. Total costs for Toy A is $1 and total costs for Toy B is $2. The maximum number of Toy A is 500 and Toy B is 400.

Answer 1

the answer is $2, 000. i believe

Step-by-step explanation:

Answer 2

$2, 000.

Step-by-step explanation:

Okay, we are given the following data or parameters or infomation which are goin to help us in solving the question above.

So, we are given that; (1). ''Toy A requires 0.25 hours of assembly and 0.1 hours of packing for each toy while Toy B requires 0.20 hours of assembly and 0.15 hours of packing for each toy.

(2). "The maximum assembly hours is 200 and the maximum packing hours is 100. "

(3). ''Toy A sells for $3 and Toy B sells for $5. Total costs for Toy A is $1 and total costs for Toy B is $2.''

(4). "The maximum number of Toy A is 500 and Toy B is 400."

Therefore; let us delve right into the solution to the question.

Assuming a and b are the numbers of toys produced;

0.25a + 0.20 b < 200. ---------------------(1).

0.1a + 0.15b < 100. --------------------------(2).

Remember that a = 500 and b = 400.

Also, there is the need for maximizing 2a + 3b.

Using excel solver, we will get;

a = 400 and b = 400.

Thus, 2a + 3b. = (2× 400) + (3× 400).

=> $2000