{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Merchandise Plan"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Merchandise Plan","index":0,"n_rows":198,"n_cols":29,"rows_kept":198,"merged":[[31,1,31,14]]}
[]
[]
[null,"Merchandise Plan"]
[null,"For Jul-2008 through Jun-2009"]
[]
[]
[null,null,"Jul",{"$f":"INDEX(R197:AC197,1,S198+1)","v":"Aug"},{"$f":"INDEX(R197:AC197,1,T198+1)","v":"Sep"},{"$f":"INDEX(R197:AC197,1,U198+1)","v":"Oct"},{"$f":"INDEX(R197:AC197,1,V198+1)","v":"Nov"},{"$f":"INDEX(R197:AC197,1,W198+1)","v":"Dec"},{"$f":"INDEX(R197:AC197,1,X198+1)","v":"Jan"},{"$f":"INDEX(R197:AC197,1,Y198+1)","v":"Feb"},{"$f":"INDEX(R197:AC197,1,Z198+1)","v":"Mar"},{"$f":"INDEX(R197:AC197,1,AA198+1)","v":"Apr"},{"$f":"INDEX(R197:AC197,1,AB198+1)","v":"May"},{"$f":"INDEX(R197:AC197,1,AC198+1)","v":"Jun"},"Year"]
[]
[null,"Beginning Inventory",{"v":48231,"d":"$48,231"},{"$f":"IF(C19,C19,\"\")","v":{"v":41611,"d":"$41,611"}},{"v":45511,"d":"$45,511"},{"v":48709,"d":"$48,709"},{"v":65916,"d":"$65,916"},{"v":75606,"d":"$75,606"},{"v":69415,"d":"$69,415"},{"v":54804,"d":"$54,804"},{"v":51901,"d":"$51,901"},{"v":47610,"d":"$47,610"},{"v":42110,"d":"$42,110"},{"v":43279,"d":"$43,279"},{"$f":"IF(SUM(C9:N9),C9,\"\")","v":{"v":48231,"d":"$48,231"}}]
[]
[null,"Sales",{"v":72000,"d":"$72,000"},{"v":87000,"d":"$87,000"},{"v":98000,"d":"$98,000"},{"v":105000,"d":"$105,000"},{"v":110000,"d":"$110,000"},{"v":175000,"d":"$175,000"},{"v":85000,"d":"$85,000"},{"v":90000,"d":"$90,000"},{"v":95000,"d":"$95,000"},{"v":83000,"d":"$83,000"},{"v":84000,"d":"$84,000"},{"v":89000,"d":"$89,000"},{"$f":"IF(SUM(C11:N11),SUM(C11:N11),\"\")","v":{"v":1173000,"d":"$1,173,000"}}]
[]
[null,"Reductions:"]
[null,"     Employee discounts",{"v":365,"d":"$365"},{"v":206,"d":"$206"},{"v":668,"d":"$668"},{"v":1,"d":"$1"},{"v":501,"d":"$501"},{"v":1636,"d":"$1,636"},{"v":838,"d":"$838"},{"v":275,"d":"$275"},{"v":78,"d":"$78"},{"v":522,"d":"$522"},{"v":29,"d":"$29"},{"v":91,"d":"$91"},{"$f":"IF(SUM(C14:N14),SUM(C14:N14),\"\")","v":{"v":5210,"d":"$5,210"}}]
[null,"     Shortages",{"v":284,"d":"$284"},{"v":1266,"d":"$1,266"},{"v":1469,"d":"$1,469"},{"v":1418,"d":"$1,418"},{"v":1651,"d":"$1,651"},{"v":1665,"d":"$1,665"},{"v":820,"d":"$820"},{"v":1632,"d":"$1,632"},{"v":754,"d":"$754"},{"v":1976,"d":"$1,976"},{"v":841,"d":"$841"},{"v":1964,"d":"$1,964"},{"$f":"IF(SUM(C15:N15),SUM(C15:N15),\"\")","v":{"v":15740,"d":"$15,740"}}]
[null,"     Markdowns",{"v":1322,"d":"$1,322"},{"v":3433,"d":"$3,433"},{"v":4097,"d":"$4,097"},{"v":2825,"d":"$2,825"},{"v":373,"d":"$373"},{"v":511,"d":"$511"},{"v":1992,"d":"$1,992"},{"v":2674,"d":"$2,674"},{"v":3484,"d":"$3,484"},{"v":2982,"d":"$2,982"},{"v":2840,"d":"$2,840"},{"v":2963,"d":"$2,963"},{"$f":"IF(SUM(C16:N16),SUM(C16:N16),\"\")","v":{"v":29496,"d":"$29,496"}}]
[null,"         Total",{"$f":"IF(SUM(C14:C16),SUM(C14:C16),\"\")","v":{"v":1971,"d":"$1,971"}},{"v":4905,"d":"$4,905"},{"v":6234,"d":"$6,234"},{"v":4244,"d":"$4,244"},{"v":2525,"d":"$2,525"},{"v":3812,"d":"$3,812"},{"v":3650,"d":"$3,650"},{"v":4581,"d":"$4,581"},{"v":4316,"d":"$4,316"},{"v":5480,"d":"$5,480"},{"v":3710,"d":"$3,710"},{"v":5018,"d":"$5,018"},{"$f":"IF(SUM(C17:N17),SUM(C17:N17),\"\")","v":{"v":50446,"d":"$50,446"}}]
[]
[null,"Ending Inventory",{"v":41611,"d":"$41,611"},{"v":45511,"d":"$45,511"},{"v":48709,"d":"$48,709"},{"v":65916,"d":"$65,916"},{"v":75606,"d":"$75,606"},{"v":69415,"d":"$69,415"},{"v":54804,"d":"$54,804"},{"v":51901,"d":"$51,901"},{"v":47610,"d":"$47,610"},{"v":42110,"d":"$42,110"},{"v":43279,"d":"$43,279"},{"v":42113,"d":"$42,113"},{"$f":"IF(SUM(C19:N19),N19,\"\")","v":{"v":42113,"d":"$42,113"}}]
[]
[null,"Retail Purchases",{"$f":"IF(AND(ISNUMBER(C11),ISNUMBER(C17),ISNUMBER(C19),ISNUMBER(C9)),C11+C17+C19-C9,\"\")","v":{"v":67351,"d":"$67,351"}},{"v":95805,"d":"$95,805"},{"v":107432,"d":"$107,432"},{"v":126451,"d":"$126,451"},{"v":122215,"d":"$122,215"},{"v":172621,"d":"$172,621"},{"v":74039,"d":"$74,039"},{"v":91678,"d":"$91,678"},{"v":95025,"d":"$95,025"},{"v":82980,"d":"$82,980"},{"v":88879,"d":"$88,879"},{"v":92852,"d":"$92,852"},{"$f":"IF(SUM(C21:N21),SUM(C21:N21),\"\")","v":{"v":1217328,"d":"$1,217,328"}}]
[]
[null,"Average Markup",{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.52,"d":"52%"},{"v":0.47,"d":"47%"},{"v":0.48,"d":"48%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"$f":"IF(OR(ISNUMBER(O21),ISNUMBER(O25)),O21/O25-1,\"\")","v":{"v":0.49941054315305244,"d":"50%"}}]
[]
[null,"Purchases at Cost",{"$f":"IF(ISNUMBER(C21),C21/(1+C23),\"\")","v":{"v":44900.666666666664,"d":"$44,901"}},{"v":63870,"d":"$63,870"},{"v":71621.33333333333,"d":"$71,621"},{"v":84300.66666666667,"d":"$84,301"},{"v":81476.66666666667,"d":"$81,477"},{"v":113566.44736842105,"d":"$113,566"},{"v":50366.666666666664,"d":"$50,367"},{"v":61944.59459459459,"d":"$61,945"},{"v":63350,"d":"$63,350"},{"v":55320,"d":"$55,320"},{"v":59252.666666666664,"d":"$59,253"},{"v":61901.333333333336,"d":"$61,901"},{"$f":"IF(SUM(C25:N25),SUM(C25:N25),\"\")","v":{"v":811871.0419630157,"d":"$811,871"}}]
[]
[null,"Cumulative Markup",{"$f":"IF(AND(ISNUMBER(C21),ISNUMBER(C25)),C21-C25,\"\")","v":{"v":22450.333333333336,"d":"$22,450"}},{"v":31935,"d":"$31,935"},{"v":35810.66666666667,"d":"$35,811"},{"v":42150.33333333333,"d":"$42,150"},{"v":40738.33333333333,"d":"$40,738"},{"v":59054.55263157895,"d":"$59,055"},{"v":23672.333333333336,"d":"$23,672"},{"v":29733.405405405407,"d":"$29,733"},{"v":31675,"d":"$31,675"},{"v":27660,"d":"$27,660"},{"v":29626.333333333336,"d":"$29,626"},{"v":30950.666666666664,"d":"$30,951"},{"$f":"IF(SUM(C27:N27),SUM(C27:N27),\"\")","v":{"v":405456.9580369843,"d":"$405,457"}}]
[]
[null,"Gross Profit",{"$f":"IF(OR(ISNUMBER(C27),ISNUMBER(C17)),C27-C17,\"\")","v":{"v":20479.333333333336,"d":"$20,479"}},{"v":27030,"d":"$27,030"},{"v":29576.66666666667,"d":"$29,577"},{"v":37906.33333333333,"d":"$37,906"},{"v":38213.33333333333,"d":"$38,213"},{"v":55242.55263157895,"d":"$55,243"},{"v":20022.333333333336,"d":"$20,022"},{"v":25152.405405405407,"d":"$25,152"},{"v":27359,"d":"$27,359"},{"v":22180,"d":"$22,180"},{"v":25916.333333333336,"d":"$25,916"},{"v":25932.666666666664,"d":"$25,933"},{"$f":"IF(SUM(C29:N29),SUM(C29:N29),\"\")","v":{"v":355010.9580369844,"d":"$355,011"}}]
{"$rows_empty":166}
[{"$nulls":17},"MONTH TABLE: DO NOT CHANGE"]
[{"$nulls":17},"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[{"$nulls":17},{"$f":"MATCH(PROPER(LEFT(TRIM(C7),3)),R197:AC197,0)-1","v":6},{"$f":"IF(R198=11,0,R198+1)","v":7},8,9,10,11,0,1,2,3,4,5]