Use formula auditing with the spreadsheet data file named Tech Ex 10.34 Q3-6 to trace precedents for the cell labeled.

Item Data Date Inventory Level Item Type Item Code Unit Price Unit Cost $50.00 ### 73700 MX 12 $10.00 $2.00 Find dependents to the Item code and Unit Cost cells Calculating Profit Quarter 1st Quarter 2nd Quarter 3rd Quarter 3192 4769 2522 unit price*units sol Revenue unit cost*units soldCost of Goods Revenue - Cost o Gross Margin 38304 6384 31920 57228 9538 47690 30264 5044 25220 Given value Sales Expense Given value Marketing Expenses Given value Miscellaneous Sum of expensesTotal Fixed Expenses 8000 2000 230 10230 8000 2100 180 10280 9000 1900 230 11130 21690 56.63% 37410 65.37% 14090 46.56% Units Sold Gross Margin - ToProfit Profit/Revenue Profit Margin he Item code and Unit Cost 4th Quarter 5675 Total 16158 68100 193896 11350 32316 56750 161580 9000 1500 165 10665 34000 7500 805 42305 46085 119275 67.67% 61.51% Find precedents to Total profit margin cell Item Data ### Date ### Inventory Le # Item Type MX Item Code 12 Unit Price ### Unit Cost # Calculating Profit Quarter 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total 3192 4769 2522 unit price*units sol Revenue unit cost*units soldCost of Goods Revenue - Cost o Gross Margin 38304 6384 31920 57228 9538 47690 30264 5044 25220 68100 193896 11350 32316 56750 161580 Given value Sales Expense Given value Marketing Expe Given value Miscellaneous Sum of expensesTotal Fixed Exp 8000 2000 230 10230 8000 2100 180 10280 9000 1900 230 11130 9000 1500 165 10665 Units Sold Gross Margin - ToProfit Profit/Revenue Profit Margin 5675 16158 34000 7500 805 42305 21690 37410 14090 46085 119275 56.63% 65.37% 46.56% 67.67% 61.51%