Need help with the question below Note: if possible give the download link of file and make this file in word format.

Sunspot Beverages. Ltd., of Fiji utilizes the weighted-normal strategy in its cycle costing sy It makes mixed tropical natural product drinks in stages. Natural product juices are separated from new leafy foods mixed in the Blending Department The mixed juices are then packaged of pressed for delivery in the Bottling Department. The accompanying data relates to the tasks of the Blending Department for June.

(Percent Completed) Units Materials Conversion Work in process, beginning. 52,000 70%. 40% Started into production 273,500 Completed and transferred out 263,500 Work in process, ending. 62,000. 75%. 25% Materials Conversion Work in process, beginning $ 17500 $ 5,300 Cost added during June $ 187,100 $ 111,880 Required: 1. Calculate the Blending Department's equivalent units of production for materials and conversion in June. 2. Calculate the Blending Department's cost per equivalent unit for materials and conversion in June. 3. Calculate the Blending Department's cost of ending work in process inventory for materials, conversion, and in total for june. 4. Calculate the Blending Department's cost of units transferred out to the Bottling Department for materials, conversion, and in total for June. 5. Prepare a cost reconciliation report for the Blending Department for June.