{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Rolling Budget and Forecast"],"read":"whole","date_system":"1900"}

{"sheet":"Rolling Budget and Forecast","index":0,"n_rows":81,"n_cols":18,"rows_kept":81}
[]
[]
["<COMPANY NAME>"]
["Rolling Budget and Business Forecast"]
["<Date>"]
[]
["Line Item","January","February","March","Q1","April","May","June","Q2","July","August","September","Q3","October","November","December","Q4","Annual"]
["PROFIT AND LOSS"]
["Revenue"]
["Budget",{"v":65000,"d":"$65,000"},{"v":75000,"d":"$75,000"},{"v":85000,"d":"$85,000"},{"v":225000,"d":"$225,000"},{"v":75000,"d":"$75,000"},{"v":80000,"d":"$80,000"},{"v":90000,"d":"$90,000"},{"v":245000,"d":"$245,000"},{"v":95000,"d":"$95,000"},{"v":100000,"d":"$100,000"},{"v":105000,"d":"$105,000"},{"v":300000,"d":"$300,000"},{"v":120000,"d":"$120,000"},{"v":130000,"d":"$130,000"},{"v":145000,"d":"$145,000"},{"v":395000,"d":"$395,000"},{"v":1165000,"d":"$1,165,000"}]
["Actual",{"v":60000,"d":"$60,000"},{"v":70000,"d":"$70,000"},{"v":88000,"d":"$88,000"},{"v":218000,"d":"$218,000"},{"v":95000,"d":"$95,000"},{"v":65000,"d":"$65,000"},{"v":88000,"d":"$88,000"},{"v":248000,"d":"$248,000"},{"v":95000,"d":"$95,000"},{"v":100000,"d":"$100,000"},{"v":105000,"d":"$105,000"},{"v":300000,"d":"$300,000"},{"v":120000,"d":"$120,000"},{"v":130000,"d":"$130,000"},{"v":145000,"d":"$145,000"},{"v":395000,"d":"$395,000"},{"v":1161000,"d":"$1,161,000"}]
["Budget variance (Actual – Budget)",{"$f":"B11-B10","v":{"v":-5000,"d":"($5,000)"}},{"$f":"C11-C10","v":{"v":-5000,"d":"($5,000)"}},{"v":3000,"d":"$3,000"},{"v":-7000,"d":"($7,000)"},{"v":20000,"d":"$20,000"},{"v":-15000,"d":"($15,000)"},{"v":-2000,"d":"($2,000)"},{"v":3000,"d":"$3,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":-4000,"d":"($4,000)"}]
["Prior year",{"v":55000,"d":"$55,000"},{"v":60000,"d":"$60,000"},{"v":70000,"d":"$70,000"},{"v":185000,"d":"$185,000"},{"v":75000,"d":"$75,000"},{"v":80000,"d":"$80,000"},{"v":90000,"d":"$90,000"},{"v":245000,"d":"$245,000"},{"v":90000,"d":"$90,000"},{"v":95000,"d":"$95,000"},{"v":100000,"d":"$100,000"},{"v":285000,"d":"$285,000"},{"v":110000,"d":"$110,000"},{"v":120000,"d":"$120,000"},{"v":130000,"d":"$130,000"},{"v":360000,"d":"$360,000"},{"v":1075000,"d":"$1,075,000"}]
["Prior year variance (Actual – Prior year)",{"$f":"B11-B13","v":{"v":5000,"d":"$5,000"}},{"$f":"C11-C13","v":{"v":10000,"d":"$10,000"}},{"v":18000,"d":"$18,000"},{"v":33000,"d":"$33,000"},{"v":20000,"d":"$20,000"},{"v":-15000,"d":"($15,000)"},{"v":-2000,"d":"($2,000)"},{"v":3000,"d":"$3,000"},{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},{"v":15000,"d":"$15,000"},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":15000,"d":"$15,000"},{"v":35000,"d":"$35,000"},{"v":86000,"d":"$86,000"}]
["Cost of Goods Sold"]
["Budget",{"v":50000,"d":"$50,000"},{"v":55000,"d":"$55,000"},{"v":65000,"d":"$65,000"},{"v":170000,"d":"$170,000"},{"v":55000,"d":"$55,000"},{"v":60000,"d":"$60,000"},{"v":70000,"d":"$70,000"},{"v":185000,"d":"$185,000"},{"v":70000,"d":"$70,000"},{"v":75000,"d":"$75,000"},{"v":80000,"d":"$80,000"},{"v":225000,"d":"$225,000"},{"v":90000,"d":"$90,000"},{"v":100000,"d":"$100,000"},{"v":125000,"d":"$125,000"},{"v":315000,"d":"$315,000"},{"v":895000,"d":"$895,000"}]
["Actual",{"v":47500,"d":"$47,500"},{"v":55000,"d":"$55,000"},{"v":63000,"d":"$63,000"},{"v":165500,"d":"$165,500"},{"v":45000,"d":"$45,000"},{"v":55000,"d":"$55,000"},{"v":63000,"d":"$63,000"},{"v":163000,"d":"$163,000"},{"v":70000,"d":"$70,000"},{"v":75000,"d":"$75,000"},{"v":80000,"d":"$80,000"},{"v":225000,"d":"$225,000"},{"v":90000,"d":"$90,000"},{"v":100000,"d":"$100,000"},{"v":125000,"d":"$125,000"},{"v":315000,"d":"$315,000"},{"v":868500,"d":"$868,500"}]
["Budget variance (Budget – Actual)",{"$f":"B16-B17","v":{"v":2500,"d":"$2,500"}},{"$f":"C16-C17","v":{"v":0,"d":"$0"}},{"v":2000,"d":"$2,000"},{"v":4500,"d":"$4,500"},{"v":10000,"d":"$10,000"},{"v":5000,"d":"$5,000"},{"v":7000,"d":"$7,000"},{"v":22000,"d":"$22,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":26500,"d":"$26,500"}]
["Prior year",{"v":45000,"d":"$45,000"},{"v":48000,"d":"$48,000"},{"v":54000,"d":"$54,000"},{"v":147000,"d":"$147,000"},{"v":49000,"d":"$49,000"},{"v":51000,"d":"$51,000"},{"v":56000,"d":"$56,000"},{"v":156000,"d":"$156,000"},{"v":70000,"d":"$70,000"},{"v":80000,"d":"$80,000"},{"v":85000,"d":"$85,000"},{"v":235000,"d":"$235,000"},{"v":95000,"d":"$95,000"},{"v":105000,"d":"$105,000"},{"v":115000,"d":"$115,000"},{"v":315000,"d":"$315,000"},{"v":853000,"d":"$853,000"}]
["Prior year variance (Prior year – Actual)",{"$f":"B19-B17","v":{"v":-2500,"d":"($2,500)"}},{"$f":"C19-C17","v":{"v":-7000,"d":"($7,000)"}},{"v":-9000,"d":"($9,000)"},{"v":-18500,"d":"($18,500)"},{"v":4000,"d":"$4,000"},{"v":-4000,"d":"($4,000)"},{"v":-7000,"d":"($7,000)"},{"v":-7000,"d":"($7,000)"},{"v":0,"d":"$0"},{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},{"v":10000,"d":"$10,000"},{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},{"v":-10000,"d":"($10,000)"},{"v":0,"d":"$0"},{"v":-15500,"d":"($15,500)"}]
["Sales and Marketing Costs"]
["Budget",{"v":8000,"d":"$8,000"},{"v":3000,"d":"$3,000"},{"v":4000,"d":"$4,000"},{"v":15000,"d":"$15,000"},{"v":6000,"d":"$6,000"},{"v":7000,"d":"$7,000"},{"v":8000,"d":"$8,000"},{"v":21000,"d":"$21,000"},{"v":7500,"d":"$7,500"},{"v":8500,"d":"$8,500"},{"v":9000,"d":"$9,000"},{"v":25000,"d":"$25,000"},{"v":8000,"d":"$8,000"},{"v":10000,"d":"$10,000"},{"v":6500,"d":"$6,500"},{"v":24500,"d":"$24,500"},{"v":85500,"d":"$85,500"}]
["Actual",{"v":10000,"d":"$10,000"},{"v":4000,"d":"$4,000"},{"v":3000,"d":"$3,000"},{"v":17000,"d":"$17,000"},{"v":5000,"d":"$5,000"},{"v":6500,"d":"$6,500"},{"v":7500,"d":"$7,500"},{"v":19000,"d":"$19,000"},{"v":7500,"d":"$7,500"},{"v":8500,"d":"$8,500"},{"v":9000,"d":"$9,000"},{"v":25000,"d":"$25,000"},{"v":8000,"d":"$8,000"},{"v":10000,"d":"$10,000"},{"v":6500,"d":"$6,500"},{"v":24500,"d":"$24,500"},{"v":85500,"d":"$85,500"}]
["Budget variance (Budget – Actual)",{"$f":"B22-B23","v":{"v":-2000,"d":"($2,000)"}},{"$f":"C22-C23","v":{"v":-1000,"d":"($1,000)"}},{"v":1000,"d":"$1,000"},{"v":-2000,"d":"($2,000)"},{"v":1000,"d":"$1,000"},{"v":500,"d":"$500"},{"v":500,"d":"$500"},{"v":2000,"d":"$2,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Prior year",{"v":7000,"d":"$7,000"},{"v":6000,"d":"$6,000"},{"v":5000,"d":"$5,000"},{"v":18000,"d":"$18,000"},{"v":5000,"d":"$5,000"},{"v":6000,"d":"$6,000"},{"v":7000,"d":"$7,000"},{"v":18000,"d":"$18,000"},{"v":7000,"d":"$7,000"},{"v":8000,"d":"$8,000"},{"v":8000,"d":"$8,000"},{"v":23000,"d":"$23,000"},{"v":8000,"d":"$8,000"},{"v":9000,"d":"$9,000"},{"v":7000,"d":"$7,000"},{"v":24000,"d":"$24,000"},{"v":83000,"d":"$83,000"}]
["Prior year variance (Prior year – Actual)",{"$f":"B25-B23","v":{"v":-3000,"d":"($3,000)"}},{"$f":"C25-C23","v":{"v":2000,"d":"$2,000"}},{"v":2000,"d":"$2,000"},{"v":1000,"d":"$1,000"},{"v":0,"d":"$0"},{"v":-500,"d":"($500)"},{"v":-500,"d":"($500)"},{"v":-1000,"d":"($1,000)"},{"v":-500,"d":"($500)"},{"v":-500,"d":"($500)"},{"v":-1000,"d":"($1,000)"},{"v":-2000,"d":"($2,000)"},{"v":0,"d":"$0"},{"v":-1000,"d":"($1,000)"},{"v":500,"d":"$500"},{"v":-500,"d":"($500)"},{"v":-2500,"d":"($2,500)"}]
["Labor Expense"]
["Budget",{"v":35000,"d":"$35,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":115000,"d":"$115,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":45000,"d":"$45,000"},{"v":125000,"d":"$125,000"},{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"},{"v":50000,"d":"$50,000"},{"v":140000,"d":"$140,000"},{"v":50000,"d":"$50,000"},{"v":55000,"d":"$55,000"},{"v":55000,"d":"$55,000"},{"v":160000,"d":"$160,000"},{"v":540000,"d":"$540,000"}]
["Actual",{"v":40000,"d":"$40,000"},{"v":41000,"d":"$41,000"},{"v":42000,"d":"$42,000"},{"v":123000,"d":"$123,000"},{"v":42000,"d":"$42,000"},{"v":43000,"d":"$43,000"},{"v":45000,"d":"$45,000"},{"v":130000,"d":"$130,000"},{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"},{"v":50000,"d":"$50,000"},{"v":140000,"d":"$140,000"},{"v":50000,"d":"$50,000"},{"v":55000,"d":"$55,000"},{"v":55000,"d":"$55,000"},{"v":160000,"d":"$160,000"},{"v":553000,"d":"$553,000"}]
["Budget variance (Budget – Actual)",{"$f":"B28-B29","v":{"v":-5000,"d":"($5,000)"}},{"$f":"C28-C29","v":{"v":-1000,"d":"($1,000)"}},{"v":-2000,"d":"($2,000)"},{"v":-8000,"d":"($8,000)"},{"v":-2000,"d":"($2,000)"},{"v":-3000,"d":"($3,000)"},{"v":0,"d":"$0"},{"v":-5000,"d":"($5,000)"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":-13000,"d":"($13,000)"}]
["Prior year",{"v":20000,"d":"$20,000"},{"v":25000,"d":"$25,000"},{"v":30000,"d":"$30,000"},{"v":75000,"d":"$75,000"},{"v":30000,"d":"$30,000"},{"v":31000,"d":"$31,000"},{"v":33000,"d":"$33,000"},{"v":94000,"d":"$94,000"},{"v":34000,"d":"$34,000"},{"v":35000,"d":"$35,000"},{"v":36000,"d":"$36,000"},{"v":105000,"d":"$105,000"},{"v":37000,"d":"$37,000"},{"v":38000,"d":"$38,000"},{"v":37000,"d":"$37,000"},{"v":112000,"d":"$112,000"},{"v":386000,"d":"$386,000"}]
["Prior year variance (Prior year – Actual)",{"$f":"B31-B29","v":{"v":-20000,"d":"($20,000)"}},{"$f":"C31-C29","v":{"v":-16000,"d":"($16,000)"}},{"v":-12000,"d":"($12,000)"},{"v":-48000,"d":"($48,000)"},{"v":-12000,"d":"($12,000)"},{"v":-12000,"d":"($12,000)"},{"v":-12000,"d":"($12,000)"},{"v":-36000,"d":"($36,000)"},{"v":-11000,"d":"($11,000)"},{"v":-10000,"d":"($10,000)"},{"v":-14000,"d":"($14,000)"},{"v":-35000,"d":"($35,000)"},{"v":-13000,"d":"($13,000)"},{"v":-17000,"d":"($17,000)"},{"v":-18000,"d":"($18,000)"},{"v":-48000,"d":"($48,000)"},{"v":-167000,"d":"($167,000)"}]
["General and Administrative"]
["Budget",{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":11000,"d":"$11,000"},{"v":31000,"d":"$31,000"},{"v":11000,"d":"$11,000"},{"v":12000,"d":"$12,000"},{"v":15000,"d":"$15,000"},{"v":38000,"d":"$38,000"},{"v":14000,"d":"$14,000"},{"v":15000,"d":"$15,000"},{"v":16000,"d":"$16,000"},{"v":45000,"d":"$45,000"},{"v":15000,"d":"$15,000"},{"v":18000,"d":"$18,000"},{"v":15000,"d":"$15,000"},{"v":48000,"d":"$48,000"},{"v":162000,"d":"$162,000"}]
["Actual",{"v":9000,"d":"$9,000"},{"v":10000,"d":"$10,000"},{"v":12000,"d":"$12,000"},{"v":31000,"d":"$31,000"},{"v":15000,"d":"$15,000"},{"v":13000,"d":"$13,000"},{"v":14000,"d":"$14,000"},{"v":42000,"d":"$42,000"},{"v":14000,"d":"$14,000"},{"v":15000,"d":"$15,000"},{"v":16000,"d":"$16,000"},{"v":45000,"d":"$45,000"},{"v":15000,"d":"$15,000"},{"v":18000,"d":"$18,000"},{"v":15000,"d":"$15,000"},{"v":48000,"d":"$48,000"},{"v":166000,"d":"$166,000"}]
["Budget variance (Budget – Actual)",{"$f":"B34-B35","v":{"v":1000,"d":"$1,000"}},{"$f":"C34-C35","v":{"v":0,"d":"$0"}},{"v":-1000,"d":"($1,000)"},{"v":0,"d":"$0"},{"v":-4000,"d":"($4,000)"},{"v":-1000,"d":"($1,000)"},{"v":1000,"d":"$1,000"},{"v":-4000,"d":"($4,000)"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":-4000,"d":"($4,000)"}]
["Prior year",{"v":5000,"d":"$5,000"},{"v":6000,"d":"$6,000"},{"v":7000,"d":"$7,000"},{"v":18000,"d":"$18,000"},{"v":8000,"d":"$8,000"},{"v":9000,"d":"$9,000"},{"v":10000,"d":"$10,000"},{"v":27000,"d":"$27,000"},{"v":10000,"d":"$10,000"},{"v":12000,"d":"$12,000"},{"v":13000,"d":"$13,000"},{"v":35000,"d":"$35,000"},{"v":13000,"d":"$13,000"},{"v":14000,"d":"$14,000"},{"v":14000,"d":"$14,000"},{"v":41000,"d":"$41,000"},{"v":121000,"d":"$121,000"}]
["Prior year variance (Prior year – Actual)",{"$f":"B37-B35","v":{"v":-4000,"d":"($4,000)"}},{"$f":"C37-C35","v":{"v":-4000,"d":"($4,000)"}},{"v":-5000,"d":"($5,000)"},{"v":-13000,"d":"($13,000)"},{"v":-7000,"d":"($7,000)"},{"v":-4000,"d":"($4,000)"},{"v":-4000,"d":"($4,000)"},{"v":-15000,"d":"($15,000)"},{"v":-4000,"d":"($4,000)"},{"v":-3000,"d":"($3,000)"},{"v":-3000,"d":"($3,000)"},{"v":-10000,"d":"($10,000)"},{"v":-2000,"d":"($2,000)"},{"v":-4000,"d":"($4,000)"},{"v":-1000,"d":"($1,000)"},{"v":-7000,"d":"($7,000)"},{"v":-45000,"d":"($45,000)"}]
["Operating Income"]
["Budget",{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},{"v":15000,"d":"$15,000"},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":30000,"d":"$30,000"},{"v":12500,"d":"$12,500"},{"v":12500,"d":"$12,500"},{"v":12500,"d":"$12,500"},{"v":37500,"d":"$37,500"},{"v":15000,"d":"$15,000"},{"v":15000,"d":"$15,000"},{"v":15000,"d":"$15,000"},{"v":45000,"d":"$45,000"},{"v":127500,"d":"$127,500"}]
["Actual",{"v":-5000,"d":"($5,000)"},{"v":-3000,"d":"($3,000)"},{"v":2000,"d":"$2,000"},{"v":-6000,"d":"($6,000)"},{"v":0,"d":"$0"},{"v":5000,"d":"$5,000"},{"v":7000,"d":"$7,000"},{"v":12000,"d":"$12,000"},{"v":12500,"d":"$12,500"},{"v":12500,"d":"$12,500"},{"v":12500,"d":"$12,500"},{"v":37500,"d":"$37,500"},{"v":15000,"d":"$15,000"},{"v":15000,"d":"$15,000"},{"v":15000,"d":"$15,000"},{"v":45000,"d":"$45,000"},{"v":88500,"d":"$88,500"}]
["Budget variance (Actual – Budget)",{"$f":"B41-B40","v":{"v":-10000,"d":"($10,000)"}},{"$f":"C41-C40","v":{"v":-8000,"d":"($8,000)"}},{"v":-3000,"d":"($3,000)"},{"v":-21000,"d":"($21,000)"},{"v":-10000,"d":"($10,000)"},{"v":-5000,"d":"($5,000)"},{"v":-3000,"d":"($3,000)"},{"v":-18000,"d":"($18,000)"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":-39000,"d":"($39,000)"}]
["Prior year",{"v":-5000,"d":"($5,000)"},{"v":-25000,"d":"($25,000)"},{"v":-27000,"d":"($27,000)"},{"v":-57000,"d":"($57,000)"},{"v":-15000,"d":"($15,000)"},{"v":-15000,"d":"($15,000)"},{"v":-15000,"d":"($15,000)"},{"v":-45000,"d":"($45,000)"},{"v":-33000,"d":"($33,000)"},{"v":-25000,"d":"($25,000)"},{"v":-25000,"d":"($25,000)"},{"v":-83000,"d":"($83,000)"},{"v":-30000,"d":"($30,000)"},{"v":-20000,"d":"($20,000)"},{"v":-20000,"d":"($20,000)"},{"v":-70000,"d":"($70,000)"},{"v":-255000,"d":"($255,000)"}]
["Prior year variance (Actual – Prior year)",{"$f":"B41-B43","v":{"v":0,"d":"$0"}},{"$f":"C41-C43","v":{"v":22000,"d":"$22,000"}},{"v":29000,"d":"$29,000"},{"v":51000,"d":"$51,000"},{"v":15000,"d":"$15,000"},{"v":20000,"d":"$20,000"},{"v":22000,"d":"$22,000"},{"v":57000,"d":"$57,000"},{"v":45500,"d":"$45,500"},{"v":37500,"d":"$37,500"},{"v":37500,"d":"$37,500"},{"v":120500,"d":"$120,500"},{"v":45000,"d":"$45,000"},{"v":35000,"d":"$35,000"},{"v":35000,"d":"$35,000"},{"v":115000,"d":"$115,000"},{"v":343500,"d":"$343,500"}]
["BALANCE SHEET"]
["Cash"]
["Budget",{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":42000,"d":"$42,000"},{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"},{"v":48000,"d":"$48,000"},{"v":52000,"d":"$52,000"},{"v":55000,"d":"$55,000"},{"v":55000,"d":"$55,000"},{"v":60000,"d":"$60,000"},{"v":65000,"d":"$65,000"},{"v":70000,"d":"$70,000"},{"v":70000,"d":"$70,000"},{"v":70000,"d":"$70,000"}]
["Actual",{"v":43000,"d":"$43,000"},{"v":42000,"d":"$42,000"},{"v":41000,"d":"$41,000"},{"v":41000,"d":"$41,000"},{"v":38000,"d":"$38,000"},{"v":40000,"d":"$40,000"},{"v":41000,"d":"$41,000"},{"v":41000,"d":"$41,000"},{"v":48000,"d":"$48,000"},{"v":52000,"d":"$52,000"},{"v":55000,"d":"$55,000"},{"v":55000,"d":"$55,000"},{"v":60000,"d":"$60,000"},{"v":65000,"d":"$65,000"},{"v":70000,"d":"$70,000"},{"v":70000,"d":"$70,000"},{"v":70000,"d":"$70,000"}]
["Budget variance (Actual – Budget)",{"$f":"B48-B47","v":{"v":-2000,"d":"($2,000)"}},{"$f":"C48-C47","v":{"v":-3000,"d":"($3,000)"}},{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"v":-2000,"d":"($2,000)"},{"v":-2000,"d":"($2,000)"},{"v":-4000,"d":"($4,000)"},{"v":-4000,"d":"($4,000)"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Prior year",{"v":125000,"d":"$125,000"},{"v":110000,"d":"$110,000"},{"v":95000,"d":"$95,000"},{"v":95000,"d":"$95,000"},{"v":85000,"d":"$85,000"},{"v":75000,"d":"$75,000"},{"v":65000,"d":"$65,000"},{"v":65000,"d":"$65,000"},{"v":60000,"d":"$60,000"},{"v":50000,"d":"$50,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":35000,"d":"$35,000"},{"v":30000,"d":"$30,000"},{"v":25000,"d":"$25,000"},{"v":25000,"d":"$25,000"},{"v":25000,"d":"$25,000"}]
["Prior year variance (Actual – Prior year)",{"$f":"B48-B50","v":{"v":-82000,"d":"($82,000)"}},{"$f":"C48-C50","v":{"v":-68000,"d":"($68,000)"}},{"v":-54000,"d":"($54,000)"},{"v":-54000,"d":"($54,000)"},{"v":-47000,"d":"($47,000)"},{"v":-35000,"d":"($35,000)"},{"v":-24000,"d":"($24,000)"},{"v":-24000,"d":"($24,000)"},{"v":-12000,"d":"($12,000)"},{"v":2000,"d":"$2,000"},{"v":15000,"d":"$15,000"},{"v":15000,"d":"$15,000"},{"v":25000,"d":"$25,000"},{"v":35000,"d":"$35,000"},{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"}]
["Inventory"]
["Budget",{"v":100000,"d":"$100,000"},{"v":105000,"d":"$105,000"},{"v":110000,"d":"$110,000"},{"v":110000,"d":"$110,000"},{"v":115000,"d":"$115,000"},{"v":120000,"d":"$120,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"},{"v":120000,"d":"$120,000"},{"v":120000,"d":"$120,000"},{"v":115000,"d":"$115,000"},{"v":110000,"d":"$110,000"},{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"}]
["Actual",{"v":95000,"d":"$95,000"},{"v":100000,"d":"$100,000"},{"v":105000,"d":"$105,000"},{"v":105000,"d":"$105,000"},{"v":105000,"d":"$105,000"},{"v":112000,"d":"$112,000"},{"v":118000,"d":"$118,000"},{"v":118000,"d":"$118,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"},{"v":120000,"d":"$120,000"},{"v":120000,"d":"$120,000"},{"v":115000,"d":"$115,000"},{"v":110000,"d":"$110,000"},{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"}]
["Budget variance (Actual – Budget)",{"$f":"B54-B53","v":{"v":-5000,"d":"($5,000)"}},{"$f":"C54-C53","v":{"v":-5000,"d":"($5,000)"}},{"v":-5000,"d":"($5,000)"},{"v":-5000,"d":"($5,000)"},{"v":-10000,"d":"($10,000)"},{"v":-8000,"d":"($8,000)"},{"v":-7000,"d":"($7,000)"},{"v":-7000,"d":"($7,000)"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Prior year",{"v":80000,"d":"$80,000"},{"v":85000,"d":"$85,000"},{"v":90000,"d":"$90,000"},{"v":90000,"d":"$90,000"},{"v":90000,"d":"$90,000"},{"v":100000,"d":"$100,000"},{"v":110000,"d":"$110,000"},{"v":110000,"d":"$110,000"},{"v":115000,"d":"$115,000"},{"v":105000,"d":"$105,000"},{"v":110000,"d":"$110,000"},{"v":110000,"d":"$110,000"},{"v":105000,"d":"$105,000"},{"v":95000,"d":"$95,000"},{"v":90000,"d":"$90,000"},{"v":90000,"d":"$90,000"},{"v":90000,"d":"$90,000"}]
["Prior year variance (Actual – Prior year)",{"$f":"B54-B56","v":{"v":15000,"d":"$15,000"}},{"$f":"C54-C56","v":{"v":15000,"d":"$15,000"}},{"v":15000,"d":"$15,000"},{"v":15000,"d":"$15,000"},{"v":15000,"d":"$15,000"},{"v":12000,"d":"$12,000"},{"v":8000,"d":"$8,000"},{"v":8000,"d":"$8,000"},{"v":10000,"d":"$10,000"},{"v":20000,"d":"$20,000"},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":15000,"d":"$15,000"},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"}]
["Accounts Receivable"]
["Budget",{"v":45000,"d":"$45,000"},{"v":48000,"d":"$48,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":55000,"d":"$55,000"},{"v":55000,"d":"$55,000"},{"v":54000,"d":"$54,000"},{"v":54000,"d":"$54,000"},{"v":53000,"d":"$53,000"},{"v":52000,"d":"$52,000"},{"v":51000,"d":"$51,000"},{"v":51000,"d":"$51,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
["Actual",{"v":47000,"d":"$47,000"},{"v":48000,"d":"$48,000"},{"v":49000,"d":"$49,000"},{"v":49000,"d":"$49,000"},{"v":51000,"d":"$51,000"},{"v":53000,"d":"$53,000"},{"v":54000,"d":"$54,000"},{"v":54000,"d":"$54,000"},{"v":53000,"d":"$53,000"},{"v":52000,"d":"$52,000"},{"v":51000,"d":"$51,000"},{"v":51000,"d":"$51,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
["Budget variance (Actual – Budget)",{"$f":"B60-B59","v":{"v":2000,"d":"$2,000"}},{"$f":"C60-C59","v":{"v":0,"d":"$0"}},{"v":-1000,"d":"($1,000)"},{"v":-1000,"d":"($1,000)"},{"v":-4000,"d":"($4,000)"},{"v":-2000,"d":"($2,000)"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Prior year",{"v":65000,"d":"$65,000"},{"v":63000,"d":"$63,000"},{"v":61000,"d":"$61,000"},{"v":61000,"d":"$61,000"},{"v":60000,"d":"$60,000"},{"v":58000,"d":"$58,000"},{"v":55000,"d":"$55,000"},{"v":55000,"d":"$55,000"},{"v":48000,"d":"$48,000"},{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"},{"v":47000,"d":"$47,000"},{"v":43000,"d":"$43,000"},{"v":42000,"d":"$42,000"},{"v":42000,"d":"$42,000"},{"v":42000,"d":"$42,000"}]
["Prior year variance (Actual – Prior year)",{"$f":"B60-B62","v":{"v":-18000,"d":"($18,000)"}},{"$f":"C60-C62","v":{"v":-15000,"d":"($15,000)"}},{"v":-12000,"d":"($12,000)"},{"v":-12000,"d":"($12,000)"},{"v":-9000,"d":"($9,000)"},{"v":-5000,"d":"($5,000)"},{"v":-1000,"d":"($1,000)"},{"v":-1000,"d":"($1,000)"},{"v":5000,"d":"$5,000"},{"v":7000,"d":"$7,000"},{"v":6000,"d":"$6,000"},{"v":6000,"d":"$6,000"},{"v":3000,"d":"$3,000"},{"v":7000,"d":"$7,000"},{"v":8000,"d":"$8,000"},{"v":8000,"d":"$8,000"},{"v":8000,"d":"$8,000"}]
["Net Fixed Assets"]
["Budget",{"v":250000,"d":"$250,000"},{"v":245000,"d":"$245,000"},{"v":240000,"d":"$240,000"},{"v":240000,"d":"$240,000"},{"v":235000,"d":"$235,000"},{"v":230000,"d":"$230,000"},{"v":225000,"d":"$225,000"},{"v":225000,"d":"$225,000"},{"v":300000,"d":"$300,000"},{"v":295000,"d":"$295,000"},{"v":290000,"d":"$290,000"},{"v":290000,"d":"$290,000"},{"v":285000,"d":"$285,000"},{"v":280000,"d":"$280,000"},{"v":275000,"d":"$275,000"},{"v":275000,"d":"$275,000"},{"v":275000,"d":"$275,000"}]
["Actual",{"v":250000,"d":"$250,000"},{"v":245000,"d":"$245,000"},{"v":240000,"d":"$240,000"},{"v":240000,"d":"$240,000"},{"v":235000,"d":"$235,000"},{"v":230000,"d":"$230,000"},{"v":225000,"d":"$225,000"},{"v":225000,"d":"$225,000"},{"v":300000,"d":"$300,000"},{"v":295000,"d":"$295,000"},{"v":290000,"d":"$290,000"},{"v":290000,"d":"$290,000"},{"v":285000,"d":"$285,000"},{"v":280000,"d":"$280,000"},{"v":275000,"d":"$275,000"},{"v":275000,"d":"$275,000"},{"v":275000,"d":"$275,000"}]
["Budget variance (Actual – Budget)",{"$f":"B66-B65","v":{"v":0,"d":"$0"}},{"$f":"C66-C65","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Prior year",{"v":230000,"d":"$230,000"},{"v":230000,"d":"$230,000"},{"v":231000,"d":"$231,000"},{"v":231000,"d":"$231,000"},{"v":234000,"d":"$234,000"},{"v":235000,"d":"$235,000"},{"v":235000,"d":"$235,000"},{"v":235000,"d":"$235,000"},{"v":240000,"d":"$240,000"},{"v":240000,"d":"$240,000"},{"v":242000,"d":"$242,000"},{"v":242000,"d":"$242,000"},{"v":244000,"d":"$244,000"},{"v":245000,"d":"$245,000"},{"v":248000,"d":"$248,000"},{"v":248000,"d":"$248,000"},{"v":248000,"d":"$248,000"}]
["Prior year variance (Actual – Prior year)",{"$f":"B66-B68","v":{"v":20000,"d":"$20,000"}},{"$f":"C66-C68","v":{"v":15000,"d":"$15,000"}},{"v":9000,"d":"$9,000"},{"v":9000,"d":"$9,000"},{"v":1000,"d":"$1,000"},{"v":-5000,"d":"($5,000)"},{"v":-10000,"d":"($10,000)"},{"v":-10000,"d":"($10,000)"},{"v":60000,"d":"$60,000"},{"v":55000,"d":"$55,000"},{"v":48000,"d":"$48,000"},{"v":48000,"d":"$48,000"},{"v":41000,"d":"$41,000"},{"v":35000,"d":"$35,000"},{"v":27000,"d":"$27,000"},{"v":27000,"d":"$27,000"},{"v":27000,"d":"$27,000"}]
["Accounts Payable"]
["Budget",{"v":25000,"d":"$25,000"},{"v":28000,"d":"$28,000"},{"v":32000,"d":"$32,000"},{"v":32000,"d":"$32,000"},{"v":34000,"d":"$34,000"},{"v":35000,"d":"$35,000"},{"v":36000,"d":"$36,000"},{"v":36000,"d":"$36,000"},{"v":35000,"d":"$35,000"},{"v":34000,"d":"$34,000"},{"v":33000,"d":"$33,000"},{"v":33000,"d":"$33,000"},{"v":32000,"d":"$32,000"},{"v":31000,"d":"$31,000"},{"v":30000,"d":"$30,000"},{"v":30000,"d":"$30,000"},{"v":30000,"d":"$30,000"}]
["Actual",{"v":26000,"d":"$26,000"},{"v":30000,"d":"$30,000"},{"v":34000,"d":"$34,000"},{"v":34000,"d":"$34,000"},{"v":35000,"d":"$35,000"},{"v":35500,"d":"$35,500"},{"v":36500,"d":"$36,500"},{"v":36500,"d":"$36,500"},{"v":35000,"d":"$35,000"},{"v":34000,"d":"$34,000"},{"v":33000,"d":"$33,000"},{"v":33000,"d":"$33,000"},{"v":32000,"d":"$32,000"},{"v":31000,"d":"$31,000"},{"v":30000,"d":"$30,000"},{"v":30000,"d":"$30,000"},{"v":30000,"d":"$30,000"}]
["Budget variance (Actual – Budget)",{"$f":"B72-B71","v":{"v":1000,"d":"$1,000"}},{"$f":"C72-C71","v":{"v":2000,"d":"$2,000"}},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":1000,"d":"$1,000"},{"v":500,"d":"$500"},{"v":500,"d":"$500"},{"v":500,"d":"$500"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Prior year",{"v":18000,"d":"$18,000"},{"v":20000,"d":"$20,000"},{"v":24000,"d":"$24,000"},{"v":24000,"d":"$24,000"},{"v":25000,"d":"$25,000"},{"v":26000,"d":"$26,000"},{"v":26000,"d":"$26,000"},{"v":26000,"d":"$26,000"},{"v":27000,"d":"$27,000"},{"v":28000,"d":"$28,000"},{"v":27000,"d":"$27,000"},{"v":27000,"d":"$27,000"},{"v":28000,"d":"$28,000"},{"v":29000,"d":"$29,000"},{"v":28000,"d":"$28,000"},{"v":28000,"d":"$28,000"},{"v":28000,"d":"$28,000"}]
["Prior year variance (Actual – Prior year)",{"$f":"B72-B74","v":{"v":8000,"d":"$8,000"}},{"$f":"C72-C74","v":{"v":10000,"d":"$10,000"}},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":9500,"d":"$9,500"},{"v":10500,"d":"$10,500"},{"v":10500,"d":"$10,500"},{"v":8000,"d":"$8,000"},{"v":6000,"d":"$6,000"},{"v":6000,"d":"$6,000"},{"v":6000,"d":"$6,000"},{"v":4000,"d":"$4,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"}]
["Long-Term Debt"]
["Budget",{"v":125000,"d":"$125,000"},{"v":48000,"d":"$48,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":55000,"d":"$55,000"},{"v":55000,"d":"$55,000"},{"v":54000,"d":"$54,000"},{"v":54000,"d":"$54,000"},{"v":53000,"d":"$53,000"},{"v":52000,"d":"$52,000"},{"v":51000,"d":"$51,000"},{"v":51000,"d":"$51,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
["Actual",{"v":125000,"d":"$125,000"},{"v":48000,"d":"$48,000"},{"v":49000,"d":"$49,000"},{"v":49000,"d":"$49,000"},{"v":51000,"d":"$51,000"},{"v":53000,"d":"$53,000"},{"v":54000,"d":"$54,000"},{"v":54000,"d":"$54,000"},{"v":53000,"d":"$53,000"},{"v":52000,"d":"$52,000"},{"v":51000,"d":"$51,000"},{"v":51000,"d":"$51,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
["Budget variance (Actual – Budget)",{"$f":"B78-B77","v":{"v":0,"d":"$0"}},{"$f":"C78-C77","v":{"v":0,"d":"$0"}},{"v":-1000,"d":"($1,000)"},{"v":-1000,"d":"($1,000)"},{"v":-4000,"d":"($4,000)"},{"v":-2000,"d":"($2,000)"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Prior year",{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"},{"v":45000,"d":"$45,000"},{"v":65000,"d":"$65,000"},{"v":65000,"d":"$65,000"},{"v":65000,"d":"$65,000"},{"v":65000,"d":"$65,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":85000,"d":"$85,000"},{"v":85000,"d":"$85,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"}]
["Prior year variance (Actual – Prior year)",{"$f":"B78-B80","v":{"v":80000,"d":"$80,000"}},{"$f":"C78-C80","v":{"v":3000,"d":"$3,000"}},{"v":4000,"d":"$4,000"},{"v":4000,"d":"$4,000"},{"v":-14000,"d":"($14,000)"},{"v":-12000,"d":"($12,000)"},{"v":-11000,"d":"($11,000)"},{"v":-11000,"d":"($11,000)"},{"v":-22000,"d":"($22,000)"},{"v":-23000,"d":"($23,000)"},{"v":-24000,"d":"($24,000)"},{"v":-24000,"d":"($24,000)"},{"v":-35000,"d":"($35,000)"},{"v":-35000,"d":"($35,000)"},{"v":-25000,"d":"($25,000)"},{"v":-25000,"d":"($25,000)"},{"v":-25000,"d":"($25,000)"}]