Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SEVERAL PARTS TO THIS QUESTION INCLUDING EXCEL SHEET PLEse anwser all parts! its ALL one question!!! Drect Matenus Uied, Cost of Geods Manulestured Required: Donnisad

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
SEVERAL PARTS TO THIS QUESTION INCLUDING EXCEL SHEET PLEse anwser all parts! its ALL one question!!!
Drect Matenus Uied, Cost of Geods Manulestured Required: Donnisad Frcei spreadsheet 1. What was the coit of direct meteriais vied in September? 2. What was the cotal manufacturno rost in stoptembent 3. What wis the cost of 0000m manufactured fs sectember? acovuning dats analite seteingn. osting $200,000 and incurred direct labor cost of $130,000. Overhead totaled $315,000 for the month. Information on inventories was as A cost increased by 25% and total overhead costs decreased by 20%. Using Excel (or some other spreadsheet software tool), calculate anges in direct labor cost and overhead costs. and effort savings of utilizing technology in setting up and solving formulas as typicall Direct Materials Used, Cost of Goods Manufactured In September, Lauren Ashley Company purchased materials costing $200,000 and incurred direct labor cost of $130,000 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? 4. Assume that Lauren Ashley Company's monthly incurred direct labor cost increased by 25% and total overhead costs dec Lauren Ashely's new cost of goods manufactured that results from the changes in direct labor costhand overhead costs. Even for a relatively simple exercise, this requirement illustrates the time and effort savings of utilizing technology in setting accounting data analytic settings. 1. Materials inventory, September 1 Materials purchases in September Materials inventory, September 30 Direct materials used in September 2. Direct materials Direct labor Manufacturing overhead Total manufacturing cost 3. Total manufacturing cost Add: Work in process, September 1 Less: Work in process, September 30 Cost of goods manufactured

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions