What is the Excel Formula for Margin Improvement?

D E F H Source of saving: Cost of deliver from Sch to Np per project Cost of deliver from Sch to Np per week Cost of deliver from Sch to Np per week for all teams Cost of deliver from Sch to Np in one year Gas to $17.23 $51.68 $51.68 $2377.19 A B 1 What We Knox from Alex 2 Value Note 3 Annual Revenuelyear $1,300,000 4 Schaumburg share of revenue 90.00% 5 Schaumburg Revenue $1,170,000 6 Naperville Revenue $130,000 7 projects per team 2.5 2-3 per week 8 size of each project $3,500 $3k-$4k 9 Weeks worked per year 46 10 number of teams in Schaumburg 2 11 Number of teams in Naperville 1 12 Painters per team 5 13 Hourly rate $22.00 14 Over Time hourly rate $40.00 15 Average over time hours per person 3 perueck 16 Delays in Finishing projects 35.00% 17 Source of saving: No late 18 delivery 19 Labor Cost of late paint deliveries 20 cost of late delivery per painter per week $120 21 cost of late delivery for all painters per week $1,800 22 cost of late delivery for one year $82,800 23 Labor savings from no late delivery $82,800 24 25 26 Source of saving: Fines 27 Fines paid for delayed projects $45,500 28 29 Source of saving: Marketing 30 Estimated Print Marketing expenditure $26,000 31 Annual Savings No late delivery Print Marketing Fines Gas to Naperville Total Savings Margin Improvement $82 800 $26 000 $45 500 $2377 $156 677 Assumptions - need to be Confirmed by Jesse Value Note Ave distance between Ben Moore and job sites in Schaumburg 0 miles Average price of driving a truok per mile 0.58 per mile Distance from Sch to Naperville 30 round trip miles Average project per week in Naperville 3 Total Marketing expenditure how much is print?) 2.00% X of annual revenue