Every week Mary needs to decide how many units she needs for each item. She would

like to estimate the weekly replenishment order size using the annual sales data $($i$.$e$.,$ the

$2$

number of units sold for each item during that week$).$ Please 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 exactly $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.