OM Question. ANSWER USING EXCEL. SHOW WORK AND FORMULAS FOR EACH ANSWER. Thank youOnly this question, I hope to get an answer within an hour. And I need calculations and formulas, thank you very muchT

OM Question. ANSWER USING EXCEL. SHOW WORK AND FORMULAS FOR EACH ANSWER. Thank you

Only this question, I hope to get an answer within an hour. And I need calculations and formulas, thank you very much

Teddy Bower is an outdoor clothing and accessories chain. To ensure a full line of outdoor clothing and accessories, the marketing department at Teddy Bower insists that they also sell waterproof hunting boots. Unfortunately, they don’t have expertise in manufacturing those kinds of boots. Therefore, Teddy Bower contacted several Taiwanese suppliers to request quotes. Due to competition, Teddy Bower knows that it cannot sell these boots for more than $54. However, $40 per boot was the best quote from the suppliers. In addition, Teddy Bower anticipates excess inventory will need to be sold off at a 50 percent discount at the end of the season. Given the $54 price, Teddy Bower’s demand forecast is for 400 boots, with a standard deviation of 300.

a) If Teddy Bower decides to include these boots in its assortment, how many boots should it order from its supplier?

b) The marketing department will not be happy with the planned order quantity (from part a). They are likely to argue that Teddy Bower is a service-oriented company that requires a high fill rate. In particular, they insist that Teddy Bower order enough boots to have at least a 98 percent fill rate. What order quantity yields a 98 percent fill rate for Teddy Bower?

C) John Briggs, a buyer in the procurement overheard at lunch a discussion of supplier. After following up on his suggestion, the supplier responded that Teddy Bower could get a 10 percent discount if they were willing to order at least 800 boots. If the objective is to maximize expected profit, how many boots should it order given his new offer?