provide formula 1. Sundial Company has assigned $710,000 in total overhead cost to four different activity cost
Fantastic news! We've Found the answer you've been seeking!
Question:
provide formula
Transcribed Image Text:
1. Sundial Company has assigned $710,000 in total overhead cost to four different activity cost pools. The activity requirements for its two 2 products lines, Economy and Deluxe, are shown below. 3 45678c 9 20 21 A Input formulas to solve for the various unknowns in the table below. The formulas may vary for each cost pool depending on what items are known and unknown. 1 30 31 Assign indirect costs to products or services using activity based costing. Note: Use cell A2 from the given information to complete this question. 10 Activity Cost Pool 11 Material Handling 12 Machine Set-Ups 13 Engineering Support 14 Power and Space 15 Total overhead cost 16 17 Use formulas to assign overhead to each product using both activity rates and activity proportions (%). 18 19 Create if/then statements to verify that the two methods produce the same results. Note: Use cell A2 from the given information to complete this question. 22 23 Activity Cost Pool 24 Material Handling 25 Machine Set-Ups 26 Engineering Support 27 Power and Space 28 Total Overhead Cost 29 Activity Overhead Cost Cost Driver 5,000 S 300,000 $ 210.000 S 710,000 Material moves Set-ups Activity Rate per move per set-up Engineering hours $12.50 per hour 20,000 square feet. Overhead Assigned Using Activity Rates Economy Deluxe Total per square feet Economy Model Economy Activity Requirements by Product Line Activity Proportion (%) 2,000 300 2,000 Overhead Assigned Using Activity Proportions (%) Deluxe 20% 50% Total Deluxe Activity Model Proportion (%) 3,000 900 Verification: Create if/then statements to determine if the two methods produce identical results by indicating "pass" or "fail" Deluxe Economy pass pass pass pass pass pass pass pass pass pass Total pass pass pass pass pass M 1. Sundial Company has assigned $710,000 in total overhead cost to four different activity cost pools. The activity requirements for its two 2 products lines, Economy and Deluxe, are shown below. 3 45678c 9 20 21 A Input formulas to solve for the various unknowns in the table below. The formulas may vary for each cost pool depending on what items are known and unknown. 1 30 31 Assign indirect costs to products or services using activity based costing. Note: Use cell A2 from the given information to complete this question. 10 Activity Cost Pool 11 Material Handling 12 Machine Set-Ups 13 Engineering Support 14 Power and Space 15 Total overhead cost 16 17 Use formulas to assign overhead to each product using both activity rates and activity proportions (%). 18 19 Create if/then statements to verify that the two methods produce the same results. Note: Use cell A2 from the given information to complete this question. 22 23 Activity Cost Pool 24 Material Handling 25 Machine Set-Ups 26 Engineering Support 27 Power and Space 28 Total Overhead Cost 29 Activity Overhead Cost Cost Driver 5,000 S 300,000 $ 210.000 S 710,000 Material moves Set-ups Activity Rate per move per set-up Engineering hours $12.50 per hour 20,000 square feet. Overhead Assigned Using Activity Rates Economy Deluxe Total per square feet Economy Model Economy Activity Requirements by Product Line Activity Proportion (%) 2,000 300 2,000 Overhead Assigned Using Activity Proportions (%) Deluxe 20% 50% Total Deluxe Activity Model Proportion (%) 3,000 900 Verification: Create if/then statements to determine if the two methods produce identical results by indicating "pass" or "fail" Deluxe Economy pass pass pass pass pass pass pass pass pass pass Total pass pass pass pass pass M
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Provide a structural formula for the product from each of the following reactions. (a) (b) (c) (d) (e) (f) (1) LDA (2) CH,CH Br. CH,COH NaH Cl Br2 (excess), NaOH (1) LDA (3) H20 ), NaoH
-
Provide a structural formula for the product from each of the following reactions. (a) (b) (1) NaOCH, CH,OH (2)Br o o (3) HCI, H,O, heat OH heat HO
-
Provide a structural formula for each of the following compounds: (a) 2-Ethyl-1-butanamine (b) N-Ethyl-1-butanamine (c) Dibenzylamine (d) Tribenzylamine (e) Tetraethylammonium hydroxide (f)...
-
Find f. f(x) = f'(x) = 12x + X x > 0, f(1) = -4
-
Parkman Sporting Goods is preparing its annual report for its 2011 fiscal year. The company's controller has asked for your help in determining how best to disclose information about the following...
-
In Exercises 1215, find each indicated sum. 00 1=1 2 5 1-1
-
Analog tape players read sound recorded on magnetic tape. The sound is recorded by magnetizing the tape longitudinally (magnetization parallel to the tape's length) with varying magnetic field...
-
River Co. began the accounting period with a $132,000 debit balance in its Accounts Receivable account. During the accounting period, River Co. earned revenue on account of $180,000. The ending...
-
Which Python data structure is constructed using the code below? a = {"a": 1, "b": 2, "c": 3}
-
Natalie had a very busy December. At the end of the month, after journalizing and posting the December transactions and adjusting entries, Natalie prepared the following adjusted trial balance....
-
What is the net electric charge of this object? Note for advanced students: you can assume charge is measured in any convenient units, e.g. coulombs or units of e. Write down only the number part of...
-
Every family has that person who, although outgoing and friendly, just can't seem to keep stuff together. They are always on the verge of a big break, but incessantly wind up a day late and dollar...
-
The Scaled Agile Framework (SAFe) focuses on providing a knowledge base of patterns for scaling development work across all levels of the enterprise . Research this methodology. What are the core...
-
SportZ has invoices for materials purchased from Platinum Steel Incorporated. The invoices are for $4,242 due 60 days ago, $12,567 due in 30 days, and $18,451 due in 140 days. If SportZ pays all of...
-
Suppose a university wished to offer a certain course. The administration felt that the course might be more effective if taught with alternative teaching methods. Four different teaching approaches...
-
1. A dispute arose when the National Union of Hotel, Bar and Restaurant Workers representing the workers and the restaurant sought to have the hotel joined as a party in the Industrial Court. The...
-
FPJ Corp., a domestic corporation, engaged in the real estate business. It is the registered owner of a determinate land with improvements. XXX Corp., on the other hand, is a domestic corporation...
-
Assume Eq. 6-14 gives the drag force on a pilot plus ejection seat just after they are ejected from a plane traveling horizontally at 1300 km/h. Assume also that the mass of the seat is equal to the...
-
Indicate whether each of the items listed below would be included (I) in or excluded (E) from gross income for the 2012 tax year. ________a. Welfare payments ________b. Commissions ________c. Hobby...
-
Calculate the amount of the child and dependent care credit allowed for 2012 in each of the following cases, assuming the taxpayers had no income other than the stated amounts. a. William and Carla...
-
Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...
-
A. Identify a topic for a presentation. B. Write a positioning statement. C. Write a preview statement.
-
Identify a topic of interest. Create a storyboard to outline the titles, content, and related story line of your PowerPoint slides.
-
Create an electronic slide presentation for your topic of interest. Ensure that it conveys your key messages effectively.
Study smarter with the SolutionInn App