Thanks for your work a few weeks ago on our Air-Accountant shoes. The information you provided was very helpful. As you know, our research and development department has been busy creating the latest sports energy drink for accountants "Balance-ade." I asked the team to come up with some preliminary data for a typical month of manufacturing this product. The product goes through a two-stage process, mixing and bottling. Below is information for the mixing department: Complete with respect to Conversion Complete with respect to Materials 90% 70% Units Work in Process Work in Process June 1st June 30th 30,000 50% Materials cost in Work in Process- June 1st Conversion cost in Work in Process-June 1st 35,000 44,00o Materials cost added during June Conversion cost added during June 135,000 $ 215,000 Units started into production 390,000 10,000 Units transferred to the next process What I need from you is to help us run the process costing numbers on this data. I would like to a see the following in Excel (round all equivalent unit costs to the penny): 1. A full process costing report, including equivalent units, the cost per equivalent unit, and a reconciliation report. Since we haven't officially started production yet, we don't know how far along some of these products will be a month end. Please provide another view where the units are 100% of the way done with materials and 85% done with conversion costs. If this changes the cost per equivalent unit, please explain why Going back to the original data. We are also wondering if we can substitute one of the direct materials with a cheaper option. This will lead to lower material cost but this new material does requires more mixing time so there will be increased conversion cost. Please provide another view and reduce the material cost added during the period by 20% and increase the conversion costs by 15%. Should we move forward with the new material? Please explain. 2. 3. Remember to make you excel sheet presentable and professional so I can take it directly to Mr.Shoe