Using the excel spreadsheet provided, prepare the calculations. FilePaste16HomeX CutCopyFormat PainterClipboardV:Direct materialDirect laborInsert Page LayoutASUMMARY from Part 1ReadyB Division Overhead9XCollection Facility OverheadTOCalibri2728 Division Overhead2925 Division Overhead Total26BI U✓01 Cost per Bin23456 Total bins processed7819 Overhead Allocation Base = Output20 Collection Facility Total Overhead21fx2223 Collection Facility Overhead Allocation24vProject 6 - Part 2Accessibility: Good to goType here to searchFontProduction MixFormulas Data+11V$VΑ' ΑBA✓WW17YEAR 5 SUMMARYWWAB$ 2,430,000.00 $ 1,215,000.00$ 4,800,000.00 $ 200,000.00$ 4,181,299.20 $ 174,220.80$ 3,936,000.00 $ 164,000.00$ 15,347,299.20 $ 1,753,220.80127.89 $120,000WW$ 4,355,520.00ReviewWW$ 4,100,000.00Developer Helpab Wrap Text===Merge & Center -=Year 5CABViewAB30,00058.44637AB○ 발AlignmentD$E7WWYEAR 6 SUMMARYWWAB$ 1,215,000.00 $ 4,252,500.00$ 3,669,907.50 $ 611,604.00$ 4,263,047.05 $ 710,452.95$ 3,266,217.68 $ 544,327.56$ 12,414,172.22 $ 6,118,884.51Power Pivot137.94 $$ 4,973,500.00ww90,000B$ 3,810,545.00WWGeneralYear 6$ - % 9XNumberFWABABChabank67.9990,000AB-0.00.00 ➜.0GConditional Format as CellFormatting Table Styles ✓StylesNHJKStudents Enter Formulas HERE in yellow cells+Insert Delete FormatACellshuluLLa McPhΣ AutoSurFillClearMV FilePaste505152116Home Insert Page LayoutReadyCutCopyFormat PainterClipboardE XACalibri37 Collection Facility Overhead38 Division Overhead394041 Cost per Bin4243444546474849BIUHD-1080Project 6 - Part 2Accessibility: Good to goType here to searchfxv+Formulas Data ReviewFont2425 Division Overhead Total262728 Division Overhead293031 Summary of Costs using Output as Overhead Allocation Base32333435 Direct material36 Direct laborΑ Α΄✓ ✓ A✓11vB17$ 4,100,000.00WW==Cab Wrap Text===Merge & CenterABViewYEAR 5 SUMMARYWWAB2,430,000.00 $ 1,215,000.00$$ 4,800,000.00 $ 200,000.00$ 7,230,000.00 $ 1,415,000.00EtDeveloper HelpAlignmentDEWWV$ 3,810,545.00BPower Pivot17XGeneralConditional Format as$ % 900-90CellFormatting Table Styles ✓StylesVNumberYEAR 6 SUMMARYWWAB$ 1,215,000.00 $ 4,252,500:00$ 3,669,907.50 $ 611,604.00F$ 4,884,907.50 $ 4,864,104.00WABGPHN1BVJInsert Delete FormatKCellshulu---LHShinetta McPhersonΣ AutoSumFillClearMGREEN CELLS: Students use a formula to reference your calculationsso that this area automatically brings in the NEW totals fromyour calculationsVVSFSFiEditinNE83°F

Name: Using the excel spreadsheet provided, prepare the calculations. FilePa
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: Using the excel spreadsheet provided, prepare the calculations. FilePaste16HomeX CutCopyFormat PainterClipboardV:Direct materialDirect laborInsert Page LayoutASUMMARY from Part 1ReadyB Division Overhead9XCollection Facility OverheadTOCalibri2728 Divi

Overhead cost allocation refers to the process of allocating cost of overhead to various products in…

Business

Accounting

X ✓ fx A SUMMARY from Part 1 Direct material Direct labor Collection Facility Overhead Division Overhead Cost per Bin Total bins processed Production Mix e Overhead Allocation Base = Output O Collection Facility Total Overhead 1 2 3 Collection Facility Overhead Allocation 4 5 Division Overhead Total 6 7 8 Division Overhead YEAR 5 SUMMARY WW AB $ $ $ 2,430,000.00 $ 1,215,000.00 4,800,000.00 $ 200,000.00 4,181,299.20 $ 174,220.80 $ 3,936,000.00 $ 164,000.00 $ 15,347,299.20 $1,753,220.80 $ 127.89 $ WW 120,000 Year 5 $ 4,355,520.00 ww $ 4,100,000.00 WW C AB 30,000 AB 58.44 AB D YEAR 6 SUMMARY WW AB $ 1,215,000.00 $ 4,252,500.00 $ 3,669,907.50 $ 611,604.00 $ 4,263,047.05 $ 710,452.95 $3,266,217.68 $544,327.56 $ 12,414,172.22 $ 6,118,884.51 $ 137.94 $ WW 90,000 Year 6 $ 4,973,500.00 WW $ 3,810,545.00 WW AB 67.99 90,000 AB AB

X ✓ fx A SUMMARY from Part 1 Direct material Direct labor Collection Facility Overhead Division Overhead Cost per Bin Total bins processed Production Mix e Overhead Allocation Base = Output O Collection Facility Total Overhead 1 2 3 Collection Facility Overhead Allocation 4 5 Division Overhead Total 6 7 8 Division Overhead YEAR 5 SUMMARY WW AB $ $ $ 2,430,000.00 $ 1,215,000.00 4,800,000.00 $ 200,000.00 4,181,299.20 $ 174,220.80 $ 3,936,000.00 $ 164,000.00 $ 15,347,299.20 $1,753,220.80 $ 127.89 $ WW 120,000 Year 5 $ 4,355,520.00 ww $ 4,100,000.00 WW C AB 30,000 AB 58.44 AB D YEAR 6 SUMMARY WW AB $ 1,215,000.00 $ 4,252,500.00 $ 3,669,907.50 $ 611,604.00 $ 4,263,047.05 $ 710,452.95 $3,266,217.68 $544,327.56 $ 12,414,172.22 $ 6,118,884.51 $ 137.94 $ WW 90,000 Year 6 $ 4,973,500.00 WW $ 3,810,545.00 WW AB 67.99 90,000 AB AB

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 6CE: Refer to Cornerstone Exercise 7.3 and solve for the allocated costs to Fabricating and Assembly...

See similar textbooks

Similar questions

Activity Cost Pool Cost Driver EstimatedOverhead Use perProduct A Use perProduct B Machine Setups Setups $144,000 6,000 2,000 Assembly Number of Parts 71,000 25,000 46,000 Machine Maintenance Machine Hours 200,000 13,000 37,000 Compare the overhead allocation using (A) the traditional allocation method and (B) the activity-based costing method. (Hint: the traditional method uses machine hours as the allocation base.) For those boxes in which you must enter subtractive or negative numbers use a minus sign.
Please refer to the pictures for info and questions 1 and 2. See below for question 3 format. Department Departmental Overhead Rate Standard Deluxe Hours per Unit Overhead Allocated Hours per Unit Overhead Allocated Assembly Finishing Totals $0 $0
eBook Carlton's Kitchen's three cost pools and overhead estimates are as follows: Activity Cost Pool Cost Driver EstimatedOverhead Use perProduct A Use perProduct B Machine Setups Setups $162,000 5,000 4,000 Assembly Number of Parts 68,000 24,000 44,000 Machine Maintenance Machine Hours 150,000 13,000 37,000 Compare the overhead allocation using (A) the traditional allocation method and (B) the activity-based costing method. (Hint: the traditional method uses machine hours as the allocation base.) For those boxes in which you must enter subtractive or negative numbers use a minus sign. Product A Product B Total Overhead (ABC) $fill in the blank 1 $fill in the blank 2 Total overhead (traditional) fill in the blank 3 fill in the blank 4 Difference $fill in the blank 5 $fill in the blank 6
Please check my answer: - process accounting - ch6-ex51 Unit Cost and Cost Assignment, Nonuniform Inputs Loran Inc. had the following equivalent units schedule and cost for its fabrication department during September: Materials Conversion Units completed 180,000 180,000 Add: Units in ending WIP x Fraction complete 79,000 51,350 (79,000 x 65%) Equivalent units of output 259,000 231,350 Costs: Work in process, September 1: Materials $147,000 Conversion costs 7,875 Total $154,875 Current costs: Materials $1,068,000 Conversion costs 289,055 Total $1,357,055 Required: 1. Calculate the unit cost for materials, for conversion, and in total for the fabrication department for September. If required, round your answers to the nearest cent. Unit materials cost $4.69 Unit conversion cost $1.28 Total unit cost $5.97 2. Calculate the cost of units transferred out…
Identify under or over allocation from the following information :i. Actual Overhead tk 2,000, allocated overhead tk 1,500ii. Allocated Overhead 6,000 ,actual overhead 5,200iii. Actual Overhead 10,000, allocated overhead tk 18,000
HELP WITH CORRECT ANSWER AND WORKING Schedule of Activity CostsQuality Control ActivitiesActivity CostProcess audits$48,200Training of machine operators27,000Processing returned products16,700Scrap processing (disposal)25,200Rework8,900Preventative maintenance28,100Product design43,800Warranty work6,900Finished goods inspection23,000 From the above schedule of activity costs, determine the total activity cost. a. $227,800 b. $99,000 c. $275,638 d. $149,700
Explain how each activity in this list can be associated with the corresponding unit or batch level provided. A. Assembling products: batch level B. Issuing raw materials: unit level C. Machine setup: unit level D. Inspection: batch level E. Loading the labeling machine: unit level F. Equipment maintenance: unit level G. Printing a banner: batch level H. Moving material: unit level i. ordering a part: unit level
Journalizing the distribution of service department costs to production departments Required: Using your solution to P4-7, prepare journal entries for the following: The distribution of the total factory overhead of $79,400 to the individual production and service departments where it originated. The distribution of the Building Maintenance overhead to the appropriate other departments. The distribution of the Factory Office overhead to the appropriate other departments.
Refer to Cornerstone Exercise 7.3 and solve for the allocated costs to Fabricating and Assembly using the direct method of support department cost allocation. The Fabricating Department overhead rate is based on normal activity of 82,000 machine hours. The Assembly Department overhead rate is based on normal activity of 160,000 direct labor hours. Job 316 required six machine hours in Fabricating and four direct labor hours in Assembly. Total direct materials cost 120, and total direct labor cost was 80. Required: 1. Calculate the overhead rate for Fabricating based on machine hours and the overhead rate for Assembly based on direct labor hours. (Round overhead rates to the nearest cent.) 2. Using the overhead rates calculated in Requirement 1, calculate the cost of Job 316. 3. What if Job 316 had required one machine hour in Fabricating and four direct labor hours in Assembly? Direct labor and direct materials costs remained the same. Calculate the new cost of Job 316.
Refer to the data in Problem 6.31. Assume that the FIFO method is used. Required: 1. Prepare a physical flow schedule. 2. Calculate equivalent units of production for direct materials and conversion costs. 3. Compute unit cost. Round to three decimal places. 4. Calculate the cost of goods transferred to Painting at the end of the month. Calculate the cost of ending inventory.
Question Content Area Adirondack Marketing Inc. manufactures two products, A and B. Presently, the company uses a single plantwide factory overhead rate for allocating overhead to products. However, management is considering moving to a multiple department rate system for allocating overhead. Line Item Description Overhead TotalDirectLabor Hours DLH perProduct A DLH perProduct B Painting Dept. $249,000 11,500 3 5 Finishing Dept. 86,300 10,900 4 8 Totals $335,300 22,400 7 13 The single plantwide factory overhead rate for Adirondack Marketing Inc. is a.$21.65 per dlh b.$7.92 per dlh c.$14.97 per dlh d.$2.86 per dlh
Simplifying the ABC System: Equally Accurate Reduced ABC Systems Selected activities and other information are provided for Patterson Company for its most recent year of operations. Activity Driver Quantity Wafer A Wafer B 7. Inserting dies Number of dies 2,200,000 0.7 0.3 8. Purchasing materials Number of purchase orders 1,900 0.2 0.8 1. Developing test programs Engineering hours 11,500 0.25 0.75 3. Testing products Test hours 20,000 0.6 0.4 ABC assignments $155,000 $155,000 Total overhead cost $310,000 Required: 1. Form reduced system cost pools for activities 7 and 8. Do not round interim calculations. Round your final answers to the nearest dollar. Inserting dies cost pool $ 186,000…