{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Identification","Periodic","Perpetual"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Identification","index":0,"n_rows":74,"n_cols":8,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["Student Name:","Your Name Here"]
["5 Digit Identification Number:",11111]
["Date:","2017-07-20"]
[]
[]
["Random Number"]
[]
[null,{"$f":"B2/10000","v":1.1111}]
[null,{"$f":"TRUNC(B8)","v":1}]
[null,{"$f":"B2/1000","v":11.111000000000001}]
[null,{"$f":"TRUNC(B10)","v":11}]
[null,{"$f":"B11-(B9*10)","v":1}]
[null,{"$f":"B2/100","v":111.11}]
[null,{"$f":"TRUNC(B13)","v":111}]
[null,{"$f":"B14-(B11*10)","v":1}]
[null,{"$f":"B2/10","v":1111.0999999999999}]
[null,{"$f":"TRUNC(B16)","v":1111}]
[null,{"$f":"B17-(B14*10)","v":1}]
[null,{"$f":"B2","v":11111}]
[null,{"$f":"TRUNC(B19)","v":11111}]
[null,{"$f":"B20-(B17*10)","v":1}]
[]
[null,{"$f":"B9+B12+B15+B18+B21","v":5}]
[]
[]
[1,6,{"$f":"IF(A26=$B$23,B26,0)","v":0}]
[2,8,{"$f":"IF(A27=$B$23,B27,0)","v":0}]
[3,3,0]
[4,4,0]
[5,9,9]
[6,1,0]
[7,2,0]
[8,3,0]
[9,5,0]
[10,7,0]
[11,9,0]
[12,6,0]
[13,6,0]
[14,4,0]
[15,3,0]
[16,2,0]
[17,6,0]
[18,2,0]
[19,1,0]
[20,1,0]
[21,7,0]
[22,9,0]
[23,8,0]
[24,7,0]
[25,3,0]
[26,6,0]
[27,1,0]
[28,2,0]
[29,3,0]
[30,4,{"$f":"IF(A55=$B$23,B55,0)","v":0}]
[31,5,0]
[32,7,0]
[33,8,0]
[34,9,0]
[35,5,0]
[36,3,0]
[37,5,0]
[38,7,0]
[39,3,0]
[40,6,0]
[41,7,0]
[42,8,0]
[43,2,0]
[44,5,0]
[45,7,0]
["Randon numbers",null,{"$f":"SUM(C26:C70)","v":9},{"$f":"B23","v":5},{"$f":"B14","v":111},{"$f":"B17","v":1111},{"$f":"B19","v":11111},{"$f":"G71/C71","v":1234.5555555555557}]
[null,null,{"$f":"D72/9","v":1.3888888888888888},{"$f":"D71*2.5","v":12.5},{"$f":"E71*2.5","v":277.5},{"$f":"F71*2.5","v":2777.5},{"$f":"G71*2.5","v":27777.5},{"$f":"H71*2.5","v":3086.3888888888891}]
[null,null,{"$f":"(C72+C71)/2","v":5.1944444444444446},{"$f":"$C$73*D71","v":25.972222222222221},{"$f":"$C$73*E71","v":576.58333333333337},{"$f":"$C$73*F71","v":5771.0277777777783},{"$f":"$C$73*G71","v":57715.472222222226},{"$f":"$C$73*H71","v":6412.8302469135806}]
[null,null,{"$f":"SUM(C72:C73)","v":6.5833333333333339},{"$f":"$C$74*C71","v":59.250000000000007},{"$f":"$C$74*D71","v":32.916666666666671},{"$f":"$C$74*E71","v":730.75000000000011},{"$f":"$C$74*F71","v":7314.0833333333339},{"$f":"$C$74*G71","v":73147.416666666672}]

{"sheet":"Periodic","index":1,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":false,"merged":[[26,1,26,3],[0,1,0,2],[3,10,3,12],[3,13,3,16],[0,9,1,16],[14,1,14,3],[8,1,9,1],[8,2,9,2],[1,1,1,3],[14,14,26,18]]}
[null,"Please fill out the cells in column C by selecting the correct value from the drop-down menu.  The correct answer will result in the cell turning to a green shade allowing you to monitor your progress and determine which topics require more study.  ",null,null,null,null,null,null,null,"All parts of the problem refer back to this tab.  Any changes to the cells below will flow through to the rest of the workbook with the exception of # of units purchased and sold",null,null,null,null,null,null,null,{"$f":"Identification!$C$71","v":9},{"$f":"Identification!$D$71","v":5},{"$f":"Identification!$E$71","v":111},{"$f":"Identification!$F$71","v":1111},{"$f":"Identification!$G$71","v":11111},{"$f":"Identification!$H$71","v":1234.5555555555557}]
[null,{"$f":" CONCATENATE(Identification!B1, \" Corporation is in its first year of operation and engages in the purchase and resale of military equipment.  Purchases and sales for the first year of operation were as follows:\"  )","v":"Your Name Here Corporation is in its first year of operation and engages in the purchase and resale of military equipment.  Purchases and sales for the first year of operation were as follows:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S2/9","v":1.3888888888888888},{"$f":"S1*2.5","v":12.5},{"$f":"T1*2.5","v":277.5},{"$f":"U1*2.5","v":2777.5},{"$f":"V1*2.5","v":27777.5},{"$f":"W1*2.5","v":3086.3888888888891}]
[null,"Date","Purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(R1+R2)/2","v":5.1944444444444446},{"$f":"$R$3*S1","v":25.972222222222221},{"$f":"$R$3*T1","v":576.58333333333337},{"$f":"$R$3*U1","v":5771.0277777777783},{"$f":"$R$3*V1","v":57715.472222222226},{"$f":"$R$3*W1","v":6412.8302469135806}]
[null,"2008-01-07",{"$f":"CONCATENATE(P7, \" units @ \",TEXT(Q7,\"$#,##0\"),\" each\")","v":"50 units @ $31,250 each"},null,null,null,null,null,null,null,"Sales",null,null,"Purchases",null,null,null,{"$f":"SUM(R2:R3)","v":6.5833333333333339},{"$f":"$R$4*R1","v":59.250000000000007},{"$f":"$R$4*S1","v":32.916666666666671},{"$f":"$R$4*T1","v":730.75000000000011},{"$f":"$R$4*U1","v":7314.0833333333339},{"$f":"$R$4*V1","v":73147.416666666672}]
[null,"2008-03-15",{"$f":"CONCATENATE(P8, \" units @ \",TEXT(Q8,\"$#,##0\"),\" each\")","v":"70 units @ $32,250 each"},null,null,null,null,null,null,null,"Total Sales","# of Units","Sales Price",null,"Total Cost","# of Units","Purchase Price"]
[null,"2008-06-16",{"$f":"CONCATENATE(P9, \" units @ \",TEXT(Q9,\"$#,##0\"),\" each\")","v":"30 units @ $32,750 each"}]
[null,"2008-08-03",{"$f":"CONCATENATE(P10, \" units @ \",TEXT(Q10,\"$#,##0\"),\" each\")","v":"90 units @ $33,250 each"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P7*Q7","v":1562500},50,{"$f":"IF(S8<100,S8*1000,S8*100)","v":31250},{"$f":"R1*2.5","v":22.5},12.5,277.5,2777.5,27777.5,3086.3888888888891]
[null,"2008-10-11",{"$f":"CONCATENATE(P11, \" units @ \",TEXT(Q11,\"$#,##0\"),\" each\")","v":"25 units @ $34,250 each"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P8*Q8","v":2257500},70,{"$f":"Q7+1000","v":32250},{"$f":"R2*2.5","v":3.4722222222222223},31.25,693.75,6943.75,69443.75,7715.9722222222226]
[null,"Date","Sales",null,null,null,null,null,null,null,{"$f":"L9*M9","v":4421250},90,{"$f":"Q9*1.5","v":49125},null,{"$f":"P9*Q9","v":982500},30,{"$f":"Q8+500","v":32750},12.986111111111111,64.930555555555557,1441.4583333333335,14427.569444444445,144288.68055555556,16032.075617283952]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P10*Q10","v":2992500},90,{"$f":"Q9+500","v":33250},16.458333333333336,148.12500000000003,82.291666666666686,1826.8750000000002,18285.208333333336,182868.54166666669]
[null,"2017-03-16",{"$f":"CONCATENATE(L9,\" units @ \",TEXT(M9,\"$#,##0\"),\" each\")","v":"90 units @ $49,125 each"},null,null,null,null,null,null,null,{"$f":"L11*M11","v":6678750},130,{"$f":"Q11*1.5","v":51375},null,{"$f":"P11*Q11","v":856250},25,{"$f":"Q10+1000","v":34250}]
[null,"2017-11-01",{"$f":"CONCATENATE(L11,\" units @ \",TEXT(M11,\"$#,##0\"),\" each\")","v":"130 units @ $51,375 each"},null,null,null,null,"SOLUTION"]
[]
[]
["(a)",{"$f":" CONCATENATE(\"If \",Identification!B1, \" Corporation uses the first-in, first-out (FIFO) inventory method (periodic approach), what values would be assigned to ending inventory and cost of goods sold?  How much is gross profit?\")","v":"If Your Name Here Corporation uses the first-in, first-out (FIFO) inventory method (periodic approach), what values would be assigned to ending inventory and cost of goods sold?  How much is gross profit?"},null,null,null,null,null,null,null,null,null,null,null,null,"COMMENTS: (Had to moved to a textbox since hiding comment boxes resulted in an error)\nH21, H33: Cells that are hardcoded and need to be changed if the number of units are altered\nQ7 : This is formatted to fall within 1,000 and 100,000 based on the randomized number in Cell R8\nS8: This is the random number I used to make the problem unique to each user\n"]
[null,null,null,null,null,null,null,null,null,0]
[null,"Beginning inventory",0,null,null,null,null,0,null,{"$f":"$H$21","v":7130000},"FIFO COGS"]
[null,"Plus:  Purchases",0,null,null,null,null,{"$f":"SUM(O7:O11)","v":8651250},null,{"$f":"$H$18","v":8651250},"Purchases"]
[null,"Cost of goods available for sale",{"$f":"C18+C17","v":0},null,null,null,null,{"$f":"H18+H17","v":8651250},null,{"$f":"$H$25","v":3970000},"FIFO Gross Profit"]
[null,"Less:  Ending inventory",0,null,null,null,null,{"$f":"H19-H21","v":1521250},null,{"$f":"$H$23","v":11100000},"Sales"]
[null,"Cost of goods sold ",{"$f":"C19-C20","v":0},null,null,null,null,{"$f":"P7*Q7+P8*Q8+P9*Q9+70*Q10","v":7130000},null,{"$f":"$H$20","v":1521250},"FIFO End Inventory"]
[null,null,null,null,null,null,null,null,null,{"$f":"$H$33","v":7245000},"LIFO COGS"]
[null,"Sales",0,null,null,null,null,{"$f":"SUM(K9:K11)","v":11100000},null,{"$f":"$H$32","v":1406250},"LIFO End Inventory"]
[null,"Cost of goods sold",{"$f":"C21","v":0},null,null,null,null,{"$f":"H21","v":7130000},null,{"$f":"$H$37","v":3855000},"LIFO Gross Profit"]
[null,"Gross profit",0,null,null,null,null,{"$f":"H23-H24","v":3970000}]
[]
["(b)",{"$f":" CONCATENATE(\"If \",Identification!B1, \" Corporation uses the last-in, first-out (LIFO) inventory method (periodic approach), what values would be assigned to ending inventory and cost of goods sold?  How much is gross profit?\")","v":"If Your Name Here Corporation uses the last-in, first-out (LIFO) inventory method (periodic approach), what values would be assigned to ending inventory and cost of goods sold?  How much is gross profit?"}]
[]
[null,"Beginning inventory",0,null,null,null,null,0]
[null,"Plus:  Purchases",0,null,null,null,null,{"$f":"SUM(O7:O11)","v":8651250}]
[null,"Cost of goods available for sale",{"$f":"C30+C29","v":0},null,null,null,null,{"$f":"H30+H29","v":8651250}]
[null,"Less:  Ending inventory ",0,null,null,null,null,{"$f":"H31-H33","v":1406250}]
[null,"Cost of goods sold",{"$f":"C31-C32","v":0},null,null,null,null,{"$f":"P11*Q11+P10*Q10+P9*Q9+P8*Q8+5*Q7","v":7245000}]
[]
[null,"Sales",0,null,null,null,null,{"$f":"SUM(K9:K11)","v":11100000}]
[null,"Cost of goods sold",{"$f":"C33","v":0},null,null,null,null,{"$f":"H33","v":7245000}]
[null,"Gross profit",0,null,null,null,null,{"$f":"H35-H36","v":3855000}]

{"sheet":"Perpetual","index":2,"n_rows":80,"n_cols":47,"rows_kept":80,"cut":false,"hidden":false,"merged":[[8,7,8,9],[31,34,44,37],[79,1,79,4],[47,1,47,11],[20,34,20,36],[0,1,0,11],[17,21,17,22],[17,24,17,25],[17,3,17,4],[17,6,17,7],[15,1,15,11],[2,6,2,9],[11,7,11,9],[12,7,12,9],[9,6,10,6],[9,7,10,9],[3,7,3,9],[4,7,4,9],[5,7,5,9],[6,7,6,9],[7,7,7,9],[20,38,20,40],[49,21,49,22],[49,24,49,25],[49,3,49,4],[49,6,49,7]]}
[null,"Select the correct answer from the drop-down options for all cells highlighted red.  Once the correct answer is selected the cell will automatically be shaded green allowing you to monitor your progress and determine which topics require further study. "]
[]
[null,null,null,null,null,null,{"$f":" CONCATENATE(Identification!B1, \" Corporation is in its first year of operation and engages in the purchase and resale of military equipment.  Purchases and sales for the first year of operation were as follows:\"  )","v":"Your Name Here Corporation is in its first year of operation and engages in the purchase and resale of military equipment.  Purchases and sales for the first year of operation were as follows:"}]
[null,null,null,null,null,null,"Date","Purchases"]
[null,null,null,null,null,null,"2008-01-07",{"$f":"AF22","v":"50 units @ $31,250 each"}]
[null,null,null,null,null,null,"2008-03-15",{"$f":"AF23","v":"70 units @ $32,250 each"}]
[null,null,null,null,null,null,"2008-06-16",{"$f":"AF24","v":"30 units @ $32,750 each"}]
[null,null,null,null,null,null,"2008-08-03",{"$f":"AF25","v":"90 units @ $33,250 each"}]
[null,null,null,null,null,null,"2008-10-11",{"$f":"AF26","v":"25 units @ $34,250 each"}]
[null,null,null,null,null,null,"Date","Sales"]
[]
[null,null,null,null,null,null,"2017-03-16",{"$f":"AF29","v":"90 units @ $49,125 each"}]
[null,null,null,null,null,null,"2017-11-01",{"$f":"AF30","v":"130 units @ $51,375 each"}]
[]
[]
["(c)",{"$f":" CONCATENATE(\"If \",Identification!B1, \" Corporation uses the first-in, first-out (FIFO) inventory method (perpetual approach), what values would be assigned to ending inventory and cost of goods sold?  How much is gross profit?\")","v":"If Your Name Here Corporation uses the first-in, first-out (FIFO) inventory method (perpetual approach), what values would be assigned to ending inventory and cost of goods sold?  How much is gross profit?"}]
[]
[null,"Date",null,"Purchases",null,null,"Sales",null,null,"Cost of Goods Sold",null,"Balance",null,null,"Balance Column Drop Down",null,null,null,null,"Date",null,"Purchases",null,null,"Sales",null,null,"Cost of Goods Sold",null,"Balance",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Identification!$C$71","v":9},{"$f":"Identification!$D$71","v":5},{"$f":"Identification!$E$71","v":111},{"$f":"Identification!$F$71","v":1111},{"$f":"Identification!$G$71","v":11111},{"$f":"Identification!$H$71","v":1234.5555555555557}]
[null,{"$f":"T19","v":"2008-01-07"},null,{"$f":"V19","v":"50 units @ $31,250 each ="},{"$f":"W19","v":1562500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G5","v":"2008-01-07"},null,{"$f":"CONCATENATE(AF22, \" =\")","v":"50 units @ $31,250 each ="},{"$f":"$AM$24","v":1562500},null,null,null,null,null,null,{"$f":"CONCATENATE(AN24,\" x \",TEXT(AO24,\"$#,##0\"),\" = \",TEXT(AM24,\"$#,##0\"))","v":"50 x $31,250 = $1,562,500"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ19/9","v":1.3888888888888888},{"$f":"AQ18*2.5","v":12.5},{"$f":"AR18*2.5","v":277.5},{"$f":"AS18*2.5","v":2777.5},{"$f":"AT18*2.5","v":27777.5},{"$f":"AU18*2.5","v":3086.3888888888891}]
[null,{"$f":"T20","v":"2008-03-15"},null,{"$f":"V20","v":"70 units @ $32,250 each ="},{"$f":"W20","v":2257500},null,null,null,null,null,null,{"$f":"L19","v":0},null,null,null,{"$f":"$AD$40","v":"20 x $33,250 = $665,000"},null,null,null,{"$f":"G6","v":"2008-03-15"},null,{"$f":"CONCATENATE(AF23, \" =\")","v":"70 units @ $32,250 each ="},{"$f":"$AM$25","v":2257500},null,null,null,null,null,null,{"$f":"CONCATENATE(AN24,\" x \",TEXT(AO24,\"$#,##0\"),\" = \",TEXT(AM24,\"$#,##0\"))","v":"50 x $31,250 = $1,562,500"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AP18+AP19)/2","v":5.1944444444444446},{"$f":"$AP$20*AQ18","v":25.972222222222221},{"$f":"$AP$20*AR18","v":576.58333333333337},{"$f":"$AP$20*AS18","v":5771.0277777777783},{"$f":"$AP$20*AT18","v":57715.472222222226},{"$f":"$AP$20*AU18","v":6412.8302469135806}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$36","v":"25 x $34,250 = $856,250"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AN25,\" x \",TEXT(AO25,\"$#,##0\"),\" = \",TEXT(AM25,\"$#,##0\"))","v":"70 x $32,250 = $2,257,500"},null,"Purchases",null,null,{"$f":"Periodic!K4","v":"Sales"},null,null,null,{"$f":"Periodic!N4","v":"Purchases"},null,null,{"$f":"SUM(AP19:AP20)","v":6.5833333333333339},{"$f":"$AP$21*AP18","v":59.250000000000007},{"$f":"$AP$21*AQ18","v":32.916666666666671},{"$f":"$AP$21*AR18","v":730.75000000000011},{"$f":"$AP$21*AS18","v":7314.0833333333339},{"$f":"$AP$21*AT18","v":73147.416666666672}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$24","v":"30 x $32,250 = $967,500"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM24+AM25","v":3820000},null,{"$f":"CONCATENATE(AN24, \" units @ \",TEXT(AO24,\"$#,##0\"),\" each\")","v":"50 units @ $31,250 each"},null,null,{"$f":"Periodic!K5","v":"Total Sales"},{"$f":"Periodic!L5","v":"# of Units"},{"$f":"Periodic!M5","v":"Sales Price"},null,{"$f":"Periodic!O5","v":"Total Cost"},{"$f":"Periodic!P5","v":"# of Units"},{"$f":"Periodic!Q5","v":"Purchase Price"}]
[null,{"$f":"T23","v":"2017-03-16"},null,null,null,null,{"$f":"Y23","v":"90 units @ $49,125 each = "},{"$f":"Z23","v":4421250},null,null,null,null,null,null,null,{"$f":"$AD$27","v":"30 x $32,750 = $982,500"},null,null,null,{"$f":"G12","v":"2017-03-16"},null,null,null,null,{"$f":"CONCATENATE(AF29,\" = \")","v":"90 units @ $49,125 each = "},{"$f":"$AI$26","v":4421250},null,{"$f":"CONCATENATE(AN24,\" x \",TEXT(AO24,\"$#,##0\"),\" = \",TEXT(AM24,\"$#,##0\"))","v":"50 x $31,250 = $1,562,500"},null,null,null,{"$f":"CONCATENATE(AN25, \" units @ \",TEXT(AO25,\"$#,##0\"),\" each\")","v":"70 units @ $32,250 each"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$19","v":"50 x $31,250 = $1,562,500"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"40 x \",TEXT(AO25,\"$#,##0\"),\" = \",TEXT(40*AO25,\"$#,##0\"))","v":"40 x $32,250 = $1,290,000"},null,{"$f":"CONCATENATE(\"30 x \",TEXT(AO25,\"$#,##0\"),\" = \",TEXT(30*AO25,\"$#,##0\"))","v":"30 x $32,250 = $967,500"},null,{"$f":"CONCATENATE(AN26, \" units @ \",TEXT(AO26,\"$#,##0\"),\" each\")","v":"30 units @ $32,750 each"},null,null,null,null,null,null,{"$f":"Periodic!O7","v":1562500},{"$f":"Periodic!P7","v":50},{"$f":"Periodic!Q7","v":31250},{"$f":"AP18*2.5","v":22.5},12.5,277.5,2777.5,27777.5,3086.3888888888891]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$21","v":"70 x $32,250 = $2,257,500"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM24+40*AO25","v":2852500},null,null,null,{"$f":"CONCATENATE(AN27, \" units @ \",TEXT(AO27,\"$#,##0\"),\" each\")","v":"90 units @ $33,250 each"},null,null,null,null,null,null,{"$f":"Periodic!O8","v":2257500},{"$f":"Periodic!P8","v":70},{"$f":"Periodic!Q8","v":32250},{"$f":"AP19*2.5","v":3.4722222222222223},31.25,693.75,6943.75,69443.75,7715.9722222222226]
[null,{"$f":"T26","v":"2008-06-16"},null,{"$f":"V26","v":"30 units @ $32,750 each = "},{"$f":"W26","v":982500},null,null,null,null,null,null,{"$f":"L24","v":0},null,null,null,{"$f":"$AD$31","v":"90 x $33,250 = $2,992,500"},null,null,null,{"$f":"G7","v":"2008-06-16"},null,{"$f":"CONCATENATE(AF24,\" = \")","v":"30 units @ $32,750 each = "},{"$f":"$AM$26","v":982500},null,null,null,null,null,null,{"$f":"CONCATENATE(\"30 x \",TEXT(AO25,\"$#,##0\"),\" = \",TEXT(30*AO25,\"$#,##0\"))","v":"30 x $32,250 = $967,500"},null,{"$f":"CONCATENATE(AN28, \" units @ \",TEXT(AO28,\"$#,##0\"),\" each\")","v":"25 units @ $34,250 each"},null,null,{"$f":"Periodic!K9","v":4421250},{"$f":"Periodic!L9","v":90},{"$f":"Periodic!M9","v":49125},null,{"$f":"Periodic!O9","v":982500},{"$f":"Periodic!P9","v":30},{"$f":"Periodic!Q9","v":32750},{"$f":"AP20*2.5","v":12.986111111111111},64.930555555555557,1441.4583333333335,14427.569444444445,144288.68055555556,16032.075617283952]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AN26, \" x \", TEXT(AO26,\"$#,##0\"), \" = \", TEXT(AN26*AO26, \"$#,##0\"))","v":"30 x $32,750 = $982,500"},null,null,null,null,null,null,null,null,{"$f":"Periodic!O10","v":2992500},{"$f":"Periodic!P10","v":90},{"$f":"Periodic!Q10","v":33250},{"$f":"AP21*2.5","v":16.458333333333336},148.12500000000003,82.291666666666686,1826.8750000000002,18285.208333333336,182868.54166666669]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COGS Drop Down",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD22-AB25+AM26","v":1950000},null,"Sales",null,null,{"$f":"Periodic!K11","v":6678750},{"$f":"Periodic!L11","v":130},{"$f":"Periodic!M11","v":51375},null,{"$f":"Periodic!O11","v":856250},{"$f":"Periodic!P11","v":25},{"$f":"Periodic!Q11","v":34250}]
[null,{"$f":"T29","v":"2008-08-03"},null,{"$f":"V29","v":"90 units @ $33,250 each = "},{"$f":"W29","v":2992500},null,null,null,null,null,null,{"$f":"L26","v":0},null,null,null,{"$f":"$AB$38","v":"30 x $32,250 = $967,500"},null,null,null,{"$f":"G8","v":"2008-08-03"},null,{"$f":"CONCATENATE(AF25,\" = \")","v":"90 units @ $33,250 each = "},{"$f":"$AM$27","v":2992500},null,null,null,null,null,null,{"$f":"AD26","v":"30 x $32,250 = $967,500"},null,{"$f":"CONCATENATE(AJ26,\" units @ \",TEXT(AK26,\"$#,##0\"),\" each\")","v":"90 units @ $49,125 each"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L27","v":0},null,null,null,{"$f":"$AB$39","v":"30 x $32,750 = $982,500"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD27","v":"30 x $32,750 = $982,500"},null,{"$f":"CONCATENATE(AJ28,\" units @ \",TEXT(AK28,\"$#,##0\"),\" each\")","v":"130 units @ $51,375 each"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AB$24","v":"40 x $32,250 = $1,290,000"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AN27, \" x \", TEXT(AO27, \"$#,##0\"), \" = \", TEXT(AN27*AO27, \"$#,##0\"))","v":"90 x $33,250 = $2,992,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AB$23","v":"50 x $31,250 = $1,562,500"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD28+AM27","v":4942500},null,null,null,null,"COMMENTS:\nAB24, AB40, AB56, AB72, AD24, AD26, AD40, AD56, AD73 : These cell's formulas contains a hard coded value and will need to be updated if the purchased/sold quantity is changed"]
[null,{"$f":"T33","v":"2008-10-11"},null,{"$f":"V33","v":"25 units @ $34,250 each = "},{"$f":"W33","v":856250},null,null,null,null,null,null,{"$f":"L29","v":0},null,null,null,{"$f":"$AB$40","v":"70 x $33,250 = $2,327,500"},null,null,null,{"$f":"G9","v":"2008-10-11"},null,{"$f":"CONCATENATE(AF26,\" = \")","v":"25 units @ $34,250 each = "},{"$f":"$AM$28","v":856250},null,null,null,null,null,null,{"$f":"AD29","v":"30 x $32,250 = $967,500"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD30","v":"30 x $32,750 = $982,500"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L31","v":0},null,null,"Total Drop Down",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD31","v":"90 x $33,250 = $2,992,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$42","v":1521250},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AN28, \" x \", TEXT(AO28, \"$#,##0\"), \" = \", TEXT(AM28, \"$#,##0\"))","v":"25 x $34,250 = $856,250"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$28","v":1950000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD32+AM28","v":5798750}]
[null,{"$f":"T38","v":"2017-11-01"},null,null,null,null,{"$f":"Y38","v":"130 units @ $51,375 each = "},{"$f":"Z38","v":6678750},null,null,null,null,null,null,null,{"$f":"$AB$25","v":2852500},null,null,null,{"$f":"G13","v":"2017-11-01"},null,null,null,null,{"$f":"CONCATENATE(AF30,\" = \")","v":"130 units @ $51,375 each = "},{"$f":"$AI$28","v":6678750},null,{"$f":"AD33","v":"30 x $32,250 = $967,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$22","v":3820000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD34","v":"30 x $32,750 = $982,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AB$41","v":4277500},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(70, \" x \", TEXT(AO27,\"$#,##0\"), \" = \", TEXT(AO27*70,\"$#,##0\"))","v":"70 x $33,250 = $2,327,500"},null,{"$f":"CONCATENATE(20, \" x \", TEXT(AO27, \"$#,##0\"), \" = \", TEXT(20*AO27, \"$#,##0\"))","v":"20 x $33,250 = $665,000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$32","v":4942500},null,null,null,null,null,null,null,null,null,null,null,{"$f":"30*AO25+AM26+70*AO27","v":4277500},null,{"$f":"AD36","v":"25 x $34,250 = $856,250"}]
[null,null,null,null,null,null,"Total Sales",{"$f":"H38+H23","v":11100000},null,null,null,{"$f":"L37-J41","v":0},null,null,null,{"$f":"$AD$37","v":5798750},null,null,null,null,null,null,null,null,"Total Sales",{"$f":"Z38+Z23","v":11100000},null,null,null,{"$f":"AD37-AB41","v":1521250}]
[null,null,null,null,null,null,"Less COGS",{"$f":"J41+J25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less COGS",{"$f":"AB41+AB25","v":7130000}]
[null," ",null,null,null,null,"Gross Profit",{"$f":"H42-H43","v":11100000},null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"Gross Profit",{"$f":"Z42-Z43","v":3970000}]
[]
[]
[]
["(d)",{"$f":" CONCATENATE(\"If \",Identification!B1, \" Corporation uses the last-in, first-out (LIFO) inventory method (perpetual approach), what values would be assigned to ending inventory and cost of goods sold?  How much is gross profit?\")","v":"If Your Name Here Corporation uses the last-in, first-out (LIFO) inventory method (perpetual approach), what values would be assigned to ending inventory and cost of goods sold?  How much is gross profit?"}]
[]
[null,"Date",null,"Purchases",null,null,"Sales",null,null,"Cost of Goods Sold",null,"Balance",null,null,"Balance Drop Down",null,null,null,null,"Date",null,"Purchases",null,null,"Sales",null,null,"Cost of Goods Sold",null,"Balance"]
[null,{"$f":"T51","v":"2008-01-07"},null,{"$f":"V51","v":"50 units @ $31,250 each ="},{"$f":"W51","v":1562500},null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$73","v":"15 x $32,750 = $491,250"},null,null,null,{"$f":"T19","v":"2008-01-07"},null,{"$f":"V19","v":"50 units @ $31,250 each ="},{"$f":"$AM$24","v":1562500},null,null,null,null,null,null,{"$f":"AD19","v":"50 x $31,250 = $1,562,500"}]
[null,{"$f":"T52","v":"2008-03-15"},null,{"$f":"V52","v":"70 units @ $32,250 each ="},{"$f":"W52","v":2257500},null,null,null,null,null,null,{"$f":"L51","v":0},null,null,null,{"$f":"$AD$68","v":"25 x $34,250 = $856,250"},null,null,null,{"$f":"T20","v":"2008-03-15"},null,{"$f":"V20","v":"70 units @ $32,250 each ="},{"$f":"$AM$25","v":2257500},null,null,null,null,null,null,{"$f":"AD20","v":"50 x $31,250 = $1,562,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$56","v":"30 x $31,250 = $937,500"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD21","v":"70 x $32,250 = $2,257,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$59","v":"30 x $32,750 = $982,500"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD22","v":3820000}]
[null,{"$f":"T55","v":"2017-03-16"},null,null,null,null,{"$f":"Y55","v":"90 units @ $49,125 each = "},{"$f":"Z55","v":4421250},null,null,null,null,null,null,null,{"$f":"$AD$51","v":"50 x $31,250 = $1,562,500"},null,null,null,{"$f":"T23","v":"2017-03-16"},null,null,null,null,{"$f":"Y23","v":"90 units @ $49,125 each = "},{"$f":"$AI$26","v":4421250},null,{"$f":"AD53","v":"70 x $32,250 = $2,257,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"$AD$53","v":"70 x $32,250 = $2,257,500"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"20 x \",TEXT(AO24,\"$#,##0\"),\" = \",TEXT(20*AO24,\"$#,##0\"))","v":"20 x $31,250 = $625,000"},null,{"$f":"CONCATENATE(\"30 x \",TEXT(AO24,\"$#,##0\"),\" = \",TEXT(30*AO24,\"$#,##0\"))","v":"30 x $31,250 = $937,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$63","v":"90 x $33,250 = $2,992,500"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM25+20*AO24","v":2882500}]
[null,{"$f":"T58","v":"2008-06-16"},null,{"$f":"V58","v":"30 units @ $32,750 each = "},{"$f":"W58","v":982500},null,null,null,null,null,null,{"$f":"L56","v":0},null,null,null,null,null,null,null,{"$f":"T26","v":"2008-06-16"},null,{"$f":"V26","v":"30 units @ $32,750 each = "},{"$f":"$AM$26","v":982500},null,null,null,null,null,null,{"$f":"AD56","v":"30 x $31,250 = $937,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COGS Drop Down",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD27","v":"30 x $32,750 = $982,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AB$72","v":"15 x $32,750 = $491,250"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD54-AB57+AM26","v":1920000}]
[null,{"$f":"T61","v":"2008-08-03"},null,{"$f":"V61","v":"90 units @ $33,250 each = "},{"$f":"W61","v":2992500},null,null,null,null,null,null,{"$f":"L58","v":0},null,null,null,{"$f":"$AB$56","v":"20 x $31,250 = $625,000"},null,null,null,{"$f":"T29","v":"2008-08-03"},null,{"$f":"V29","v":"90 units @ $33,250 each = "},{"$f":"$AM$27","v":2992500},null,null,null,null,null,null,{"$f":"AD58","v":"30 x $31,250 = $937,500"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L59","v":0},null,null,null,{"$f":"$AB$70","v":"25 x $34,250 = $856,250"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD59","v":"30 x $32,750 = $982,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AB$55","v":"70 x $32,250 = $2,257,500"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD31","v":"90 x $33,250 = $2,992,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AB$71","v":"90 x $33,250 = $2,992,500"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD60+AM27","v":4912500}]
[null,{"$f":"T65","v":"2008-10-11"},null,{"$f":"V65","v":"25 units @ $34,250 each = "},{"$f":"W65","v":856250},null,null,null,null,null,null,{"$f":"L61","v":0},null,null,null,null,null,null,null,{"$f":"T33","v":"2008-10-11"},null,{"$f":"V33","v":"25 units @ $34,250 each = "},{"$f":"$AM$28","v":856250},null,null,null,null,null,null,{"$f":"AD61","v":"30 x $31,250 = $937,500"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L62","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD62","v":"30 x $32,750 = $982,500"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L63","v":0},null,null,"Total Drop Down",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD63","v":"90 x $33,250 = $2,992,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$74","v":1428750},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD36","v":"25 x $34,250 = $856,250"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$60","v":1920000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD64+AM28","v":5768750}]
[null,{"$f":"T70","v":"2017-11-01"},null,null,null,null,{"$f":"Y70","v":"130 units @ $51,375 each = "},{"$f":"Z70","v":6678750},null,null,null,null,null,null,null,{"$f":"$AB$57","v":2882500},null,null,null,{"$f":"T38","v":"2017-11-01"},null,null,null,null,{"$f":"Y38","v":"130 units @ $51,375 each = "},{"$f":"$AI$28","v":6678750},null,{"$f":"AD68","v":"25 x $34,250 = $856,250"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$54","v":3820000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD67","v":"90 x $33,250 = $2,992,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AB$73","v":4340000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(15, \" x \", TEXT(AO26,\"$#,##0\"), \" = \", TEXT(AO26*15,\"$#,##0\"))","v":"15 x $32,750 = $491,250"},null,{"$f":"AD65","v":"30 x $31,250 = $937,500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AD$64","v":4912500},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM28+AM27+15*AO26","v":4340000},null,{"$f":"CONCATENATE(\"15 x \",TEXT(AO26, \"$#,##0\"), \" = \", TEXT(15*AO26, \"$#,##0\"))","v":"15 x $32,750 = $491,250"}]
[null,null,null,null,null,null,"Total Sales",{"$f":"H70+H55","v":11100000},null,null,null,{"$f":"L69-J73","v":0},null,null,null,{"$f":"$AD$69","v":5768750},null,null,null,null,null,null,null,null,"Total Sales",{"$f":"Z70+Z55","v":11100000},null,null,null,{"$f":"AD69-AB73","v":1428750}]
[null,null,null,null,null,null,"Less COGS",{"$f":"J73+J57","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less COGS",{"$f":"AB73+AB57","v":7222500}]
[null,null,null,null,null,null,"Gross Profit",{"$f":"H74-H75","v":11100000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross Profit",{"$f":"Z74-Z75","v":3877500}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A period of falling costs"]
["(e)","The LIFO method of accounting for inventory will always yield a higher cost of goods sold and thus a lower tax liability under which of the situation?",null,null,null,null,null,null,null,null,null,null,null,null,null,"A period of rising costs"]