Question
In: Accounting
A B C D E F 1 Chapter 3: Applying Excel 2 3 Enter a formula...
|
A |
B |
C |
D |
E |
F |
||
| 1 | Chapter 3: Applying Excel | ||||||
| 2 | |||||||
| 3 | Enter a formula into each of the cells marked with a ? below | ||||||
| 4 | Review Problem: Activity-Based Costing | ||||||
| 5 | |||||||
| 6 | Data | ||||||
| 7 | Deluxe | Tourist | |||||
| 8 | Annual sales in units | 2,000 | 10,000 | ||||
| 9 | Direct materials per unit | $25 | $17 | ||||
| 10 | Direct labor-hours per unit | 5 | 4 | ||||
| 11 | |||||||
| 12 | Direct labor rate | $12 | per DLH | ||||
| 13 | |||||||
| 14 | Estimated | ||||||
| 15 | Overhead |
Expected Activity |
|||||
| 16 | Activities and Activity Measures | Cost | Deluxe | Tourist | Total | ||
| 17 | Labor related (direct labor-hours) | $ 80,000 | 10,000 | 40,000 | 50,000 | ||
| 18 | Machine setups (setups) | 150,000 | 3,000 | 2,000 | 5,000 | ||
| 19 | Production orders (orders) | 70,000 | 270 | 230 | 500 | ||
| 20 | General factory (machine-hours) | 250,000 | 12,000 | 28,000 | 40,000 | ||
| 21 |
$550,000 |
||||||
| 22 |
(a)
|
||||||
Solutions
Expert Solution
| CALCULATION OF UNIT COSTING AS PER ABC METHOD | ||||||||
| Particulars | Delux | Tourist | ||||||
| (2, 000 Units) | (10,000 Units) | |||||||
| Direct Material | $25 | $17 | ||||||
| Direct Labour | $60 | $48 | ||||||
| (5 Hrs X $ 12) | (4 Hrs X $ 12) | |||||||
| Overhead Cost: | ||||||||
| Labor related (direct labor-hours) | $8.0 | $6.4 | ||||||
| Machine setups (setups) | $45.0 | $6.0 | ||||||
| Production orders (orders) | $18.9 | $3.2 | ||||||
| General factory (machine-hours) | $37.5 | $17.5 | ||||||
| Total Cost Per unit | $194.4 | $98.1 | ||||||
| Calculation of the Cost Driver Rate Per Unit Per Product | ||||||||
| Total Activity of Delux | Rate of Activity | Total Activity | "/" By No. of Units | Rate Per unit | ||||
| Direct Labour Related = | $80,000 | 10000 | $1.6 | $16,000.0 | 2000 | $8.0 | ||
| Divide by | " / " | |||||||
| total Activity = | 50000 | Total Activity of Tourist | ||||||
| Activity Rate | $1.6 | 40000 | $1.6 | $64,000.0 | 10000 | $6.4 | ||
| Total Cost | $80,000.0 | |||||||
| Machiene Related = | $1,50,000.0 | Total Activity of Delux | Rate of Activity | Total Activity | "/" By No. of Units | Rate Per unit | ||
| Divide by | " / " | 3000 | $30.0 | $90,000.0 | 2000 | $45.0 | ||
| total Activity = | 5000 | |||||||
| Activity Rate | $30.00 | Total Activity of Tourist | ||||||
| 2000 | $30.0 | $60,000.0 | 10000 | $6.0 | ||||
| Total Cost | $1,50,000.0 | |||||||
| Production Orders = | $70,000.0 | Total Activity of Delux | Rate of Activity | Total Activity | "/" By No. of Units | Rate Per unit | ||
| Divide by | " / " | 270 | $140.0 | $37,800.0 | 2000 | $18.9 | ||
| total Activity = | 500 | |||||||
| Activity Rate | $140.00 | Total Activity of Tourist | ||||||
| 230 | $140.0 | $32,200.0 | 10000 | $3.2 | ||||
| Total Cost | $70,000.0 | |||||||
| General Factory Machiene - Hours | $2,50,000.0 | Total Activity of Delux | Rate of Activity | Total Activity | "/" By No. of Units | Rate Per unit | ||
| Divide by | " / " | 12000 | $6.3 | $75,000.0 | 2000 | $37.5 | ||
| total Activity = | 40000 | |||||||
| Activity Rate | $6.25 | Total Activity of Tourist | ||||||
| 28000 | $6.3 | $1,75,000.0 | 10000 | $17.5 | ||||
| Total Cost | $2,50,000.0 | |||||||
ekkarill92 answered 2 years agoRelated Solutions
A B C D E F 1 Chapter 3: Applying Excel 2 3 Enter a formula...
A
B
C
D
E
F
1
Chapter 3: Applying Excel
2
3
Enter a formula into each of the cells marked
with a ? below
4
Review Problem: Activity-Based Costing
5
6
Data
7
Deluxe
Tourist
8
Annual sales in units
2,000
10,000
9
Direct materials per unit
$25
$17
10
Direct labor-hours per unit
5
4
11
12
Direct labor rate
$12
per DLH
13
14
Estimated
15
Overhead
Expected Activity
16
Activities and Activity...
A B C D E F 1 Chapter 8: Applying Excel 2 3 Data 4 Exhibit...
A
B
C
D
E
F
1
Chapter 8: Applying Excel
2
3
Data
4
Exhibit 8-8: Standard Cost Card
5
Inputs
Standard
Quantity
Standard Price
6
Direct
materials
3.0
pounds
$4.00
7
Direct
labor
0.50
hours
$22.00
per
hour
8
Variable manufacturing overhead
0.50
hours
$6.00
per
hour
9
10
Actual
results:
11
Actual output
2,090
units
12
Actual variable manufacturing overhead
cost
$6,174
13
Actual Quantity
Actual price
14
Actual direct materials cost
6,115
pounds
$3.9
pounds...
Chapter 3: Applying Excel 2 3 Enter a formula into each of the cells marked with...
Chapter 3: Applying Excel
2
3
Enter a formula into each
of the cells marked with a ? below
4
Review Problem: Activity-Based Costing
5
6
Data
7
Deluxe
Tourist
8
Annual
sales in units
1,000
9,000
9
Direct
materials per unit
$33
$33
10
Direct
labor-hours per unit
1
1
11
12
Direct
labor rate
$17
per
DLH
13
14
Estimated
15
Overhead
Expected Activity
16
Activities and Activity Measures
Cost
Deluxe
Tourist
Total
17
Labor...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Selling price per...
A
B
C
D
1
Chapter 5: Applying Excel
2
3
Data
4
Selling
price per unit
$321
5
Manufacturing costs:
6
Variable per unit produced:
7
Direct materials
$141
8
Direct labor
$69
9
Variable manufacturing overhead
$40
10
Fixed manufacturing overhead per year
$127,600
11
Selling
and administrative expenses:
12
Variable per unit sold
$5
13
Fixed per year
$65,000
14
15
Year 1
Year 2
16
Units
in beginning inventory
0
17
Units
produced during the year...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 30,000...
A
B
C
D
1
Chapter 5: Applying Excel
2
3
Data
4
Unit sales
30,000
units
5
Selling price per unit
$70
per unit
6
Variable expenses per unit
$42
per unit
7
Fixed expenses
$420,000
8
If your formulas are correct, you should get the correct answers
to the following questions.
(a)
What is the break-even in dollar
sales?
(b)
What is the margin of safety percentage?
(c)
What is the degree of operating leverage? (Round...
A B C 1 Chapter 4: Applying Excel 2 3 Data 4 Beginning work in process...
A
B
C
1
Chapter 4: Applying Excel
2
3
Data
4
Beginning work in process inventory:
5
Units in process
200
6
Completion with respect to materials
10
%
7
Completion with respect to conversion
45
%
8
Costs in the beginning work in process
inventory:
9
Materials cost
$404
10
Conversion cost
$6,210
11
Units
started into production during the period
15,000
12
Costs
added to production during the period:
13
Materials cost
$245,921
14
Conversion cost
$996,935...
Six people (A, B, C, D, E, F) are lining up to enter a museum. (1)...
Six people (A, B, C, D, E, F) are lining up to enter a
museum.
(1) How many ways are there to line up the six people if A is
somewhere before B, although not necessarily immediately
before?
(2) How many ways are there to line up the six people if A is
next to C?
(3) How many ways are there to line up the six people if A must
be next to B but C and D can...
1. Processes A, B, C, D, E, and F require service times of 3, 5, 2,...
1. Processes A, B, C, D, E, and F require service times of 3, 5,
2, 5, 3, and 5. Their arrival times are 0, 1, 3, 9, 10, and 12.
What is the average turnaround time, waiting time, response time,
and throughput when using SRJF, RR (q=2), and MLF
(q=22i+1). Show your work.
1. Processes A, B, C, D, E, and F require service times of 3, 5, 2,...
1. Processes A, B, C, D, E, and F require service times of 3, 5,
2, 5, 3, and 5. Their arrival times are 0, 1, 3, 9, 10, and 12.
What is the average turnaround time, waiting time, response time,
and throughput when using SRJF, RR (q=2), and MLF
(q=22i+1). Show your work.
(a) (f ∘ g)(3) (b) g(f(2)) (c) g(f(5)) (d) (f ∘ g)(−3) (e) (g ∘ f)(−1) (f) f(g(−1))
(a) (f ∘ g)(3)
(b) g(f(2))
(c) g(f(5))
(d) (f ∘ g)(−3)
(e) (g ∘ f)(−1)
(f) f(g(−1))
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Discuss proactive and defensive marketing in context to the company position in the hypothetical market structure...
- Write a java code that could be used to show the simulation of a tornado. use...
- A Canadian company issues an 8-year term bond with face value of $1,000 and 6% coupon...
- 1. Consider the following nuclides: &
- In general, teams can be described three ways. Name and define each.
- JAVASCRIPT: Please create an array of student names and another array of student grades. - Create...
- Topic - Construction: Structural, loads, tension 1.) Explain why pure tension members are the most efficient...
ADVERTISEMENT