{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cost of Sales Tool"],"not_rendered":{"charts":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Cost of Sales Tool","index":0,"n_rows":41,"n_cols":6,"rows_kept":41,"merged":[[28,1,28,5],[29,1,29,5]]}
[]
[null,"[COMPANY NAME]"]
[null,"COST OF SALES TOOL"]
[null,"[DATE]"]
[]
[null,"COST OF SALES"]
{"$rows_empty":19}
[null,"DATA MODEL"]
[]
[null,"Model key:"]
[null,"White cells are fields that you can edit."]
[null,"Gray cells are calculated for you and should not be changed."]
[]
[null,"Customer name","Annual Total Sales","Annual Cost of Sales","Gross profit","Cost of sales %"]
[null,"Proseware, Inc.",{"v":2865,"d":"$2,865.00"},{"v":221,"d":"$221.00"},{"$f":"IFERROR(IF(SUM(C33-D33)=0,\"\",SUM(C33-D33)),\"\")","v":{"v":2644,"d":"$2,644.00"}},{"$f":"IFERROR(SUM(D33/C33),\"\")","v":{"v":0.07713787085514834,"d":"7.71%"}}]
[null,"A. Datum Corporation",{"v":23000,"d":"$23,000.00"},{"v":3210,"d":"$3,210.00"},{"v":19790,"d":"$19,790.00"},{"v":0.13956521739130434,"d":"13.96%"}]
[null,"Margie's Travel",{"v":5678,"d":"$5,678.00"},{"v":1234,"d":"$1,234.00"},{"v":4444,"d":"$4,444.00"},{"v":0.2173300457907714,"d":"21.73%"}]
[null,"The Phone Company",{"v":8540,"d":"$8,540.00"},{"v":2210,"d":"$2,210.00"},{"v":6330,"d":"$6,330.00"},{"v":0.25878220140515223,"d":"25.88%"}]
[null,"Coho Winery",{"v":45752,"d":"$45,752.00"},{"v":12456,"d":"$12,456.00"},{"v":33296,"d":"$33,296.00"},{"v":0.272250393425424,"d":"27.23%"}]
[null,"Tailspin Toys",{"v":22000,"d":"$22,000.00"},{"v":12131,"d":"$12,131.00"},{"v":9869,"d":"$9,869.00"},{"v":0.551409090909091,"d":"55.14%"}]
[null,"Fabrikam, Inc.",{"v":1523,"d":"$1,523.00"},{"v":854,"d":"$854.00"},{"v":669,"d":"$669.00"},{"v":0.5607353906762967,"d":"56.07%"}]
[null,"Wingtip Toys",{"v":17154,"d":"$17,154.00"},{"v":11546,"d":"$11,546.00"},{"v":5608,"d":"$5,608.00"},{"v":0.6730791652092807,"d":"67.31%"}]
[{"$nulls":3},"Total Gross Profit:",{"$f":"SUBTOTAL(109,tblData[Gross profit])","v":{"v":82650,"d":"$82,650.00"}},{"$f":"SUBTOTAL(101,tblData[Cost of sales %])","v":{"v":0.3437861719578086,"d":"34%"}}]