Michael Motkowski Email & Phone Number

San Antonio, Tx, Us

San Antonio, Texas, United States

Created financial processes that included fixed asset management, plant conversion and fixed costs reporting, accounting procedures and guidelines, and INFOR LN implementation.Implemented a Days of Supply reporting model which broke out the highest surplus parts in order to guide operations in improving working capital by $2.0M.Built SQL based reporting models by creating custom queries within the ERP Datalake to create PowerBI visualizations for management reporting related to total truck conversion and fixed costs, labor efficiency metrics, and plant scrap.Effectively managed financial closing within two business days by reducing reporting timing, consolidating multiple journal entries, and assisting in system remediations to minimize the number of manual entries.Managed three direct reports by delegating tasks such as remediating accounts payable issues, updatingmanagerial reporting for the plant controller and director, and coaching on presentation and data analytics skills such as SQL reporting and Excel data modeling/ forecasting.Updated annual standards costing based off truck material, freight, variable, fixed, and direct overhead costs.Updated monthly forecasts related to total plant labor costs, indirect material consumption, services, utilities, depreciation, and program start up expense and compared versus actuals and budget monthly to assist operations in understanding how to improve costs performance.

Lisle, Il

Created a labor cost model that assisted management in union negotiations between multiple plants by providing the team with cost metrics related to incremental wages, benefits, and other incentives which resulted in a total cost per unit mitigation of $300 per unit.Built a discounted cash flow model related to the construction of a new manufacturing plant by obtaining data related to capital investment, labor, logistics, and material costs savings that had a positive NPV of $150M which resulted in board approval.Managed a $300 million capital budget for a new manufacturing greenfield facility through maintaining a tracking model and dashboard, effectively communicating actuals versus forecasted spend, and automating processes within the PeopleSoft accounting system to ensure capital and expense is reconciled to the ledger for completeness and accuracy.Generated a conversion cost reporting model that assisted management in determining which cost categories needed to be prioritized to drive cost savings between all four plants.Built an outbound logistics destination reporting model within Tableau which improved forecast accuracy by 80%.

Lisle, Il

Assisted in the remediation of the sales return accrual through redesigning the accrual template, creating process flow maps, participating in various audit meetings to ensure compliance, and compiling historical data for the SAB99 restatement template.Facilitated the conversion of SOX narratives into process maps which helped the parts team and other external parties in understanding the routine accounting procedures and the risks and controls associated with them.Enhanced efficiencies within the parts accounting group by consolidating various journal entries and account reconciliations which reduced close from four to three business days.

Lisle, Il

Assisted with month end close by completing various journal entries, reconciliations, and ad-hoc requests.Maintained and updated a biweekly order board which assisted the team in calculating how many units each customer had on order and if there were any special accounting treatments associated with the contract.Collaborated cross functionally between other departments throughout the company to develop leaseaccounting procedures to ensure revenue recognition compliance.