Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Recompute the rates using the CAP Input Sheets please explain solve highlight areas in yellow in pictures. Summary of Accounting Changes T CAP Change Total

image text in transcribed
  1. Recompute the rates using the CAP Input Sheets
  2. please explain solve highlight areas in yellow in pictures.

image text in transcribed
Summary of Accounting Changes T CAP Change Total - IT Transfer CAP Change From: 2013 2014 2015 201 a)=CAP Summary Line 25 Total MFG Indirect Total 2017 28,586,088 $ b)=CAP Summary Line 26 32,980,133 $ 31,036,156 Total ENG Indirect Total 6,595,561 $ 7,510,430 $ 31,431,118 $ 30,714,690 $ 7,231,340 $ 7,154,409 $ c)=CAP Summary Line 2 7,315,989 Total Material Indirect Total 782,080 S 839,702 $ 828,517 $ 845,415 $ d)=CAP Summary Line 28 880,035 Total G&A Indirect Total 3,253,206 3,128,841 3,209,034 e)=a+b+c+d Total Indirect Total IT Transfer 38,831,898 $ 44,583,471 $ 42,638,210 $ 41,843,355 $ 42,441,214 Total - IT Transfer CAP Change To: 2013 2014 2015 2016 2017 f)=CAP Summary Line 48 MFG Overhead Pool 13,591,164 $ 14,266,711 $ 3)=CAP Summary Line 4 19,187,194 $ 6,366,182 h)=CAP Summary Line 50 ENG Overhead Pool 14,645,174 $ 23,183,405 $ 14,923,374 $ Material Overhead Pool 9,415,949 $ 17,783,426 $ 27,162,377 5,436,466 $ 6,063,352 7,035,305 S )=CAP Summary Line 51 7,639,419 Total G&A Indirect Total 388,319 $ 1,070,003 $ 1,492,337 $ 2,092,168 $ 1,273,236 1)=f+gth+i Total Indirect Total IT Transfer 38,831,898 42,638,210 REVISED CALCULATION FOR IT CAP 2013 2014 2015 2016 2017 k)=TAD FCST Line 15 Previous MFG Overhead Rate 42.2000% I)=TAD FCST Line 14 40.8204% 41.4708% Previous MFG Overhead $ 166,670,884 $ 42.7814% 42.4977% 187,422,620 $ 181,761,368 $ 179,607,991 $ Adjustment to MFG Overhead Adjustment to MFG Overhead $ Student Insert n) 0 ) = 1+m+n Adjusted MFG Overhead $ 166,670,884 $ 187,422,620 $ Student Insert 181,761,368 $ 179,607,991 $ 180,902,124 p)=TAD FCST Line 13 Previous MFG Overhead Base 394,955,000 $ 459,139,460 $ 438,287,720 $ 419,826,900 $ q) Adjustment to MFG Overhead Base 425,675,280 r)=p+q Adjusted MFG Overhead Base 394,955,000 $ 459,139,460 $ 438,287,720 $ 419,826,900 $ 425,675,280 :)=0 Adjusted MFG Overhead Rate 42.2000% 40.8204% 41.4708% t)=s-k 12.7814% 42.4977% MFG Overhead Rate Delta 0.0000% 0.0000% 0.0000% 0.0000% 0.0000% u)=TAD FCST Line 10 Previous Eng Overhead Rate 78.3626% 77.6238% 79.0756% V)=TAD FCST Line 9 81.7767% 83.2483% Previous ENG Overhead $ 88,086,500 $ 99,329,391 $ 36,456,497 $ Adjustment to ENG Overhead $ 96,387,924 $ 37,750,809 Student Insert v ) =v+w+ x Adjustment to ENG Overhead $ Adjusted ENG Overhead $ 88,086,500 $ 99,329,391 $ 96,456,497 $ 96,387,924 $ 97,750,809 z)=TAD FCST Line 8 Previous ENG Overhead Base 112,408,900 $ aa) 127,962,600 $ 121,980,163 $ 117,867,150 $ 117,420,750 Adjustment to ENG Overhead Base djusted ENG Overhead Base 112,408,900 $ 127,962,600 $ 121,980,163 $ 117,867,150 $ 117,420,750 ac)=y/ab Adjusted ENG Overhead Rate 78.3626 77.6238% 79.0756% 81.7767% 3.2483% ad)=ac-u Eng Overhead Rate Delta .00009 0.0000% 0.0000% 0.0000% 0.0000% ae)=TAD FCST Line 5 Previous Material Overhead Rate 10.0848% 9.6934% 10.0916% af)=TAD FCST Line 4 10.5159% Previous MAT Overhead $ 6,626,103 $ 62,740,367 $ Adjustment to MAT Overhead $ 1,432,562 $ ag) 1,281,329 $ $1,954,045 Student Insert ai)=af+ag+ah Adjustment to MAT Overhead $ Student Insert Adjusted MAT Overhead $ 56,626,103 $ 62,740,367 $ 61,432,562 $ 61,281,329 $ 61,954,045 aj)=TAD FCST Line 3 Previous MAT Overhead Base 561,500,000 $ 647,250,000 $ 608,750,000 $ 582,750,000 $ 581,500,000 ak) al)-aj+ak Adjustment to MAT Overhead Base Adjusted MAT Overhead Base 561,500,000 $ 647,250,000 $ 608,750,000 $ 582,750,000 $ 581,500,000 am)=ai/al Adjusted MAT Overhead Rate 10.0848 9.6934% 10.5159% 0.6542% an)=am-ae 10.0916% Material Overhead Rate Delta 0.0000% 0.0000% 0.0000% 0.0000% ao)=TAD FCST Line 22 Previous G&A Rate 11.7821% 11.4416% ST Line 21 11.8136% 12.3152% 12.5008% Previous G&A $ 138,414,713 $ 154,965,262 $ 153,375,120 $ 154,618,682 $ 158,640,155 aq) Adjustment to G&A ar) Adjustment to G& Student Insert as) Student Insert at) Adjustment to G&A Adjustment to G&A au)=ap+aq+ar+as+at Adjusted G&A 138,414,713 $ 154,965,262 $ 153,375,120 $ 154,618,682 $ av)=TAD FCST Line 19 Previous G&A Base $ $ 1,174,783,333 $ 1,354,401,800 $ 1,298,295,243 $ 1,255,514,112 $ 1,269,043,823 Adjustment to G&A Base ax) Student Insert Adjustment to G&A Base ay) Adjustment to G&A Base Student Insert Student Insert ba) Student Insert bb)=av+aw+ax+az+ba Adjustment to G&A Base Adjusted G&A Bas $ 1,174,783,333 $ 1,354,401,800 $ 1,298,295,243 $ 1,255,514,112 $ 1,269,043,823 bc=au/bb Adjusted G&A Rate 11.7821% 11.4416% 11.8136% 12.3152% 12.5008%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella

2nd edition

134730372, 134730370, 978-0134730370

More Books

Students also viewed these Accounting questions