Global Inc. is a power management company and has been planning to diversify its operations into construction contracts On April 1,2013 GlobalInc. began operations of its construction divisionand entered into contracts for two separate projects. Project A with acontract price was $1,200,000 started on April 1, 2013 and expected to be completed by March 31, 2015. Project A provided for penalties of $20,000 per week for late completion. Although during 2014 project A had been on schedule for timely completion, it was completed two weeks late in April 2015. Second project is project Bstarted on April 1, 2013 and expected to be completed by March 31, 2016. Though the original contract price of project B was $1,600,000,change orders during 2015 added $20,000 to the original contract price. The following data pertains to the separate long-term construction projects in progress Project A Project B As of Dec 31,2014 Costs incurred to date $640,000 $720,000 Estimated Cost to complete 160,000 900,000 Billings 680,000 880,000 Cash Collections 550,000 730,000 Project A Project B As of Dec. 31 2015 Costs incurred to date 900,000 1,440,000 Estimated costs to complete - 360,000 Billings 1,120,000 1,420,000 Cash Collections 1,120,000 1,250,000 Global Inc. accounts for its long-term construction contracts using the percentage of completion method for financial reporting purposes and the completed contract method for income tax purposes. Enacted tax rates are 25% for 2014 and 30% for 2015 and 2016 Global Inc.'s revenue and expensesfor Power Management division for the year 2015 are given below Revenues $1,500,000 Selling and Administrative Expenses 495,000 Depreciation on Plant and Equipment 345,000 chaged on straight line method every year Global Inc.offers a defined contribution plan to its employees. Plan Benefit Obligation balance on 1/1/2015was $230,00, Fair Value of Plan Assets on 1/1/15 was $230,000 The selttlement rate is 10% and expected rate of return is 6% Service cost for 2015 was $43,500 Amortization of prior service cost was $16,500 Actual return on plan assets is $12,400 Selling and Administrative expenses shwon above do not include pension expenses. Deprecaition deducted on income tax return for Power Management division is $395,000 for 2014 and 2015 "dyn~

Week 3 Project 1 Please read the scenario and the requirements 2 Submit your solution in the template provided in the doc. Sharing Global Inc. is a power management company and has been planning to diversify its operations into construction con On April 1,2013 Global Inc. began operations of its construction division and entered into contracts for two separat Project A with a contract price was $1,200,000 started on April 1, 2013 and expected to be completed by March 31 Project A provided for penalties of $20,000 per week for late completion. Although during 2014 project A had been on schedule for timely completion, it was completed two weeks late in April 2015. Second project is project B started on April 1, 2013 and expected to be completed by March 31, 2016. Though the original contract price of project B was $1,600,000,change orders during 2015 added $20,000 to the ori The following data pertains to the separate long-term construction projects in progress Project A As of Dec 31,2014 Costs incurred to date Estimated Cost to complete Billings Cash Collections Project B $640,000 160,000 680,000 550,000 Project A $720,000 900,000 880,000 730,000 Project B As of Dec. 31 2015 Costs incurred to date Estimated costs to complete Billings Cash Collections 900,000 1,120,000 1,120,000 1,440,000 360,000 1,420,000 1,250,000 Global Inc. accounts for its long-term construction contracts using the percentage of completion method and the completed contract method for income tax purposes. Enacted tax rates are 25% for 2014 and 30% for 2015 and 2016 Global Inc.'s revenue and expenses for Power Management division for the year 2015 are given below Revenues Selling and Administrative Expenses Depreciation on Plant and Equipment chaged on straight line method every year $1,500,000 495,000 345,000 Global Inc.offers a defined contribution plan to its employees. Plan Benefit Obligation balance on 1/1/2015 was $230,00, Fair Value of Plan Assets on 1/1/15 was $230 The selttlement rate is 10% and expected rate of return is 6% Service cost for 2015 was $43,500 Amortization of prior service cost was $16,500 Actual return on plan assets is $12,400 Selling and Administrative expenses shwon above do not include pension expenses. Deprecaition deducted on income tax return for Power Management division is $395,000 for 2014 and 2 s operations into construction contracts red into contracts for two separate projects. ted to be completed by March 31, 2015. o weeks late in April 2015. d by March 31, 2016. ng 2015 added $20,000 to the original contract price. percentage of completion method for financial reporting purposes r the year 2015 are given below f Plan Assets on 1/1/15 was $230,000 on expenses. vision is $395,000 for 2014 and 2015 Requirements A. Prepare a schedule showing Global Inc construction division balances in the following accounts at De 31, 2014 1 Accounts Receivable 2 Inventory/Current Liability for Project A 3 Inventory/Current Liability for Project B B. Prepare a schedule showing Global Inc. Gross Profit(Loss) recognized on construction contracts for the years ended under the percentage completion method. C Compute deferred taxes for 2014 and 2015 and record Income Tax entry for 2015. D. Prepare Global Inc. Income Statement for the year 2015. accounts at De 31, 2014 ontracts for the years ended Dec. 31, 2014and 2015, Grading Rubric Requirement a 25 Accounts Receivable Excess of billing over process cost Billings in execess of estimated earnings 8 points Requirement b 40 Correct Gross profit/Loss for Project A 2014 Correct Gross profit/Loss for Project A 2015 Correct Gross profit/Loss for Project B 2014 Correct Gross profit/Loss for Project B 2015 Requirement c 40 Correct pension expense Correct Deferred Tax for 2014 Correct Deferred Tax for 2015 Correct Tax Entry for 2015 Requirement D 25 Correct computation of Income before tax Correct computation of Net Income 5 points are just for timely submission Late submission will attract a penalty of 10 points for every day of late submiss timated earnings 8 points s for Project A 2014 s for Project A 2015 s for Project B 2014 s for Project B 2015 Income before tax Net Income 5 points 10 points 10 points 10 points 10 points 10 points 10 points 15 points 10 points 10 points 5 points 10 points 15 points ely submission act a penalty of 10 points for every day of late submission PK##########!#pp###########[Content_Types].xml ##(########################################################################### ################################################################################ ################################################################################ ################################################################################ ################################################################################ ################################################################################ #######################################VN0###q##!##G@#> 7Ki#FD3k 9#4fbE#6wi&^#z"ARVY#PG' #L8b&J"#% % SHB?Tz#y%sg ,###?~L# *#X[]^3t>X#P]>#f /@k9#T;#0,3N}#C39qqwA}p'^`4$*rQ##f#fvmk# lQc!M~##qq$:.I##2>###fF@ZV]!b.U#B|lM;##{i] [q'}#lI Zw}?>#[u#X######-#EB^-e ####PK##########! #U0####L#######_rels/.rels ##(########################################################################### ################################################################################ ################################################################################ ################################################################################ ################################################################################ ################################################################################ #######################################MO0 H#BKwAH!T~I#$#'##T##G~/ ^CVea8###OeY#bYlGPF.O#N f]rV2 Gn#6H m###q#Nqv#U7#99'#'#H#$#h #%r}L'"M?#+^$#:% uC#QwVQM3@# )##D#1@l WMZ##S B'L:g[nKTMP_3AeT4@ #K=3D ##N[mA##!2,Y3>#2Uv8p#Lu##Ad t@4#t?SV -c[V###^#xKH#rY#u:[V 5 7mY!H#d,!! D +D uD # ue9e##K e##J##J # !4u(t6')%!Ju^0G{H####2#ec_#V#E|(#@6v#L#c#?##l8x#!~r #MP#."EQB#Q(E#iD# %####B# 9>^d###O##RD Fd#YB"!HQ# 9 5;$"##L0*E#iD#%$#;##T ?+t#&bQ)"H#2,! #t##T{%##:UD #B##DH#:UjD:y#43y{(A"R4"##9BJQ#E#kyB(A"R4"## ! U###O2C/"#HQ5)"H#2,!![U)_#^4###Q! H! "KHT#6|>w[>#RD Fd#YBB>BT>}Ki:#b(A"R4"##wb#w#D)"H#2,!![L9Pr # q(A"R4"### S#GQ)"H#2,!! G)l8E###1h#B##D ## MLJ#)D#Ad #Jg)|0 F#" w]l[.|b#D"R4"##u}]o /Fq#bB##D .#'o#-b###iD#%$f[J#(A"R4"##B#gw|?j#L7O.# %RD Fd###?? E e # 2w]D#&QY#HT} #Wc#M5a# 3n##1#7###B##F V+#ff5hqz1j0""-%".i_*)Q#}h+U'\\^iq'J##`##{ $ ##|4 ~ 9"K cg|e \\m#Mu` O|Zy HZA#z*##=$7(|_#&R}#XY#-)yt l8w! q{#'A0,Ghw2#$#-JhBc,N,#oLl#t hyMnmn##_q#~f*c3#?#@o#oz#z#'#j_4'T#f| $MBM"/7#uJ######PK##########! #}j###########xl/worksheets/sheet3.xmln0#Ww/CUJj##0`1k; #rPM# x#Y=#YF_w, $#.cFJqt(U##L*t#I2Z`i`I([:##fQ;ht#VM###O#F ? MAKUC#e* ^,#rm8--+##\\D #N#y#C/ I}S#,g`PAeZr90D#l#3###4 \\#Mat';H+a6,##B#}>/A#[iTd=Ww#(=V"F,w1EZujp#x/z7qe#H_#? l~#tL#ZW@]-@%/Q##s 2>>C b=#| Yn^qT.k{P*{d#/6UYO a7 ? # 7Q###[n2on/;}E O ; y Q?-s2EV{GMyTSv#ddj| H.uu7"2[Lxk#c>cO#? #\\G5OgcJ`XF##}uSt#0|]] #oy#'#WWO uG )P#v #w mem6>ffn'O Q6 C#}2}: %##[T~##6k_:0> y U #D@s:?OTi#?n9nuae\\Z#I0 W#~> KVKG#:#i X 8##5###?#yH#\\OynSc34Z$S}{#p##%if ###ai#$[ d ###{3 7Cn6#FH?5h##4#,#|}#""r$9#$#p ##n#av#yh##mic?=s#(%c###@$#E$p#~#= ####q# W!# 1IM@#vF#@##9;tbv8###s@R ##"H HP;s#g##S$p:#M #@## D# Lyfn0ix4##w[Z~V#IAp ###~P,EZyP=##d$#p ###3|Xf8H]{ ) ####@$#E$wq>,!ZyX=:#### #"#T #u#rz f4~#####@$#E$7? +# 4~## #"#T #A#V#m##Q@@R ##"H HP}o3;#~7QY#z#HeTY$# W?#7#)6m7W|kO}?g#!t~~######PK##########! #8;=###]#######xl/worksheets/_rels/sheet1.xml.relsJ#1##n "R^>@n&! S#uKKo7#,W#a#{G2e##`exs#TK"##XW'lOe#P10#*n` >`+yP#P-N hgL Mw#b{H@n#}{S#uKKoo>Y>$Xh`!###]|# l#oA#)E4p@U{}|rD$*%9?(En`I&}*ru;;Mso#3t##=:v{p[gF(1e@6 wS ?>Lbg"WOe}?S.>2gd^d#E ####PK##########! #w##########xl/worksheets/_rels/sheet3.xml.relsj#1 E>$RJY?(#`#&X#\\4[=##nV4R? ,*x@^g#"qM.L=Fm^uO8o[L#Nbk#]#b?;t3 #3##reSQ ws)+y%5~$^wK##V}9M(# `#o#l4U9: 9 =(cNcZ9 ##MT!_X1tyF9#F#) %###:yI(3rb&g###,.N}Q W8Z?jS9vv#f#x()VJ+cV Y+Kd##{(t5#d##y4##~#####9]i^>`-N#d~! ###Y+Pma&W#eqk EH&T#sW#p"cvee{n;'_~#7zd={#\\u##FW |m # 9#WC#K#?"W#w)^(N#:^#X#" :I#^*##+2X70# 3^L#.#{#OK*V ^m0[ow# o w`y##mJ#(? z`u['bkN## 1#"J#C#N#H#_X?Z=4G'a q##uwPmkvQc80#tv#S&>.##U #pB=#@##(>Wx9#*1.`##"Pf[/~#t+^cY#kp/ v#1`.##$##;z#M#!xrwCZ #|VTl]i\\G_##|#I(B_`'Re#0 ?:#d#)e;\\:mP_) %w#;{1,m;h#dC#y#+#P8#x>f#\\2)J^##xu### ? #M~S#\\}#####PK##########! #{##x###########xl/drawings/vmlDrawing1.vmlU]k0#}#?#!/Ic+K?TP: #b)ZYXrtl^fP{tt'$kCpYn[]YZY##wo H##k]*#_3#T #xO#UQF`IUsC:? E,C")##g#EEJk#2w}g #hUNYz$#hrH#|zjbX#_#|## 6 VF@D6ZY?Hpa :snH#c%.Mx? X##zu#Dh;3j"9]6jyh8KirJMS#gJt+mJK? 1%#hszGA)6G#$#[#O#h##? 5#%1s2|@+zjO`a #}## #=& G-#9OFf6H(! kK,:hj1-t6X#lP".)^#KxjY EM$j#ie$PbY$Mkd5ojo,Ry#X 2?tbh&=W::# H#[$*}mDOr##oI#{p| r>}Z#&Nj:Nv#4(_BjGk`,\\=loP%CKaPJ4DQ_//hJ a 0c0g#TiF-#>-#>#j9@#0( i1#J u##-M###qFqI`3#####PK##########!#K####"######xl/theme/theme1.xmlZKo#7## X%2"#,IZQ#IH# #M^ C6@##)#_\\IKE_vx# oz0tL# [X,##L#8#> hym~#2qY#`{GeCd##cV#`#? G*@ K#/A##k7#jN #]t9Ah)xrR1o#LMZVU#3##^)7FAA4K/?#k >#dX#aF8(n+(#PS.Ai.-_\\Ux#}#GZ#$CA3U## #y7/7/>~q'ON#oy98/?D=xYG? ##5~y##S#|]n# h}n0+:#8##-#;#! f>\\{ ###(Y^8mY## # ##q##nqmkAM}3&{ G$% w##CJ#nPp =$#u#iBI#' 9# #v#y#6#(Xvp#* y0#a# 6w3D #p:#(q}~!O#GI7#m| #>&*.#CEGc#9E#'G# #Ag'B l#_`nHt33[T:! {@">C3i,;u'tao]###;#z>#Qv%(#wk# #;x# #1y#h4P/l#f#`|#H#OHj#^#7@749 M0 #PD##e#:TA#0I7#A!y##X##eD9eY0& %ut\\{{b#uSM2`pg3#&d=?HP#[Aj\\#5 b[m###p. &B*B#4#P[# AT_##.4N&v^yw{m#x]?iqs.] u#lh!c#c>'#{# #S#C?(t######PK##########!#I#i###7%## ###xl/styles.xmlZmo6#>`AP#Hr,vmwq###@2`# #LD)^lbJD^yw#>x]T4#8#QVo#P]T#vf# 1=##q_(#7u###CG#W \\(bZ#V|MY=#z;-+i#NqU V#"w#0)aK!* PTY#IuJI)W`g'?)]AE#EW:Vk? nuqm##$zJ#$:4#z vDA#.>#ZQ}94w#Y i3yb'!$*lUX[PcJoZJ6a5#e&UZsq#x?%Q*#E.d#J# R)rj8#?}pTF09#~v# )YGb >L3 R# #%? yp#h#:t##e9F##gI/###)d#T#X## k0a[J#sg+tGDsr,#If] #nmi3%##^T{B1k_F_n XIU#Z#-#6Fa!x(#X((p#e#G#q6##5kTd]Sm#IXN u.*ON## }l#9j#x#q@it#fr#np#KM###0S VZgI#&)#I@bW$H~O#i#9##T&FO#+]J#JR0as\\9 s7a;#y[#&c2$SLX 2z:Sxif##m)/lj#i#'43F&1_i%&! #g##M(#####PK##########!#qIY###c#######xl/comments3.xmlSj0 ##N$)Q(C#n4#W}an#c'KO~ug#v#'##2qC+( t#8[ti^Guzl.*9&(Z];>#S[S? W{8##._)$"souT#6###6#Gyc#-$Mxx=d0&c=U"y##g=#? ##c-#l#>/;il#fSx#'sJK;l#+{Fv###MzG5HK##o'lzG~z!gem 8##\\jp ####PK##########!#4### ##'###xl/printerSettings/printerSettings2.binVo@#.GZ## @BbEHY q8U#AWZ4#(c%#FN ##uP8q+B*!g|}"z ?#*\\#L8s) #Ou$,.W-qb.px]#4#t#d#?q##Q#1 %MS*#r9dgb ? g##Q.@cua|E4d#"=Rc#5Ez5'a5Ge#z %#eT*]Z5J)#?5F_6|#3##~_*Q3#~$O$v#z!ko`+ ' /#Ik#$Vzm #/e#Z]Z%V#J>x#]b}M|;##' 'x .'}#N#k##n] (Xy##8#{\\z#####PK##########!#PI###U#######xl/comments4.xmlj#! # Hi\\I ##9>U#M1C#=X#u#Uo[vw%3p#w(n} vn#J##\\DF#8,[ #q;pHi8###@QX8 ##8#X#d5#~16# #/V9K# 4#"BO##M#B#-##q5@#9a]Lvx#qm#8# #1\\fNW #)######Nlr?,H$#'\\;{"r?#pD?#####PK##########! #:###O#######xl/comments2.xmlj#!# Hm4i iPC/B =#`cCl#K/=#Df~S:!a# B#]#vmw#0l##h~#+s}=##_ U#$#hLi #X@I9##e?r##yjg?#h/#=#DH{#H # #[)8##g?#o#cc#####PK###########!#pp#########################[Content_Types].xmlPK##-#########! #U0####L####################_rels/.relsPK##-#########! #[####a#####################xl/_rels/workbook.xml.relsPK##-#########!#v9F####################S ##xl/workbook.xmlPK##-#########!#IKQ ##3###################xl/worksheets/sheet4.xmlPK##-#########! ##I{#####################M###xl/drawings/vmlDrawing4.vmlPK##-#########! #}j#########################xl/worksheets/sheet3.xmlPK##-#########! #kg####0####################xl/worksheets/sheet2.xmlPK##-#########! #8;=###]#################4$##xl/worksheets/_rels/sheet1.xml.relsPK###########!#PA####]#################e %##xl/worksheets/_rels/sheet2.xml.relsPK##-#########! #w#####################xl/worksheets/_rels/sheet3.xml.relsPK###########!#-{###]#################'##xl/worksheets/_rels/sheet4.xml.relsPK###########!#u=xl|#####################(##xl/drawings/vmlDrawing3.vmlPK###########!# ###################+##xl/worksheets/sheet1.xmlPK###########!#sPx#####################1##xl/drawings/vmlDrawing2.vmlPK###########!#{##x#####################c4##xl/drawings/vmlDrawing1.vmlPK###########!##y#J*###" #################7##xl/sharedStrings.xmlPK##-#########! #K####"################p:##xl/theme/theme1.xmlPK##-#########!#I#i###7%## #############A##xl/styles.xmlPK##-#########! #:83.###0#################G##xl/comments1.xmlPK##-#########!#r@w3### ##'#############H##xl/printerSettings/printerSettings1.binPK##-#########! ######################TK##docProps/app.xmlPK##-#########!#X %a####################QN##docProps/core.xmlPK##-#########! #qIY###c#################P##xl/comments3.xmlPK##-#########!##1### ##'#############pR##xl/printerSettings/printerSettings3.binPK##-#########! #4### ##'#############T##xl/printerSettings/printerSettings2.binPK##-#########! #PI###U#################_W##xl/comments4.xmlPK##-#########! #:###O#################X##xl/comments2.xmlPK#############>Z####