AOS Financial Calculator

HOW TO USE
1. Plug in salary fields (fill in one and the rest are automatically calculated).
2. Plug in a percentage representing benefit costs per employee; make sure to click the "Add Benefits" button.
3. Plug in the time estimate for each ad category; include time for communications and interaction.
4. Plug in rates for each ad category.
5. Plug in weekly volume totals for each ad category.
6. Click on "Calculate" button here ------->

SALARY CALCULATOR
Annual Monthly Weekly Daily Hourly Minute
Enter amount in any field; other fields will recalculate automatically when you tab to the next cell.  Enter percentage to add for benefits; salary cells automatically update when you click "Add Benefits" button.
%
DESIGNERS REQUIRED PER WEEK
Simple Normal Advanced Complex D-Truck Legals
Total: • 1 Designer = 40 hrs. (per week)
• Designers Required = ((Ad Composition Minutes x Ad Volume)/60)/40
MINUTES PER AD
Simple Normal Advanced Complex D-Truck Legals
Avg. Time: Enter estimated number of minutes necessary to make up ads in each category, including time necessary for interaction and communication. Average time will be calculated when you click "Calculate" below.
WEEKLY LABOR COST
Simple Normal Advanced Complex D-Truck Legals
Total Labor: • Weekly Labor Cost = Designers x Weekly Salary
AD COMPOSITION RATES
Simple Normal Advanced Complex D-Truck Legals
Avg. Rate: Enter rates for various complexity categories. To calculate an average rate, click the "Calculate" button below.
COST PER AD
Simple Normal Advanced Complex D-Truck Legals
Avg. Cost: Cost Per Ad = Weekly Labor Cost / Ad Volume
WEEKLY AD VOLUME
Simple Normal Advanced Complex D-Truck Legals
Total Volume: Enter the number of ads, potential or actual, that were produced in a given week in each complexity category.  Total volume of all ads, regardless of complexity, is calculated when you click the "Calculate" button below.
WEEKLY REVENUE
Simple Normal Advanced Complex D-Truck Legals
Total Rev.: • Ad composition rates x Weekly ad volume = Weekly revenue total
• Total Weekly Revenue = Sum of Weekly Revenue in each complexity category
 
WEEKLY NET
Simple Normal Advanced Complex D-Truck Legals
Total Net: • Weekly Net Revenue = Weekly Revenue – Weekly Labor Cost
MARGIN PER AD
Simple Normal Advanced Complex D-Truck Legals
Avg. Margin: • Total Margin = (Ad Composition Rate – Cost Per Ad) / Ad Composition Rate