How in Excel?

File Home Insert Draw Formulas Data Review View Help Editing Calibri 11 B Merge M General F29 * X V fx =IF(E29=0,",IF(D29="purchase orders","per order",IF(D29:"machine hours","per MH","per setup"))) A B G 42 Total allocated cost 43 Units produced 44 Overhead cost per unit 45 46 Overhead cost per unit-Squared Edge 47 Activity Activity Usage Activity Rate Allocated Cost 48 Purchasing 49 Depreciation 50 Setup 51 Total allocated cost 52 Units produced 53 Overhead cost per unit 54 55 3. Determine product cost per unit for each of the two products using activity-based costing. 56 57 (Use cells A4 to 121 from the given information to complete this question.) 58 Product Cost 59 Per Unit Direct Materials Direct Labor Overhead per Unit 60 Rounded Edge 61 Squared Edge 62 63 FA = Graded Worksheet Calculation Mode: Automatic Workbook Statistics 72'F ClearFile Home Insert Draw Formulas Data Review View Help Editing Calibri 11 V B ab Merge General $ 19 XV Ax A B C D K 21 Total $108,000 22 23 Required: 24 1. Compute the activity rate for each activity using activity-based costing. 25 26 (Use cells A4 to 121 from the given information to complete this question.) 27 28 Activity Budgeted Cost Budgeted Activity Usage Activity Rate 29 Purchasing + 30 Depreciation 31 Setup 32 33 2. Compute overhead cost per unit for each of the two products using activity-based costing. 84 35 (Use cells A4 to 121 from the given information to complete this question.) 36 37 Overhead cost per unit-Rounded Edge 38 Activity Activity Usage Activity Rate Allocated Cost 39 Purchasing 40 Depreciation 41 Setup 42 Total allocated cost 43 Units produced = B Graded Worksheet + Calculation Mode: Automatic Workbook Statistics