Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me 2 Cost flow relationships The following information is available for the first year of operations of Creston Inc., a manufacturer of fabricating
please help me
2 Cost flow relationships The following information is available for the first year of operations of Creston Inc., a manufacturer of fabricating equipment Sales $ 12,645,000 Gross profit 5.313,400 Indirect labor 410,000 Indirect materials 183,900 Other factory overhead 827,700 Materials purchased 4,215,000 Total manufacturing costs for the period 8,052,000 Materials inventory, and of period 296,300 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet Determine the following amounts. Round your answers to the nearest dollar a. Cost of goods sold b. Direct materials cost DDIO c. Direct labor cost Search (Opt Excel template - Saved Data Review Formulas View File Home Insert Page Layout Arial 10 B Ar Av F C18 fx A B D E 1 Cost flow relationships 2 The Oluwig Horauon is available for ne list year ol operations of Creston Inc., a manufacturer of fabricating 3 equipment 4 5 DATA 6 Sales $12,645,000 7 Gross profit 5,313,400 8 Indirect labor 418,900 9 Indirect materials 183,900 10 Other factory overhead 827,700 11 Materials purchased 4,215,000 12 Total manufacturing costs for the period 8,052,000 13 Materials inventory, end of period 296,300 14 Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric results for the green entry cells (C18, C20, 15 C22) into the appropriate fields in CNOWV2 for grading. 16 17 Amount Formulas 18 a. Cost of goods sold 19 20 b. Direct materials cost 21 22 c. Direct labor cost 23 24 25 26 27 28 29 30 = Data + 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