Could you please solve/explain them in the attached Excel format? That is the way we are learning them.I really appreciate the help. Lisa creates two types of jewelry: Type A and Type B. TypeA requires 90 minutes of carving and 1 hour of assembly,while Type B requires 45 minutes of carving and 2 hoursof assembly.Lisa can sell Type A for $12 and Type B for $55. If Lisa has1000 hours of curving and 500 hours of assembly time,how many of each type of jewelry should she make tomaximize revenue? Keep in mind that the number of TypeA jewelry has to be at least twice the number of Type Bjewelry.(Possible Answer: $9875)(Suggestion: Convert all hours to minutes to avoidmixing them up.) 1234252656789101112131415 MODEL161718192021222324313233A3435DATA363729272829 CONSTRAINTS30 LSBDECISION VARIABLESсOBJECTIVE FUNCTIONRELATION RSD[Name]EFLL

Let, x, and y represent the type A and type B jewelry items.DATACurving time (in min)Assembly time…

Answered: Lisa creates two types of jewelry: Type…

Advanced Engineering Mathematics

10th Edition

ISBN:9780470458365

Author:Erwin Kreyszig

Publisher:Erwin Kreyszig

Chapter2: Second-order Linear Odes

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Related questions

Question

Could you please solve/explain them in the attached Excel format? That is the way we are learning them.

I really appreciate the help.

Lisa creates two types of jewelry: Type A and Type B. Type
A requires 90 minutes of carving and 1 hour of assembly,
while Type B requires 45 minutes of carving and 2 hours
of assembly.
Lisa can sell Type A for $12 and Type B for $55. If Lisa has
1000 hours of curving and 500 hours of assembly time,
how many of each type of jewelry should she make to
maximize revenue? Keep in mind that the number of Type
A jewelry has to be at least twice the number of Type B
jewelry.(Possible Answer: $9875)
(Suggestion: Convert all hours to minutes to avoid
mixing them up.)

1
2
3
4
25
26
5
6
7
8
9
10
11
12
13
14
15 MODEL
16
17
18
19
20
21
22
23
24
31
32
33
A
34
35
DATA
36
37
29
27
28
29 CONSTRAINTS
30 LS
B
DECISION VARIABLES
с
OBJECTIVE FUNCTION
RELATION RS
D
[Name]
E
F
LL

Expert Solution

Step 1: Formulating the given problem:

Let, x, and y represent the type A and type B jewelry items.

DATA	Curving time (in min)	Assembly time (in min)	Cost
Type A	90	60	12
Type B	45	120	55
Available time	1000	500

Decision variable is

Type A, and

Type B

Objective function is

Max Revenue $R equals 12 x plus 55 y$

Subjected to constraints:

$90 x plus 45 y less or equal than 1000 space space space space space space space space space space space left parenthesis 1 right parenthesis 60 x plus 120 y less or equal than 500 space space space space space space space space space space space left parenthesis 2 right parenthesis$

and given that number of type A jewelry is at least twice the number of type B jewelry.

$x greater or equal than 2 y x minus 2 y greater or equal than 0 space space space space space left parenthesis 3 right parenthesis$

and $x comma y greater or equal than 0$