Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Walter decides it would be an acceptable use of Marjories time to let her run some cost analyses on three key aspect of his landscaping

Walter decides it would be an acceptable use of Marjories time to let her run some cost analyses on three key aspect of his landscaping jobs, equipment hours, number of large trees in the project, and direct labor. data is avaliable for the past 3 years, even though walter has never taken the time to run the analysis himself. Marjorie gathers the following data -

image text in transcribed

Specifcy the recommended model -

Y = ($ (BLANK) x Equipment hours) + ($ BLANK x DL hours) + $ BLANK

please fill in the blanks

\begin{tabular}{|c|c|c|c|c|c|} \hline Year & Month & Equipment Hours & Number of Large Trees & DL Hours & Landscaping Cost \\ \hline 1 & 1 & 120 & 10 & 500 & $18,000 \\ \hline 1 & 2 & 85 & 9 & 450 & 13,500 \\ \hline 1 & 3 & 105 & 8 & 300 & 8,250 \\ \hline 1 & 4 & 125 & 12 & 550 & 15,000 \\ \hline 1 & 5 & 90 & 5 & 475 & 11,250 \\ \hline 1 & 6 & 110 & 10 & 250 & 9,300 \\ \hline 1 & 7 & 135 & 8 & 400 & 11,250 \\ \hline 1 & 8 & 105 & 7 & 400 & 20,250 \\ \hline 1 & 9 & 145 & 10 & 225 & 14,250 \\ \hline 1 & 10 & 130 & 10 & 550 & 24,000 \\ \hline 1 & 11 & 150 & 13 & 625 & 21,000 \\ \hline 1 & 12 & 155 & 6 & 350 & 14,250 \\ \hline 2 & 1 & 85 & 8 & 460 & 19,800 \\ \hline 2 & 2 & 95 & 7 & 575 & 14,850 \\ \hline 2 & 3 & 115 & 9 & 310 & 9,075 \\ \hline 2 & 4 & 135 & 10 & 450 & 16,500 \\ \hline 2 & 5 & 100 & 6 & 485 & 12,375 \\ \hline 2 & 6 & 120 & 11 & 260 & 10,230 \\ \hline 2 & 7 & 145 & 9 & 410 & 12,375 \\ \hline 2 & 8 & 115 & 8 & 410 & 22,275 \\ \hline 2 & 9 & 105 & 11 & 235 & 15,675 \\ \hline 2 & 10 & 140 & 11 & 560 & 26,400 \\ \hline 2 & 11 & 100 & 12 & 635 & 23,100 \\ \hline 2 & 12 & 80 & 7 & 360 & 15,675 \\ \hline 3 & 1 & 242 & 9 & 600 & 24,010 \\ \hline 3 & 2 & 171 & 7 & 585 & 18,070 \\ \hline 3 & 3 & 103 & 10 & 320 & 13,800 \\ \hline 3 & 4 & 224 & 8 & 460 & 20,050 \\ \hline 3 & 5 & 124 & 7 & 285 & 15,100 \\ \hline 3 & 6 & 270 & 12 & 660 & 24,500 \\ \hline 3 & 7 & 114 & 5 & 240 & 18,500 \\ \hline 3 & 8 & 262 & 9 & 420 & 26,980 \\ \hline 3 & 9 & 257 & 12 & 245 & 19,060 \\ \hline 3 & 10 & 240 & 8 & 570 & 28,400 \\ \hline 3 & 11 & 180 & 7 & 645 & 27,970 \\ \hline 3 & 12 & 144 & 8 & 650 & 19,060 \\ \hline \end{tabular}

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

Portfolio Of Marketing Audits Company Self Assessment Audits

Authors: David Crosby

1st Edition

1902433157, 978-1902433158

More Books

Students also viewed these Accounting questions