excel sheet practice

Anonymous
timer Asked: Nov 19th, 2016

Question description

Open the PDF file solution then convert it to an excel sheet you will find a given number and equation on the right hand you just need to plug the number that's given and do the equation to be appear as an equation when I point out to the number I have already did the first one to give you the idea hoe to start the work. it need to all in one spreadsheet.

find the attached of the excel sheet that I already started and the PDF file solution.

Micro Case 3 Actual Volume: Budget Volume: Variable Expense Factor: Volume Change Factor: Volume Adjustment Factor: Description -------------------------Salaries Vol. Adj. 240,000 300,000 0.60 (0.20) (0.12) Actual ----------------$314,000 ----------------$314,000 Hours Vol. Adj. 10,000 ----------------10,000 Labor Rate $31.40 A B C D E A B C D E Variance Budget (Unfavorable) --------------------------------$345,400 F $31,400 (41,448) G ($41,448) --------------------------------$303,952 H ($10,048) 11,000 I 1,000 (1,320) J (1,320) --------------------------------9,680 K (320) $31.40 L $0.00 Given in the problem Given in the problem Used determined (A - B) / B4 (C x D) F Given in the problem G (F x E) H (F +/- G) I Given in the problem J (I x E) K (I +/- J) L (F / I) or (H / K) Labor Rate Variance: $0 M ([Budget Labor Rate - Actual Rate] x Volume Adjusted Budgeted Hours) M ( (Budget L - Actual L) x Budget K) Efficiency Variance: ($10,048) N ([Volume Adjusted Budgeted Hours - Actual Hours] x Actual Labor Rate) N ( (Budget K - Actual K) x Actual L) Total Variance: ----------------($10,048) O O (Sum of M & N) -- most equal H
Micro Case 4 Actual Volume: Budget Volume: Variable Expense Factor: Volume Change Factor: Volume Adjustment Factor: Description -------------------------Salaries Vol. Adj. 21,000 20,000 0.00 0.05 0.00 Actual ----------------$228,800 ----------------$228,800 Hours Vol. Adj. Labor Rate 20,800 Budget ----------------$237,120 0 ----------------$237,120 ----------------20,800 19,760 0 ----------------19,760 $11.00 $12.00 A B C D E A B C D E Variance (Unfavorable) ----------------F $8,320 G $0 ----------------H $8,320 I J Given in the problem Given in the problem Used determined (A - B) / B4 (C x D) F Given in the problem G (F x E) H (F +/- G) I Given in the problem J (I x E) (1,040) 0 ----------------K (1,040) K (I +/- J) L L (F / I) or (H / K) $1.00 Labor Rate Variance: $19,760 M ([Budget Labor Rate - Actual Rate] x Volume Adjusted Budgeted Hours) M ( (Budget L - Actual L) x Budget K) Efficiency Variance: ($11,440) N ([Volume Adjusted Budgeted Hours - Actual Hours] x Actual Labor Rate) N ( (Budget K - Actual K) x Actual L) Total Variance: ----------------$8,320 O O (Sum of M & N) -- most equal H
Micro Case 5 9,900 9,000 100.0% 10.0% 10.0% Actual Volume Budgeted Volume Variable Expense Factor Volume Change Factor Volume Adjustment Factor Spending Supply Item Item A Item B Item C Item D Item E Item F Item G Item H Item I Item J Totals Actual Budget $7,920 $2,625 8,576 6,972 11,902 5,829 740 748 89,100 83,164 1,600 2,740 2,109 2,655 8,747 8,707 2,250 2,245 6,120 5,792 $139,064 $121,477 Variance (Unfav) ($5,295) (1,604) (6,073) 8 (5,936) 1,140 546 (40) (5) (328) ($17,587) Volume Adjust $263 697 583 75 8,316 274 266 871 225 579 $12,148 Usage Volume Adjusted Budget $2,888 7,669 6,412 823 91,480 3,014 2,921 9,578 2,470 6,371 $133,625 Volume Adjusted Variance ($5,033) (907) (5,490) 83 2,380 1,414 812 831 220 251 ($5,439) Actual 1,760 1,600 3,480 400 450 100 74 350 30 120 Budget 750 1,599 1,524 411 426 180 93 348 30 114 Variance (Unfav) (1,010) (1) (1,956) 11 (24) 80 19 (2) 0 (6) Volume Adjust 75 160 152 41 43 18 9 35 3 11 Unit Price Volume Adjusted Budget 825 1,759 1,676 452 469 198 102 383 33 125 Volume Adjusted Variance (935) 159 (1,804) 52 19 98 28 33 3 5 Actual $4.50 $5.36 $3.42 $1.85 $198.00 $16.00 $28.50 $24.99 $75.00 $51.00 Note: This spreadsheet looks different from the example used in the program because it stretches across the page while the one projected during the program had to be stacked vertically for reasons of legibility. Budget $3.50 $4.36 $3.82 $1.82 $195.22 $15.22 $28.55 $25.02 $74.83 $50.81 Variance Variance (Unfav) ($1.00) ($1.00) $0.40 ($0.03) ($2.78) ($0.78) $0.05 $0.03 ($0.17) ($0.19) Usage ($4,208) 852 (6,169) 96 3,683 1,568 807 820 225 275 ($2,050) Price ($825) (1,759) 678 (14) (1,302) (154) 5 11 (6) (24) ($3,389) Total ($5,033) (907) (5,490) 83 2,380 1,414 812 831 220 251 ($5,439)
Actual Volume: 240,000 Description Salaries Vol.Adj Budget Volume: Variable Expense Factor: Volume Change Factor: 300,000 0.6 -0.2 Actual Budget $314,000 $314,000 Hours Vol.Adj 10,000 10,000 Labor Rate Labor Rate Variance $31.40 Variance (Unfavorable) $345,400 $31,400 ($41,448) ($41,448) $303,952 ($10,048) 11,000 -1320 9,680 $31.40 1,000 -1320 -320 $0.00 Volume Adjustment Factor: -0.12

Tutor Answer

(Top Tutor) Studypool Tutor
School: Duke University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors