PROCUREMENT EXCEL SHEETS AND HOW TO CREATE THEM

-

 


1. Supplier List: This sheet is used to keep track of all the suppliers that the procurement team works with. It should include information such as suppliername, contact details, address, products/services provided, pricing details, and any other relevant information. This sheet helps in managing and categorizing suppliers, as well as providing a quick reference for the procurement team when sourcing products or services.


2. Purchase Request Sheet: This sheet is used to create and track purchase requests from different departments or individuals within the organization. It should include fields such as the requester's name, department, item description, quantity, desired delivery date, and budget allocation. This sheet helps in streamlining the procurement process by providing a central location for all purchase requests, allowing the procurement team to prioritize and manage them effectively.

3. Purchase Order Sheet: This sheet is used to create and manage purchase orders once they have been approved. It should include fields such as the supplier's name, contact details, delivery address, item description, quantity, unit price, total cost, and payment terms. This sheet helps in ensuring accurate and timely communication between the procurement team and the supplier, as well as providing documentation for tracking and reconciling orders.

4. Inventory Management Sheet: This sheet is used to track and manage the inventory of products or materials in the organization. It should include fields such as item name, quantity on hand, reorder point, lead time, supplier information, and storage location. This sheet helps in maintaining optimal inventory levels, avoiding stockouts or overstocking, and facilitating efficient procurement decisions based on inventory levels.

5. Supplier Performance Evaluation Sheet: This sheet is used to assess and evaluate the performance of different suppliers. It should include criteria such as delivery timeliness, product quality, pricing competitiveness, communication responsiveness, and customer service. This sheet helps in monitoring and comparing the performance of various suppliers, identifying areas for improvement, and making informed decisions when selecting or renewing supplier contracts.

6. Price Comparison Sheet: This sheet is used to compare and analyze pricing information from different suppliers for the same product or service. It should include fields such as supplier name, item description, unit price, quantity, total cost, and any additional charges. This sheet helps in identifying the most cost-effective options and negotiating better deals with suppliers, ultimately saving costs for the organization.

Comments

Post a Comment

Popular posts from this blog

Strategic Management Process

-
Image
STRATEGIC MANAGEMENT PROCESS   Strategic management process consist of four basic elements i.e. situation analysis, strategy formulation, strategy implementation and strategy evaluation. All of these four elements are essential to execute a management plan in contemplation for required changes and improvements in a plan.  Situation Analysis Situation analysis is a comprehensive assessment of market presence in a company that rely on internal and external parts. It helps to analyze the capabilities and effect of business climate on the company. It inspects the recent and potential consumer of business and how they counter with products and services  Strategy formulation  Strategy formulation is a process that includes establishing and planning the policies of companies. It is segmented into three organizational forms named operational, competitive and corporate. Operational policies are connected with several sectors like human resources, marketing, finance and produc...
Read more

Traditional Procurement VS Modern Procurement

-
Image
Procurement is also known as the process of buying which companies adopt to buy their firm raw material, components and other resources to perform their operation. The traditional methods of purchasing were only restricted to focus on three basic criteria’s that is delivery , quality and cost. Later the researchers identified the importance of issues related to environment and its concern. Keeping environmental challenges in view the concept of green procurement which is even known as environmental purchasing was added as an essential in the firm supply management decisions. Over the previous year green procurement has been gaining a considering attention in both industry and academics, the prime reason is the further issue of global warming, changes in climate and also to prevent the natural resources from being depleted. Therefore, our research primarily focuses on green procurement and its contribution towards enhancing the performance of the firm.
Read more

STEPS OF PROCUREMENT AND BID MANAGEMENT

-
Image
  1. Bid Planning: This stage involves defining the objectives scope and requirements of the procurement bid. It also includes developing a bid timeline identifying key stakeholders and establishing evaluation criteria. 2. Bid Document Preparation: During this phase the procurement team prepares the necessary bid documents such as the RFP bid instructions terms and conditions and technical specifications. These documents outline the procurement requirements and serve as the basis for vendor submissions. 3. Bid Advertising and Outreach: In order to attract a wide range of qualified vendors it is important to advertise the bid publicly. This can be done through various channels such as online bid platforms industry publications and direct communication with potential vendors. 4. Bid Evaluation: Once the bid submission period closes the procurement team evaluates the received bids. This entails reviewing vendor proposals assessing compliance with the requirements and conducting a tech...
Read more