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