Need It Back Within 2 Hrs Part 3 On 7.18; All Of 7.34; Part 5 And 6 Of 9.29 In Attached Sheet

profilehwhlp9
HareE_BUSI555-31.xlsx
Home>Business & Finance homework help>Accounting homework help>Need It Back Within 2 Hrs Part 3 On 7.18; All Of 7.34; Part 5 And 6 Of 9.29 In Attached Sheet

Grade Rubric

Point University
BUSI 555 Cost Management & Decision Making
Week 3 Excel Assignment
Chapters 6, 7 & 9
Exercise or Problem Points Points Earned Comments
6.11 5

Dr. Paz: Instructor will enter points earned here		 6.16 5
7.18 5
7.19 5
7.34 15
9.29 15
50 0 0%

Ex 6-11

Exercise 6.11 Name:
1. Select the appropriate accounts from the drop-down menus in the shaded cells in columns B and C.
Enter the appropriate amounts in the shaded cells in columns I and J.
Journal Entries
Work in Process—Encapsulating 64,800 Finished Goods
Work in Process—Mixing 64,800 Work in Process—Bottling
Work in Process—Encapsulating
Work in Process—Bottling 126,000 Work in Process—Mixing
Work in Process—Encapsulating 126,000
Finished Goods 194,400
Work in Process—Bottling 194,400
2. Enter the appropriate amounts in the shaded cells in columns C, D, F, G, I, J, and L.
T-accounts
WIP—Mixing WIP—Encapsulating WIP—Bottling Finished Goods
86,400 64,800 64,800 126,000 126,000 194,400 194,400
79,200 72,000
21,600 18,000 3,600 194,400

Ex 6.16

Exercise 6.16 Name:
Enter the appropriate amounts in the shaded cells in column K.
1. Physical Flow Schedule Units
Units to account for:
Units, beginning work in process 80,000
Units started 95,000
Units to account for 175,000
Units accounted for:
Units completed and transferred out:
Started and completed 78,000
From beginning work in process 80,000
Units in ending work in process 17,000
Total units accounted for 175,000
Enter the appropriate amounts in the shaded cells in columns E, G, I, and K.
2. Equivalent Units - Weighted Average Method Materials Conversion
Units completed 158,000 158,000
Units, ending work in process: Percent
Materials 17,000 x 100% 17,000
Conversion 17,000 x 25% 4,250
Equivalent units of output 175,000 162,250
3. Equivalent Units - FIFO Method Materials Conversion
Units started and completed 78,000 78,000
Units, beginning work in process: Percent
Materials 80,000 x 0% 0
Conversion 80,000 x 70% 56,000
Units, ending work in process:
Materials 17,000 x 100% 17,000
Conversion 17,000 x 25% 4,250
Equivalent units of output 95,000 138,250

Ex 7.18

Exercise 7.18 Name:
Enter the appropriate amounts in the gray-shaded cells. The essay answers will not be graded.
1. Cost Driver Information Dept. A Dept B. Total
Year 1
Actual direct labor hours 24,000 36,000 60,000 24000 36000
Cost allocation ratios 40% 60% 100%
Year 2
Actual direct labor hours 25,000 25,000 50,000 25000 25000
Cost allocation ratios 50% 50% 100%
Allocation Human Resources Department Producing Departments
Year 1 Dept. A Dept B. Total
Actual Human Resources Costs $ 120,000 120000
Allocation to producing departments
Dept. A $ 120,000 x 40% $ 48,000 0.4
Dept. B $ 120,000 x 60% $ 72,000 0.6
Total $ 48,000 $ 72,000 $ 120,000
Allocation Human Resources Department Producing Departments
Year 2 Dept. A Dept B. Total
Actual Human Resources Costs $ 120,000 120000
Allocation to producing departments
Dept. A $ 120,000 x 50% $ 60,000 0.5
Dept. B $ 120,000 x 50% $ 60,000 0.5
Total $ 60,000 $ 60,000 $ 120,000
2.
The manager of department B is not controlling HR cost better than manager of department a. Department A alocation of HR costs increased because the usage of department B has been decreased.
3.
[Key essay answer here]

Prob 7.34

Problem 7.34 Name:
Enter the appropriate amounts in the gray-shaded cells or select from the drop-down list. Essay answers will not be graded.
1. Allocation Ratios for Fixed Costs
SLC Reno Portland Total
Hours of flight time 2,000 4,000 2,000 8,000 2000 4000 2000
25.00% 50.00% 25.00% 100.00%
No. of passengers 10,000 15,000 5,000 30,000 10000 15000 5000
33.33% 50.00% 16.67% 100.00%
Variable rates: Maintenance Baggage
Expected cost Wrong $240,000 = Wrong $150,000 = 30000 64000
Activity level 8000 30000
Allocation Based on Budgeted Activity
SLC Reno Portland
Maintenance—fixed:
Cost: $240,000 240000
Ratio: 0.25 0.5 0.25
Maintenance—var.:
Rate: $7,500.00 Wrong 3.75
Flight hrs. 2000 4000 2000
Baggage—fixed:
Cost: $50,000 Wrong 150000
Ratio: 0.3333 0.5 0.1667
Baggage—var.:
Rate: 2.1333
Passengers 10000 15000 5000
2. Allocation Based on Actual Activity
SLC Reno Portland
Maintenance—fixed:
Cost: $235,000 Wrong 240000
Ratio: 0.25 0.5 0.25
Maintenance—var.:
Rate: 3.75
Flight hrs. 1800 4200 2500
Baggage—fixed:
Cost: $156,000 Wrong 150000
Ratio: 0.3333 0.5 0.1667
Baggage—var.:
Rate: 2.1333
Passengers 8000 16000 6000
Do any costs remain in the two support departments? Yes
[Key essay answer here]

Ex 7.19

Exercise 7.19 Name:
Enter the appropriate amounts in the shaded cells in columns J and L.
Cost Driver Information Dept. A Dept B. Total
Year 1
Expected direct labor hours 20,000 20,000 40,000 20000 20000
Fixed cost allocation ratios 50% 50% 100%
Year 2
Expected direct labor hours 20,000 20,000 40,000 20000 20000
Fixed cost allocation ratios 50% 50% 100%
Enter the appropriate amounts in the shaded cells in columns F and H.
1. Product Costing Allocation Human Resources Dept. Producing Departments
Year 1 Dept. A Dept B. Total
Allocation to producing departments
Variable costs:
Dept. A 20,000 dlh x $ 0.25 $ 5,000 20000 0.25
Dept. B 20,000 dlh x $ 0.25 $ 5,000 20000 0.25
Fixed costs:
Dept. A $ 100,000 x 50% $ 50,000 100000 0.5
Dept. B $ 100,000 x 50% $ 50,000 100000 0.5
Total $ 55,000 $ 55,000 $ 110,000
Product Costing Allocation Human Resources Dept. Producing Departments
Year 2 Dept. A Dept B. Total
Allocation to producing departments
Variable costs:
Dept. A 20,000 dlh x $ 0.25 $ 5,000 20000 0.25
Dept. B 20,000 dlh x $ 0.25 $ 5,000 20000 0.25
Fixed costs:
Dept. A $ 100,000 x 50% $ 50,000 100000 0.5
Dept. B $ 100,000 x 50% $ 50,000 100000 0.5
Total $ 55,000 $ 55,000 $ 110,000
2. Performance Evaluation Allocation Human Resources Dept. Producing Departments
Year 1 Dept. A Dept B. Total
Allocation to producing departments
Variable costs:
Dept. A 24,000 dlh x $ 0.25 $ 6,000 24000 0.25
Dept. B 36,000 dlh x $ 0.25 $ 9,000 36000 0.25
Fixed costs:
Dept. A $ 100,000 x 50% $ 50,000 100000 0.5
Dept. B $ 100,000 x 50% $ 50,000 100000 0.5
Total $ 56,000 $ 59,000 $ 115,000
Performance Evaluation Allocation Human Resources Dept. Producing Departments
Year 2 Dept. A Dept B. Total
Allocation to producing departments
Variable costs:
Dept. A 25,000 dlh x $ 0.25 $ 6,250 25000 0.25
Dept. B 25,000 dlh x $ 0.25 $ 6,250 25000 0.25
Fixed costs:
Dept. A $ 100,000 x 50% $ 50,000 100000 0.5
Dept. B $ 100,000 x 50% $ 50,000 100000 0.5
Total $ 56,250 $ 56,250 $ 112,500

Prob 9.29

Problem 9.29 Name:
Enter the appropriate amounts in the gray-shaded cells or select from the drop-down lists.
1. Overhead Rates
Standard fixed overhead rate = Budgeted fixed overhead
Projected volume x Hours per unit
= $770,000 770000
100,000 x 2 100000 2
= $3.85 per DLH
Standard variable overhead rate = Budgeted variable overhead
Projected volume x Hours per unit
= $444,000 444000
100,000 x 2 100000 2
= $2.22 per DLH
2. Applied Overhead
Applied fixed overhead = Units produced x DLR/unit x Fixed OH rate
= 97,000 x 2 x $3.85 97000 2 3.85
= $746,900
Applied variable overhead = Units produced x DLR/unit x Fixed OH rate
= 97,000 x 2 x $2.22 97000 2 2.22
= $430,680
Total fixed overhead variance = Actual fixed OH − Applied fixed OH
= $780,000 − $746,900 780000 746900
= $33,100 Underapplied Underapplied
Total variable overhead variance = Actual variable OH − Applied variable OH
= $435,600 − $430,680 435600 430680
= $4,920 Underapplied Underapplied
3. Fixed Overhead Variances:
Actual Fixed Overhead DH x SFOR SH x SFOR
200,000 x $3.85 (23,100) x $3.85 200000 194000 3.85
-$10,000 $770,000 780000
Spending Volume
4. Variable Overhead Variances:
Actual Variable Overhead AH x SVOR SH x SVOR
196,000 x $ 2.22 (4,440) x $ 2.22 196000 194000 2.22
$ (480) $ 435,120 435600
Spending Efficiency
5. Three-Variance Analysis
Volume variance: $22,407 U 23100 U
Wrong
Variable OH efficiency variance: -$4,440 U 4440 U
Wrong
Spending variance: -$10,480 U 10480 U
Wrong
6. Journal Entries Debit Credit
Work in Process 1,177,580 1177580 Cost of Goods Sold
Fixed Overhead Control Wrong 430,680 746,900 Fixed Overhead Control
Variable Overhead Control Wrong 746,900 430,680 Fixed Overhead Spending Variance
Fixed Overhead Volume Variance
Wrong 435,600 780,000 Miscellaneous Accounts
435,600 Variable Overhead Control
1215600 Variable Overhead Efficiency Variance
Variable Overhead Spending Variance
23,100 Work in Process
10,000
4,440
480
33100
4920
38020
23,100
10,000
4,440
480