Macro-free .xlsx
13-Week Cash Flow
Enter weekly receipts and payments. Adjust the downside collection rate to see when the cash buffer falls below target.
Download workbookExplore this workbookDownload editable Excel workbooks and try the formulas with sample data.
20 Excel templates, each with sample data, editable inputs, and a dashboard. Workbook tabs and labels are in Turkish.
Macro-free .xlsx
Enter weekly receipts and payments. Adjust the downside collection rate to see when the cash buffer falls below target.
Download workbookExplore this workbookMacro-free .xlsx
Combine weekly demand, lead time and committed stock to calculate when and how much to order. Pack size and minimum order quantity are both applied.
Download workbookExplore this workbookMacro-free .xlsx
Classify invoices and partial receipts by due date. Review outstanding balances, overdue days and follow-up exposure.
Download workbookExplore this workbookMacro-free .xlsx
Compare budget, actual spend, open commitments and remaining forecast by department.
Download workbookExplore this workbookMacro-free .xlsx
Compare planned and measured work-package completion. Use cost efficiency to forecast final project cost.
Download workbookExplore this workbookMacro-free .xlsx
Combine discounts, returns, commissions, logistics and advertising. Review unit contribution and the advertising break-even ceiling.
Download workbookExplore this workbookMacro-free .xlsx
Weight opportunity value by close probability. Review target gap, downside exposure and high-confidence deals.
Download workbookExplore this workbookMacro-free .xlsx
Convert demand to machine hours including setup time and scrap. Calculate remaining capacity shortfalls after overtime.
Download workbookExplore this workbookMacro-free .xlsx
Track calendar and meter-based intervals together. Prioritize due maintenance using the expected downtime cost.
Download workbookExplore this workbookMacro-free .xlsx
Compare suppliers on delivery, quality and price using adjustable weights. Review score and threshold attainment together.
Download workbookExplore this workbookMacro-free .xlsx
Track day, peak and night usage separately. Estimate energy costs, excess demand charges and potential savings from load shifting.
Download workbookExplore this workbookMacro-free .xlsx
Record overnight shifts, breaks and staffing demand. Identify uncovered labor hours and estimated labor costs.
Download workbookExplore this workbookMacro-free .xlsx
Track partial shipments against promised dates. Measure on-time-in-full delivery and outstanding overdue units.
Download workbookExplore this workbookMacro-free .xlsx
Include discounts, sales fees and fixed overhead in your pricing. Calculate the list price required for the margin target and your break-even volume.
Download workbookExplore this workbookMacro-free .xlsx
Track first-pass yield, scrap and rework. Compare the cost of poor quality across manufacturing batches.
Download workbookExplore this workbookMacro-free .xlsx
Reconcile opening recurring revenue with new, expansion, contraction and churn movements. Measure monthly net and gross revenue retention.
Download workbookExplore this workbookMacro-free .xlsx
Compare quotes in different currencies on a common basis. Include freight, exchange-rate stress, customs and local costs.
Download workbookExplore this workbookMacro-free .xlsx
Calculate chargeable weight using actual and dimensional weight. Include the fuel surcharge, minimum freight and service fees.
Download workbookExplore this workbookMacro-free .xlsx
Record opening, first response and resolution times. Monitor priority-specific response and resolution breaches, including open tickets.
Download workbookExplore this workbookMacro-free .xlsx
Adjust principal, nominal annual rate and term. Compare total interest and payoff timing before and after regular extra principal payments.
Download workbookExplore this workbookMacro-free .xlsx
Plan weekly shifts for up to 12 employees. Set shift times and unpaid breaks, then see employee and team totals. The workbook includes blank plans and completed examples in English and Turkish.
Download the weekly shift plannerExplore this workbookMacro-free .xlsx
Change the start, end, and break values to calculate net time. The workbook includes English and Turkish worksheets.
Download Excel workbookExplore this workbookMacro-free .xlsx
Compare planned and actual hours by employee and site. Allocate shifts and breaks across month boundaries.
Download workbookExplore this workbookMacro-free .xlsx
Find inventory position from on-hand, inbound and reserved quantities. Compare the reorder point with the proposed full-case quantity.
Download workbookExplore this workbookMacro-free .xlsx
Link invoices to partial payments. See open and overdue balances as of the selected date.
Download workbookExplore this workbookMacro-free .xlsx
Clean employee IDs without losing leading zeros. Match names and sites to the master list and find missing or duplicate records.
Download workbookExplore this workbook