Complete the master inventory record using the math functionality of Sheets$/$Excel$.$ information:

REQUIRED FOR POINTS:

$2$

calculations and reference$/$link to the master record for each detail. Making connections to

the Master Inventory Record allows the worksheet to be used for analyzing potential

changes in the results.

Chapter & Course Outcomes: $($to be demonstrated in this project$)$

Calculate Cost of Goods Sold and Ending Inventory using $3$ costing

methods in the perpetual system of inventory.

Analyze the impact on the financial statements of each inventory

costing method and system of inventory.

Use Microsoft Excel proficiently to record and summarize information

used in business analysis and decision making.

$*$Use

Learning

resources

$($Slides$)$ &

Ebook Ch $7$

$**$ consider all possible locations$/$shelves in your analysis of COGS and End Inv

$**$If you are typing numbers, you are not meeting the requirements of the project. C$15$:F$17$

Sheet$1$ Project #$2$ Inventory Costing$\_$Allison Schultz

Share

C$15$:F$17$

$3$ Answer the following questions using the above information: double click in the answer box and begin typing your answer; enter when done

Sheet$1-$

Location $($Shelves$)$ # of Units Cost per unit Total cost

Beginning inventory $20$ $ $20\mathrm{.}00400$

Jan $15$ purchase $30$ $ $25\mathrm{.}00750$

Jan $20$ purchase $35$ $ $28\mathrm{.}00980$

Jan $30$ purchase $30$ $ $30\mathrm{.}00900$

Available Inventory $1153030$

January $25$ Sales $52$ each method calculation

Ending Inventory $63$ is on schedule below

Complete the inventory costing schedules documenting details $($shelf$/$purchase location$)$ in the calculation of BOTH ending inventory and cost of goods sold. Use math functionality for calculations and reference$/$link to the master record for each detail. Making connections to the Master Inventory Record allows the worksheet to be used for analyzing potential changes in the results.