Use Excel to complete the assignment. Specifics Amount ($) Inventory in process, April 1, 7,000 gallons:...

Transcribed Image Text:

Use Excel to complete the assignment. 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 Costs processed in April 10,225 Direct materials cost for April, 62,000 gallons 68,000 Direct labor cost for April 12,500 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 on April 1), 64,000 gallons ? Inventory in process, April 30, 5,000 gallons, 25% conversion ? costs Requirements 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) 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) Use Excel to complete the assignment. 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 Costs processed in April 10,225 Direct materials cost for April, 62,000 gallons 68,000 Direct labor cost for April 12,500 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 on April 1), 64,000 gallons ? Inventory in process, April 30, 5,000 gallons, 25% conversion ? costs Requirements 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) 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)