As the cost manager/accountant of XYZ Company, you have been provided with the following information. Use...

Transcribed Image Text:

As the cost manager/accountant of XYZ Company, you have been provided with the following information. Use Excel to complete the assignment. EXAMPLE EXCEL FILE FORMAT All blank spaces should be formulas using the data provided from this Word Document. Units charged to production: Inventory in process, January 1 Karachi Carpet Company Cost of Production Report-Cutting Department For the Month Ended January 31 Unit Information Equivalent Units Whole Units Direct Materials Conversion Specifics Amount ($) Inventory in process, April 1, 7,000 gallons: Direct materials cost, for 7,000 gallons 7,000 Conversion costs, for 7,000 gallons, 70% completed 3,225 Total inventory process, April 1 10,225 Direct materials cost for April, 62,000 gallons 68,000 Received from Weaving Department Total units accounted for by the Cutting Department Units to be assigned costs: Inventory in process, January 1 Started and completed in January Transferred to finished goods in January Inventory in process, January 31 Direct labor cost for April 12,500 Total units to be assigned cost Factory overhead applied for April 9,275 Total production cost to account for 100,000 Gallons transferred to Packaging in April (includes units in process ? Cost per equivalent unit: on April 1), 64,000 gallons Inventory in process, April 30, 5,000 gallons, 25% conversion costs ? Total costs for January in Cutting Department Total equivalent units Cost per equivalent unit Costs assigned to production: Requirements Inventory in process, January 1 Costs incurred in January a. Turn in EXCEL file using FORMULAS to complete the cost sheet. (50 points) b. Find the total number of units to be assigned cost during the month of April? (5 points) c. What are the total equivalent units for Direct materials? (5 points) d. What are the total equivalent units for conversion cost? (10 points) e. What is the cost per equivalent unit for direct materials? (5 points) f. What is the convention cost per equivalent unit? (5 points) Total costs accounted for by the Cutting Department Costs allocated to completed and partially completed units: Inventory in process, January 1 balance To complete inventory in process, January 1 Cost of completed January 1 work in process Started and completed in January Transferred to finished goods in January Inventory in process, January 31 Total costs assigned by the Cutting Department g. Allocate cost to units transferred out and partially completed. (10 points) h. Considering the current economic conditions, would you recommend your company outsource raw materials from China or get them from the U.S. Explain the reason for your decision in paragraph format. (10 points) Cost Information Direct Materials Conversion Direct Materials Conversion Total As the cost manager/accountant of XYZ Company, you have been provided with the following information. Use Excel to complete the assignment. EXAMPLE EXCEL FILE FORMAT All blank spaces should be formulas using the data provided from this Word Document. Units charged to production: Inventory in process, January 1 Karachi Carpet Company Cost of Production Report-Cutting Department For the Month Ended January 31 Unit Information Equivalent Units Whole Units Direct Materials Conversion Specifics Amount ($) Inventory in process, April 1, 7,000 gallons: Direct materials cost, for 7,000 gallons 7,000 Conversion costs, for 7,000 gallons, 70% completed 3,225 Total inventory process, April 1 10,225 Direct materials cost for April, 62,000 gallons 68,000 Received from Weaving Department Total units accounted for by the Cutting Department Units to be assigned costs: Inventory in process, January 1 Started and completed in January Transferred to finished goods in January Inventory in process, January 31 Direct labor cost for April 12,500 Total units to be assigned cost Factory overhead applied for April 9,275 Total production cost to account for 100,000 Gallons transferred to Packaging in April (includes units in process ? Cost per equivalent unit: on April 1), 64,000 gallons Inventory in process, April 30, 5,000 gallons, 25% conversion costs ? Total costs for January in Cutting Department Total equivalent units Cost per equivalent unit Costs assigned to production: Requirements Inventory in process, January 1 Costs incurred in January a. Turn in EXCEL file using FORMULAS to complete the cost sheet. (50 points) b. Find the total number of units to be assigned cost during the month of April? (5 points) c. What are the total equivalent units for Direct materials? (5 points) d. What are the total equivalent units for conversion cost? (10 points) e. What is the cost per equivalent unit for direct materials? (5 points) f. What is the convention cost per equivalent unit? (5 points) Total costs accounted for by the Cutting Department Costs allocated to completed and partially completed units: Inventory in process, January 1 balance To complete inventory in process, January 1 Cost of completed January 1 work in process Started and completed in January Transferred to finished goods in January Inventory in process, January 31 Total costs assigned by the Cutting Department g. Allocate cost to units transferred out and partially completed. (10 points) h. Considering the current economic conditions, would you recommend your company outsource raw materials from China or get them from the U.S. Explain the reason for your decision in paragraph format. (10 points) Cost Information Direct Materials Conversion Direct Materials Conversion Total