Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Wiley CPAexcel Exam Review Focus Notes Auditing And Attestation 2022

Authors: Wiley

1st Edition

111984858X, 978-1119848585

More Books

Students also viewed these Accounting questions

Question

OSINT is used for cracking passwords

Answered: 1 week ago

Question

a valuing of personal and psychological privacy;

Answered: 1 week ago