# excel sheet practice

Anonymous

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

(Top Tutor) Studypool Tutor
School: Duke University
Studypool has helped 1,244,100 students
flag Report DMCA

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