Question: The sheet Inventory lists a grocery store's inventory for two months. Calculate the percent change for each item to two decimal places. If the

The sheet Inventory lists a grocery store's inventory for two months. Calculate the percent change for each item to two decimal places. If the formula gives an error, put "Initial Stock" in the cell. Note that when old contains a zero then the formula results in a division by zero. Dec Jan item Inventory Price Inventory Price Doritos Nacho Cheese 329 3.99 322 3.69 Doritos Cool Ranch 227 3.99 250 3.69 Pringles 210 1.49 273 1.49 Cheez-its 65 3.39 49 3.49 Ruffles 108 4.79 111 4.29 Lays 96 3.99 75 3.79 Lays Baked 35 3.29 28 3.49 Stacy's Pita Chips 40 5.89 51 5.89 Pringles Sour Cream and Onion 75 1.49 83 1.49 Terra Original 0 51 3.69 Terra Blue 0 50 3.59 Change Inventory Price
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
