DOLCIS. B. $20 per payment EXCEL TEMPLATE EX 26-21 Process activity analysis Obj. 1,3 The procurement process for Omni Wholesale Company includes a series of activities that transforms a materials requisition into a vendor check. The process begins with a request for materials. The requesting department prepares and sends a materials request form to the Pur- chasing Department. The Purchasing Department then places a request for a quote to vendors. Vendors prepare bids in response to the request for a quote. A vendor is selected based on the lowest bid. A purchase order to the low-bid vendor is prepared. The vendor delivers the materials to the company, whereupon a receiving ticket is prepared. Payment to the vendor is authorized if the materials request form, receiving ticket, and vendor invoice are in agreement These three documents fail to agree 40% of the time, initiating effort to reconcile the differences. Once the three documents agree, a check is issued. The process can be diagrammed as follows: Preparing Materials Request (M/R) Requesting, Receiving and Selecting Vendor Bids Preparing Purchase Order Preparing Receiving Ticket (RA) Matching MRP San Varde Inve Preparing and Delivering Vendor Check Correcting Reconciliation Differences An activity analysis indicated the following activity costs with this process: Preparing materials request $36.000 Requesting, receiving and selecting vendor bids 100,000 Preparing purchase order 20,000 Preparing receiving ticket 24,000 Matching M/R, R/T, and invoice 48,000 Correcting reconciliation differences 140,000 Preparing and delivering vendor payment 32.000 Total process activity cost $400,000 On average, the process handles 20,000 individual requests for materials that result in 20,000 individual payments to vendors. Chapter 26 Lean Manufacturing and Activity Analysis 1337 Management proposes to improve this process in two ways. First, the Purchasing Depart- ment will develop a preapproved vendor list for which orders can be placed without a request for quote. It is expected that this will reduce the cost of requesting and receiving vendor bids by 75%. Second, additional training and standardization will be provided to reduce errors in troduced into the materials requisition form and receiving tickets. It is expected that this will reduce the number of reconciliation differences from 40% to 10%, over an average of 20,000 payments. A. Develop a table showing the percent of individual activity cost to the total process cost. B. Determine the average total process cost per vendor payment, assuming 20,000 payments. C. Prepare a table showing the improvements in the activity costs as a result of the changes proposed by management Show columns of activity cost prior to improvement, after im- provement, and savings. D. Estimate the average cost per vendor payment, assuming that the changes proposed by management are enacted for 20,000 total payments
