Maria has an online shop where she sells hand-made paintings and cards. She sells the
painting for $50 and the card for $20. It takes her 2 hours to complete 1 painting and 45
minutes to make a single card. She also has a day job and makes paintings and cards in her
free time. She cannot spend more than 15 hours a week to make paintings and cards.
Additionally, she should make not more than 10 paintings and cards per week. She makes
a profit of $25 on painting and $15 on each card. How many paintings and cards should she
make each week to maximize her profit.
The mathematical model for this problem is:
Maximize 25x+15y
Subject to 2x+0.75y<=15
,x+y<=10
,x,y>=0
where x and y are the numbers of paintings and cards, respectively.
a- Solve this problem in Excel. (15 pts)
b. Which right-hand-side would you prefer to increase and why? (15 pts)
2. Maria has an online shop where she sells hand-made paintings and cards. She sells the painting for S50 and the card for S20.It takes her 2 hours to complete l painting and 45 minutes to make a single card. She also has a day job and makes paintings and cards in her free time. She cannot spend more than 15 hours a week to make paintings and cards. Additionally,she should make not more than 10 paintings and cards per week. She makes a profit of S25 on painting and $15 on each card. How many paintings and cards should she make each week to maximize her profit The mathematical model for this problem is: Maximize 25x+15y Subject to 2x+0.75y15 x+y10 x,y0 where x and y are the numbers of paintings and cards,respectively aSolve this problem in Excel.15pts b- Which right-hand-side would you prefer to increase and why?(15 pts)