Reference no: EM133797498
Strategic Procurement
PROJECT - Procurement Analysis of a Publicly Traded Company with Cost Analysis Dashboard
Objective
This assignment involves a comprehensive procurement analysis of a publicly traded company, using available online data. You will examine the company's contract types, Indigenous procurement initiatives, sustainable procurement efforts, and cost structures. The assignment includes a cost analysis that you will represent in a dashboard, providing insights into spending patterns and cost-saving opportunities.
Company - Enbridge Inc.
Structure
Part 1: Company Overview (Based on allocation of publicly traded company )
Task: Provide a brief overview of the company, including its main business activities, key procurement needs, and relevant procurement or sustainability initiatives.
Deliverable: A 1-page summary of the company and its procurement context.
Part 2: Analysis of Contract Types
Task: Research the types of procurement contracts the company uses, based on available data. Include a discussion on suitability, limitations, and examples of contracts relevant to the company's industry. Get solution now!
Deliverable: A 2-3-page report detailing the types of contracts and recommendations for potentially beneficial contract types.
Part 3: Indigenous Procurement Practices
Task: Evaluate the company's Indigenous procurement practices, including any policies, partnerships, or goals related to Indigenous engagement.
Deliverable: A 2-page analysis with insights into the company's Indigenous procurement and recommendations for enhancing it.
Part 4: Sustainable Procurement and Ethical Practices
Task: Assess the company's sustainable procurement practices, focusing on eco-friendly sourcing, ethical labor, and supplier transparency.
Deliverable: A 2-page report summarizing current sustainable practices and areas for potential improvement.
Part 5: Cost Analysis and Dashboard Representation
Task: Conduct a cost analysis using available data, focusing on spend categories, cost drivers, and potential cost-saving opportunities within the company's procurement function. For example, students can analyze the distribution of spending across suppliers, product categories, or contract types. The goal is to identify areas of high spend and suggest cost optimization strategies.
Dashboard Requirements:
Use a tool like Microsoft Excel, Google Sheets, or Power BI to create a dashboard representing key aspects of the cost analysis.
Dashboard Elements:
Spend Distribution: Visuals (e.g., pie charts) showing spend distribution by category, department, or supplier type.
Cost Trends: Line charts or bar graphs illustrating trends over time if data is available.
Potential Savings: Highlight areas with opportunities for cost savings, such as alternative suppliers or contract renegotiation opportunities.
Top Suppliers: List of top suppliers by spend, showing high-cost contracts that could be re-evaluated.
Deliverable: A dashboard section and accompanying 1-page summary explaining the cost analysis insights and recommended cost-saving strategies.
Part 6: Recommendations and Implementation Plan
Task: Propose actionable recommendations for enhancing the company's procurement strategy, covering contract types, Indigenous procurement, sustainability, and cost savings.
Deliverable: A 2-3-page report with short-term, medium-term, and long-term recommendations and an implementation plan.
This work should be written in APA Format with clear headings.