Copy and paste the relevent reports and your analysis to a Word document. Copy and paste the grading rubric on the next page at the end of your Word document. Submit your document through blackboard. Also, note that salespersons receive a 10% commission based on selling price. Using the menu option Analyze, choose Statistical then Statistics on the amount field, print the statistics, and agree the total inventory to the general ledger. Extract and print out all inventory items that have net been used or sold in six months. Included in the printout the total cost of those items. Extract the finished goods into a separate file Extract those items that have a net categories value less than cost. Add a column and calculate the amount each of those items should be written down, and print a report that includes those items and the total of the write-down. Add a field and calculating inventory turnover for each item in inventory. Extract and print a report of those items with a turnover less than The report should include the total extended cost of those items. Extract the new materials into a separate the (see hint in part c. but replace "F" with "R") Extract those items that have a replacement cost less than cost, add a column and calculate the amount each of those items should be writen donw, and print a report that includes those items and the total of the write-down. Add a column and calculate inventory turnover for each item. Extract and print a report of those items with a turnover less than? The report should include the total extended cost of those items. Prepare a report of the audit implications of your findings, indicating any additional procedures that should be performed. Copy and paste the relevent reports and your analysis to a Word document. Copy and paste the grading rubric on the next page at the end of your Word document. Submit your document through blackboard. Also, note that salespersons receive a 10% commission based on selling price. Using the menu option Analyze, choose Statistical then Statistics on the amount field, print the statistics, and agree the total inventory to the general ledger. Extract and print out all inventory items that have net been used or sold in six months. Included in the printout the total cost of those items. Extract the finished goods into a separate file Extract those items that have a net categories value less than cost. Add a column and calculate the amount each of those items should be written down, and print a report that includes those items and the total of the write-down. Add a field and calculating inventory turnover for each item in inventory. Extract and print a report of those items with a turnover less than The report should include the total extended cost of those items. Extract the new materials into a separate the (see hint in part c. but replace "F" with "R") Extract those items that have a replacement cost less than cost, add a column and calculate the amount each of those items should be writen donw, and print a report that includes those items and the total of the write-down. Add a column and calculate inventory turnover for each item. Extract and print a report of those items with a turnover less than? The report should include the total extended cost of those items. Prepare a report of the audit implications of your findings, indicating any additional procedures that should be performed
