Excel work or please show work and calculations.
The Carla Vista Paint Co. uses a process costing system. You have been giver the following selected information for July 2022: Percent Complete Units Beginning work in process inventory 7000 70% Units started 27000 Ending work in process inventory 11,000 60% The total cost of the beginning work in process inventory was $40,330, of which $7,630 was for direct labour costs. Overhead is applied on the basis of direct labour costs. DuringJuly, the company added $75,650 of direct materials, $55,050 of direct labour, and $60,555 of overhead to work in process inventory All direct materials are added at the beginning of the process, and the conversion costs are incurred uniformly throughout the process. Calculate the overhead rate. Overhead rate Calculate the direct materials, the direct labour, and the overhead cost components of the beginning work in process. Direct Materials Direct Labour ove Components of beginning work in process inventory $ $ $ Calculate the number of equivalent units of production that would be used to establish the weighted average costs for direct materials, direct labour, and overhead. Direct Materials Conversion Equivalent units of Production Calculate the number of equivalent units of production that would be used to establish the FIFO costs for direct materials, direct labour, and overhead. Direct Materials Conversion Equivalent units of production $ $ Calculate the overhead rate. Overhead rate Calculate the direct materials, the direct labour, and the overhead cost components of the beginning work in process. Direct Materials Direct Labour Ove Components of beginning work in process inventory $ $ $ Calculate the number of equivalent units of production that would be used to establish the weighted average costs for direct materials, direct labour, and overhead. Direct Materials Conversion Equivalent units of Production Calculate the number of equivalent units of production that would be used to establish the FIFO costs for direct materials, direct labour, and overhead Direct Materials Conversion Equivalent units of production $ Assuming weighted-average is used, calculate the cost of goods completed and transferred out. (Round unit cost to 4 decimal places, eg. 1.5259 and final answer to decimal places, eg. 125.) Cost of goods completed and transferred out $ Assuming FIFO is used, calculate the cost of ending work in process for materials, direct and overhead. Show each component separately. (Round unit cost to 4 decimal places, eg, 1.5259 and final answers to decimal places, eg. 125.) Direct Materials Direct Labour Overhead Cost of ending work in process inventory $
