Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 revenueStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started