Materials$$120,000$$$120,000$Work in process$$70,000$$$100,000$Finished goods$$60,000$$$70,000$

$1.$ What was the cost of direct materials used in September?

fill in the blank $1$ of $1$$

$2.$ What was the total manufacturing cost in September?

fill in the blank $1$ of $1$$

$3.$ What was the cost of goods manufactured for September?

fill in the blank $1$ of $1$$

$4.$ Assume that Lauren Ashley Company's monthly incurred direct labor cost increased by $25\%$ and total overhead costs decreased by $20\%.$ Using Excel $($or some other spreadsheet software tool$),$ calculate Lauren Ashely's new cost of goods manufactured that results from the changes in direct labor cost and overhead costs.

fill in the blank $1$ of $1$$

Even for a relatively simple exercise, this requirement illustrates the time and effort savings of utilizing technology in setting up and solving formulas as typically

requiredis not required

in management accounting data analytic settings.