Author: Helen Thomas

EDI Transaction Codes

EDI Transaction Codes

There are many electronic data interchange (EDI) transaction codes that relate to business documents, such as invoices and purchase orders. These can be exchanged with your trading partners or other third parties using EDI. Most EDI partners support the EDI transaction codes you need, including codes that are defined by the ANSI ASC X12 standard for EDI.

There’s a wide range of categories that ANSI ASC X12 EDI standard use, including;

  • Order and Financial Series
  • Transportation Air and Motor Series (TAM)
  • Transportation Ocean Series (TOS)
  • Transportation Rail Series (TRS)
  • Warehousing Series (WAR)

EDI Transaction Codes – List of EDI Code Types

There’s many ways EDI transactions can impact a company’s business. At the front and most importantly, a company and their trading partner will need to agree on which EDI transaction standards are needed to support operative communication.

EDI codes can vary based on the industry you use, this includes transportation & logistics EDI codes, manufacturing & retail EDI codes, finance EDI codes, government EDI codes, healthcare & insurance EDI codes and others.

Transportation and Logistics

EDI 104: Air Shipment Information
EDI 106: Motor Carrier Rate Proposal
EDI 107: Request for Motor Carrier Rate Proposal
EDI 108: Response to a Motor Carrier Rate Proposal
EDI 109: Vessel Content Details
EDI 110: Air Freight Details and Invoice
EDI 120: Vehicle Shipping Order
EDI 121: Vehicle Service
EDI 125: Multilevel Railcar Load Details
EDI 126: Vehicle Application Advice
EDI 127: Vehicle Baying Order
EDI 128: Dealer Information
EDI 129: Vehicle Carrier Rate Update
EDI 160: Transportation Automatic Equipment Identification
EDI 161: Train Sheet
EDI 163: Transportation Appointment Schedule Information
EDI 204: Motor Carrier Load Tender
EDI 210: Motor Carrier Freight Details and Invoice
EDI 211: Motor Carrier Bill of Lading
EDI 212: Motor Carrier Delivery Trailer Manifest
EDI 213: Motor Carrier Shipment Status Inquiry
EDI 214: Transportation Carrier Ship. Status Message
EDI 215: Motor Carrier Pick-up Manifest
EDI 216: Motor Carrier Shipment Pick-up Notification
EDI 217: Motor Carrier Loading and Route Guide
EDI 219: Logistics Service Request
EDI 220: Logistics Service Response
EDI 222: Cartage Work Assignment
EDI 223: Consolidators Freight Bill and Invoice
EDI 224: Motor Carrier Summary Freight Bill Manifest
EDI 225: Response to a Cartage Work Assignment
EDI 227: Trailer Usage Report
EDI 228: Equipment Inspection Report
EDI 240: Motor Carrier Package Status
EDI 250: Purchase Order Shipment Management Document
EDI 300: Reservation (Booking Request) (Ocean)
EDI 301: Confirmation (Ocean)
EDI 303: Booking Cancellation (Ocean)
EDI 304: Shipping Instructions
EDI 309: Customs Manifest
EDI 310: Freight Receipt and Invoice (Ocean)
EDI 311: Canada Customs Information
EDI 312: Arrival Notice (Ocean)
EDI 313: Shipment Status Inquiry (Ocean)
EDI 315: Status Details (Ocean)
EDI 317: Delivery/Pickup Order
EDI 319: Terminal Information
EDI 322: Terminal Operations and Intermodal Ramp Activity
EDI 323: Vessel Schedule and Itinerary (Ocean)
EDI 324: Vessel Stow Plan (Ocean)
EDI 325: Consolidation of Goods in Container
EDI 326: Consignment Summary List
EDI 350: Customs Status Information
EDI 352: U.S. Customs Carrier General Order Status
EDI 353: Customs Events Advisory Details
EDI 354: U.S. Customs Auto. Manifest Archive Status
EDI 355: U.S. Customs Acceptance/Rejection
EDI 356: U.S. Customs Permit to Transfer Request
EDI 357: U.S. Customs In-Bond Information
EDI 358: Customs Consist Information
EDI 359: Customs Customer Profile Management
EDI 361: Carrier Interchange Agreement (Ocean)
EDI 404: Rail Carrier Shipment Information
EDI 410: Rail Carrier Freight Details and Invoice
EDI 412: Trailer or Container Repair Billing
EDI 414: Rail Carhire Settlements
EDI 417: Rail Carrier Waybill Interchange
EDI 418: Rail Advance Interchange Consist
EDI 419: Advance Car Disposition
EDI 420: Car Handling Information
EDI 421: Estimated Time of Arrival & Car Scheduling
EDI 422: Equipment Order
EDI 423: Rail Industrial Switch List
EDI 424: Rail Carrier Services Settlement
EDI 425: Rail Waybill Request
EDI 426: Rail Revenue Waybill
EDI 429: Railroad Retirement Activity
EDI 431: Railroad Station Master File
EDI 432: Rail Deprescription
EDI 433: Railroad Reciprocal Switch File
EDI 434: Railroad Mark Register Update Activity
EDI 435: Standard Transportation Commodity Code Master
EDI 436: Locomotive Information
EDI 437: Railroad Junctions & Interchanges Activity
EDI 440: Shipment Weights
EDI 451: Railroad Event Report
EDI 452: Railroad Problem Log Inquiry or Advice
EDI 453: Railroad Service Commitment Advice
EDI 455: Railroad Parameter Trace Registration
EDI 456: Railroad Equipment Inquiry or Advice
EDI 460: Railroad Price Distribution Request or Response
EDI 463: Rail Rate Reply
EDI 466: Rate Request
EDI 468: Rate Docket Journal Log
EDI 470: Railroad Clearance
EDI 475: Rail Route File Maintenance
EDI 485: Ratemaking Action
EDI 486: Rate Docket Expiration
EDI 490: Rate Group Definition
EDI 492: Miscellaneous Rates
EDI 494: Rail Scale Rates
EDI 601: U.S. Customs Export Shipment Information
EDI 603: Transportation Equipment Registration
EDI 715: Intermodal Group Loading Plan
EDI 854: Shipment Delivery Discrepancy Info.
EDI 858: Shipment Information
EDI 859: Freight Invoice
EDI 920: Loss or Damage Claim: Gen. Commodities
EDI 924: Loss or Damage Claim: Motor Vehicle
EDI 925: Claim Tracer
EDI 926: Claim Status Report and Tracer Reply
EDI 928: Automotive Inspection Detail
EDI 980: Functional Group Totals
EDI 990: Response to a Load Tender
EDI 998: Set Cancellation

Manufacturing and Retail

EDI 101: Name and Address Lists
EDI 140: Product Registration
EDI 141: Product Service Claim Response
EDI 142: Product Service Claim
EDI 143: Product Service Notification
EDI 159: Motion Picture Booking Confirmation
EDI 170: Revenue Receipts Statement
EDI 180: Return Merchandise Authorization & Notification
EDI 244: Product Source Information
EDI 290: Cooperative Advertising Agreements
EDI 503: Pricing History
EDI 504: Clauses and Provisions
EDI 620: Excavation Communication
EDI 625: Well Information
EDI 753: Request For Routing Instructions
EDI 754: Routing Instructions
EDI 816: Organizational Relationships
EDI 818: Commission Sales Report
EDI 830: Planning Schedule w/ Release Capability
EDI 832: Price/Sales Catalog
EDI 840: Request for Quotation
EDI 841: Specifications/Technical Information
EDI 842: Nonconformance Report
EDI 843: Response to Request for Quotation
EDI 845: Price Authorization Acknowledgment/Status
EDI 846: Inventory Inquiry/Advice
EDI 847: Material Claim
EDI 848: Material Safety Data Sheet
EDI 850: Purchase Order
EDI 851: Asset Schedule
EDI 852: Product Activity Data
EDI 853: Routing and Carrier Instruction
EDI 855: Purchase Order Acknowledgment
EDI 856: Ship Notice/Manifest
EDI 857: Shipment and Billing Notice
EDI 860: Purchase Order Change Request: Buyer Initiated
EDI 861: Receiving Advice/Acceptance Certificate
EDI 862: Shipping Schedule
EDI 863: Report of Test Results
EDI 865: Purchase Order Change Acknowledgment/Request: Seller Initiated
EDI 866: Production Sequence
EDI 867: Product Transfer and Resale Report
EDI 869: Order Status Inquiry
EDI 870: Order Status Report
EDI 873: Commodity Movement Services
EDI 874: Commodity Movement Services Response
EDI 875: Grocery Products Purchase Order
EDI 876: Grocery Products Purchase Order Change
EDI 877: Manufacturer Coupon Family Code Structure
EDI 878: Product Authorization/De-authorization
EDI 879: Price Information
EDI 881: Manufacturer Coupon Redemption Detail
EDI 882: Direct Store Delivery Summary Information
EDI 883: Market Development Fund Allocation
EDI 884: Market Development Fund Settlement
EDI 885: Retail Account Characteristics
EDI 886: Customer Call Reporting
EDI 887: Coupon Notification
EDI 888: Item Maintenance
EDI 889: Promotion Announcement
EDI 890: Contract & Rebate Management
EDI 891: Deduction Research Report
EDI 893: Item Information Request
EDI 894: Delivery/Return Base Record
EDI 895: Delivery/Return Acknowledgment or Adjustment
EDI 896: Product Dimension Maintenance
EDI 940: Warehouse Shipping Order
EDI 943: Warehouse Stock Transfer Shipment Advice
EDI 944: Warehouse Stock Transfer Receipt Advice
EDI 945: Warehouse Shipping Advice
EDI 947: Warehouse Inventory Adjustment Advice

Finance

EDI 130: Student Educational Record (Transcript)
EDI 131: Student Educational Record (Transcript) Acknowledgment
EDI 132: Human Resource Information
EDI 133: Educational Institution Record
EDI 135: Student Aid Origination Record
EDI 138: Education Testing and Prospect Request and Report
EDI 139: Student Loan Guarantee Result
EDI 144: Student Loan Transfer and Status Verification
EDI 146: Request for Student Educational Record (Transcript)
EDI 147: Response to Request for Student Educational Record (Transcript)
EDI 155: Business Credit Report
EDI 188: Educational Course Inventory
EDI 189: Application for Admission to Educational Institutions
EDI 190: Student Enrollment Verification
EDI 191: Student Loan Pre-Claims and Claims
EDI 197: Real Estate Title Evidence
EDI 198: Loan Verification Information
EDI 199: Real Estate Settlement Information
EDI 200: Mortgage Credit Report
EDI 201: Residential Loan Application
EDI 202: Secondary Mortgage Market Loan Delivery
EDI 203: Secondary Mortgage Market Investor Report
EDI 205: Mortgage Note
EDI 206: Real Estate Inspection
EDI 245: Real Estate Tax Service Response
EDI 248: Account Assignment/Inquiry & Service/Status
EDI 259: Residential Mortgage Insurance Explanation of Benefits
EDI 260: Application for Mortgage Insurance Benefits
EDI 261: Real Estate Information Request
EDI 262: Real Estate Information Report
EDI 263: Residential Mortgage Insurance Application Response
EDI 264: Mortgage Loan Default Status
EDI 265: Real Estate Title Insurance Services Order
EDI 266: Mortgage or Property Record Change Notification
EDI 810: Invoice
EDI 811: Consolidated Service Invoice/Statement
EDI 812: Credit/Debit Adjustment
EDI 814: General Request, Response or Confirmation
EDI 819: Joint Interest Billing and Operating Expense Statement
EDI 820: Payment Order/Remittance Advice
EDI 821: Financial Information Reporting
EDI 822: Account Analysis
EDI 823: Lockbox
EDI 824: Application Advice
EDI 827: Financial Return Notice
EDI 828: Debit Authorization
EDI 829: Payment Cancellation Request
EDI 831: Application Control Totals
EDI 833: Mortgage Credit Report Order
EDI 844: Product Transfer Account Adjustment
EDI 849: Response to Product Transfer Account Adjustment
EDI 872: Residential Mortgage Insurance Application
EDI 880: Grocery Products Invoice

Communications and Controls

EDI 102: Associated Data
EDI 242: Data Status Tracking
EDI 815: Cryptographic Service Message
EDI 864: Text Message
EDI 868: Electronic Form Structure
EDI 993: Secured Receipt or Acknowledgment
EDI 997: Functional Acknowledgment
EDI 999: Implementation Acknowledgment

Government

EDI 103: Abandoned Property Filings
EDI 105: Business Entity Filings
EDI 113: Election Campaign & Lobbyist Reporting
EDI 149: Notice of Tax Adjustment or Assessment
EDI 150: Tax Rate Notification
EDI 151: Electronic Filing of Tax Return Data Acknowledgment
EDI 152: Statistical Government Information
EDI 153: Unemployment Insurance Tax Claim or Charge Information
EDI 154: Secured Interest Filing
EDI 157: Notice of Power of Attorney
EDI 158: Tax Jurisdiction Sourcing
EDI 175: Court and Law Enforcement Notice
EDI 176: Court Submission
EDI 179: Environmental Compliance Reporting
EDI 185: Royalty Regulatory Report
EDI 194: Grant or Assistance Application
EDI 195: Federal Communications Commission (FCC) License Application
EDI 196: Contractor Cost Data Reporting
EDI 249: Animal Toxicological Data
EDI 251: Pricing Support
EDI 280: Voter Registration Information
EDI 283: Tax or Fee Exemption Certification
EDI 284: Commercial Vehicle Safety Reports
EDI 285: Commercial Vehicle Safety and Credentials Information Exchange
EDI 286: Commercial Vehicle Credentials
EDI 288: Wage Determination
EDI 500: Medical Event Reporting
EDI 501: Vendor Performance Review
EDI 511: Requisition
EDI 517: Material Obligation Validation
EDI 521: Income or Asset Offset
EDI 527: Material Due-In and Receipt
EDI 536: Logistics Reassignment
EDI 540: Notice of Employment Status
EDI 561: Contract Abstract
EDI 567: Contract Completion Status
EDI 568: Contract Payment Management Report
EDI 650: Maintenance Service Order
EDI 805: Contract Pricing Proposal
EDI 806: Project Schedule Reporting
EDI 813: Electronic Filing of Tax Return Data
EDI 826: Tax Information Exchange
EDI 836: Procurement Notices
EDI 838: Trading Partner Profile
EDI 839: Project Cost Reporting
EDI 996: File Transfer

Healthcare and Insurance

EDI 100: Insurance Plan Description
EDI 111: Individual Insurance Policy & Client Info.
EDI 112: Property Damage Report
EDI 124: Vehicle Damage
EDI 148: Report of Injury, Illness, or Incident
EDI 186: Insurance Underwriting Requirements Reporting
EDI 187: Premium Audit Request and Return
EDI 252: Insurance Producer Administration
EDI 255: Underwriting Information Services
EDI 256: Periodic Compensation
EDI 267: Individual Life Annuity & Disability Application
EDI 268: Annuity Activity
EDI 269: Health Care Benefit Coordination Verification
EDI 270: Eligibility, Coverage or Benefit Inquiry
EDI 271: Eligibility, Coverage or Benefit Information
EDI 272: Property and Casualty Loss Notification
EDI 273: Insurance/Annuity Application Status
EDI 274: Health Care Provider Information
EDI 275: Patient Information
EDI 276: Health Care Claim Status Request
EDI 277: Health Care Information Status Notification
EDI 278: Health Care Services Review Information
EDI 362: Cargo Insurance Advice of Shipment
EDI 834: Benefits Enrollment and Maintenance
EDI 835: Health Care Claim Payment/Advice
EDI 837: Health Care Claim

How To Use POS Data For Clever Retail Execution

Using POS Data For Retail

One of the most basic tools retail brands use to understand their position in the market is point-of-sale data. From the very first time a shopper put your product in their cart to the national sales you may have right now, POS data gives you a clear picture of when and where your products are scanned for purchase, as well as your competitors.

When you have these data insights in hand, brands can identify new shopping trends, opportunities for growth, competitive threats, and more, and use that insight to build an intelligent strategy for where and how to invest at retail.

Clients can open a POS report and get a deeper understanding of not just where and when products are sold, but what field activities and in-store conditions are influencing those sales, they’re able to use POS data to inform their retail execution strategy as well.

From optimizing store position and display execution to improving partnerships with retail managers, companies are using point-of-sale data to radically improve execution in the store to drive sales velocity.

How To Use POS Data For Intelligent Retail Execution

There’s a number of different ways you can use your POS Data to execute your retail strategies.

  • Allows you to accurately track promotions and results
  • Opportunity to recruit retail partners to invest in your promotions
  • Respond to noncompliance faster for more effective promotions
  • More effectively plan which stores your field team should visit to have the biggest impact on sales.

Let’s take a look at 3 effective ways to use your POS Data now.

(1) Optimize Inventory And Stock Levels

We find this utterly fascinating, but it’s estimated that nearly 50 percent of small businesses don’t track inventory manually or with some type of software? That’s wild, right? If you’re not tracking your inventory, we can guarantee your inventory is wrong. You have to invest into the technology and resources, period.

Based on a 2018 survey by the National Retail Federation (NRF), shrink, or loss of inventory related to theft, shoplifting, error, or fraud, is reducing the bottom line by $46.8 billion across the retail industry.

Wow! $46.8 billion and 2019 will likely be bigger.

With the right POS data, your business doesn’t have to be part of that statistic. Rather, your company can be in full control of your inventory and ahead of the game as it pertains to key business decisions that can help you thrive in 2020.

The majority of modern POS systems allow you to conduct the following actions to help you manage for stock. These include but are not limited to:

  • Inventory counts
  • Check stock levels at different stores
  • Transfer stock
  • Manage returns, etc.
  • Automated reorder points

When you have your POS to help you stay on top of stock levels, it’s easier to track your items through every step of the way. It’ll allow you make better decisions when forecasting, purchasing, ordering, marketing and advertising.

Most importantly, the POS data you receive will help you ensure that your stock levels are optimized. Automated reorder points, stock transfers, inventory counts and other key features enable you to always have the right products at the right time. Right products at the right time, you know how important that is.

(2) Product And Customer Insights

Your POS data can provide you with plenty of product-specific insights also. Let’s take a quick look at which are most important.

  • Product Affinity (Items Bought Together): With this data in hand, we can show them to customers during the checkout process or during the shopping campaign.
  • Order History: We’re always looking for most data to build customer profiles. Having the ability to track customer’s purchases is huge, allowing you to follow up with relative content, marketing and promotions.
  • Sales By Product: We always need to know product sales data. There’s a number of trends we can get insights on that allow us to make appropriate decisions on individual products.
  • Refunds, Returns And Exchanges: We get to find out which items are being returned, what customers are buying in their place, and even who’s a serial returner.

If you’re a retailer, Product Affinity is huge for your company to take advantage of every sales opportunity. This allows us to make relevant recommendations to our customers. By doing so, we can greatly increase our (AOV) average order value per customer.

We love the fact that you can create customer profiles with your POS Data.

There’s so many ways to leverage POS to help your company build relationships, expectations and a great experience every time they shop.

(3) Making The Right Staffing Decisions

You don’t hear a lot of people talking about it, but you can use your POS data to learn about employee performance.

This can help you in many ways;

  • Learn Who’s Over Performing
  • Learn Who’s Under Performing
  • Learn Who Deserves A Promotion
  • Learn Who Deserves A New Title
  • Learn Who’s Most Effective Or Not Effective
  • Learn Who Needs Training
  • See How New Employees Are Performing

While we like to focus a lot on “sales,” you should consider everything employees bring to the table.

This staff-specific data can also inform staffing decisions. Anticipating extra foot traffic for an upcoming busy season or campaign? Schedule your best employees. Noticing trends for busy days or even times? Again, get your top performers on the roster.

But you can dig deeper into your POS data, beyond simply sales. You can look at time periods when you generate a lot or minimal sales and consider your staff to sales ratio. Do you have enough people on the floor to help all of your customers at any given time? It’s important to stay on top of this, especially considering that 6% of all possible sales are lost because of lack of service.

Are You Using Your POS Data To Grow?

It’s not just enough to have POS Data, you need to have the ability to collect it and analyze it.

Going through your POS Data can be a headache, we already hear you.

This is where Accelerated Analytics® can help you.

Our POS reporting allows you to easily analyze your POS Data. Accelerated Analytics® is a comprehensive software-as-a-service (SaaS) solution for collecting, analyzing, and reporting on retail EDI 852, POS, and supply chain data. Accelerated Analytics includes rich web-based analytics and mobile access so that business users can focus on responding faster, optimizing assortments and increasing sales.

We’d love to show you the POS reports we can help you create. Schedule a demo here or reach out to us directly at 941-746-2073.

What Is Supply Chain Sustainability (SCS)?

Supply Chain Sustainability (SCS)

Supply chain sustainability (SCS) is a holistic view of supply chain processes, logistics and technologies that addresses the environmental, social, economic and legal aspects of every supply chain’s components.

There’s a number of different factors that could affect SCS, this could include but is not limited too;

  • Emissions
  • Waste
  • Carbon Footprint
  • Labor Violations
  • Air Pollution
  • Health Of Workers
  • Safety Of Workers

SCS is based on the principle that socially responsible products and practices should be a priority for every company. While this ensures we’re taking steps that are good for the planet and all of us that live here, it’s also great for building positive brand awareness, minimizing environmental impact and improving long-term profitability.

An organization’s supply chain integrates both inputs and outputs. It outlines the process of producing and delivering consumer goods. Focusing on the supply chain is one key pillar of achieving business sustainability as it covers a range of areas for improvement. This could include a number of different things, such as;

  • Policies And Regulations
  • Exploration
  • Mining
  • Processing
  • Refining And Recycling
  • Purification
  • Manufacturing
  • Shipping

Historically speaking, the supply chain was simply all about logistics and knowing when and where goods were moving. However, supply chain trends have been changing continuously over the decade with the rise of the digital supply chain and accompanying visibility and analytics tools that can provide companies the ability to gather data about each component in the supply chain and how it performs.

The growing transparency has enhanced the concept of using responsible sources and it has encouraged supply chain partners to develop and share best practices for green operations and logistics. When we look at supply chain predictions for 2020, one of the top 10 factors is green logistics. Supply chain efficiency is all about having that ability to monitor every component of your supply chain, which leads to the opportunities to improve and adapt as needed.

In bigger companies, the task of focusing on supply chain sustainability can take on different job titles, such as a sustainability officer or a supply chain analyst. While everything falls under supply chain management, the task at hand would be to focus on implementing and developing processes that support sustainability. The job can also involve other elements of the supply chain, such as qualifying new suppliers, quality performance targets, delivery targets or supplier relationships.

The big question business owners need to ask, how can we improve our supply chain sustainability?

How to Improve Supply Chain Sustainability

Companies should take the following measures in order to achieve a more sustainable supply chain:

  • Using Supply Chain Management Tools And Technology – You have endless options as it pertains to new technology for your supply chain. If you’re not using them, you’re not moving forward.
  • Use Resources That Are Available To You – There’s a wide range of organizations out there that have resources you can access to learn how to help your business hit your environmental goals. These include but are not limited to World Wildlife Fund, The Sustainability Accounting Standards Board or The Sustainability Consortium.
  • Identify Where Your Supply Chain Needs Improved – This is why we preach technology, analytics and data. Without these, it’s going to be near impossible to evaluate where your supply chain needs improved.
  • Get Clarity On Your Goals – You have goals you want to achieve. You have to build a plan and put that plan in action to achieve the goals you’re aiming for. Pay close attention to government regulations, even recommendations from other professionals.
  • Finding Sustainable Partners – If sustainability is a key component of your company, we’d recommend building relationships with other companies that have sustainability at the core of their mission.
  • Always Be Accountable – You want to make sure you’re accountable throughout the whole process. rocesses that can be put in place to ensure liability are routine audits, implementation of sustainability programs and teams, software tools that track impact and customer-facing goals and progress reports.

 

*Accelerated Analytics publishes resources like this to provide insights to different analytical metrics, data points and formulas. POS Analytics. Please be aware, this doesn’t mean that our product will this metric, data point or formula. To learn exactly what our reporting covers, please feel free to schedule a demo or give us a call. Thanks for understanding.

10 Supply Chain Predictions For 2020

Supply Chain Predictions

2020 is here and one of the industries that have seen unparalleled levels of change is supply chains. While the foundational measures still apply, such as quality, productivity, and service , we’re seeing supply chain trends that are focused on digital transformation. Is it a sign of things to come?

You already know how important supply chain management is. Now, it’s time to discuss how you can make it better.

The thriving digital economy has opened up opportunities in every level of the supply chain. Companies are searching for ways to hit their business goals and stay ahead of the competition, they understand that the digital modern world is changing the game.  Implementing these advanced supply chain capabilities can allow you to be more efficient and effective with your current business processes. We’re even seeing new business models that translate directly to business performance that is tangible and measurable.

What does 2020 have in store for the supply chain industry? What about beyond? Here’s what we feel are the top 10 supply chain predictions for 2020.

Prediction 1: Automated Supplier And Spend Data Analysis

At the end of 2020, more than 50 percent of all large manufacturers will have automated supplier and spend data analysis, which can result in a 15 percent procurement in productivity gained.

Prediction 2: Artificial Intelligence (AI)

Within the next 2 years, nearly half of all manufacturing supply chains will have adopted supply chain resiliency and artificial intelligence (AI), which can result in a big 15 percent boost to productivity.

Prediction 3: Warehouse Robotics

By the year 2023, 2 out of 3 warehouses will be using robots and situational data to optimize storage, which is expected to increase capacity by more than 20 percent. This will also cut order processing time by at least 50 percent.

Prediction 4: Blockchains

By the year 2023, over 25 percent of OEMs will be utilizing blockchain to source spare parts, which is believed to increase accuracy of usable parts by a whopping 60 percent. This can also lower expedite costs by more than 40 percent.

Prediction 5: Micro-Applications

Supply chain micro-applications will account for nearly 33 percent of all new technology investments in retail and manufacturing by the year 2023.

Prediction 6: Process Automation

By 2022, firms will dedicate around 33 percent of their logistics business process outsourcing services budget to process automation, focusing on order, inventory and shipment tracking.

Prediction 7: Flexible Warehousing

By 2022, the amount of companies that will be offering flexible warehousing options will increase by over 50 percent. This is going to help address seasonal demand and has the ability to lower fixed overhead costs by 20 percent.

Prediction 8: AI-Infused Automation

By 2023, 60% of G2000 manufacturers will invest in AI-infused robotic process automation to automate tasks through increased productivity and address supply chain skills deficit.

Prediction 9: Customized Supply Chains

Within the next 4 years, 3/4 of all consumer-facing companies will have developed the ability to customize at scale within their supply chains, which could result in a 2–3 percentage point increase in market share.

Prediction 10: APR-Powered Trade

By 2024, for transparency and efficiency, 40% of customs agencies will join private blockchain and API-powered trade platform ecosystems to achieve a 50% increase in cross-border compliance.

Invest In Technology

One of the most effective investments you can make in your supply chain is technology. We’re seeing a ton of amazing features that are allowing companies to customize their entire supply chain. Every business owner has to continuously think about the future of their company and the technology race is on. If a piece of technology can improve your efficiency and effectiveness, you’d better consider adding it to your supply chain.

We’re not talking about investing in technology just to do it. Rather, we’re talking about tech, tools and features that allow you to solve business problems and leverage business opportunities. If you’re not a technology company, you should be looking for a technology partner that can help you get optimized around the right technology.

If you don’t know exactly where you should focus, you need to evaluate your whole supply chain. Where can time be saved? Where can money be saved? Where can be more efficient? If you’re not collecting data and analytics to guide your decisions, get it implemented ASAP.

Both manufacturers and retailers are re-thinking and re-imagining their products, services and processes because of the new capabilities that a digitally optimized supply chain can offer. Having the technology is great but technology alone is not going to make your supply chain successful. Business owners must continue to innovate and create value from their investments in solving real business problems and enabling new offerings to customers.

*Accelerated Analytics publishes resources like this to provide insights to different analytical metrics, data points and formulas. POS Analytics. Please be aware, this doesn’t mean that our product will this metric, data point or formula. To learn exactly what our reporting covers, please feel free to schedule a demo or give us a call. Thanks for understanding.

Supply Chain Management Trends In 2020

Supply Chain Management Trends

We feel it’s fair to say, the supply chain industry is going through an important transformational period.

Most companies already know that supply chain efficiency is key for long-term success. Over the last few years, this sector has seen massive growth. If you’re not staying current, you’re risking being left behind or worse, getting passed by your competition.

Let’s take a closer look at the biggest supply chain management trends we feel are going to take over 2020.

(AI) Artificial Intelligence And (ML) Machine Learning

There’s no question about it, technology is driving the growth of supply chains. Even better, there’s no signs of it slowing down anytime soon. Companies see this opportunity and they’re investing more in technology to increase efficiency.

There’s also major challenges and concerns ahead, especially with threats like cybersecurity. The good news, AI can be used as a shield to guard your company against the threat. AI will continue to grow from strength to strength as processes become more advanced and commonplace in the market.

Green Logistics

As more companies focus their attention on green logistics and sustainability, it’s becoming more important for companies to understand how they can implement strategies that are environmental friendly.

Green logistics has one priority goal, minimizing environmental damage through transportation and resource intensive processes. This will include;

Data And Analytics

Supply chain companies know data is the key to massive growth. Big data will give you all the insights you need to make education based decisions. If you’re utilizing your data in the right way, it’s going to give companies the opportunity to better understand their customers and gather vital business intelligence from it.

We discuss this all the time with retailers, your POS data can transform your company if you’re collecting that data, analyzing that data and making decisions based on it. When you have the opportunity to learn more about your customers and what they want, the sky is the limit.

No matter what direction supply chains take in 2020, it remains key that companies in the supply chain space remain flexible and operate with a lean approach in order to achieve sustained success. The new decade will bring lots of change and the companies that are willing to adapt will be the ones that stand to benefit the most.

*Accelerated Analytics publishes resources like this to provide insights to different analytical metrics, data points and formulas. POS Analytics. Please be aware, this doesn’t mean that our product will this metric, data point or formula. To learn exactly what our reporting covers, please feel free to schedule a demo or give us a call. Thanks for understanding.

Realized Gain Definition

COVID-19 Retail Sales Impact

A realized gain results from selling an asset at a price higher than the original purchase price. It occurs when an asset is sold at a level that would exceed its book value cost.

While an asset may be carried on a balance sheet at a level above cost, any gains while the asset is still being held are considered “unrealized” as the asset is only being valued at fair market value. If you’re selling an asset that results in a loss, this is referred to as a realized loss.

How Do Realized Gains Work?

  • Realized gains and unrealized gains differ in a number of different ways. An unrealized gain usually refers to a gain reported on a company’s financial statements and will appreciate the value of the specified asset on a company’s books.
  • Unrealized gains are typically not taxed. They add to an asset’s originally reported book value at the time of purchase and can occur on all types of assets and investments held by a company.

The assets are included in the company’s balance sheet, even so, they could be reported with or without the unrealized gains. Unrealized gains for an asset can be used to determine a selling price since these gains are added to the asset’s book valuation.

An asset’s value, held on the company’s books, most often includes the total unrealized gain for which it has received and appreciated above its originally booked price. However, unrealized gains may sometimes be off-balance sheet accruals allowing the asset to remain at book value until a sale.

Realized Gains And Unrealized Gains

While realized gains are actualized, an unrealized gain is a potential profit that exists on paper, which is the result of an investment. It is an increase in the value of an asset that has not been sold for cash yet, like a stock position that has increased in value but still remains open. A gain won’t become realized until that position is sold for a profit.

When unrealized gains present, it usually means an investor believes the investment has room for higher future gains. If it was the opposite, he/she would sell now and recognize the current gain. Unrealized gains can come about because holding an investment for an extended time period lowers the tax burden of the gain.

If an investor holds a stock for longer than one year, his tax rate is reduced to the long-term capital gains tax. If an investor wants to move the capital gains tax burden to another tax year, he can sell the stock in January of the proceeding year versus selling in the current year.

Investors should also note the distinction between realized gains and realized income. Realized income refers to income that you have earned and received, such as income from wages or a salary as well as income from interest or dividend payments.

*Accelerated Analytics publishes resources like this to provide insights to different analytical metrics, data points and formulas. POS Analytics. Please be aware, this doesn’t mean that our product will this metric, data point or formula. To learn exactly what our reporting covers, please feel free to schedule a demo or give us a call. Thanks for understanding.

What Is Purchase Price?

What Is Purchase Price

Purchase price can be referred to a number of different things depending on the “context” of the conversation. With that in mind, here’s how we’re categorizing it.

The purchase price is the price someone pays for something, which could be a service, product or investment. The specific purchase price is important because that’s the base for calculating whether the purchase is a gain or loss. Purchase prices would include commission and sales charges paid for an investment, the weighted average cost being used for multiple purchases of the same security.

Purchase Price Explained

If we’re using an “investor” example, it would be something like this;

An investor buys 100 shares of XYZ stock on 4 different dates over a 5 year period, including 100 shares purchased at a market price of $40, $60, $80 and $100 per share. In order to determine the cost basis of the purchases, the investor would need to calculate the weighted average cost, this would be the total dollar amount of the purchases divided by the number of shares purchased.

(Total Amount Of Purchases) Divided (Shares Purchased)

With each having 100 shares, the dollar amounts of XYZ stock purchases would be $4,000, $6,000, $8,000 and $10,000 or a total of $28,000, the purchase total is divided by 400 shares, which equals a total of $70 per share.

If this investor would add a stock position, he/she can calculate a new weighted average price. They would need to add the dollar amount of the new purchases and the additional shares into the equation. This formula can be adjusted for stock sales, such as the investor only selling a portion of holdings. With commission costs added, the weighted average cost might approximate $72 per share.

The Differences Between Realized and Unrealized Gains

Investors have to be familiar with the purchase price as its used to calculate gains or losses for tax purposes. This activity is reported on Schedule D of IRS form 1040. An investor reports a realized gain if he or she sells some or all of his or her investment holdings. If he or she sells no securities, the investor has an unrealized gain or loss, which would not be reported for tax purposes.

Let’s end this with one more example. A investor sells 100 shares of XYZXYZ stock at a sale price of $90 per share and uses the weighted average cost of $72 to calculate a realized gain of $28 per share. The investor would report the number of shares, along with the weighted average cost and the sale price per share on a Schedule D form. The total realized gain of $2,800 would be classified as long term because the investor held the shares for over one year. The $2,800 long-term capital gain is offset by any capital losses, and the net gain is taxable using capital gains tax rates.

*Accelerated Analytics publishes resources like this to provide insights to different analytical metrics, data points and formulas. POS Analytics. Please be aware, this doesn’t mean that our product will this metric, data point or formula. To learn exactly what our reporting covers, please feel free to schedule a demo or give us a call. Thanks for understanding.

 

Operating Expenses

operating expenses

Operating expenses refers to expenditures that a business incurs due to activities that aren’t directly related with the production of goods or services. Often abbreviated as OPEX, operating expenses include rent, equipment, inventory costs, marketing, payroll, insurance, step costs, and funds allocated for research and development.

Understanding Operating Expense

Operating expenses are necessary for many companies and unavoidable. While some businesses focus on reducing operating expenses to gain a competitive advantage and increase earnings, reducing operating expenses can also compromise the integrity and quality of operations. There’s a delicate balance most are trying to find, one that is focused on quality and profit.

Now, the Internal Revenue Service (IRS) allows businesses to deduct operating expenses if the business is operating  to turn a profit. Even so, the IRS and most accounting principles distinguish between operating expenses and capital expenditures.

Let’s take a quick look at a few operating expenses and how each would be categorized below.

Compensation Related Operating Expenses

  • Compensation and related payroll tax expenses, only for non-production employees
  • Sales commissions (though this could be interpreted as a variable cost, placing it into cost of goods sold)
  • Benefits for non-production employees
  • Pension plan contributions, this would be for non-production employees

Office Related Operating Expenses

  • Accounting expenses
  • Legal fees
  • Office supplies
  • Utility costs
  • Insurance costs
  • Property taxes
  • Depreciation of fixed assets, only non-production areas
  • Repair costs for non-production facilities
  • Rent costs for non-production facilities
  • Sales and marketing-related operating expenses

Advertising And Marketing Costs

  • Direct mailing costs
  • Entertainment costs
  • Sales material costs (sales script, brochures, etc.)
  • Travel costs

Important: Finance-related costs may be excluded from the operating expenses definition, on the grounds that they are not generated by the ongoing operations of a business. If these costs were to be included, examples would include auditor fees, bank fees, debt placement costs, and interest expense.

The definition of operating expenses is sometimes expanded to include the cost of goods sold, thereby encompassing every operational aspect of a business. If so, the following costs are also examples of operating expenses:

  • Freight in & freight out
  • Direct materials
  • Direct labor
  • Benefits for production personnel
  • Utility costs for production facilities
  • Rent of production facilities
  • Property taxes on production facilities
  • Compensation for production personnel
  • Depreciation of production equipment and facilities
  • Repair of production equipment and facilities

 

*Accelerated Analytics publishes resources like this to provide insights to different analytical metrics, data points and formulas. POS Analytics. Please be aware, this doesn’t mean that our product will this metric, data point or formula. To learn exactly what our reporting covers, please feel free to schedule a demo or give us a call. Thanks for understanding.

Deducting Inventory Expenses

Deducting Inventory Expenses

Buying, making and storing inventory all cost your business money. The good news, the majority of your inventory-related expenses are deductible when it’s time to file your taxes. If you have the scenario where you can’t sell all of your inventory, you may be able to generate some additional deductions out of it by selling it at a low price or giving it away.

Let’s look at a few options you may have.

(1) Cost of Goods Sold

The money you spend buying raw materials or finished goods for your inventory is a business expense, along with the labor, shipping and overhead. Rather than deduct these expenses directly, you write them off as the cost of goods sold.

For example, if you start the year with $20,000 in inventory, spend $5,000 to get more and end the year with $8,000 in inventory, your cost is $25,000 less $8,000 — $17,000. That would be your deduction.

(2) Storage Space

If you’re storing inventory in your house, you can take a write-off for the business use of your home. For example, if you devote 20 percent of your house to storage, you can deduct 20 percent of your mortgage interest, utilities, property taxes and some of your other expenses. In order to claim this deduction, your home has to be your only place of business and where you use the storage space regularly.  Most business owners use an easy to follow formula;

  • Calculate $5/square foot

(3) Donations

If you’re having trouble selling inventory, you may want to consider donating it to charity. Your deduction is either the fair market value of the donation or the cost of the donated inventory, whichever one would be less.

If you’re a sole proprietor, you can’t write the donation off as a business expense. However, you can take it as a personal expense, you can itemize it on a Schedule A. The same rule would apply if your business is a partnership.

(4) Cheap

If you don’t have plans to donate your inventory, you could potentially sell it at a lost. The IRS does allows you to take a write-off for inventory that isn’t worth its full value, such as being damaged or if it’s an older model. You can’t just write it down, you would need evidence that it has less value now.

There’s a number of different ways you can do that;

  • Marking the price down
  • Claiming a loss when it doesn’t sell
  • Sell it at a discount to other companies

*Accelerated Analytics publishes resources like this to provide insights to different analytical metrics, data points and formulas. POS Analytics. Please be aware, this doesn’t mean that our product will this metric, data point or formula. To learn exactly what our reporting covers, please feel free to schedule a demo or give us a call. Thanks for understanding.

Closing Inventory: 3 Methods To Calculate It

Closing Inventory

Closing inventory, also referred to as ending inventory, refers to the amount of inventory a business has left on the shelves and in stock at the end of the accounting year. Closing inventory is counted in 2 different ways:

  • To reflect the physical amount of products left in stock
  • To reflect the monetary value of products left in stock

In these 2 cases, you’ll either have a number of units or dollars left to reflect.

Ending inventory is the value of the stock or product that remains at the end of an accounting period.

The ending inventory refers to the final value of products held by a company at the end of a financial period such as the accounting year.

Ending inventory is determined by the value of the beginning inventory, plus purchases less the cost of goods sold.

 

Estimating Closing Inventory

Now, if you can’t count inventory on hand at the end of an accounting period or you can assign values to products, there’s a few things you can do. There’s a wide range of situations that can cause this, like too much shipping activity at the end of the month to do a count. If your staff is pressed for time or you just don’t have anyone available, there are two methods you can use to estimate the closing inventory.

3 Methods To Calculate Closing Inventory

(1) The Gross Profit Method

To calculate closing inventory by the gross profit method, use these 3 steps:

  1. Add the cost of beginning inventory plus the cost of purchases during the time frame = the cost of goods available for sale.
  2. Multiply the expected gross profit percentage by sales during the time period = the estimated cost of goods sold.
  3. Subtract the number from Step 1 minus the number from Step 2 = ending inventory.

(2) The Retail Inventory Method

This approach is popular among retailers to calculate closing inventory.  It’s a little different from above, here’s the 4 steps to follow:

  1. Calculate Cost-To-Retail Percentage: Cost divided by retail price.
  2. Calculate Cost Of Goods Available For Sale: Cost of beginning inventory plus cost of purchases.
  3. Calculate Cost Of Sales During The Period: Sales x cost-to-retail percentage.
  4. Calculate Ending Inventory: Cost of goods available for sale minus cost of sales during the period.

(3) Physical Counting Method

If you need an accurate count of closing inventory, rather than an estimate, physically counting is the safest way to go. If you have the time and manpower, the simplest way to calculate ending inventory is the following 5 steps:

  1. Count the quantity of unsold products on the store’s shelves and stockroom.
  2. Determine the cost of each individual unit.
  3. Multiply the cost by the number of products.
  4. If you have different prices for products, you will need to multiply separately, then add all the amounts together.
  5. This will give you a dollar amount for your ending inventory.

How Ending Inventory Is Used

Your ending inventory will always be based on the market value or the lowest value of the goods that your company possesses. The cost of purchases made for the inventory is added to the value of the stock at the beginning of the selected period.

The market value of goods created or distributed by a company is generally higher than the associated costs. Despite that, it can change if the goods become outdated and experience depreciation and/or become obsolete.

In this case, the market value can fall below the cost of production for the goods, this would create a loss in asset value.

Why Ending Inventory Is Important

It’s a good idea to keep track of your inventory over the entirety of the fiscal year, but ending inventory is particularly important to calculate. Not only in order to ensure your actual stocks match with your sales and purchases over the course of the the accounting period, but also because this is often required in the case of an audit.

Whether your ending inventory matches with your financial transactions can indicate how well your business has stuck to its budget and can be useful for determining whether there are any glaring problems with production costs.

It is also important to a business because ending inventory carries over to the new accounting period. An inaccurate measure of stock value would then continue to have financial implications into the new accounting period.

*Accelerated Analytics publishes resources like this to provide insights to different analytical metrics, data points and formulas. POS Analytics. Please be aware, this doesn’t mean that our product will this metric, data point or formula. Thanks for understanding.