PROCESS COSTING ASSIGNMENTS Use the information below for BOTH the Weighted AVG and FIFO assignments. Tha followine data are available for BRIGHT Company for the month of May: Required: Using the EXCEL TEMPLATE PYOVIDED IN MODULE 8B, complete the 5 steps to the WEIGHTED AVERAGE problem for Bright Company. Note: Students are encouraged to 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. zStudents should focus on "understanding" the 5 -steps of process costing. sWhen 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 Taccount at the bottom of the spreadsheet when you have completed the 5 steps of process costing. PRequired: You must use appropriate EXCEL formulas whenever possible (import in's you aiready have in the spreadsheet and use formulas to do all calculations). >submit your spreadsheet to the Dropbox by the due date. This is an INOIVIDUAL ASSIGNMENT (Work duplicoted from onother student will result in a grade of ZERO for BOTH students and must be REPORTED as ocodemic misconduct