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 |
|||||
| (a) |
(a)What is the traditional unit product cost for the Deluxe model after this change?
|
Solutions
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
- 4. Why did the United States and the Soviet Union find themselves in a “Cold War”...
- The Facts: Ann and Bill decided to start a coffee shop. They agreed Bill would provide...
- MARGI sells different types of wine. Customers place orders to the most popular “Summer Wine” at...
- A firm's bonds have a maturity of 8 years with a $1,000 face value, have an...
- Naive reasoning suggests that a string theory vacuum with cosmological constant Lambda1 is always unstable as...
- I. Design and code a class Rectangle that has the following properties: Two private members double...
- A bond has a $1,000 par value, 10 years to maturity, and an 8% annual coupon...
ADVERTISEMENT