Al Habib manufacturer uses the FIFO method in its process costing system. The following information is available for the company for the month of February 2023. All materials are added at the start of production. All spoilage is abnormal and is detected by the final inspection at the end of the process. Beginning work in process (80% complete) Units Started Ending work in process (55% complete) Completed and transferred out Beginning work-in-process costs: Materials Conversion Current costs: Materials Conversion 9,500 units 42,000 units 18,000 units 31,000 units $14,000 $38,200 $50,750 $173,130 Required: Using the Microsoft Excel program, prepare a cost of production report for the company for the month of February 2023. Your report must be completed in a good format with all four steps in a typical process costing system.

Al Habib manufacturer uses the FIFO method in its process costing system. The following information is available for the company for the month of February 2023. All materials are added at the start of production. All spoilage is abnormal and is detected by the final inspection at the end of the process. Beginning work in process (80% complete) Units Started Ending work in process (55% complete) Completed and transferred out Beginning work-in-process costs: Materials Conversion Current costs: Materials Conversion 9,500 units 42,000 units 18,000 units 31,000 units $14,000 $38,200 $50,750 $173,130 Required: Using the Microsoft Excel program, prepare a cost of production report for the company for the month of February 2023. Your report must be completed in a good format with all four steps in a typical process costing system.

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter5: Process Cost Accounting—general Procedures

Section: Chapter Questions

Problem 2P: Dublin Brewing Co. uses the process cost system. The following data, taken from the organizations...

See similar textbooks

Similar questions

During December, Krause Chemical Company had the following selected data concerning the manufacture of Xyzine, an industrial cleaner: All materials are added at the beginning of processing in this department, and conversion costs are added uniformly during the process. The beginning work in process inventory had 120 of raw materials and 180 of conversion costs incurred. Materials added during December were 540, and conversion costs of 1,484 were incurred. Krause uses the first-in, first-out (FIFO) process cost method. The equivalent units of production used to compute conversion costs for December were: a. 110 units. b. 104 units. c. 100 units. d. 92 units.
Chrome Solutions Company manufactures special chromed parts made to the order and specifications of the customer. It has two production departments, Stamping and Plating, and two service departments, Power and Maintenance. In any production department, the job in process is wholly completed before the next job is started. The company operates on a fiscal year, which ends September 30. Following is the post-closing trial balance as of September 30: Additional information: The balance of the materials account represents the following: The company uses the FIFO method of accounting for all inventories. Material A is used in the Stamping Department, and materials B and C are used in the Plating Department. The balance of the work in process account represents the following costs that are applicable to Job 905. (The customer’s order is for 1,000 units of the finished product.) The finished goods account reflects the cost of Job 803, which was finished at the end of the preceding month and is awaiting delivery orders from the customer. At the beginning of the year, factory overhead application rates were based on the following data: In October, the following transactions were recorded: Purchased the following materials and supplies on account: The following materials were issued to the factory: Customers’ orders covered by Jobs 1001 and 1002 are for 1,000 and 500 units of finished product, respectively. Factory wages and office, sales, and administrative salaries are paid at the end of each month. (Assume FICA and federal income tax rates of 8% and 10%, respectively.) Record the company’s liability for state and federal unemployment taxes. (Assume rates of 4% and 1%, respectively, and that none of the employees had reached the $8,000 limit.) Record the payroll distribution for October. Wages of the supervisors, custodial personnel, etc., totaled $9,500; administrative salaries were $18,300. Miscellaneous factory overhead incurred during October totaled $4,230. Miscellaneous selling and administrative expenses were $1,500. These items as well as the FICA tax and federal income tax withheld for September were paid. (See account balances on the post-closing trial balance for September 30.) Annual depreciation on plant assets is calculated using the following rates (round to nearest dollar): Factory buildings–5% Machinery and equipment–20% Office equipment–20% The balance of the prepaid insurance account represents a three-year premium for a fire insurance policy covering the factory building and machinery. It was paid on the last day of the preceding month and became effective on October 1. The summary of factory overhead prepared from the factory overhead ledger is reproduced here: The total expenses of the Maintenance Department are distributed on the basis of floor space occupied by the Power Department (8,820 sq ft), Stamping Department (19,500 sq ft), and Plating Department (7,875 sq ft). The power department expenses are then allocated equally to the Stamping and Plating departments. After the actual factory overhead expenses have been distributed to the departmental accounts and the applied factory overhead has been recorded and posted, any balances in the departmental accounts are transferred to Under- and Overapplied Overhead. Jobs 905 and 1001 were finished during the month. Job 1002 is still in process at the end of the month. During the month, Jobs 803 and 905 were sold with a mark-on percentage of 50% on cost. Received $55,500 from customers in payment of their accounts. Checks were issued in the amount of $43,706 for payment of the payroll. Required: Set up the beginning trial balance in T-accounts. Prepare materials inventory ledger cards and enter October 1 balances. Prepare a Payroll Summary and Schedule of Earnings and Payroll Taxes for the month of October. Set up job cost sheets as needed. Record all transactions and related entries for October and post to T-accounts. Prepare a service department expense distribution worksheet for October. At the end of the month: Analyze the balance in the materials account, the work in process account, and the finished goods account. Prepare the statement of cost of goods manufactured for the month ended October 31.
Dublin Brewing Co. uses the process cost system. The following data, taken from the organizations books, reflect the results of manufacturing operations during October: Production Costs Work in process, beginning of period: Costs incurred during month: Production Data: 13,000 units finished and transferred to stockroom Work in process, end of period, 2,000 units one-half completed Required: Prepare a cost of production summary for October.
Proteger Company manufactures insect repellant lotion. The Mixing Department, the first process department, mixes the chemicals required for the repellant. The following data are for the current year: Direct materials are added at the beginning of the process. Ending inventory is 95 percent complete with respect to direct labor and overhead. The cost of goods transferred out for the year is: a. 4,471,200 b. 3,571,200 c. 3,780,000 d. 3,024,000
Holmes Products, Inc., produces plastic cases used for video cameras. The product passes through three departments. For April, the following equivalent units schedule was prepared for the first department: Costs assigned to beginning work in process: direct materials, 90,000; conversion costs, 33,750. Manufacturing costs incurred during April: direct materials, 75,000; conversion costs, 220,000. Holmes uses the weighted average method. Required: 1. Compute the unit cost for April. 2. Determine the cost of ending work in process and the cost of goods transferred out.
Kokomo Kayak Inc. uses the process cost system. The following data, taken from the organizations books, reflect the results of manufacturing operations during the month of March: Production Costs Work in process, beginning of period: Costs incurred during month: Production Data: 18,000 units finished and transferred to stockroom. Work in process, end of period, 3,000 units, two-thirds completed. Required: Prepare a cost of production summary for March.
Davis Co. uses backflush costing to account for its manufacturing costs. The trigger points are the purchase of materials, the completion of goods, and the sale of goods. Prepare journal entries to account for the following: a. Purchased raw materials, on account, 70,000. b. Requisitioned raw materials to production, 70,000. c. Distributed direct labor costs, 15,000. d. Factory overhead costs incurred, 45,000. (Use Various Credits for the account in the credit part of the entry.) e. Completed all of the production started. f. Sold the completed production for 195,000, on account. (Hint: Use a single account for raw materials and work in process.)
Heap Company manufactures a product that passes through two processes: Fabrication and Assembly. The following information was obtained for the Fabrication Department for September: a. All materials are added at the beginning of the process. b. Beginning work in process had 80,000 units, 30 percent complete with respect to conversion costs. c. Ending work in process had 17,000 units, 25 percent complete with respect to conversion costs. d. Started in process, 95,000 units. Required: 1. Prepare a physical flow schedule. 2. Compute equivalent units using the weighted average method. 3. Compute equivalent units using the FIFO method.
Softkin Company manufactures sun protection lotion. The Mixing Department, the first process department, mixes the chemicals required for the repellant. The following data are for the current year: Direct materials are added at the beginning of the process. Ending inventory is 95 percent complete with respect to direct labor and overhead. Required: Prepare a production report for the Mixing Department for the current year.
The standard cost summary for the most popular product of Phenom Products Co. is shown as follows, together with production and cost data for the period. One gallon each of liquid lead and varnish are added at the start of processing. The balance of the materials is added when the process is two-thirds complete. Labor and overhead are added evenly throughout the process. There were no units in process at the beginning of the month. Required: Calculate equivalent production for materials, labor, and overhead. (Be sure to refer to the standard cost summary to help determine the percentage of materials in ending work in process.) Calculate materials and labor variances and indicate whether they are favorable or unfavorable, using the diagram format shown in Figure 8-4. Determine the cost of materials and labor in the work in process account at the end of the month.
Narwhal Swimwear has a beginning work in process inventory of 13,500 units and transferred in 130,000 units before ending the month with 14,000 units that were 100% complete with regard to materials and 30% complete with regard to conversion costs. The cost per unit of material is $5.80 and the cost per unit for conversion is $8.20 per unit. Using the weighted-average method, what is the amount of material and conversion costs assigned to the department for the month?
Chavez Concrete Inc. has two production departments. Blending had 1,000 units in process at the beginning of the period, two-fifths complete. During the period 7,800 units were received from Mixing, 8,200 units were transferred to the finished goods storeroom, and 600 units were in process at the end of the period, 1/3 complete. The cost of the beginning work in process was: The costs during the month were: 1. Using the data in E5-15, prepare a cost of production summary for the month ended January 31, 2016. 2. Prepare a journal entry to transfer the cost of the completed units from Blending to the finished goods storeroom.