Buyer Analytics - Purchasing ToolPak
//div#caption {font-weight: bold; margin: 2em 0 0 0; font-color: color: //#525252;}//div#bodytext {margin: 0.75em 1.5em; line-height: 1.33em;}//div#bodydetail {margin: 0.25em 2.5em; line-height: 1.
| Publisher: | Buyer Analytics | License: | Shareware |
| Version: | 2007 | Date Added: | 13 November, 2008 |
| File Size: | 1000.0 KB | Downloads: | 15 |
| Price: | $49.95 | Editor Rating: |  |
| Systems: | Windows Vista, Windows2000, Win98, WinME, WinXP |
//div#caption {font-weight: bold; margin: 2em 0 0 0; font-color: color: //#525252;}//div#bodytext {margin: 0.75em 1.5em; line-height: 1.33em;}//div#bodydetail {margin: 0.25em 2.5em; line-height: 1.33em;}//table {width: 450px;}//#contentWrapper { //float: left; //width: 450px; //padding: 5px; //margin-left: 5px; //margin-top: 30px; //margin-bottom: 30px; //overflow: hidden; //}//#canvasWrapper { //width: 790px; //margin: 0 auto; //padding: 5px; //text-align: left;// }//td{// border-bottom-color: #cccccc;// border-bottom-style: solid;// border-bottom-width: 1px;// padding: 0;// font-size: 8pt; }//#pageFooter1 { background: inherit; border-top: 2px solid #EADAC9; color: //Gray; margin-top: 25px; padding-top: 4px; margin-bottom: 50px; }body { border: 0px; height: 100%; margin: 0px; padding: 5px; } Purchasing ToolPak - Excel® Solutions for Procurement Professionals Purchasing Toolpak is a collection of professional office forms and spreadsheets. There are 35 useful forms. All conveniently work inside Microsoft Excel. They are designed to simplify your daily purchasing tasks and help you leverage the power of Excel. Work smarter with Purchasing ToolPak for Excel! Eliminate the need to spend valuable hours drafting various forms. Purchasing ToolPak for procurement professionals offers instant access to a wide variety of forms – anything from a purchase order to a bid analysis template. And it's the best way to implement standards of excellence in your procurement practices. Features at a Glance Select from 35 professional office forms Simplify your daily office tasks! Incredibly easy to use! Save time, money and energy! Works with Microsoft Excel 2000- 2007! Complete List of Procurement Forms and Templates Bid Evaluation Quickly evaluate bids from multiple suppliers. After entering description, quantity and price for each supplier, the bid evaluation template does the rest of the work! Claim Cost Valuation Evaluate the cost of supplier claims. In cases where advance payments and or inventory holding costs are incurred due to claims, you can calculate the cost impact to your organization. Early Shipment ValuationVendors that ship and invoice items prior to the required date impact cash flow and inventory carrying cost. Early shipment valuation calculates the cost based upon the number of days early and the value of the shipment.Escalation HedgeTypically suppliers announce a price increase by providing advance notice to the buyer. Escalation hedge will calculate the return on investment based upon the incremental inventory purchased, inventory carrying cost and the price before and after the increase. Measurement Use unit of measure to convert quantity or price. Categories of conversion are segregated into area, length, volume and weight. Payment TermsWith the payment terms template you can quickly analyze alternative payment terms from competing suppliers and determine if taking the discount is worthwhile. Progress Payments With progress payments compare and analyze terms from competing vendors. Review the cost of proposed progress payments. Quantity Break Many times suppliers will offer a price reduction in exchange for ordering a higher quantity. With quantity break a purchasing professional can evaluate the lower price benefit versus the impact on cash flow and inventory holding cost. Spec Change ROIChanging to a new supplier can be costly. Buyers trade off the savings to be achieved versus the cost and complexity of qualifying the new supplier. The return on investment is calculated based upon the price savings, quantity and the estimated cost of qualification. Bid Waiver RequestThe bid wavier template is used for obtaining approval not to bid. Bid Evaluation Three additional bid analysis templates are provided. A well prepared and accurate bid analysis supports sound decision making. The analysis also supports the buyer's negotiating strategy. Change Orders Many times purchase orders are changed for description, quantity, price or terms. These changes should be documented. Use the change order template to document this information. Contract Approval RequestIn many organizations procurement policy requires management approval of contracts. Use this template for approval of procurement contracts. Contract Log Use the contract log to track the status of your contracts. Contracts can be organized by type and status. Excess Property ReportUse the excess property report to identify surplus equipment and materials to be sold by procurement. With this template you can assess fair market value versus acquisition cost. Incorrect Billing NoticeUse this template to request supplier's to review invoice discrepancies. Seven common invoice errors are listed. Expediting WorksheetThe materials expediting worksheet template is used to track critical deliveries. Send this form to your suppliers for completion. Order AcknowledgementAfter issuing a purchase order you'll want confirmation from the supplier. With the order acknowledgement template the supplier can confirm the purchase order to ensure order accuracy. Price RecordWhen ordering parts or services supplier's may change pricing without notice. This form tracks and provides a historical record of all purchases. Purchase Order ExcelThe purchase order template provides the information needed to order parts or services. There are two purchase order templates; one for ordering parts and a second for the purchase of services. Purchase Order WordThe first purchase order for Word is completed like all Word documents. The second template is a Word form. With the Word form you tab through the document. There are drop downs for payment terms, freight terms, F.O.B. point and ship via text boxes. Receiving ReportUse the receiving report to report receipt of goods or services. Track receipts for each purchase order. Rejection ReportFrom time to time materials not meeting specification will be rejected. Use the rejection report template to document materials not conforming to specification. Release OrderMany purchasing departments will issue release orders on the basis of a blanket order or contract.Two release order templates are provided; one for parts and a second for services. Request for ProposalA common task for purchasing is to manage the competitive bid process. This template will work with parts or services. There is ample room to enter a detailed item description. Along with price, the supplier provides lead time, payment terms and freight terms. RequisitionIn most organizations a procurement department will support manufacturing and other departments for the purchase of goods and services. Two procurement requisition templates are provided; one for parts and a second for services. SavingsPurchasing professionals demonstrate value to the organization through implementation and reporting cost saving projects. Description, buyer name, cost reduction type, supplier name, year of savings and savings amount are entered by the buyer. Shortage Damage ReportUse the shortage and damage report template to document issues with receipts. Traveling RequisitionThe traveling requisition form is typically used for ordering production materials. The requisition is a great way to document historical purchases. Verbal Quote RecordUse the verbal quote record to document pricing from suppliers. A buyer or his assistant may obtain pricing verbally from suppliers.Improve your purchasing decision making skills. Try Buyer Analytics today! Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
