Question

In: Accounting

With the data given below we need to fill out the spreadsheet. Data Work in process,...

With the data given below we need to fill out the spreadsheet.
Data
Work in process, beginning:
Units in process 200
Completion with respect to materials 55%
Completion with respect to conversion 30%
Costs in the beginning inventory:
Materials cost $9,600
Conversion cost $5,575
Units started into production during the period 5,000
Costs added to production during the period:
Materials cost $368,600
Conversion cost $350,900
Work in process, ending:
Units in process 400
Completion with respect to materials 40%
Completion with respect to conversion 25%
Enter a formula into each of the cells marked with a ? below
Weighted Average method:
Equivalent Units of Production
Materials Conversion
Units transferred to the next department 110 60
Ending work in process:
Materials 160
Conversion 100
Equivalent units of production 270 160
Costs per Equivalent Unit
Materials Conversion
Cost of beginning work in process inventory $       9,600 $       5,575
Costs added during the period $368,600 $350,900
Total cost $   378,200 $   356,475
Equivalent units of production 270 160
Cost per equivalent unit $1,400.74 $2,227.97
Costs of Ending Work in Process Inventory and the Units Transferred Out
Materials Conversion Total
Ending work in process inventory:
Equivalent units of production 270 160
Cost per equivalent unit $1,400.74 $2,227.97
Cost of ending work in process inventory $378,200 $356,475 $734,675
Units completed and transferred out:
Units transferred to the next department 270 160
Cost per equivalent unit $1,400.74 $2,227.97
Cost of units transferred out ? ? ?
Cost Reconciliation
Costs to be accounted for:
Cost of beginning work in process inventory ?
Costs added to production during the period ?
Total cost to be accounted for ?
Costs accounted for as follows:
Cost of ending work in process inventory ?
Cost of units transferred out ?
Total cost accounted for ?

Solutions

Expert Solution

Equivalent Units of Production
Materials Conversion
Units transferred to the next department (200+5000-400) 4800 4800
Ending work in process:
Materials (400 x 40%) 160
Conversion (400 x 25%) 100
Equivalent units of production 4960 4900
Costs per Equivalent Unit
Materials Conversion
Cost of beginning work in process inventory $ 9600 5575
Costs added during the period $ 368600 350900
Total cost $ 378200 356475
Equivalent units of production 4960 4900
Cost of equivalent unit $ 76.25 72.75
Cost of Ending Work in Process Inventory and the Units Transferred Out
Materials Conversion Total
Ending work in process inventory:
Equivalent units of production 160 100
Cost per equivalent unit $ 76.25 72.75
Cost of ending work in process inventory $ 12200 7275 19475
Units completed and transferred out:
Units transferred to the next department 4800 4800
Cost per equivalent unit $ 76.25 72.75
Costs of units transferred out $ 366000 349200 715200
Cost Reconciliation
Costs to be accounted for:
Cost of beginning work in process inventory $ 15175
Costs added to production during the period $ 719500
Total cost to be accounted for $ 734675
Costs accounted for as follows:
Cost of ending work in process inventory $ 19475
Cost of units transferred out $ 715200
Total cost accounted for $ 734675

Related Solutions

**DO NOT FILL OUT THE QUESTIONAIRE, IT IS NOT ASKING TO FILL IT OUT** Below is...
**DO NOT FILL OUT THE QUESTIONAIRE, IT IS NOT ASKING TO FILL IT OUT** Below is the second page of a survey questionnaire. " Spot four poorly designed features in such page " : ... ... ... ... ... ... ... ... 2. State your age in years _ _ 3. How long have you used the Internet? (check one only) _ < 1 year _ 1 - 4 years _ 4 - 8 years _ > 8 years 4....
Given the data in the spreadsheet below, what is the probability of completing the critical path...
Given the data in the spreadsheet below, what is the probability of completing the critical path of the project in 34 or more time units? Activity Preceded By Optimistic Time Most Likely Time Pessimistic Time A None 12.89 15.25 18.21 B None 14.17 15.61 18.13 C A and B 12.33 14.2 17.98 D A and B 14.84 17.64 20.53
Fill in all the underlined spots on the spreadsheet with the data about Absorbance of Light...
Fill in all the underlined spots on the spreadsheet with the data about Absorbance of Light for different Nitrate Levels. The goals are: 1) to compute the correlation and slope of the regression line by using the "SS formulas" and 2) to compute SSE, the sum of the squared "errors" (residuals). Data from Exercise 2.69 (p. 97) The absorbance of Light for Different Nitrate Levels y - that Nitrates x (mg/liter of water) Absorbance y x^2 values y^2 values x*y...
Please fill out the charts below with the given information. The following selected transactions were completed...
Please fill out the charts below with the given information. The following selected transactions were completed by Amsterdam Supply Co., which sells office supplies primarily to wholesalers and occasionally to retail customers. Also note that the company uses a clearing house to take care of all bank as well as non-bank credit cards used by its customers. Record on page 10 of the journal Mar.      2              Sold merchandise on account to Equinox Co., $18,900, terms FOB destination, 1/10, n/30. The...
A company operates a process costing system. The work-in-process account for last month is given below:...
A company operates a process costing system. The work-in-process account for last month is given below: Work in Process Account Opening work in process 0 Closing work in process 144,000 Manufacturing costs incurred during the month 624,000 Cost of goods manufactured 480,000 The company finished producing 12,000 units and 4,000 incomplete units were still in process at the end of the month. The closing work in progress was complete to the same degree for materials and conversion costs. What was...
Fill in all the remaining blanks in the table below and fill out the appropriate formula each.
Fill in all the remaining blanks in the table below and fill out the appropriate formula each.Residual maturityResidual MaturityInterest rate of Zero coupon bondPrice of Zero Coupon Bondone-year intrinsic forward interest ratepar yield18.00%27.00%36.00%
Comparative data on three companies in the same service industry are given below. Required: 2. Fill...
Comparative data on three companies in the same service industry are given below. Required: 2. Fill in the missing information. (Round the "Turnover" and "ROI" answers to 2 decimal places.) Company A B C Sales $3,232,000 $1,869,000 Net operating income $387,840 $280,350 Average operating assets $2,020,000 $3,010,000 Margin % % 4 % Turnover 2.40 Return on investment (ROI) % 10.50 % %
Comparative data on three companies in the same service industry are given below. Required: 2. Fill...
Comparative data on three companies in the same service industry are given below. Required: 2. Fill in the missing information. (Round the "Turnover" and "ROI" answers to 2 decimal places.) Company A B C Sales $2,865,000 $2,387,000 Net operating income $315,150 $405,790 Average operating assets $1,910,000 $3,170,000 Margin % % 6 % Turnover 2.50 Return on investment (ROI) % 11.90 % %
Comparative data on three companies in the same service industry are given below. Required: 2. Fill...
Comparative data on three companies in the same service industry are given below. Required: 2. Fill in the missing information.(Round your Turnover answers to 2 decimal places. Round your Margin and ROI percentage answers to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) Companies in the Same Industry A B C Sales $4,048,000 $2,219,000 Net operating income $647,680 $310,660 Average operating assets $1,760,000 $3,230,000 Margin % % 8.00 % Turnover 2.20 Return on investment (ROI) % 9.80 %...
This is all the information that is given. We are supposed to fill in the excel...
This is all the information that is given. We are supposed to fill in the excel form Equity Journal Entries                                                                               a. The stock has a $2 par value.              b. The stock has neither par nor stated value.              c. The stock has a $5 stated value.                                    ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT