ERP Core Concepts Essential Training using Excel

Master core CRM concepts and how retailers maintain leads, prospects, opportunities, and campaigns within the sales pipeline to drive customer experience and sales outcomes.

Explore how CRM information drives the marketing portion of the sales pipeline, managing leads, contacts, accounts, opportunities, campaigns, and cases from qualification to customer.

Explore how crm supports b2c and b2b sales for toy trains, leveraging multi-channel marketing, bots for off hours support and lead generation, and formal customer inquiry handling.

Explore how leads convert to accounts and contacts in the ERP CRM data, differentiate qualified and unqualified prospects, and track sources like website in the ERP train spreadsheet.

Explore how qualified leads convert to accounts and opportunities, capturing value, probability, closing date, and win or loss status for sales and campaigns, including revenue expectations.

The CRM tracks customer-reported issues with case numbers and recorded actions to resolve them, emphasizing organized case handling to maintain strong customer relations.

See how the CRM Analytics Best Board consolidates marketing and sales activity across three locations, tracking leads converted, opportunities won, and service tickets closed on first contact.

Complete hands on exercises in the ERP train spreadsheet CRM tab, determining leads, quotes, and expected revenue using list prices, discounts, and a 30-day social media campaign.

Recap crm concepts: manage leads, accounts, contacts, opportunities, campaigns, and cases. Convert qualified leads to contacts and accounts, track opportunities and closures, and explore crm through research tasks.

Master CPQ by exploring configuring products for sale, applying guided selling and selling restrictions, setting prices with methods like cost-plus and fixed price, and generating a price book for quotes.

Configure products by following configuration rules to create valid mixed-item sets, enabling accurate pricing and guided selling. The CPQ module flags invalid configurations due to regional restrictions.

Apply hands-on product configuration in Excel by creating a blue train in the Configure tab, copying the red and green trains, and enforcing a Texas-only shipping rule.

price products by calculating standard cost and applying cost-plus, fixed profit percentage, or fixed price methods, then derive net price from discounts and reference price book and contract price lists.

Explore how internal and external price books translate to price lists, discounts, and contract pricing, and learn to calculate price and gross profit across pricing methods.

Practice pricing items in excel by calculating gross profit or price, verifying cost plus profit equality, transferring to the external price book, and applying the Virginia discount structure.

Learn core CPQ concepts from configuring and pricing to drafting, approving, submitting quotes, and tracking statuses from draft to accepted; convert approved quotes into sales orders within the CRM.

Explains the ERP quote workflow: versioned quotes, price validity, bill-to and ship-to addresses, line items with totals, terms, and converting accepted quotes into sales orders with profit analysis.

See how a customer-accepted court converts to a sales order, carrying bill to and ship to details, line items, pricing, and discounts, with profit analysis and b2c order examples.

Create and convert business-to-business and business-to-consumer quotes into sales orders using the pricing tab and discount structures, apply terms, freight, and multi-shipment delivery options, and assess quote and order profit.

Recap the CPQ process, including configuration to select item bundles, pricing methods such as cost plus, fixed percentage, and market price, and a discount structure across products, customers, and regions.

Explore how the supply chain links procuring raw materials, manufacturing, inventory, and shipping to customers. Study transportation management, materials management, and production planning, including MRP logic and plant management PLM.

Explore core concepts of transportation management by creating transport orders, selecting carriers and truck types, scheduling drops, managing inventory, and processing bill of lading for delivery.

Learn transport scheduling in ERP, including multi-drop orders, carrier execution, and the bill of lading and freight bill that document shipper, consignee, and charges.

Manage the item master to store general information for each inventory item, including description, unit of measure, weight, general ledger code, and saleability to control price lists and sales orders.

Practice item master exercise by adding a blue train item, copying green train items, and updating names and descriptions in the inventory tab; review inventory dash under item master set.

Explore the inventory items master data across plants, including item attributes, lead times, setup and run time, safety stock, and minimum order quantities used in production planning.

Learn how a bill of materials lists the items and quantities needed to make one finished product, including assemblies and raw materials, in a structured format.

Explore how a bill of material explosion drives production planning by iteratively exploding a fab item into assemblies and levels to reveal required raw materials and purchase items.

Complete the BOM exercise in Excel by exploding the bill of materials for blue and green train items, listing raw and purchased materials and quantities in the inventory tab.

Explore how demand from B2C and B2B orders drives production planning, inventory management, and lot-based manufacturing, with work centers, 3-D printers, testing, and purchase orders.

Explore how MRP uses inputs like minimum order quantity, order multiple, lead time, queue time, and safety stock to generate a plan that addresses independent demand from customers.

Explore independent and dependent demand in MRP logic, driven by sales orders and the buildup of material for fabricated items, with lead times shaping inventory and sales and operations planning.

Explore ERP core concepts in Excel with two demand exercises, balancing on-hand stock and sales orders to determine production needs and update the production planning tab.

Explore how supply and inventory flow drive MRP in ERP, detailing raw, purchased, and fabricated items, on-hand quantities, planned orders, and manual contingencies.

Explore mpd in enterprise resource planning core concepts, analyzing inventory, demand, and supply to compute ending inventory and plan work orders with lead times across the bill of materials.

Complete two hands-on mpd and mrp exercises in an ERP course to compute supply and ending inventory for a 1,205 unit demand with order multiple 100 and five-day lead time.

Explore how MRP generates planned work orders and planned purchase orders, how planners confirm them, and how converted orders become real orders with sequential numbering.

Explore how work centers organize shop floor layouts and how item routes link operations, from setup and run times to queue time, shaping lead time and MRP planning.

Explain how a planned work order becomes a confirmed, printed document for the shop floor, detailing item specifics, due dates via MRP, required components, and a three-step operation sequence.

Track purchase orders, PO items, vendors, unit and extended prices, and manage receipts from multiple shipments until the PO is closed, updating inventory for MRP.

Industrial engineers design and fabricate products, manage drawings for 3d printing, track shop floor changes, and oversee barcode scanners, inventory counts, and product information sheets for marketing.

Learn how quality control and quality assurance drive ERP product quality. Apply Dmanisi principle of defining, measuring, analyzing, improving, and controlling with rigorous testing and a customer issue tracking system.

Recaps the end-to-end supply chain from suppliers to customers, detailing item master data, material planning, work orders, and inventory flows within an ERP-enabled shop floor.

Explore the distinction between managerial and financial accounting, including invoicing, costing, pricing, planning, budgeting, and reporting using chart of accounts, income statement, balance sheet, equity, and cash flow statement.

Describe invoicing for B2C and B2B orders, including single or multiple invoices per shipment, email invoicing, net 30 terms, early payment discounts, and payment methods.

Engage in hands-on invoicing by preparing a shipment invoice from a transport order, calculating totals, and applying 25-day terms with a 3 percent discount for payment within 10 days.

Learn how standard costs price products and aid budgeting by comparing them with actual costs and calculating variances; review three pricing methods: cost-plus, fixed gross profit, and fixed price.

Analyze costing and pricing strategies through hands-on exercises, comparing cost-plus and fixed percentage pricing to maximize gross profit for manufactured items.

Explore how planning and budgeting shape the master budget, including sales, production, cash receipts, and income budgets, to forecast 2021 and guide resource allocation.

Develop four 2021 budgets: sales, production, cash receipts, and income using quarterly budgeted units (300,000; 250,000; 350,000; 150,000), by copying and adjusting the existing budget in Excel's managerial accounting tools.

Explore budgeting and controlling using responsibility centers, variance analysis of budget vs actual, and financial KPIs such as return on assets, return on equity, price-to-earnings ratio, and debt-to-equity.

Bookkeepers record transactions, post journal entries to the general ledger, and apply accrual accounting, using the chart of accounts and double-entry methods to prepare income statements and balance sheets.

Explore the income statement, also called the profit and loss statement, detailing revenues, cost of goods sold, gross income, SG&A, operating income, and net income.

Explore how owners' equity changes through contributions, withdrawals, and net income, illustrated by the end-of-quarter statement showing beginning balance of $60,000 and ending equity near $9 million.

Explore how the balance sheet applies the accounting equation, showing assets equal liabilities plus owner's equity, with last quarter 2020 totals matching at 15,631,762 dollars in the ERP trained spreadsheet.

Review the statement of cash flows, focusing on cash received from customers and cash paid to suppliers. Show operating, investing, and financing activities and ending cash balance.

Review core accounting roles from invoicing and costing to preparing financial statements and KPI metrics. Explore how pricing methods, standard cost of inventory, and ledgers drive profitability and cost control.

Explore the core concepts of human capital management and how HCM functions such as talent acquisition, talent management, benefits management, payroll, and workforce management cover lifecycle from entry to exit.

Leverage digital recruitment tools to fill open and internal positions. Shortlist via screening and face-to-face interviews, then offer or deny, aided by machine learning for large candidate volumes.

Manage employees through structured talent management, starting with onboarding, orientation, and quarterly reviews. Develop skills through learning and development, leadership, and succession planning for long-term growth.

practice talent management in an ERP Excel workflow by adding Gracie Gonzalez as director of sales and tracking her learning goals and course completions via the learning management system.

Explore benefits and compensation management, including health, retirement, and disability insurance, premiums, and contributions, with compensation committees setting salary ranges and offering short-term incentives, long-term incentives, stock options, and ESPP.

Master workforce management for salaried, hourly, contractors, and union workers by capturing schedules, time data, and payroll compliance with a photo ID and GPS clock in and out system.

Learn payroll processing, including calculating salaries and wages, pre-tax deductions and taxable income, mandatory federal, state, and local taxes, and net pay, illustrated by sample payslips and department reports.

Three hands-on exercises in benefits, compensation, and workforce management guide learners through payroll processing, salary deductions, and reviewing payroll solutions.

Explore core hcm concepts, including talent acquisition, talent management, benefits management, and compensation and payroll. Complete research tasks on department structure, time capture, and payslip access.

Discover enterprise asset management, project funding, and risk and compliance functions, including patents, government inquiries regarding raw materials, and legal information management, plus waterfall and scrub methodologies.

Master enterprise asset management from design to disposal. Use asset tags, barcodes, and work orders to schedule preventive maintenance and track owners across three plants.

Learn to compare waterfall and scrum project management, from initiation and planning to execution, monitoring, and closing, and use product backlogs, sprints, and roles like product owner and scrum master.

Learn how the legal department generates and manages enterprise legal information—from compliance, litigation, and intellectual property to records retention and document management—within ERP context.

Learn to identify and mitigate financial, operational, and IT risks through Sarbanes-Oxley controls, cyber security measures, disaster recovery, and compliance checklists guiding audits.

Understand information technology management across people, process, and technology, where CIO-led planning and CMA-based maturity scores guide ERP, security, and business continuity.

Explore ERP core concepts and management practices, including formal management of IT and other departments, agile scrum versus waterfall approaches, and risk and compliance controls.

Explore key performance indicators through the balanced scorecard, applying financial indicators like return on equity and net income, customer satisfaction, internal process indicators, and learning indicators to boost profitability.

Explore value, return, and ratio KPIs, including gross income, ROA, ROE, ROI, and P/E ratios. Learn to calculate them from balance sheet, income statement, cash flow statement, and owner's equity.

Explore customer key performance indicators in ERP core concepts essential training using Excel, including NPS, customer satisfaction, first contact resolution, churn, retention, CLV, CAC, and response metrics.

Discover how internal process CPUs measure business performance from project and operations perspectives, including project schedule variance, project cost variance, milestones missed, and fulfilment cycle time metrics.

Learn the difference between learning and development, the formats such as recorded training as well as instructor-led training, and the KPIs tracking training hours, promotions, and employee satisfaction.

Explore KPI implementation at Vito's across financial, customer, internal process, and learning and development domains; learn to set targets, review variances, and drive quarterly improvements.

Recap the ERP KPI framework across financial, customer, internal process, and learning metrics, including EPS, CLV, CAC, and cycle-time measures, and outline research tasks using annual reports and KPI dashboards.

Review core ERP concepts like CRM, CPQ, supply chain, and finance and HR processes, and prepare for the course recap quiz.

Celebrate finishing the ERP core concepts training using Excel; earn your certificate of completion, share your learning on LinkedIn and resume, and participate in cross-functional teams to solve enterprise problems.

Explore steps in ERP by researching topics, completing chapter-end tasks, and forming a lunch and learn group to discuss insights while evaluating market software for small to large enterprises.