Solution:
Since the given question is not clearly and fully uploaded, I saw already this complete question and I understand that your question is already read out, according to it I have answered as follows:
Calculation of Units completed and transferred:
Particulars | Units |
Units of Beginning Work In Process (given) | 300 |
Units started into production (given) | 6,200 |
Total Units available | 6,500 |
Less:Units of Closing Work in Process (given) | (450) |
Units completed and Transferred | 6050 |
Calculation of Equivalent unit of production for the mixing department:
Particulars | Materials | Conversion |
Units transferred to the next department (Given as100%) (calculated) | 6050 | 6050 |
Ending WIP Materials =450*40% (given) = 180 Conversion =450*30% ( given) = 135 |
180 |
135 |
Equivalent units of Production | 6,230 | 6,185 |
Therefore, Equivalent Units of production for materials is 6,230 and conversion is 6,185.
Calculation of cost per equivalent Units as follows:
Particulars | Materials | Conversion |
Cost of Beginning WIP (given) (a) | $10,500 | $6,750 |
Cost added during the period (given) (b) | $330,912 | $406,408 |
Total Cost ( A = (a) +(b) ) | $341.412 | $413,158 |
Equivalent Units of Production (B) (calculated) | 6,230 | 6,185 |
Cost per equivalent unit (A/B) | $54.80 | $66.80 |
Assignment of cost as follows:
Calculate Cost of ending WIP Inventory and Units transferred out: |
Particulars | Materials | Conversion | Total |
Ending WIP Inventory: | |||
Equivalent Units Of production | 180 | 135 | |
Cost per Equivalent unit | $54.8 | $66.8 | |
Cost of ending WIP | $9,864 | $9018 | $18,882 |
Units Completed and transferred out: | |||
Units transferred to next dept. | 6,050 | 6,050 | |
cost per equivalent unit | $54.8 | $66.8 | |
Cost of units transferred out | $331,540 | $404,140 | $735,680 |
Cost Reconciliation statement as follows:
Particulars | Amount ($) |
Costs to be accounted for: | |
Cost of Beginning WIP Inventory( $10,500 + $6,750) | $17,250 |
CostsAdded during the year ($330,912 + $406,408) | $737,320 |
Total Costs to be accounted for | $754,570 |
Costs to be accounted for: | |
Cost of Ending WIP | $18,882 |
Costs of Units transferred out | $735,688 |
Total cost accounted for | $754,750 |
Note : Slightly varied answers may come due to decimal points.
Hayword, Inc uses weighted average costing and has two departments and has provided data related to...
Hayword, Inc. uses weighted-average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. . Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below.if in a blank cell,...
S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell on the Budget Data...
Answers must be inputted by a formula Hayword, Inc. uses weighted average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Use the information Included in the Excel Simulation and the Excel functions described below to complete the task • Cell Reference: Allows you to refer to data from another cell in the worksheet. From...
hayword, inc. uses weighted-average costing and has two departments and has provided data related to its mixing department for the month of July. I need to know what keys to press into the spreadsheet as well. Thank you! Hayword, Inc. uses weighted-average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Use the information included...
Preparing a Performance Report using Excel's ABS, IF and SUM Functions Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from...
Patterson, Inc. has provided details of its actual cost data for the month. The Controller has asked you to compute the basic variances and the impact of those variances on unit costs. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, -D4" was entered, the formula would...
Better Bottles, Inc. uses a periodic inventory system and has provided its current inventory information. The Controller has as you to prepare a comparison of the Ending Inventory and Cost of Goods Sold totals for three different inventory costing methods: Periodic FIFO, LIFO, and Weighted-Average. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the...
Adams Corporation evaluates divisional managers based on Return on Investment (ROI) and has provided the operating results of the Northern Division from last year. The Controller has asked you to compute the ROI and Residual Income based on data from last year and if the division adds a new product line. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another...
Marta Communications, Inc. has provided incomplete financial statements for the month ended March 31. The Controller has asked you to help calculate the missing amounts in the incomplete financial statements. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=B11” was entered, the formula would output the...
JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, B5" was entered, the formula would output the...