Please help me to solve this question with Excel file $($This class mainly uses SOLVER Function$).$

Bob makes blouses and he's good at it$.$ Bob would rather make profit and be good at that. With that in mind, Bob wants you to find the best use of his available resources in order to maximize his profits. Material requirements, additional labor costs, and selling prices for each inventory item are included in the table to the right. Additional considerations are listed below.

Bob has a the following resources available to him: $45000$ Wool, $28000$ Acetate, $9000$ Cashmere, $18000$ Silk, $30000$ Rayon, $20000$ Velvet, $30000$ Cotton. Extra material can be saved and used in future months at no additional cost.

Bob also has some ideas regarding demand and knows he wants to produce subject to the following constraints.

At least:

$4200$ Itchy Pants

$3000$ Wool Blazers

$2800$ Tailored Skirts

No more than:

$5500$ Velvet Pants

$6000$ Velvet Vests

$4000$ Cashmere Sweaters

$12000$ Silk Shirts

$15000$ Silk Skirts

Your profit calculations should consider $$3,000,000$ in fixed expenses. Develop a spreadsheet model and solve for the optimal solution to maximize profit. Then adjust and use your model to answer the questions on the next sheet.

Please copy and paste your solved model for the following questions. Additionally please provide a short answer $(1-2$ sentences$)$ answering the questions. Consider all changes individually unless otherwise noted. Make sure you scroll down to see all the questions

A$.$ There's recently been a shortage of skilled seamstresses and the labor costs for the silky smooth shirt, silky smooth skirt, and velvet pants have increased by $25\%.$ What happens to your optimal solution and answer?

B$.$ We've recently identified ways to make our fabric cover more area. All Acetate and Rayon requirements have been reduced by $20\%,$ what happens to your optimal solution and answer?

C$.$ If we choose not to make any clothes requiring Velvet we can reduce our fixed costs by $$1,250,000.$ Is this worth pursuing?

D$.$ We've just been informed that we can obtain an extra $10000$ acetate. How much should we be willing to pay to purchase it and what does our optimal production look like with the additional materials?

E$.$ We've developed brand new anti$-$itch technology that will increase the selling price of the itchy pants to $$350/$unit but also increase the wool and acetate requirements by $50\%.$ Is it worth making this change?

F$.$ Consider both the effects listed in A & B and then answer the question posed in D$.$

G$.$ Assuming the original constraints, if Bob could gain more of any one material, what would you pick and why? If you make any assumptions when answering this question please include them.$\backslash$table$[[$Item$,$Itchy Pants,Softest Sweater,Silky Smooth Shirt,Silky Smooth Skirt,Tailored Skirt,Wool Blazer,Vivaciously Velvet Pants,Common Cotton Sweater,Common Cotton Skirt,Velvet Vest,Blue Button Down$],[$Selling Price,$300,450,180,120,270,320,350,130,75,200,120],[$Labor Cost,$160,150,100,60,120,140,175,60,40,\backslash$table$[[160]],90],[$Wool Required,$3,,,,,2\mathrm{.}5,,,,,],[$Acetate Required,$2,,,,1\mathrm{.}5,1\mathrm{.}5,2,,,,],[$Cashmere Required,,$1\mathrm{.}5,,,,,,,,,],[$Silk Required,,,$1\mathrm{.}5,0\mathrm{.}5,,,,,,,],[$Rayon Required,,,,,$2,,,,,,1\mathrm{.}5],[$Velvet Required,,,,,,,$3,,,1\mathrm{.}5,],[$Cotton Required,,,,,,,,$1\mathrm{.}5,0\mathrm{.}5,,]]$