Tabellab

In-House Cost per Asset: Monthly Cost Pool, Hourly Cost of Design Time, Tools and Overhead Share and Cost by Format

Lesson 5 of 20 Lab 🔒 Locked

Lessons in this course

  1. Template Reuse Rate: Flagging Template-Based Assets, Counting with COUNTIF and COUNTIFS and the Reuse Rate per FormatLabFree
  2. Turnaround Time per Asset: Calendar and Working Days, SLA Lookups, On-Time Flags and the Average per FormatLab Locked
  3. Revision Rounds: Rounds per Asset, First-Pass Approval, Over-Scope Flags and the Average per Requesting TeamLab Locked
  4. Asset Library Coverage: Available vs Missing Assets by Format, Size and Collection, Overall Coverage and Gap FlagsLab Locked
  5. In-House Cost per Asset: Monthly Cost Pool, Hourly Cost of Design Time, Tools and Overhead Share and Cost by FormatLab Locked
  6. Freelance Cost per Asset: Expected Invoice, Rush Surcharge, Extra Rounds and the Average Cost per FormatLab Locked
  7. In-House vs Freelance: All-In Freelance Cost, Cheaper Option per Format, Weighted Blend and the Break-Even VolumeLab Locked
  8. Monthly Production Scorecard: Reuse Rate, Blended Cost per Asset, Freelance Share and a Trend ChartLab Locked
  9. Template Performance: Hours Saved per Asset, Rank by Uses, Top-3 Concentration and Payback of the Build HoursLab Locked
  10. Turnaround Distribution: Median, 80th Percentile, Share within the SLA and a Histogram ChartLab Locked
  11. Rush Requests: Lead Time, Rush Flags, the Rush Rate per Team and Highlighting with a Formula RuleLab Locked
  12. Causes of Revision Rounds: Hours Lost, Shares, a Cumulative Pareto Share and the Savings of a Better BriefLab Locked
  13. First-Pass Approval and Quality: Rates per Producer, Weighted Group Rates, Brand-Check Fails and a Highlight RuleLab Locked
  14. Library Coverage Weighted by Demand: Requests without an Asset, SUMPRODUCT Coverage, the Top Gap and a Bar ChartLab Locked
  15. Library Reuse Value: Cost per Use, Unused Assets, Money Tied Up and the Reuse ShareLab Locked
  16. Capacity and Overload: Weekly Capacity, Demand Hours, Utilisation, Overload Hours and a Demand ChartLab Locked
  17. Volume Forecast: Trend with SLOPE, FORECAST.LINEAR, Freelance Assets Needed above Capacity and the Freelance BudgetLab Locked
  18. Outsourcing What-If: Capacity Cut-Off, a Cost Grid with Mixed References, Cost per Asset and a Heat MapLab Locked
  19. Data Quality Checks: Duplicate IDs, Missing Formats, Reversed Dates, Impossible Rounds and a Clean-Row CountLab Locked
  20. Final Project: The Visual Production Scorecard with Reuse, Turnaround, Cost per Asset, a Chart and a Target FlagLab Locked