Cases of pre-mixed whisky cans are manufactured at Whisky Brothers' Brisbane production plant. Within this plant, process costing is employed and, for practical purposes, it is assumed that all raw materials are added at the start of the production process. Direct labour and overhead costs occur evenly throughout the production cycle. The following information relates to the production of cases of pre-mixed whisky cans in January 2023: Work in process - 01/01/2023 (75% complete) Raw materials Conversion Work in process - 31/01/2023 (82% complete) Cases commenced in January Costs incurred: Raw materials Conversion 3,600 cases $81,000 $27,000 2,950 cases 46,000 cases $927,420 $310,150 Required: 1. Use Excel to determine the value of the closing work-in-process and the value of goods transferred out during the period under the: 1. Weighted Average Cost Method. 2. First-in-First-Out (FIFO) method.