answer this completely and i will give a like, and a good comment. Thanks. Done with excel apparently but can be done here anyway

Question 1 6 pts You work as the production line manager for Dan's Cat Empurrium, purveyor of all things cat related. You have to decide what product mix to produce to stock the grand opening of a Bothell storefront. Your factory can produce cat hats, kitten mittens, a special Dan cat toy, cat food and kitty litter. The storefront manager has requested you stock at least 150 of each product. Cat hats sell for $10 each, kitten mittens for $8 each, the special cat toy $4 each, cat food $16 per bag and kitty litter for $14. Cat hats use $2.50 worth of cotton and kitten mittens use $3 worth of cotton to produce. The special cat toy uses $1 of cotton and $0.50 of clay to produce. Cat food is directly imported from the Blue Buffalo company for $12 a bag. Kitty litter uses $5 worth of clay to produce. Your storeroom currently holds $2500 worth of cotton and $1500 worth of clay. Your contract for Blue Buffalo states that they will provide batches of 50 bags of cat food, up to maximum of 400 bags. Finally, your storefront manager has informed you that they can only stock a total of 1200 accessories (cat hats, kitten mittens and cat toys) and only a total of 850 essentials (cat food and kitty litter). Determine the optimal product mix to maximize profit and make sure to save the Sensitivity report. Report the max profit rounded to the nearest dollar. Question 2 1 pts Question 2 1 pts If your supplier of cotton offered you an additional $200 worth of cotton but asked you to pay $400, would this deal be profitable for your company? Yes O No Question 3 1 pts Your marketing and sale team came back and informed you that they overestimated the price they could sell cat hats for. Instead of $10, they determined that they would only sell for $9. Would this change your product mix? No Yes Question 4 2 pts Blue Buffalo decided to make their own cat hats and reached out to see if you were interested in buying up to 500 cat hats for $4 a piece (you still sell them for $10). However, they require you to stop producing your own cat hats. Do you take the deal? If you take the deal, what is your new max profit? If you don't take the deal, at what price should Blue Buffalo sell you the cat hats to encourage you to take the deal? (Round to the nearest dollar) Question 5 O pts