calculate the estimate for her and put the results in column G$.$ Label it "Units." Please keep $2$ decimal places if the number is not an integer. You may assume a uniform demand 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 for each item she always orders from the lowest$-$priced supplier. FYI profit margin is defined as the ratio of profit $/$ revenue. Mary has learned from the past that finding the best deal is key to DangerWay's success in 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 the last column $($column R$).$ Because the size of the database and the fact that grocery prices fluctuate on a daily basis, she would like an automated solution.