Assignment: Chapter 18 Weighted Average Process Costing The following information is available for Heigler Company for the month of May: Beginning WIP inventory, March.. 22,000 units Direct materials 80% complete 40% complete 58,000 units Conversion costs Units started in March Ending WIP inventory Direct materials Conversion costs Costs: Beginning Inventory Costs Incurred in May Note: Required: Using the EXCEL TEMPLATE PROVIDED IN MODULE 8B, complete the 5 steps to the WEIGHTED AVERAGE problem 15,000 units 70% complete 40% complete Materials Cost $24,000 $54,000 Conversion Cost $28,500 $55,000 For practice, first work this problem by hand -going through each of the 5 steps without the use of the template. Then the problem should be worked using the EXCEL template provided. Templates for process costing problems will NOT be provided on exams. Students should focus on "understanding" the 5-steps of process costing. When you download the blank template, save your spreadsheet as "Your Name Weighted Average Assignment 5" (ex: John Smith Weighted Average Assignment 5). Complete the Work in Process T-account at the bottom of the spreadsheet when you have completed the 5 steps of process costing. Required: You must use appropriate EXCEL formulas whenever possible (import #'s you already have in the spreadsheet and use formulas to do all calculations). RECONCILE to all check figures Provided Submit your spreadsheet to the Dropbox by due date. This is an INDIVIDUAL ASSIGNMENT (Note: Work duplicated from another student will result in a grade of ZERO for BOTH students and must be REPORTED as academic misconduct.)

Required: Using the EXCEL TEMPLATE PROVIDED IN MODULE 8B, complete the 5 steps to the WEIGHTED AVERAGE problem Note: - For practice, first work this problem by hand-going through each of the 5 steps without the use of the template. Then the problem should be worked using the EXCEL template provided. - Templates for process costing problems will NOT be provided on exams. Students should focus on "understanding" the 5-steps of process costing. - When you download the blank template, save your spreadsheet as "Your Name Weighted Average Assignment 5" (ex: John Smith Weighted Average Assignment 5). - Complete the Work in Process T-account at the bottom of the spreadsheet when you have completed the 5 steps of process costing. - Required: You must use appropriate EXCEL formulas whenever possible (import II's you already have in the spreadsheet and use formulas to do all calculations). - RECONGLE to all check figures Provided - Submit your spreadsheet to the Dropbox by due date, This is an INDIVIDUAL ASSIGNMENT -(Note: Work duplicated from another student will result in a erade of ZERO for BOTH students and must be REPORTED as academic misconduct.) Required: Using the EXCEL TEMPLATE PROVIDED IN MODULE 8B, complete the 5 steps to the WEIGHTED AVERAGE problem Note: - For practice, first work this problem by hand-going through each of the 5 steps without the use of the template. Then the problem should be worked using the EXCEL template provided. - Templates for process costing problems will NOT be provided on exams. Students should focus on "understanding" the 5-steps of process costing. - When you download the blank template, save your spreadsheet as "Your Name Weighted Average Assignment 5" (ex: John Smith Weighted Average Assignment 5). - Complete the Work in Process T-account at the bottom of the spreadsheet when you have completed the 5 steps of process costing. - Required: You must use appropriate EXCEL formulas whenever possible (import II's you already have in the spreadsheet and use formulas to do all calculations). - RECONGLE to all check figures Provided - Submit your spreadsheet to the Dropbox by due date, This is an INDIVIDUAL ASSIGNMENT -(Note: Work duplicated from another student will result in a erade of ZERO for BOTH students and must be REPORTED as academic misconduct.)