we need to use formulas for calculations on excal

Using the information on page 662 (9e) P16-7B, and instead of FIFO answer questions 1 and 2 using the WEIGHTED AVERAGE METHOD. No need to do question 3 . The $114,520 includes $16,800DM and $97,720DL - Create your own spreadsheet, Use page 627, exhibit 16.11 for guidance (no two spreadsheets are the same on MS Excel). - Be sure to use formulas within the program rather than a calculator. - DO not rely on the check figures since you are preparing the Average Weighted Method instead of FIFO. - Upload your saved file to Canvas for grading. Problem 16-7B A FIFO: Cost per equivalent unit; costs assigned to products 2 Belda Co makes organic juice in two departments: Cutting and Blending. Direct materials are added at the beginning of each process, and conversion costs are added evenly throughout each process. The company uses the FIFO method of process costine Data for March for the Cutting department follows Required 1. Compute equivalent units of production for both direet materials and convertion 2. Compute cost per equivilent unit of production for belin direct waterials and conversion 3. Assien coss to the departments output-specincally, to the units transferred out and to the units that remain in work in process at periodend Using the information on page 662 (9e) P16-7B, and instead of FIFO answer questions 1 and 2 using the WEIGHTED AVERAGE METHOD. No need to do question 3 . The $114,520 includes $16,800DM and $97,720DL - Create your own spreadsheet, Use page 627, exhibit 16.11 for guidance (no two spreadsheets are the same on MS Excel). - Be sure to use formulas within the program rather than a calculator. - DO not rely on the check figures since you are preparing the Average Weighted Method instead of FIFO. - Upload your saved file to Canvas for grading. Problem 16-7B A FIFO: Cost per equivalent unit; costs assigned to products 2 Belda Co makes organic juice in two departments: Cutting and Blending. Direct materials are added at the beginning of each process, and conversion costs are added evenly throughout each process. The company uses the FIFO method of process costine Data for March for the Cutting department follows Required 1. Compute equivalent units of production for both direet materials and convertion 2. Compute cost per equivilent unit of production for belin direct waterials and conversion 3. Assien coss to the departments output-specincally, to the units transferred out and to the units that remain in work in process at periodend