After entering formulas in all of the cells that contained question marks, verify that the calculated numbers
Fantastic news! We've Found the answer you've been seeking!
Question:
After entering formulas in all of the cells that contained question marks, verify that the calculated numbers match the numbers in the Review Problem.
Check your worksheet by reducing the direct labor-hours for the Deluxe model in cell B10 from 5 to 2. The Deluxe model's unit product cost under traditional costing should now be $74.00 and the ABC unit product cost should be $143.89. If you do not get these results, fmd the errors in your worksheet and correct them.
Transcribed Image Text:
1 Chapter 4: Applying Excel Enter a formula into each of the cells marked with a ? below Review Problem: Activity-Based Costing 6 Data Deluxe 2,000 $25 7. 8 Annual sales in units 9 Direct materials per unit LO Direct labor-hours per unit 11 12 Direct labor rate 13 14 15 16 Activities and Activity Measures 17 Labor related (direct labor-hours) 18 Machine setups (setups) 19 Production orders (orders) 20 General factory (machine-hours) 21 Tourist 10,000 $17 4 $12 per DLH Estimated Overhead Expected Activity Tourist Cost Deluxe Total 2$ 150,000 70,000 80.000 ? 3,000 2,000 ?. 100 300 250,000 ? 12,000 28,000 22 Compute the predetermined overhead rate Estimated total manufacturing overhead (a) 25 Estimated total amount of the allocation base (b) 26 Predetermined overhead rate (a) + (b) 27 28 Compute the manufacturing overhead applied 29 Direct labor-hours per unit (a) 30 Predetermined overhead rate (b) 31 Manufacturing overhead applied per unit (a) x (b) 32 33 Compute traditional unit product costs 34 Direct materials 35 Direct labor 36 Manufacturing overhead applied 37 Traditonal unit product cost ? ? DLHS ? per DLH Deluxe Tourist ? DLHS ? per DLH ? DLHS ? per DLH ? Deluxe Tourist ? ? ? 38 39 Compute activity rates Estimated Overhead 31 Activities 12 Labor related 13 Machine setups 14 Production orders 15 General factory Total Expected Activity ? DLHS ? setups ? orders Cost Activity Rate ? per DLH ? per setup ? per order ? per MH ? ? MHs 17 Compute the ABC overhead cost per unit 18 19 Activities s0 Labor related 51 Machine setups 52 Production orders 53 General factory 54 Total overhead cost assigned (a) 55 Number of units produced (b) 56 ABC overhead cost per unit (a) + (b) 57 58 Compute the ABC unit product costs 59 Direct materials 50 Direct labor 51 ABC overhead cost per unit (see above) 52 ABC unit product cost 53 54 55 56 57 Deluxe Expected Tourist Expected Activity Rate Activity Amount Activity Amount ? ? ? ? ? Deluxe Tourist ? ? ? 1 Chapter 4: Applying Excel Enter a formula into each of the cells marked with a ? below Review Problem: Activity-Based Costing 6 Data Deluxe 2,000 $25 7. 8 Annual sales in units 9 Direct materials per unit LO Direct labor-hours per unit 11 12 Direct labor rate 13 14 15 16 Activities and Activity Measures 17 Labor related (direct labor-hours) 18 Machine setups (setups) 19 Production orders (orders) 20 General factory (machine-hours) 21 Tourist 10,000 $17 4 $12 per DLH Estimated Overhead Expected Activity Tourist Cost Deluxe Total 2$ 150,000 70,000 80.000 ? 3,000 2,000 ?. 100 300 250,000 ? 12,000 28,000 22 Compute the predetermined overhead rate Estimated total manufacturing overhead (a) 25 Estimated total amount of the allocation base (b) 26 Predetermined overhead rate (a) + (b) 27 28 Compute the manufacturing overhead applied 29 Direct labor-hours per unit (a) 30 Predetermined overhead rate (b) 31 Manufacturing overhead applied per unit (a) x (b) 32 33 Compute traditional unit product costs 34 Direct materials 35 Direct labor 36 Manufacturing overhead applied 37 Traditonal unit product cost ? ? DLHS ? per DLH Deluxe Tourist ? DLHS ? per DLH ? DLHS ? per DLH ? Deluxe Tourist ? ? ? 38 39 Compute activity rates Estimated Overhead 31 Activities 12 Labor related 13 Machine setups 14 Production orders 15 General factory Total Expected Activity ? DLHS ? setups ? orders Cost Activity Rate ? per DLH ? per setup ? per order ? per MH ? ? MHs 17 Compute the ABC overhead cost per unit 18 19 Activities s0 Labor related 51 Machine setups 52 Production orders 53 General factory 54 Total overhead cost assigned (a) 55 Number of units produced (b) 56 ABC overhead cost per unit (a) + (b) 57 58 Compute the ABC unit product costs 59 Direct materials 50 Direct labor 51 ABC overhead cost per unit (see above) 52 ABC unit product cost 53 54 55 56 57 Deluxe Expected Tourist Expected Activity Rate Activity Amount Activity Amount ? ? ? ? ? Deluxe Tourist ? ? ?
Expert Answer:
Answer rating: 100% (QA)
Required solution Data Deluxe Tourist Annual Sales in unit 2000 10000 Direct material per unit 25 17 Direct labor hours per unit 5 4 Direct labour rate 12 per DLH Estimated Overhead Expected Activity ... View the full answer
Related Book For
University Physics with Modern Physics
ISBN: 978-0133977981
14th edition
Authors: Hugh D. Young, Roger A. Freedman
Posted Date:
Students also viewed these accounting questions
-
The Butch Holdings company will pay you $8000 at the end of each year for the next 15 years into an account paying 5% interest. If the first payment is received a year from today, what is the present...
-
You throw a baseball straight upward. If you do not ignore air resistance, how does the time required for the ball to reach its maximum height compare to the time required for it to fall from its...
-
If you do not agree with the above analysis, why not?
-
Sally works as a welder at Heavy Iron Works Company. She is the only female welder in a shop with ten male welders. Teddy is the manager of that shop with Sally and the ten male welders. Sally is...
-
The absolute pressure in a tank is 85 kPa and the local ambient absolute pressure is 97 kPa. If a U-tube with mercury, density 13550 kg/m3, is attached to the tank to measure the vacuum, what column...
-
Helium gas expands from 125 kPa, 350 K and 0.25 m3 to 100 kPa in a polytropic process with n = 1.667. How much heat transfer is involved?
-
Redesign the fractionator of Example 6.8 using a random packing. The column is to be packed with 50-mm metal Pall rings. Determine the diameter of the tower, the height of packing in the stripping...
-
Segmented Reporting Cineplex Corporation is a diversified company that operates in five different industries: A, B, C, D, and E. The following information relating to each segment is available for...
-
Tina is aware that thousands of children starve to death every day, but only after reading a story about a single starving child did she decide to donate money to a charitable organization. Tina's...
-
The isotope technetium-99m is used by doctors to image the skeleton and heart muscles. Fol- lowing injection, the concentration of this isotope decays exponentially in the body. a. Let N(t) represent...
-
Which statement is correct? (A) Glucagon is released from the muscles. (B) Glucagon releases glucose from stores. (C) Glucagon lowers blood glucose.
-
The data in the following table relates to measurements made of the period of oscillation T of a simple pendulum of variable length L. Theory predicts the following relationship: T = 2 (1) where g is...
-
In everyday life, a stress response is designed to give a quick burst of alertness and energy needed to enhance performance. But stress is not good for a long period of time. When activated for too...
-
A 12 kg block is initially moving on a smooth surface with a constant speed of 6.00 m/s until it encounters a rough floor. It then slides 14.0 m before it finally comes to rest. Determine the...
-
When a block slides to a stop along a rough surface, it clearly had Momentum while it was moving, and yet has none while it is stopped. Where did that momentum go? Explain.
-
READ: KPJ Healthcare: the first 30 years Zizah CheSenik,Rosmah MatIsa,NorehaHalid,AdlinMasood,Soo-WahLow,Khairul AkmaliahAdham Publication date: 10 October 2013 Issue publication date: 10 October...
-
Discuss the sinusoidal functional form in the LC circuit. Explain how the capacitor charge and inductor current change following a sinusoidal function.
-
Given the table below, about how much force does the rocket engine exert on the 4.0 kg payload? Distance traveled with rocket engine firing (m) Payload final velocity (m/s) 500 320 490 310 1020 450...
-
A metal wire of diameter D stretches by 0.100 mm when supporting a weight W. If the same-length wire is used to support a weight three times as heavy, what would its diameter have to be (in terms of...
-
Your electronics company has several identical capacitors with capacitance C 1 and several others with capacitance C 2 . You must determine the values of C 1 and C 2 but dont have access to C 1 and C...
-
In a Hall-effect experiment, is it possible that no transverse potential difference will be observed? Under what circumstances might this happen?
-
Evaluate \(\mathbf{T} e^{x}\) for the transformation \(\mathbf{T} x=-x\).
-
Show that the real integers \(1,2, \ldots\) do not form a group under the operation of multiplication.
-
Write a product table for the 4-fold rotations of a square about its geometric center. Is this a cyclic group? E: rotate by 0 A: rotate by 90 B: rotate by 180 C: rotate by 270
Study smarter with the SolutionInn App