In excel solve the following and be sure to include cell references

Process Costing Jones Company records the following figures for the month: Physical Units 200 Transferred-In Direct Material Cost $3,000 $4,500 100% 75% $75,000 $115,000 Conversion Cost $3,500 35% $86,000 Beginning WIP Beginning WIP %-Complete Units Started / Added-in Units Completed and Transferred to FG Ending WIP Ending WIP %-Complete 4,500 4,350 350 100% 60% 20% (1) Using the weighted-average method, calculate the total cost that will be transferred to FG Inventory and remain in ending WIP. Beginning Added Total To Account For Completed & Transferred-Out Ending Total Accounted For Physical Units Transferred-In 2. Complete EU $/EU $ Direct Mati % Complete EU $/EU $ Conversion % Complete EU $IEU $ Total Cost 36 Total Cost 37 8 (2) Using the FIFO method, calculate the total cost that will be transferred to FG Inventory and remain in ending WIP. 89 Total To Completed & Total Added 0 Beginning Account For Transferred-Out Ending Accounted For 11 Physical Units 13 14 15 16 Transferred-lo % Complete EU $/EU $ 18 9 Direct Mati % Complete EU $IEU 51 2 63 54 55 56 57 58 59 SO 9 N N DR SANS AN 98123 Conversion % Complete EU $IEU Total Cost 64