Formula: Add, Subtract, Multiply, Divide; Cell Referencing

Using Excel to Apply Perpetual Average Cost

PROBLEM

Best Cookies uses the average cost formula in a perpetual inventory system. A perpetual inventory schedule for the company's product is provided in the Student Work Area.

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated.

Fill in the missing amounts for each missing item in the following average cost perpetual inventory schedule. Display all amounts as positive numbers.

$\backslash$table$[[,$Purchases,Cost of Goods Sold,Balance$],[$Date$,$Units,Cost,Total,Units,Cost,Total,Units,,Cost,,Total$],[4-1,,,,,,,14,$$$,195\mathrm{.}00,$$$,2,730\mathrm{.}00$