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...
-
Using the data in Table 16.1, the Project Talent test score data: a. What kinds of preliminary data screening would you need to run to evaluate whether assumptions for factor analysis are reasonably...
-
At high temperatures, alkanes can undergo dehydrogenation to produce alkenes. For example: This reaction is used industrially to prepare ethylene while simultaneously serving as a source of hydrogen...
-
Describe under what circumstances patents are less likely to be effective.
-
Debra Menge started her own consulting firm, Menge Consulting, on May 1, 2014. The following transactions occurred during the month of May. May 1 Debra invested $7,000 cash in the business. 2 Paid...
-
What do Headquarters Flood Mitigation Assistance (FMA) and Pre-Disaster Mitigation (PDM) Coordinators need to enter into eGrants to control how long an application for a grant program is available to...
-
Brewsters Used Cars, Inc. employs several salespeople. Brewster, the owner of the company, has provided a file that contains sales records for each salesperson for the past month. Each record in the...
-
Taylor received a loan of $9,000 at 5.25% compounded quarterly. She had to make payments at the end of every quarter for a period of 1 year to settle the loan. a. Calculate the size of payments....
-
Expecting high returns, you decide to invest in the stock market. The returns will depend on various scenarios that may play out, and the two most important parameters are the growth rate of the...
-
The pressure at the eye of the impeller of a pump moving water at 120F is 2 psia. Will cavitation occur in this pump?
-
Water is being pumped through a pipe system at a temperature of 60C. Determine the maximum absolute pressure at the eye of the pumps impeller that would cause cavitation.
-
A pressure gauge attached to the suction port of a centrifugal pump indicates a pressure of 8 psig. The pump is being used to transport water at 70F. Atmospheric pressure is 14.696 psia. Will...
-
ITS Ltd is an electronics company which commenced business two decades earlier. It has an established product base and a set of loyal customers. The company is planning to introduce a new product...
-
List any four sauces that are most commonly preferred to serve with vegan dishes. Also provide the list of main ingredients used for preparing the sauce.
-
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?
-
The transient part of the solution arises from a. forcing function b. initial conditions c. bounding conditions
-
Fill in the Blank. The response of a linear system under any periodic force can be found by ___________ appropriate harmonic responses.
-
Find the steady-state response of the hydraulic control valve shown in Fig. 4.4 (a) to the forcing functions obtained by replacing \(x(t)\) with \(F(t)\) and \(A\) with \(F_{0}\) in Figs. 1.115....
Study smarter with the SolutionInn App