I need assistance with plugging in the numbers I attached the Excel sheet

I need help with preparing income statement for 2016 & 2017 variable costing Income statement for Absorption for 2016 & 2017 using the illustration below format provided. Then I need to have it reconciled and comment on the effect of production.

*P6-7AJackson Company produces plastic that is used for injection-molding applications such as gears for small motors. In 2016, the first year of operations, Jackson produced 4,000 tons of plastic and sold 3,500 tons. In 2017, the production and sales results were exactly reversed. In each year, the selling price per ton was $2,000, variable manufacturing costs were 15% of the sales price of units produced, variable selling expenses were 10% of the selling price of units sold, fixed manufacturing costs were $2,800,000, and fixed administrative expenses were $500,000.

Instructions

• Prepare income statements for each year using variable costing.(Use the format fromIllustration 6A.5.) (a) 2017 $2,700,000
• Prepare income statements for each year using absorption costing.(Use the format fromIllustration 6A.4.) (b) 2017 $2,350,000
• Reconcile the differences each year in net income under the two costing approaches.
• Comment on the effects of production and sales on net income under the two costing approaches.

Prepare absorption and variable costing income statements and reconcile differences between absorption and variable costing income statements when sales level and production level change. Discuss relative usefulness of absorption costing versus variable costing.

PK##########!#`z### #######[Content_Types].xml ##(########################################################################### ################################################################################ ################################################################################ ################################################################################ ################################################################################ ################################################################################ #######################################TN0###(q#!## ##`Ib-# g.B%Vl[ > #Hdu0x{}EQ.x( PgU## c)#x#%#ZEy UQ ? AG+'S!;Qv? wEvQBVB7?HPUV z2t12#P ?,3# bc(^##n\\#\\#F`0t+=q$k {V#U!! C[h[#(B:=@#  A|A 9 b#i#OvzQ #+O.;##Z9}U=q#v9ZS`mTtyd Hda###o8@.[ =######PK##########!#U0####L#######_rels/.rels ##(########################################################################### ################################################################################ ################################################################################ ################################################################################ ################################################################################ ################################################################################ #######################################N0 HCnH#LH!T#$#$@#Jc? [iT##b/N(A3b{jxV#b"gi###aWl_xb##b4#O##r0Qah#e =# P-~gw x KR#/#W+x=wY^#A#i#ZZ,#3Y 57#B[L#u| X= XXR#* Fe#I4T }S4.D#}F7W^KEIB#:AD>5 ?v1u/Ii#m# d u(#-}#4Eu#m#$ZvH#%ZfH,TLK#Y#/^  | ? Vp% yi #MT##-#w:ITJ#*s%"_#=##UYIMyp##1##$V(x#"##e3.#b PNu6g##B &M#e##(#Q>?^m).m'#>!p##}U>Irokh #P#!#|sjQ?RIY8#]Ff8JI9 #5#]-##@\\#? ##"F# ##Vy| #V\\OT#Oz"P^#&RqGjj9.##U.#`C#.H'#@[+#k*##kr# %##.J% ghJ ##b+OrY"mB##v6S6?8cV## 0>#^,#]?#$SiIF#sOi8jn## #( 6c=,#6x# S[i#5#v%Je#N_ ;#h7l##pq]4U)]g(;%~dp##e@6#--=#MM>#~ 4%a#v#2##C#WYRx=s78Cfod^\\= #;RXIy0#jm_#/N,}W:=RY}#H9EbAwk}##m ####PK##########! #u#L###l######xl/worksheets/sheet2.xmlYs#97b#C####n O? "7'#/leH|#n#nsjp #?=X1:#? n*mo#/{p{#_n#ww 7 } ' #? #;#EI ##n# N#w{}#6#(N'n#   x#Dvi^#]h_53#\\h+rU ? h{?w##\\]].W#yso>}>PG.? qxQz#{#z3Gn~K#?M(:6#p#z&g^  z*UgAbQ###TG#2^Y?\\sKztEzb~`#Nj>?# w&W^i{e3C(]7rd#|/$Bm'D ?H { {#vT59 }~oiL#W##[#zLb#3j#=oN#B 4i|{x}[#2&.U#$##Id@r 4aq#cK(?jP~SR##";#G@" 1#H $##)-iw!d+8#>eM#]yrXZ#&sV#Le; 1#H $##)  Eu#2d2OY1#3 s # K + k % /ZN OF#S? V#De##H#$###L.-;~#-_Z1e#b#d#d#d d#d dRYEnG##uh##$@R ##H%nX\\RG #9#%#5 FV*G##j3! 8###I@2 9#-Kh#)h##Y#Y#Y#Y#)`~x|00bg#H $#2#g #)8 hg#d#d#dD#5 FG#W+#`#'6@b L#`rU/#VK 7v=u[#.5#2##df@fdb Zfy|@+ #1#I4S##J#L##A#u"F20g*2z#9# 5g %H#pC4G@##}#Uo##]#H#pG#Vo#Q*A R#d##o  ~ #o?/b#=(D#s+#KH ,&u ##RZb# =D-n##Y`#g##uO:8# #PR T:%cdAq Jy!laWo~kmgCr=(m*#[v~ku##o#vF!tS ? I`##i+FvZ#i#JAYc#gaxY##YFmGbD T 1D)##+#OE#)##Q]6 hp%#=h#c&uA'LEH{0C4G@#.X1.e##ki#(#9.#]g#bJ1 #n\\' . d?'"D1#Q*H} R# Ad)ekL#u&x*2 9## x%H#C,##s,e#"##D I#4\\Zi# AEy`TdT ##Rbyki=(#cOGJ:U#_(EL{##J####;#V#CriW+##dS Inb,rn#M#S###-#-##V~? 4###P*I  ##D # U#*#s&" R3DsD#DKD+DkDp7##`#63u##d#7"##-#-#e+FJ@J&v-Y6 J_b@##J##H#K=n#y#"FhR#DKA#URtd##zj:T5#! "D1 I#4##)xJ#JQxZG:A!#Z Z RcV#ILl>#WSGqPN##xk$2#Q(A R3F#L##Q )gk{gK%k7##5uhhh)HX r*JFSot2| #+Q^C*Hd##Q(####sD##8Wb-* #Q#T6C4G@DBFT =#3Y5/"D1#Q*H= R9BeV#PT##9# %#5RP{IM+z#9#3#|f:n;{G-$qzbD #Q(GT #3j83s5OV+i:C"#>(2#!M#Q(A"# DcFt@C3aDK#H#oSO   p#>?##Q(E!###8 s~####D1#Q(C#*##~aD#=#o6F8z/F*#G#(F J#G3Az##`v#{3n###xd#=E1#Q*F;#a&6$ *#U9##c#6#F#9}cWf\\#pUZ##!#%RAl##,###1 #Z#S#N#:s=guUsw#U*#g_;#T(#:jL.zQ~S0#  EU# s##x##Q(#7#A7#0" 1a>#wWY_p#DWbJ#\\_CY7zZV##e{N):,#[sKDoT##i#D1#Q*u+_Q,e%iZ^ .D ## V} A#+6kuD2###WG##J#4 U3m#@14Kt# 6 #W*# # %RD##Qhb a G# 7~#Ol T#1UH#!#%RD##Qhh!o_.}_x=%\\V*+_vbJ#2D9##C_^n5[hZ| #F"D1#Q(C#*##M ##*[ !e#S-5Smw#-6#:v#O#T}Ji  sE4mw#{0 T#zd)#~#zd#UC#_M2TS#6?|nvo>R_bg`L#D? dI~L8 Ers7_bEZCKF_]^@##}xs+>T7######PK##########! ####[#######xl/theme/theme1.xmlY#5##?$Y5[%#m&I#8qv#UP{DBB#####Tj%.Y("_3 nW=#K#u?i/l#G#6&i# uJ8#7%N+#~p###(CM;|W,hF %6#8D##iq###bT!"mE(#7@W####5,$v##/vIE#QV.3#*x:;u#Z |#u#4#HS.Ohw #ZZ#+5#-|C#5#xw#8hx J#Vjuh.^_6L#=0#U2k## | v.&,Z###9#b#Q2uH## =i(j#=Z(&s? #X#k_3>G? 4##MUW Z = Dg##hOx7### ##'u|bb!M#FgY #D4##o.#4%&\\#{#W#4 ^pbZ#j#h#\\#})##,xn! tlGb#IL.#k4oR#q4#xf##Fw#-Gd#MuXmD!#6F#$,M#! ZlXmFMc# ##Q##Z##G#T!d#T\\7)qln0^%@>i? PGL>##c*f~ 'Qb?Jf0Euq#+D J#K@5 0#3##f #fatZ?8 CoJ ?#-#b#U#T]#Z hQ3#7A/ku#\\5#Hle-#qVJm# #m? @Z#U##Bi0@i>%8pN(#)qD/)51? VvC(qVnkh_#5f#rw#ZpEX#n+##? >e#M\\#lWj#,&En)#C`##GW)l>jO|#SJ%%| gj#M$t2uE#Kps9x A| B###\\S#f|3?#G# a9q #ct)[CjQ3Ay#E [#VY\\@#x'R0%;;aw#QZ!vJ[ [ ##x/#####PK##########! #ZLB###########xl/sharedStrings.xmlX[o6#~#p`t4MS#,`E#m:#@KU"5  P ,3vdE w"ki27#{$uj2?/W#?Bg"7ZV :q#jw[x_#\\pCSJi#WZ)2#xlT#{J#UZS 8 #a# whnL###)%?]^]##G#/#TH|###3 _fpFwk.#G#53##'#*_Hl&-##E!#4id@ 3ie4gCU5x!p(oO#n #rpN ? ,0pBhH#R[#]#X#-##rS;C ?##)AB jgZ/1mh| lv`#]C#=~w} #zW[#|,Roq051zn#!@%kuHhs#~}>sK# ## #A**$4gSX{##7W N'T2:4#V}#.# Hk($Ikrq2ic[Pq6)6? #4,[~zt iRs[tlVVW#NmP##~'###4S.*5AQs#.aZJx.A#[4Jq!  W##2[###\\#=_{Z4Zv5#r&({/Ih(d#N`F# w#}Oj )?Vve;}tScS()QrCdk$zL Y>)SogQ`#D#cnO#+x[G^&v#PuM=ts)#O=#? c#'_}zlF^ANi #vX#2PTB##Y##)UTK S%/|8TFz6#[#Z1&t6i;KB}->! {u#rR/Zqg6%]#'hRkYY###r= Lv/TUH r:q |~#r#.,F3#Y#rfs|#D!k3q#w+gw`R? #J]#'>6\\H#xUR`#q$SWj lJ,[##X2p 4nS[Z5 ?#*S&,#E9#ez>V! ff=WKFAKHc@g/ 9.#|HwS.#r#b ##yM)N `F +-G;~h\\*#9#*C#5#K{#:cyjDz00#'k#{O2{#F*(^Q4p#ug|/k#xs$ $K/#}#Bfb[#tO9?.X^a(6!9##R-)###Qn9#g"#J4r8WJ:#wP+#F5jc3#hg^#=s#D(gsK# #^5z/# -D#*ih?8zThD  AI1b #){S#B}E*a{Cx}KSz#Gk9! 5E\\|! > L#&"#}o#X7#>> > iiz\\Lnf#gv56#e91bKSIxf Qxbb~##sC 5!$}4#Nehbj/2 / #wwIl.+w# os};#p-4DQz| SWB##eeQ  .^* rbpt 0|LnX#c#/}P| bJ'###d#^.NFG>#b%#0&`=#!UW|? W2] ` ##fE###k#? d>@,;)2Qu3yk##U(#}0s=^#FwxVw,#}jl##')cc#_# Mm_#E#n#_K#j#oK^#2pWvkI#'B#mZ#*##bV. [B#c? 3b#un#v%N#)l   P_#Z1]MYvFPMF8#z#}mSU#kp vyDs!U~}\\]}#[C\\z$z$es"q  r )>#a#Y## _ %YSLiT#R`##hb#hT qi!##! N(#RTewi='W2T#E'{_r#9;#0>Gn_kU\\xrm5 ##_Xo[*l5\\[,6F1J ##c UtL*:#N###&Bz##Wd i#`F#C T#C@# $##uu*d\\"T/B;#! m}jSd`M#6#d`M#6#d`M#6#_2######PK##########!##=T### P####3 ##'###xl/printerSettings/printerSettings2.bin2a0f0#B#### #PPP %`2#,##,lw#;o`gd`dx##"t##3#W# S)#P#@4#####d#OP% #/7 E G ! s.#B#@#zI7pT#UB#Z#####`#Fh#h#h#h##5B0#gh#]1 "r PmZ?3.9 EY7\\x#G;~2#K7vS#{ ii n#   VFW%l+#v6.*w#SN5(#4?n*#bQQ^.###)ln"{K ?##_joy*m~K#"s -_d#M9#f/R# E.+Gk   #&~usr##~&pIOJb{&Zzs6 g#^Q#esk /&3{=#Xw#|}t   3>Ko.8^biw_ ? r kzwzwr [zrdr o SW_>Oik|OxdiV_l/WSo %f w -NO}&_6\\b##Q###F#5c4#FC`4#FC`4#FC`4#FC`4#FC`4#FC`4#FC`4#FCz! ######PK##########!# ###########xl/calcChain.xmltn0###c~#arTbq