$4)$ Every week Mary needs to decide how many units she needs for each item. She wouldlike to estimate the weekly replenishment order size using the sales data from Week $52$of last year $($i$.$e$.,$ the number of units sold for each item during that week$).$ Please

$1$

calculate the estimate for her and put the results in column G$.$ Label it "Units." Pleasekeep $2$ decimal places if the number is not an integer. You may assume a uniformdemand function across the whole year and each year has only $52$ weeks.$$This information may be useful to you: Her profit margin is $5\%$ for all items and foreach item she always orders from the lowest$-$priced supplier. FYI profit margin isdefined as the ratio of profit $/$ revenue.Mary has learned from the past that finding the best deal is key to DangerWay's successin today's highly competitive grocery retail industry. Therefore, for each item on the "Suppliers"worksheet she would like to find the supplier that offers the lowest price and list its name in thelast column $($column R$).$ Because the size of the database and the fact that grocery pricesfluctuate on a daily basis, she would like an automated solution