Final Project: The Visual Production Scorecard with Reuse, Turnaround, Cost per Asset, a Chart and a Target Flag
Lessons in this course
- Template Reuse Rate: Flagging Template-Based Assets, Counting with COUNTIF and COUNTIFS and the Reuse Rate per FormatFree
- Turnaround Time per Asset: Calendar and Working Days, SLA Lookups, On-Time Flags and the Average per Format Locked
- Revision Rounds: Rounds per Asset, First-Pass Approval, Over-Scope Flags and the Average per Requesting Team Locked
- Asset Library Coverage: Available vs Missing Assets by Format, Size and Collection, Overall Coverage and Gap Flags Locked
- In-House Cost per Asset: Monthly Cost Pool, Hourly Cost of Design Time, Tools and Overhead Share and Cost by Format Locked
- Freelance Cost per Asset: Expected Invoice, Rush Surcharge, Extra Rounds and the Average Cost per Format Locked
- In-House vs Freelance: All-In Freelance Cost, Cheaper Option per Format, Weighted Blend and the Break-Even Volume Locked
- Monthly Production Scorecard: Reuse Rate, Blended Cost per Asset, Freelance Share and a Trend Chart Locked
- Template Performance: Hours Saved per Asset, Rank by Uses, Top-3 Concentration and Payback of the Build Hours Locked
- Turnaround Distribution: Median, 80th Percentile, Share within the SLA and a Histogram Chart Locked
- Rush Requests: Lead Time, Rush Flags, the Rush Rate per Team and Highlighting with a Formula Rule Locked
- Causes of Revision Rounds: Hours Lost, Shares, a Cumulative Pareto Share and the Savings of a Better Brief Locked
- First-Pass Approval and Quality: Rates per Producer, Weighted Group Rates, Brand-Check Fails and a Highlight Rule Locked
- Library Coverage Weighted by Demand: Requests without an Asset, SUMPRODUCT Coverage, the Top Gap and a Bar Chart Locked
- Library Reuse Value: Cost per Use, Unused Assets, Money Tied Up and the Reuse Share Locked
- Capacity and Overload: Weekly Capacity, Demand Hours, Utilisation, Overload Hours and a Demand Chart Locked
- Volume Forecast: Trend with SLOPE, FORECAST.LINEAR, Freelance Assets Needed above Capacity and the Freelance Budget Locked
- Outsourcing What-If: Capacity Cut-Off, a Cost Grid with Mixed References, Cost per Asset and a Heat Map Locked
- Data Quality Checks: Duplicate IDs, Missing Formats, Reversed Dates, Impossible Rounds and a Clean-Row Count Locked
- Final Project: The Visual Production Scorecard with Reuse, Turnaround, Cost per Asset, a Chart and a Target Flag Locked