$12$ Prob $12-1($Input$)$Using this Excel sheet, enter the data from the problem statements and formulas to answer

the following questions regarding Millennium Liquors. Refer to the notations near the cells for help in placing the correct values in the correct cells.

Your work will be automatically graded when you submit.

Consider using the "Check your work" button to confirm your answers. You get one free usage.You need to enter information from the problem in YELLOW cellsYou need to eneter formulas to calculate answers in BLUE cellsGREEN cells are calculated for you. No need to update.RKhQ$*$Millennium Liquors is a wholesaler of sparkling wines. Its most popular product is the French Bete Noire, which is shipped directly from France. Weekly demand is $45$ cases. Millennium purchases each case for USD $120,$ there is a USD $300$ fixed cost for each order $($independent of the quantity ordered$),$ and its annual holding cost is $25$ percent. Assume $52$ weeks per year.Demand Rate

$($units per year$)$Order Cost

$($$ per Order$)$Holding Cost per unit

$($$ per unit per year$)$Optimal Order Quantity

$($Units$)$Weekly demand $*52$ weeksFixed Cost for each orderCase cost $*$ holding cost $\%$Q$*=$

SQRT$(2$ x K x R $/$ h$)2340$$$300$$$30\mathrm{.}00216<<<<<<<<<<<<<<<$