Question: What is the formula for margin improvement? It is supposed to be 12.05%. D E F H Source of saving: Cost of deliver from Sch

 What is the formula for margin improvement? It is supposed to

What is the formula for margin improvement? It is supposed to be 12.05%.

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 Schto Np per week for all teams Cost of deliver from Sch to Np in one year Gas to $17.23 $51.681 $51.681 $2377.19 A B 1 What We Knoy from Alex 2 Value Note 3 Annual Revenue/year $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 12.05% Assumptions - need to be Confirmed by Jesse Value Note Ave distance between Ben Moore and job sites in Schaumburg O miles Average price of driving a truck per mile 0.58 per mile Distance from Soh to Naperville 30 round trip miles Average project per week in Naperville 3 Total Marketing expenditure (how much is print?) 2.00% of annual revenue

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!