$1$ Cost of Direct Materials Used in Production for a Manufacturing Company $\backslash$table$[[$Materials purchased,$$150,100],[$Materials inventory, September $1,47,400],[$Materials inventory, September $30,39,500]]$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answer in the question below.

Open spreadsheet

Determine the cost of direct materials used in production by Gabbitas during the month ended September $30.$ $

Gabbitas Manufacturing Company reported the following materials data for the month ending September $30$:

REQUIRED:

$1$ Determine the cost of direct materials used in production by Gabbitas during the month ended September $30.$

Using formulas and cell references from the problem data, perform the required analysis.

$2$ Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv$2$

for grading.