Question

In: Accounting

Prepare the cost reconciliation portion of the Initial Review Department's production report for March.

United Claim Processors provides claims processing services for major insurance companies. The Winnipeg location processes all health benefit claims for various insurance benefit providers. Claims are received electronically or by mail in the Initial Review Department. Employees in this department sort claims into simple and complex categories and note any missing documentation that may be required. Simple claims are then passed on to the Processing Department where skilled claims processors match information from the claim with each individual's accounts in the database and then estimate the value of the benefit payment to be paid. Complex claims go to a separate processing centre for further examination. The next stage in the simple claims process is the Approval and Payment Department where final approvals and payments to claimants are initiated and completed.

During March, the Initial Review Department transferred 5,000 simple claims to the Processing Department. At the end of March, 800 claims remained in the Initial Review Department that were 80% complete with respect to conversion. The cost per equivalent unit for the month was $1.50 per claim processed and total costs incurred in the Initial Review Department during the month totalled $8,460. (Note there are only conversion costs in this process; no raw materials are added at any point.) 

 

Required:

Prepare the cost reconciliation portion of the Initial Review Department's production report for March.

Solutions

Expert Solution

 

Here is the cost reconciliation report:

 

Cost reconciliation:

  Total Cost Conversion EU  
Cost accounted for as follow:      
Transferred to Packaging Dept:      
5,000 claims × $1.50 $7,500 $5,000  
Work in process, March 31:      
Conversion, $1.50 per EU $960 $640 (800 × 80%)
Total cost accounted for $8,460  

The total cost accounted for is $8,460.

Related Solutions

Prepare bank reconciliation and related entries. AP The bank portion of the bank reconciliation for Katsaris...
Prepare bank reconciliation and related entries. AP The bank portion of the bank reconciliation for Katsaris Company at August 31, 2017, was as follows: KATSARIS COMPANYBank Reconciliation August 31, 2017 Cash balance per bank $13,229 Add: Deposits in transit 2,350 15,579 Less: Outstanding cheques #4451 $1,740 #4460 549 #4461 723 #4462 1,840 #4464 620 5,472 Adjusted cash balance per bank $10,107 The unadjusted cash balance per books on September 30, 2017, was $10,228. The September bank statement showed the following:...
Prepare a cost of production report for the Machining Department for May using the FIFO method...
Prepare a cost of production report for the Machining Department for May using the FIFO method of costing. Phillips Company needs to prepare a cost of production report for the machining department. The follow data has been provided: 1. Work in process, May 1, had 90,000 units that were 40% completed and the following costs:    Direct materials       $72,720    Direct labor       $108,000    Overhead       $36,000 2. During the month of May, 180,000 units were completed and...
Prepare a production cost report using the weighted average method and show the journal entry for...
Prepare a production cost report using the weighted average method and show the journal entry for transferring units from the molding to the welding department. I think I have it done correctly, but would like to see! Work in process beginning:    Units in process 24,000    Stage of completion for materials 80%    Stage of completion for labor and overhead 30%    Costs in work in process inventory: Materials $172,460 Labor 68,900 Overhead 141,300    Total costs in beginning...
Discuss the steps used to prepare a production report under the FIFO and Weighted Average Cost...
Discuss the steps used to prepare a production report under the FIFO and Weighted Average Cost methods.
Using the Microsoft Excel, kindly prepare a cost production report for Department I and Department II...
Using the Microsoft Excel, kindly prepare a cost production report for Department I and Department II using the Weighted Average Method. Paper Needs Inc, has the following production data for the month of June 20xx. DEPARTMENT I DEPARTMENT II QUANTITY SCHEDULE Units Percentage of completion Units Percentage of completion Work-in process, beginning 15,000 2/3 complete    9,000 1/3 complete Transferred to next department 30,000 ? Work-in process, end    5,000 2/5 complete    8,000 7/8 complete COST ANALYSIS DEPARTMENT I...
Using the Microsoft Excel, kindly prepare a cost production report under the FIFO Method. Paper Needs...
Using the Microsoft Excel, kindly prepare a cost production report under the FIFO Method. Paper Needs Inc, has the following production data for the month of June 20xx. DEPARTMENT I DEPARTMENT II QUANTITY SCHEDULE Units Percentage of completion Units Percentage of completion Work-in process, beginning 15,000 2/3 complete    9,000 1/3 complete Transferred to next department 30,000 ? Work-in process, end    5,000 2/5 complete    8,000 7/8 complete COST ANALYSIS DEPARTMENT I DEPARTMENT II Work-in process, beginning Cost from...
Prepare a Production Cost Report: FIFO Method (LO 8-2, 4, 5) Lansing, Inc. provides the following...
Prepare a Production Cost Report: FIFO Method (LO 8-2, 4, 5) Lansing, Inc. provides the following information for one of its department’s operations for June (no new material is added in Department T): WIP inventory—Department T Beginning inventory (15,000 units, 60% complete with respect to Department T costs) Transferred-in costs (from Department S) $ 116,000 Department T conversion costs 53,150 Current work (35,000 units started) Prior department costs 280,000 Department T costs 209,050 The ending inventory has 5,000 units, which...
Review Problems for Cost Classification 1. The cost of leather used in the production of women’s...
Review Problems for Cost Classification 1. The cost of leather used in the production of women’s shoes. 2. Maintenance costs for painting equipment in a car factory. 3. The VP of HR’s annual salary. 4. Rent on the manufacturing facility. 5. Depreciation on a tradeshow booth. 6. Salary of a labourer hired to sew soles to shoes. 7. Telephone charges of the CEO’s assistant. 8. Cost of paper required to print coupons to be mailed to customers. 9. Rent on...
How do you do a Cost of Production report?
How do you do a Cost of Production report?
E16-7 Prepare a production report The Sanding Department of Quik Furniture Company has the following production...
E16-7 Prepare a production report The Sanding Department of Quik Furniture Company has the following production and manufacturing cost data for March 2017, the first month of operation. Production: 7,000 units finished and transferred out; 3,000 units started that are 100% complete as to materials and 20% complete as to conversion costs. Manufacturing costs: Materials $33,000; labor $21,000; overhead $36,000. Instructions Prepare a production cost report. NOTE: Enter a number in cells requesting a value; enter either a number or...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT