Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started