Inventory Management Based on Previous Demand. Every week Britney needs to decide how many units she needs to replenish for each item. She would like to estimate the weekly replenishment order size using both the sales and quotes data from Week 52 of last year (more precisely, the number of units sold across all items during that week). Please calculate the estimate for her and put the results in column G. Label it "Units." Since we do not have weekly sales data, we will assume the following for simplicity: (1) There were exactly 52 weeks in the last year; (2) Weekly demand for each item is constant all year long (i.e., demand in week 1 = demand in week 2 = demand in week 52) (Think: given annual sales, how do you calculate weekly sales); (3) Britney always orders from the supplier with the lowest quote; and (4) Britney always sets a fixed 5% markup for each item. Let's quickly organize what information we have on hand. For each item, we know: (1) the annual sales from the last year, (2) the unit cost (lowest quote), and (3) the 5% markup for the selling price. Now, it is your job to estimate the weekly replenishment order size for each item. For your solutions, allow decimal numbers for "Units" by setting the format to have 2 decimal places. Hint: Annual Sales = Unit Cost * 1.05 * Annual Quantity Sold Home Aneert Draw Page Layout Formulas Data Reviow View Automate 9 Toll me (4) Upolate Avalabie Wo ve made some fixes and improveneots: To complete the process, the app needs to restart