Direct Materials Used, Cost of Goods Manufactured In September, Lauren Ashley Company purchased materials costing $180,000 and incurred direct labor cost of $150,000, Overhead totaled $375,000 for the month. Information on inventories was as follows: 1. What was the cost of direct materials used in September? 2. What was the total manufacturing cost in September? 3. What was the cost of goods manufactured for September? 4. Assume that Lauren Ashley Company's monthly incurred direct Iabor 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. 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. 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 in management accounting data analytic settings