SuperCalc ver. B5.26 THIS IS A SAMPLE SUPERCALC WORKSHEETΟΟΟP7 $"THIS IS A SAMPLE SUPERCALC WORKSHEET "JAN  "FEB  "MAR  "APR  "MAY  "JUN  "JUL  "AUG  "SEPT  "OCT  "NOV  "DEC !"TOTALS A SAM!"NET SALESSAMP1000S‚DB4+(B4*.10)‚DC4+(C4*.10)‚D1D4+(D4*.10)‚DdE4+(E4*.10)‚DQF4+(F4*.10)‚DqVG4+(G4*.10)‚DHqqH4+(H4*.10) ‚D!CXˆI4+(I4*.10) ‚D#W”v‘J4+(J4*.10) ‚D%“t$`K4+(K4*.10) ‚D(SgL4+(L4*.10) ‚E!8BƒvrSUM(B4:M4)""COST OF GOODS SOLDP300T ‚C3B6+(B6*.10)‚C60C6+(C6*.10)‚C9“D6+(D6*.10)‚CC’0E6+(E6*.10)‚CH1SF6+(F6*.10)‚CSh0G6+(G6*.10)‚CXFH6+(H6*.10) ‚Cd0vd0I6+(I6*.10) ‚Cps„0sJ6+(J6*.10) ‚Cw"s€0K6+(K6*.10) ‚C…Y53L6+(L6*.10) ‚Dd(Q00SUM(B6:M6) '-(Q0!"GROSS PROFIT‚CpB4-B6:M6)‚CwC4-C6:M6)‚C„pD4-D6:M6)‚C“E4-E6:M6)‚D$‡F4-F6:M6)‚D'5pG4-G6:M6)‚D@ 'H4-H6:M6)‚DdpI4-I6:M6) ‚DQ!gJ4-J6:M6) ‚DPV3ƒpK4-K6:M6) ‚Da—"L4-L6:M6) ‚D—”'pM4-M6:M6) ‚E–‰˜cpGSUM(B8:M8) #"RESEARCH & DEVELOPMENTALC WO P160EA ƒC`B10+(B10*.10)ALC WO ƒC6C10+(C10*.10)ALC WO ƒC!)`D10+(D10*.10)ALC WO ƒC#BVE10+(E10*.10)ALC WO ƒC%v`F10+(F10*.10)ALC WO ƒC(4IvG10+(G10*.10)ALC WO ƒC1”s`H10+(H10*.10)ALC WO ƒC4)t –I10+(I10*.10)ALC WO ƒC7rqc`J10+(J10*.10)ALC WO ƒCAI˜y6K10+(K10*.10)ALC WO ƒCEd˜g)w`L10+(L10*.10)ALC WO ƒD4!HTu6SUM(B10:M10)ALC WO !"MARKETINGUM( P200KE ƒC"@B11+(B11*.12)ALC WO ƒC%€C11+(C11*.12)ALC WO ƒC( …`D11+(D11*.12)ALC WO ƒC1G‡ E11+(E11*.12)ALC WO ƒC5$h3f@F11+(F11*.12)ALC WO ƒC9GdSp6€G11+(G11*.12)ALC WO ƒCD!6(!`H11+(H11*.12)ALC WO ƒCIQ’cRX–I11+(I11*.12)ALC WO ƒCUFusJ11+(J11*.12)ALC WO ƒCbidh„K11+(K11*.12)ALC WO ƒCiW ™†i(L11+(L11*.12)ALC WO ƒDH&bfT$I`SUM(B11:M11)ALC WO ""ADMINISTRATIVE1:M11) P140IN ƒCB12+(B12*.08)ALC WO ƒC2–C12+(C12*.08)ALC WO ƒCcYhD12+(D12*.08)ALC WO ƒChEDE12+(E12*.08)ALC WO ƒC W“RF12+(F12*.08)ALC WO ƒC"!b@RG12+(G12*.08)ALC WO ƒC#™59v)(H12+(H12*.08)ALC WO ƒC%‘0"”9F4I12+(I12*.08)ALC WO ƒC'˜`dw”bJ12+(J12*.08)ALC WO ƒC0"II–K12+(K12*.08)ALC WO ƒC2d)E•‡dSL12+(L12*.08)ALC WO ƒD&VywC2SUM(B12:M12)ALC WO '-yw #"TOTAL OPERATING EXPENSESC WO ƒCPSUM(B10:B13)ESC WO ƒCUSUM(C10:C13)ESC WO ƒC`wvSUM(D10:D13)ESC WO ƒCg(SUM(E10:E13)ESC WO ƒCs”(2dSUM(F10:F13)ESC WO ƒCXU†s’SUM(G10:G13)ESC WO ƒCvp"H–SUM(H10:H13)ESC WO ƒC™8fAQ4ˆSUM(I10:I13)ESC WO ƒD—)pt)„%SUM(J10:J13)ESC WO ƒDt€)„FXSUM(K10:K13)ESC WO ƒD8Ay402SUM(L10:L13)ESC WO ƒDxc1#CHSUM(M10:M13)ESC WO ƒEI v1wSUM(B14:M14)ESC WO""INCOME BEFORE TAXES)‚C B8-B14XES)‚C!ˆC8-C14XES)‚C#’$D8-D14XES)‚C&”rE8-E14XES)‚C(TAg6F8-F14XES)‚C1&G8-G14XES)‚C3—™wQH8-H14XES)‚C75UH‰eI8-I14XES) ‚C@2 'WPJ8-J14XES) ‚CCˆ58U4 K8-K14XES) ‚CGrxqf–€L8-L14XES) ‚CQ…CV0Be M8-M14XES) ƒD@dˆuaR(SUM(B16:M16)ESC WO!"INCOME TAXES‚B€B16*.40M16)‚B‡RC16*.40M16)‚B•h–D16*.40M16)‚CEWˆ€E16*.40M16)‚CAvf”@F16*.40M16)‚CFE0C G16*.40M16)‚CX†9‘A`H16*.40M16)‚C€”"U†I16*.40M16) ‚C†p€cJ16*.40M16) ‚CU&BhK16*.40M16) ‚C€qHfxrL16*.40M16) ‚C tBRM16*.40M16) ƒD%cUP$`’SUM(B18:M18)ESC WO '-cUP!"NET INCOMEM(‚CB16-B18M18)‚C€C16-C18M18)‚C54@D16-D18M18)‚Ch6ƒ E16-E18M18)‚CeA`F16-F18M18)‚Cig•d€G16-G18M18)‚C 8)Y†Pb@H16-H18M18)‚C"!A3)3yI16-I18M18) ‚C$)V ”PJ16-J18M18) ‚C&2‰!# RK16-K18M18) ‚C(c!#L16-L18M18) ‚C1&x%YM16-M18M18) ƒD$8E3%6‘7SUM(B20:M20)ESC WO