In September, Lauren Ashley Company purchased materials costing $200,000 and incurred direct labor cost of $120,000. Overhead totaled $325,000 for the month. Information on inventories was as follows: Materials September 1 September 30 $120,000 80,000 70,000 $130,000 90,000 65,000 Work in process Finished goods Required: Download Excel spreadsheet 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?
In September, Lauren Ashley Company purchased materials costing $200,000 and incurred direct labor cost of $120,000. Overhead totaled $325,000 for the month. Information on inventories was as follows: Materials September 1 September 30 $120,000 80,000 70,000 $130,000 90,000 65,000 Work in process Finished goods Required: Download Excel spreadsheet 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?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![Direct Materials Used, Cost of Goods Manufactured
In September, Lauren Ashley Company purchased materials costing $200,000 and incurred direct labor cost of $120,000. Overhead totaled $325,000 for the month.
Information on inventories was as follows:
Materials
Work in process
Finished goods
Required:
September 1 September 30
$120,000
80,000
70,000
$130,000
90,000
65,000
Download Excel spreadsheet
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 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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F97fb0af1-8233-4785-b739-5232e26a42da%2Ff3c41b84-8570-4857-905d-a7d5aaf86549%2Fd6t2oy_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Direct Materials Used, Cost of Goods Manufactured
In September, Lauren Ashley Company purchased materials costing $200,000 and incurred direct labor cost of $120,000. Overhead totaled $325,000 for the month.
Information on inventories was as follows:
Materials
Work in process
Finished goods
Required:
September 1 September 30
$120,000
80,000
70,000
$130,000
90,000
65,000
Download Excel spreadsheet
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 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.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education