Mist Fertilizer Ltd manufactures pre-mixed garden fertilizer for the garden center retail market. The original ingredients including nitrogen, phosphorous and potassium components are mixed in the Primary Process Department (PPD). The fertilizer mix is then transferred to the Granulating and Blending Department (G&BD) for blending and drying (and where a final ingredient is added 70% through the process) and then the mix is transferred to the Bagging Department (BD) where the product is finished and bagged ready for sale. Conversion costs (labor and overheads) are assumed to be incurred evenly throughout the process. In the Granulating and Blending Department (G&BD) at the commencement of June 2018, there were 10,800 kgs of a mixture in progress, 50% complete, costing at 1 June 2018 $40,550 from the prior PPD, as well as $10,400 for conversion costs incurred in the G&BD so far. During the month of June, a further 80,000 kg of fertilizer mix came into the G&BD from the PPD, with costs attached from that prior department amounting to $109,270. The cost of mixture ingredients in the G&BD for June amounted to $108,960, while conversion costs incurred, were $250,525. At the end of June, there were 15,300 kgs of a mixture on hand at the 75% point in the process, the rest having been transferred to the Bagging Department (BD).

Required Using the excel templates provided, determine the cost of the completed Granulating and Blending Department mixture for June, the cost of the incomplete mixture at the end of June, complete the Granulating and Blending Department Work In Process (WIP) Inventory Ledger Account for June and prepare the general journal entry for materials transferred out of Granulating and Blending

Department WIP during June using: a) the Weighted Average costing assumption (15 marks). b) the FIFO assumption (16 marks). c) Ensure that you employ the correct use of the excel spreadsheet formula in all cells apart from the data section (2 marks)

nd AlXi ir (ead aden centre retel msket The originl ingredients incloding Primary Process Drwm (PO The fertliaer mix is thee ransferred to the Celating and Bending Departmt (O&BD) for Departmest (BD) wbere the prodect is nhed and baeeed enady o ncuend evenly throughoult the peocess commencement of Tune 2018, there were BO,800 of misnare in are assamed to b to wir cead prior PPD,a well as $10,400 for conversion costs incurred in the G&BD so far.During the month of June, a further 80,000 kg of talie x cm to the O& BD trom the POD with costs attached fon that prior departmest amounting to $109,270 the process, the rest aving bees ransferred to the Baping nd AlXi ir (ead aden centre retel msket The originl ingredients incloding Primary Process Drwm (PO The fertliaer mix is thee ransferred to the Celating and Bending Departmt (O&BD) for Departmest (BD) wbere the prodect is nhed and baeeed enady o ncuend evenly throughoult the peocess commencement of Tune 2018, there were BO,800 of misnare in are assamed to b to wir cead prior PPD,a well as $10,400 for conversion costs incurred in the G&BD so far.During the month of June, a further 80,000 kg of talie x cm to the O& BD trom the POD with costs attached fon that prior departmest amounting to $109,270 the process, the rest aving bees ransferred to the Baping