Inventory Worksheet

$1)$ Fill in the "Profit" column by using a formula. Recall that profit is calculated by subtracting the cost to purchase from the price. Ensure that your answer is in Accounting format.

$2)$ Use the MAX function to determine which ingredient's profit amount is the highest. Ensure that your answer is in Accounting format.

$3)$ Use a function to determine the average price for all the ingredients. Ensure that your answer is in Accounting format.

$4)$ Use a function to determine the average profit for all the ingredients. Ensure that your answer is in Accounting format.

Price Increase Worksheet

$5)$ BAMA Burger Buggy would like to increase prices by $15\%.$ Use a function to fill in the column "Price Increase" to calculate the $15\%$ increase, using an absolute reference to cell B$1.$ Ensure that your answer is in Accounting format.

$6)$ BAMA Burger Buggy would like to adjust the increased prices so that they are rounded up to the nearest penny. Use the ROUNDUP function in column "Rounded" to accomplish this.$$Ensure that your answer is in Accounting format.

$7)$ What is the minimum price of the increased, rounded prices? Use an appropriate function to determine the answer. Ensure that your answer is in Accounting format.

$8)$ What is the count of the items in the table? Use an appropriate function to determine the answer.

Item ID Update Worksheet

$9)$ BAMA Burger Buggy would like to update the Item IDs to remove the letters after the $"$#$".$Fill in the column "Location of #$"$ with the position of the $"$#$"$ in the "Item ID$"$ column. Use the FIND function with the Search Text of an absolute$$reference to cell B$1.$

$10)$ Create the updated ID in column "New ID$"$ using the LEFT function and the value in the "Locaton of #$"$ column.