Please solve it in excel

CoursHeroTranscribedText: Question 2 The records of Fremont (Jarred-rations initial and unaudited accounts show the following ending inventory balances, which must be adjusted to actual costs. Unlts Unaudited Costs Woman-process inventory 120.000 5 793.152 Finished goods Inventor}- 20.000 331.500 As the auditor. you have learned the following information. Ending woman-process inventory is 40 percent page 343 complete with respect to conversion costs. Materials are added at the beginning of the manufacturing process, and overhead is applied at the rate of 30 percent of the direct labor costs. There was no nished goods inventory at the start of the period. The following additional information is also available. Costs Units Direct Materials Direct Labor Beginning inventory{80%completeestolsbor1 80.000 $ 240.000 $ 545.000 Units started 400,000 Current costs 1,500,000 22,200,000 Units completed and transferred to nished goods inventory 360.000 Required Prepare a production cost report for Fremont using the weighted-average method. (Hint: You will need to calculate equivalent units for three categories: materials. labor, and overhead.)