\ 1.Susan has a part-time business producing seasonal plywood yard ornaments for resale at local craft fairs and bazaars. She currently works 8 hours per day to produce 16 ornaments. What is her productivity?                  [ Select ]                          ["1.5", "2.5", "2", "1"]            She thinks that by redesigning the ornaments and switching from use of a wood glue to a hot-glue gun she can increase her total production to 20 ornaments per day. What is her new productivity?                  [ Select ]                          ["2.5", "2", "1", "1.5"]            (round to one decimal place) What is her percentage increase in productivity?                  [ Select ]                          ["25%", "40%", "50%", "20%"]            %.   2.Carbondale Casting produces cast bronze valves on a 8-person assembly line. On a recent day, 150 valves were produced during an 8-hour shift. Calculate the labor productivity of the line.                  [ Select ]                          ["3.23", "4.5", "1.25", "2.34"]             John Goodale, the manager at Carbondale, changed the layout and was able to increase production to 200 units per 8-hour shift. What is the new labor productivity per labor-hour?                 [ Select ]                          ["1.67", "3.13", "2.67", "18.75"]             What is the percentage of productivity increase?                  [ Select ]                          ["55.8", "33.8", "23.9", "45.9"]            %  3. Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of its excellent product and excellent location, demand has increased by 25% in the last year. On far too many occasions, customers have not been able to purchase the bread of their choice. Because of the size of the store, no new ovens can be added. At a staff meeting, one employee suggested ways to load the ovens differently so that more loaves of bread can be baked at one time. This new process will require that the ovens be loaded by hand, requiring additional manpower. This is the only thing to be changed. The bakery currently makes 1,800 loaves per month. The pay will be $8 per hour for employees and each employee works 160 hours per month. Charles Lackey can also improve the yield by purchasing a new blender. The new blender will mean an increase in his investment. This new blender will mean an increase in his costs of $150 per month, but he will achieve the same new output (an increase to 2,250.00) as the change in labor hours. a. Current productivity for 640 work hours loaves/dollar =                  [ Select ]                          [".234", ".352", ".178", ".333"]            b. If Charles chooses to increase the number of work hours to 790 in order to employ the new oven loading technique, then the productivity is                  [ Select ]                          [".167", ".364", ".356", ".723"]             loaves/dollar  c. By adding manpower, the percentage increase in productivity is                  [ Select ]                          ["5.7", "3.6", "1.1", "1.9"]            % d. If Charles instead chooses to purchase a new blender (while holding labor constant at 640 hours at $8 per hour), then the productivity is                   [ Select ]                          [".482", ".427", ".678", ".390"]             loaves/dollar e. By purchasing a new blender (while holding labor constant at 640 hours at $8 per hour), the percentage increase in productivity is (comparing the answer in a. to the answer in d.)                  [ Select ]                          ["23.89", "18.56", "21.30", "11.30"]            4. As part of a study for the Department of Labor Statistics, you are assigned the task of evaluating the improvement in productivity of small businesses. Data for one of the small businesses you are to evaluate is shown below. The data are the monthly average of last year and the monthly average this year. Determine the multi-factor productivity using the following costs: labor: $8 per hour; capital: 8.3% per month of investment; energy: $.60 per BTU Last YearThis YearProduction15001500Labor350325Capital1500018000Energy30002750 a. What is the percent change in the labor productivity?                  [ Select ]                          ["7.7", "11.7", "8.9", "2.3"]            %   b. What is the overall multi-factor productivity change?                  [ Select ]                          ["2.3", "11.2", "7.9", "1.8"]            %  5.A local university is considering changes to its class structure in an effort to increase professor productivity. The old schedule had each professor teaching 5 classes per week, with each class meeting an hour per day on Monday, Wednesday, and Friday. Each class contained 20 students. The new schedule has each professor teaching only 3 classes, but each class meets daily (Mon.-Fri.) for an hour. New classes contain 50 students. Calculate the labor productivity for the initial situation (students/hour).                 [ Select ]                          ["5.25", "10.0", "6.67", "11.56"]            Calculate the labor productivity for the schedule change (students/hour).                 [ Select ]                          ["10.0", "6.67", "12.56", "4.23"]            What is the change in productivity?                  [ Select ]                          ["45%", "50%", "25%", "38%"]            6.Martin Manufacturing has implemented several programs to improve its productivity. They have asked you to evaluate the firm's productivity by comparing this year's performance with last year's. The following data are available: Last YearThis YearOutput10,500 units12,100 unitsLabor Hours12,00013,200Utilities$7,600$8,250Capital$83,000$88,000 a. What is the percent change in labor hours this year vs. last year?                  [ Select ]                          ["4.76%", "7.69%", "5.34%", "3.25%"]            b. What is the percent change in utility cost this year vs. last year?                  [ Select ]                          ["-1.25%", "6.16%", "4.55%", "6.52%"]            c. What is the percent change in capital investment this year vs. last?                  [ Select ]                          ["-6.75%", "9.24%", "5.55%", "8.69%"]            d. What is the overall multi-factor productivity for last year?                  [ Select ]                          [".10233", ".01267", ".2457", ".11055"]            e. What is the overall multi-factor productivity this year?                  [ Select ]                          [".34780", ".10233", ".04677", ".11055"]            f. What is the multi-factor percent change this year vs. last year?                  [ Select ]                          ["11.8%", "3.5%", "-2.7%", "8.0%"]            7. This year, Clearwater Inc., will produce 55,600 hot water heaters at its plants in Harrisburg, PA in order to meet its expected demand. To accomplish this, each laborer at the Clearwater Plant will work 150 hours per month. If the labor productivity at the plant is 0.20 water heaters per labor-hour, How many heaters can one labor produce every month?                  [ Select ]                          ["370", "150", "0.20", "30"]            and every year                  [ Select ]                          ["2.5", "150", "73", "360"]            How many laborers are required at the plant to meet the demand?                  [ Select ]                          ["1853", "155", "150", "762"]            8. Tabby produces 'Final Exam Care Packages' for resale by her sorority. She is currently working a total of 5 hours per day to produce 90 care packages. What is Tabby's productivity?                  [ Select ]                          ["45 packages", "18 packages/ hour", "20 packages/ day", "90 packages"]            Tabby thinks that by redesigning the package, she can increase her total productivity to 122 care packages per day. What will be her new productivity?                  [ Select ]                          ["30 packages/ day", "7 packages/ hr", "122 packages", "24.4 packages/ hr"]            What will be the percentage increase in productivity if Tabby makes the change?                 [ Select ]                          ["70%", "12.2%", "32%", "35.5%"]            9. In December, Textra Motors produced 16,600 customized SUVs at its plant in New Mexico. The labor productivity at this plant is known to have been 0.18 SUV per labor-hour during that moth. 540 laborers were employed at the plant that month. How many hours did the average laborer approximately work that month?                 [ Select ]                          ["58 hours", "97 hours", "170 hours", "31 hours"]            If productivity can be increased to 0.21 SUVs per hour, how many hours would the average laborer work that month?                  [ Select ]                          ["78 hours", "31 hours", "146 hours", "113 hours"]            10.  Nancy Kirkwood runs a small job shop where garments are made. The job shop employs 8 workers. Each worker is paid $10 per hour. During the first week of March, each worker worked 45 hours. Together, they produced a batch of 132 garments. Of these garments, 52 were "seconds" (meaning that they were flawed). The seconds were sold for $90 each at a factory outlet store. The remaining 80 garments were sold to retail outlets at a price of $198 per garment. What was the labor productivity, in dollars per labor-hour, at this job shop during the first week of March?  Group of answer choices44 $/labor-hr 45.6 $/labor-hr 13 $/labor-hr 57 $/labor-hr

I. Title: Using IDEA for Data Analytics to Uncover Accounts Payable FraudII. Introduction You are a Staff Auditor at Showker & Associates LLP. A long-time client, Home Improvement Inc. has asked your firm to come and investigate a possible fraud. Management has noticed a disproportionate increase in Cost of Goods Sold in the first quarter of the current year (2017) and has recently been notified through an anonymous tip that a purchasing fraud has taken place at the company. Home Improvement Inc. is a retailer in Harrisonburg, Virginia that sells approximately 24 home improvement products including cabinets, light fixtures, faucets and more. The company buys primarily from local vendors and sells its products locally. The company currently sells products offered by 200 vendors and has 80 full-time employees.Management at Home Improvement Inc. is concerned that an employee has taken advantage of the lack of internal controls over the Accounts Payable function and has committed a fraud. Showker & Associates conducted the annual audit of the company several months prior for the year ended December 31, 2016 and found no trace of fraud. However, the firm did note that there was a lack of internal controls over vendor purchases and payments and relayed their concern to the company’s management.Your firm will be conducting a fraud investigation based on transactions that occurred during the first quarter of the current year. Therefore, the primary focus of the investigation will be on purchases made from January 1, 2017 to March 31, 2017. Purchases and payment fraud are among the most common types of fraud in an organization. The audit team has decided to use IDEA to analyze the company’s data and investigate this possible fraud.It is important to understand the possible ways in which this type of fraud could occur. It has already been mentioned that there is a lack of internal controls over the Accounts Payable function at Home Improvement Inc. With that in mind, it is important to think about what could go wrong at the company to help determine where to look for the fraud.Potential Risks in Accounts Payable:1. Payments made to unauthorized suppliers.2. Payments made to individuals or employees.3. Unauthorized premiums given to suppliers.4. Invoices paid late.5. Invoices paid on irregular dates.6. Invoices processed twice.7. Payments made in a way to go undetected by auditors.8. Missing Purchase Order or other items / documents.III. Steps to Completion As the staff auditor, your senior has assigned you with the task of analyzing the employees, vendors and purchases listings to check for fraud. These listings are updated through the end of the first quarter of the current year and contain all of the necessary information to conduct the investigation.You are to go through the following steps to complete the investigation. It is important that you are thorough and complete in your work. Throughout the assignment you must take screen captures of each step and paste them to a Word document to be turned in at completion. This will allow yourAuthors: Kenneth Blankenship and David HayesJames Madison University2senior to easily follow your work and evaluate your performance.The following Microsoft Excel data files are provided for this case:• Employees.xls• Vendors.xls• Purchases.xls1. Open the IDEA software and create a new project for Home Improvement Inc. Give the project the title Fraud Investigation. Change the Project properties to contain the proper Report name and Report period.2. Import the three excel files provided for this case into your newly created project in IDEA. Check the field statistics of each data set individually to verify that all of the data was imported correctly. From the Field Statistics, the Total Amount column in the purchases listing should equal $188,552.00.▪ The excel file titled Employees contains a detailed list of every employee at Home Improvement Inc.▪ The excel file titled Vendors contains a detailed list of every vendor that is in the company’s accounts payable system. These vendors have been approved by the Purchasing department and are paid when ordered items have been received by Home Improvement Inc.▪ The excel file titled Purchases contains a listing of all the purchases made from Home Improvement, Inc. during the first quarter of 2017. Products are purchased from Home Improvement’s vendors to be sold by the company.Once uploaded into the project, these three data sets will be used to search for any unusual, missing or duplicate information.3. From the Vendors listing, extract any rows that contain a P.O. Box as the listed billing address and analyze the results for any unusual items.4. Test for any gaps or duplicates in the purchase order number sequence on the Purchases listing. Additionally, test for any duplicate invoices.5. According to the company’s policy, it is only acceptable to avoid credit approval on small purchases below $200. Ensure that no amounts of $200 or greater were purchased without the proper approval. From the First Quarter Purchases listing, extract all purchases above the threshold that were made without credit approval.6. Run a Stratification on the Total Amount field in the First Quarter Purchases database and analyze the results. Extract any items you consider to be high or unusual payments as a result of your Stratification analysis.7. Run a Direct Extraction to check for any orders received or payments made on unusual dates (weekends) from the Purchases listing.Authors: Kenneth Blankenship and David HayesJames Madison University38. Ensure that all purchases have been made from vendors contained on the Authorized Vendors listing.9. No employees’ information should be present within the approved vendor listing. Join the two databases to search for any possible matches. Analyze any duplicate data more closely and then extract any additional information as necessary.10. Run a Summarization of the First Quarter Purchases containing all of the purchases information and order the results alphabetically by vendor name. Run a Bedford’s Law analysis on the first digit and first two digits of the Total Amount column from the listing.11. Provide an audit trail for your supervisor by taking a screen capture of your File Explorer showing all of the project databases and reports that were created during the investigation and screen captures of the expanded history of your work on the project.12. In your own words, make recommendations to the client on ways to improve their internal controls over the Accounts Payable function in order to prevent this type of fraud from occurring again in the future. Your recommendations should be based on your fraud investigation findings and each issue discovered should be addressed with a resolution.IV. Deliverables▪ Screen captures:o Create screen captures of the Audit trail you created in Step 11, ando Create a zip file of all audit trail files.▪ Word document:o Prepare a formal client report in APA Style using the recommendations you prepared in Step 12, ando The report must be written in your own words.V. Hints and Tips▪ Read the project and review the grading rubric before