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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!