I need help in this homework. Please do it as it is in the pictures on excel showing formulas
I need help in this, please do it accrately and perfect
Format Painter Formatting Table Styles Styles Clipboard Font Alignment Number Cells C5 X fa 6216 D E 5,000 B 9 Enter Your Name Here 10 11 BASE DATA: 12 13 UNITS: 14 Beginning WIP Inventory (20% complete as to CC) 15 Units started 20,000 16 Units completed and transferred out 15,000 17 Ending WIP Inventory (Mat 100 %, CC 50 % complete) 10,000 18 19 Costs: 20 Beginning inventory: 21 Materials S 4,000 22 CC S 1,000 23 Current period: 24 Materials S 16,000 25 CC S 4,000 26 27 All materials are added at the beginning of the process 28 29 30 WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT: 31 6216 D E F H B 26 27 All materials are added at the beginning of the process 28 29 30 WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT: 31 32 What is your Product's Equivalent units (EUP) for Mat & CC using Weighted Average? Record your answers here Materials EUP CC EUP 33 34 Materials EUP CC EUP 35 What is your Product's Equivalent units (EUP) for Mat & CC using FIFO? 36 Record your answers here 37 38 What is your Product's Cost per Equivalent unit (EUP) for Mat & CC using Weighted Average? 39 Record your answers here Materials Cost per EUP CC Cost per EUP 40 41 What is your Product's Cost per Equivalent unit (EUP) for Mat & CC using FIFO? 42 Record your answers here Materials Cost per EUP CC Cost per EUP 43 End MAT cost in WIP End CC cost in WIP 44 What is your Product's Cost of ending WIP inventory using Weighted Average? Record your answers here 45 C5 fox B D E F G Record your answers here 33 34 Materials EUP CC EUP 35 What is your Product's Equivalent units (EUP) for Mat & CC using FIFO? 36 Record your answers here 37 38 What is your Product's Cost per Equivalent unit (EUP) for Mat & CC using Weighted Average? Materials Cost per EUP Record your answers here CC Cost per EUP 39 40 41 What is your Product's Cost per Equivalent unit (EUP) for Mat & CC using FIFO? Record your answers here Materials Cost per EUP CC Cost per EUP 42 43 End MAT cost in WIP End CC cost in WIP 44 What is your Product's Cost of ending WIP inventory using Weighted Average? 45 Record your answers here 46 47 What is your Product's Cost of ending WIP inventory using FIFO? Record your answers here End MAT cost in WIP End CC cost in WIP 48 49 45 Record your answers here 46 End MAT cost in WIP End CC cost in WIP 47 What is your Product's Cost of ending WIP inventory using FIFO? 48 Record your answers here 49 FIFO Weighted Average $ 1.05 S 1.01 (rounded) 50 51 Check Figures: 52 53 Your product's total cost (Mat AND CC) per equivalent unit is: 54 55 Check the order of your formula calculations 56 For example, if your cell al is 15 and cell bl is 4 and cell cl is 2. 57 You want to add cells al and bl and then divide that sum by cell cl 58 If your excel formula is al+b/cl then your calculation result 16.333 59 If your excel formula is (al+bl)/cl then your calculation result is 9.5 60 The result 9.5 would be the correct answer. 61
