Cost of direct materials used in production for a manufacturing companyWalker Manufacturing Company reported the following materials data for the month ending June 30:Materials purchased$830,200Materials inventory, June 1234,100Materials inventory, June 30186,900This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answer in the question below. Open spreadsheet Determine the cost of direct materials used in production by Walker during the month ended June 30. Round your answer to the nearest dollar.$fill in the blank 2 4 My Drive - GoogleM myMCC | Middlese x* Assignment 5-Hon x* CengageNOWv2 | ( X9 Excel Online Stude XA Paraphrasing Tool xb Answered: Manufa xC Statement Of Cost X+O about:blankExceltemplate - Saved vO Search (Alt + Q)FileHomeInsertDrawPage LayoutFormulasDataReviewViewHelpA Editing vO CommentsArial10ВMerge vCurrency$ v.0000D13fxNumber FormatCFHIKLCost of direct materials used in production for a manufacturing company2Walker Manufacturing Company reported the following materials data for the month ending June 30:43DATA6.Materials purchasedMaterials inventory, June 1Materials inventory, June 30$830,200234,100186,90079.Using formulas and cell references, perform the required analysis, and input your answer into the Amount10 column. Transfer the numeric result for the green entry cell (D13) into the appropriate field in CNOWV2 for1112AmountFormula13 Cost of direct materials used in production141516171819202122232425262728A Data+Calculation Mode: AutomaticWorkbook StatisticsGive Feedback to Microsoft100% +1 ♥ 0 12:35...

The direct materials used is calculated as follows : Beginning direct materials + Purchases - Ending…

Answered: Cost of direct materials used in…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Question

Cost of direct materials used in production for a manufacturing company

Walker Manufacturing Company reported the following materials data for the month ending June 30:

Materials purchased	$830,200
Materials inventory, June 1	234,100
Materials inventory, June 30	186,900

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answer in the question below.

Open spreadsheet

Determine the cost of direct materials used in production by Walker during the month ended June 30. Round your answer to the nearest dollar.

$fill in the blank 2

4 My Drive - Google
M myMCC | Middlese x
* Assignment 5-Hon x
* CengageNOWv2 | ( X
9 Excel Online Stude X
A Paraphrasing Tool x
b Answered: Manufa x
C Statement Of Cost X
+
O about:blank
Excel
template - Saved v
O Search (Alt + Q)
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
A Editing v
O Comments
Arial
10
В
Merge v
Currency
$ v
.00
00
D13
fx
Number Format
C
F
H
I
K
L
Cost of direct materials used in production for a manufacturing company
2
Walker Manufacturing Company reported the following materials data for the month ending June 30:
4
3
DATA
6.
Materials purchased
Materials inventory, June 1
Materials inventory, June 30
$830,200
234,100
186,900
7
9.
Using formulas and cell references, perform the required analysis, and input your answer into the Amount
10 column. Transfer the numeric result for the green entry cell (D13) into the appropriate field in CNOWV2 for
11
12
Amount
Formula
13 Cost of direct materials used in production
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
A Data
+
Calculation Mode: Automatic
Workbook Statistics
Give Feedback to Microsoft
100% +
1 ♥ 0 12:35
...

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions