|
DataMuseum.dkPresents historical artifacts from the history of: CP/M |
This is an automatic "excavation" of a thematic subset of
See our Wiki for more about CP/M Excavated with: AutoArchaeologist - Free & Open Source Software. |
top - download
Length: 11648 (0x2d80)
Names: »EXMP1.FNB«
└─⟦dc6c79650⟧ Bits:30004299 FINAR Tutor
└─⟦this⟧ »EXMP1.FNB«
0x0000…0020 (0,) 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 ┆ ┆
[…0x3…]
0x0080…00a0 31 30 20 20 20 3b 20 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a ┆10 ; *************************┆
0x00a0…00c0 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a ┆********************************┆
0x00c0…00e0 2a 2a 2a 2a 2a 2a 2a 2a 2a 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆********* ┆
0x00e0…0100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
0x0100…0120 (1,) 32 30 20 20 20 3b 20 54 68 69 73 20 49 4e 43 4f 4d 45 20 4d 6f 64 65 6c 20 6f 66 20 74 68 65 20 ┆20 ; This INCOME Model of the ┆
0x0120…0140 46 61 73 74 20 46 6f 6f 64 20 43 6f 6d 70 61 6e 79 20 65 78 61 6d 69 6e 65 73 20 74 68 65 20 6c ┆Fast Food Company examines the l┆
0x0140…0160 69 6b 65 6c 79 20 20 20 2a 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ikely * ┆
0x0160…0180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
0x0180…01a0 33 30 20 20 20 3b 20 65 66 66 65 63 74 20 6f 66 20 70 72 69 63 65 20 76 61 72 69 61 74 69 6f 6e ┆30 ; effect of price variation┆
0x01a0…01c0 73 20 6f 6e 20 66 6f 72 65 63 61 73 74 20 70 72 6f 66 69 74 20 74 68 72 6f 75 67 68 20 61 20 73 ┆s on forecast profit through a s┆
0x01c0…01e0 75 70 70 6f 73 65 64 20 2a 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆upposed * ┆
0x01e0…0200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
0x0200…0220 (2,) 34 30 20 20 20 3b 20 72 65 6c 61 74 69 6f 6e 73 68 69 70 20 62 65 74 77 65 65 6e 20 50 72 69 63 ┆40 ; relationship between Pric┆
0x0220…0240 65 20 61 6e 64 20 53 61 6c 65 73 20 52 65 76 65 6e 75 65 73 2e 20 20 54 68 65 20 73 65 6e 73 69 ┆e and Sales Revenues. The sensi┆
0x0240…0260 74 69 76 69 74 79 20 20 2a 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆tivity * ┆
0x0260…0280 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
0x0280…02a0 35 30 20 20 20 3b 20 6f 66 20 74 68 65 20 62 6f 74 74 6f 6d 20 6c 69 6e 65 20 74 6f 20 74 68 69 ┆50 ; of the bottom line to thi┆
0x02a0…02c0 73 20 72 65 6c 61 74 69 6f 6e 73 68 69 70 20 69 73 20 61 6c 73 6f 20 65 78 61 6d 69 6e 65 64 2e ┆s relationship is also examined.┆
0x02c0…02e0 20 20 20 20 20 20 20 20 2a 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ * ┆
0x02e0…0300 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
0x0300…0320 (3,) 36 30 20 20 20 3b 20 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a ┆60 ; *************************┆
0x0320…0340 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a ┆********************************┆
0x0340…0360 2a 2a 2a 2a 2a 2a 2a 2a 2a 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆********* ┆
0x0360…0380 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
0x0380…03a0 39 39 39 20 20 3b 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆999 ; ┆
0x03a0…03c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x0400…0420 (4,) 31 30 30 30 20 52 6f 77 20 50 72 69 63 65 28 50 72 69 63 65 20 70 65 72 20 6b 69 6c 6f 29 20 4b ┆1000 Row Price(Price per kilo) K┆
0x0420…0440 69 6c 6f 73 28 4b 69 6c 6f 73 20 73 6f 6c 64 28 30 30 30 27 73 29 29 20 54 6f 74 73 61 6c 28 54 ┆ilos(Kilos sold(000's)) Totsal(T┆
0x0440…0460 6f 74 61 6c 20 73 61 6c 65 73 29 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆otal sales) ┆
0x0460…0480 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
0x0480…04a0 31 30 31 30 20 52 6f 77 20 50 61 63 6b 61 67 69 6e 67 20 4d 65 61 74 20 56 65 67 65 74 61 62 6c ┆1010 Row Packaging Meat Vegetabl┆
0x04a0…04c0 65 73 20 4f 74 68 65 72 28 4f 74 68 65 72 20 43 6f 73 74 73 29 00 00 00 00 00 00 00 00 00 00 00 ┆es Other(Other Costs) ┆
0x04c0…04e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0500…0520 (5,) 31 30 32 30 20 52 6f 77 20 43 6f 73 28 43 6f 73 74 20 6f 66 20 67 6f 6f 64 73 20 73 6f 6c 64 29 ┆1020 Row Cos(Cost of goods sold)┆
0x0520…0540 20 47 72 6f 73 73 28 47 52 4f 53 53 20 50 52 4f 46 49 54 29 00 00 00 00 00 00 00 00 00 00 00 00 ┆ Gross(GROSS PROFIT) ┆
0x0540…0560 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0580…05a0 31 30 33 30 20 52 6f 77 20 53 61 6c 61 72 69 65 73 20 54 72 61 6e 73 70 6f 72 74 61 74 69 6f 6e ┆1030 Row Salaries Transportation┆
0x05a0…05c0 20 4f 76 65 72 68 65 61 64 73 20 43 6f 6d 6d 69 73 73 69 6f 6e 00 00 00 00 00 00 00 00 00 00 00 ┆ Overheads Commission ┆
0x05c0…05e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0600…0620 (6,) 31 30 34 30 20 52 6f 77 20 4d 6b 74 67 28 4d 61 72 6b 65 74 69 6e 67 20 61 6e 64 29 28 41 64 6d ┆1040 Row Mktg(Marketing and)(Adm┆
0x0620…0640 69 6e 69 73 74 72 61 74 69 6f 6e 29 20 43 6f 73 74 73 28 54 6f 74 61 6c 20 63 6f 73 74 73 29 00 ┆inistration) Costs(Total costs) ┆
0x0640…0660 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0680…06a0 31 30 35 30 20 52 6f 77 20 28 61 6e 64 20 65 78 70 65 6e 73 65 73 29 20 4f 70 65 72 28 4f 70 65 ┆1050 Row (and expenses) Oper(Ope┆
0x06a0…06c0 72 61 74 69 6e 67 20 70 72 6f 66 69 74 29 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆rating profit) ┆
0x06c0…06e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0700…0720 (7,) 31 30 36 30 20 52 6f 77 20 54 61 78 20 49 6e 74 65 72 65 73 74 20 4e 65 74 74 28 4e 45 54 20 49 ┆1060 Row Tax Interest Nett(NET I┆
0x0720…0740 4e 43 4f 4d 45 29 20 4e 65 74 69 63 28 4e 45 54 20 49 4e 43 4f 4d 45 28 25 29 29 00 00 00 00 00 ┆NCOME) Netic(NET INCOME(%)) ┆
0x0740…0760 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0780…07a0 31 30 37 30 20 52 6f 77 20 44 65 62 74 28 4c 6f 6e 67 20 74 65 72 6d 20 64 65 62 74 29 20 50 61 ┆1070 Row Debt(Long term debt) Pa┆
0x07a0…07c0 79 6d 65 6e 74 28 44 65 62 74 20 72 65 70 61 79 6d 65 6e 74 29 00 00 00 00 00 00 00 00 00 00 00 ┆yment(Debt repayment) ┆
0x07c0…07e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0800…0820 (8,) 31 39 39 39 20 3b 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆1999 ; ┆
0x0820…0840 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x0880…08a0 32 30 30 30 20 43 6f 6c 20 51 31 28 4a 61 6e 29 28 2d 4d 61 72 63 68 29 20 51 32 28 41 70 72 69 ┆2000 Col Q1(Jan)(-March) Q2(Apri┆
0x08a0…08c0 6c 29 28 2d 4a 75 6e 65 29 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆l)(-June) ┆
0x08c0…08e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0900…0920 (9,) 32 30 31 30 20 43 6f 6c 20 51 33 28 4a 75 6c 79 29 28 2d 53 65 70 74 29 20 51 34 28 4f 63 74 29 ┆2010 Col Q3(July)(-Sept) Q4(Oct)┆
0x0920…0940 28 2d 44 65 63 29 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆(-Dec) ┆
0x0940…0960 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0980…09a0 32 30 32 30 20 43 6f 6c 20 54 6f 74 61 6c 28 54 6f 74 61 6c 29 28 59 65 61 72 29 00 00 00 00 00 ┆2020 Col Total(Total)(Year) ┆
0x09a0…09c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x0a00…0a20 (10,) 32 39 39 39 20 3b 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆2999 ; ┆
0x0a20…0a40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x0a80…0aa0 33 30 30 30 20 3b 20 57 65 20 77 69 6c 6c 20 73 75 70 70 6c 79 20 74 68 65 20 70 72 69 63 65 20 ┆3000 ; We will supply the price ┆
0x0aa0…0ac0 70 65 72 20 6b 69 6c 6f 20 6f 66 20 67 6f 6f 64 73 20 73 6f 6c 64 2e 00 00 00 00 00 00 00 00 00 ┆per kilo of goods sold. ┆
0x0ac0…0ae0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0b00…0b20 (11,) 33 30 30 31 20 3b 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆3001 ; ┆
0x0b20…0b40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x0b80…0ba0 33 30 31 30 20 43 6f 6e 73 69 64 65 72 20 51 31 20 74 6f 20 51 34 00 00 00 00 00 00 00 00 00 00 ┆3010 Consider Q1 to Q4 ┆
0x0ba0…0bc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x0c00…0c20 (12,) 33 30 32 30 20 41 73 6b 20 66 6f 72 20 50 72 69 63 65 20 77 69 74 68 20 22 45 6e 74 65 72 20 61 ┆3020 Ask for Price with "Enter a┆
0x0c20…0c40 20 76 61 6c 75 65 20 67 72 65 61 74 65 72 20 74 68 61 6e 20 32 30 63 22 00 00 00 00 00 00 00 00 ┆ value greater than 20c" ┆
0x0c40…0c60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0c80…0ca0 33 30 32 32 20 3b 20 57 65 20 61 72 65 20 67 6f 69 6e 67 20 74 6f 20 61 73 73 75 6d 65 20 74 6f ┆3022 ; We are going to assume to┆
0x0ca0…0cc0 74 61 6c 20 73 61 6c 65 73 20 6f 66 20 31 30 30 30 30 20 75 6e 69 74 73 20 70 65 72 20 71 75 61 ┆tal sales of 10000 units per qua┆
0x0cc0…0ce0 72 74 65 72 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆rter ┆
0x0ce0…0d00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
0x0d00…0d20 (13,) 33 30 32 34 20 3b 20 61 74 20 32 30 63 2f 6b 69 6c 6f 20 66 61 6c 6c 69 6e 67 20 6f 66 66 20 69 ┆3024 ; at 20c/kilo falling off i┆
0x0d20…0d40 6e 20 64 69 72 65 63 74 20 70 72 6f 70 6f 72 74 69 6f 6e 20 74 6f 20 61 20 72 69 73 65 20 69 6e ┆n direct proportion to a rise in┆
0x0d40…0d60 20 70 72 69 63 65 2e 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ price. ┆
0x0d60…0d80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
0x0d80…0da0 33 30 33 30 20 54 6f 74 73 61 6c 20 3d 20 31 30 30 30 30 20 2a 20 32 30 20 2f 20 50 72 69 63 65 ┆3030 Totsal = 10000 * 20 / Price┆
0x0da0…0dc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x0e00…0e20 (14,) 33 30 34 30 20 4b 69 6c 6f 73 20 3d 20 54 6f 74 73 61 6c 20 2f 20 50 72 69 63 65 00 00 00 00 00 ┆3040 Kilos = Totsal / Price ┆
0x0e20…0e40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x0e80…0ea0 33 30 34 32 20 3b 20 4e 6f 77 20 63 61 6c 63 75 6c 61 74 65 20 43 6f 73 74 20 6f 66 20 67 6f 6f ┆3042 ; Now calculate Cost of goo┆
0x0ea0…0ec0 64 73 20 73 6f 6c 64 2e 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ds sold. ┆
0x0ec0…0ee0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x0f00…0f20 (15,) 33 30 35 30 20 50 61 63 6b 61 67 69 6e 67 20 3d 20 35 25 20 6f 66 20 4b 69 6c 6f 73 00 00 00 00 ┆3050 Packaging = 5% of Kilos ┆
0x0f20…0f40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x0f80…0fa0 33 30 36 30 20 4d 65 61 74 20 3d 20 31 35 25 20 6f 66 20 54 6f 74 73 61 6c 00 00 00 00 00 00 00 ┆3060 Meat = 15% of Totsal ┆
0x0fa0…0fc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1000…1020 (16,) 33 30 37 30 20 56 65 67 65 74 61 62 6c 65 73 20 3d 20 35 25 20 6f 66 20 54 6f 74 73 61 6c 20 2b ┆3070 Vegetables = 5% of Totsal +┆
0x1020…1040 20 33 30 30 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ 300 ┆
0x1040…1060 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x1080…10a0 33 30 38 30 20 4f 74 68 65 72 20 3d 20 32 2e 35 25 20 6f 66 20 54 6f 74 73 61 6c 00 00 00 00 00 ┆3080 Other = 2.5% of Totsal ┆
0x10a0…10c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1100…1120 (17,) 33 31 30 30 20 3b 20 4f 74 68 65 72 20 63 6f 73 74 73 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆3100 ; Other costs ┆
0x1120…1140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1180…11a0 33 31 31 30 20 53 61 6c 61 72 69 65 73 20 3d 20 31 30 30 20 67 72 6f 77 20 62 79 20 31 30 25 00 ┆3110 Salaries = 100 grow by 10% ┆
0x11a0…11c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1200…1220 (18,) 33 31 32 30 20 43 6f 6d 6d 69 73 73 69 6f 6e 20 3d 20 31 25 20 6f 66 20 4b 69 6c 6f 73 00 00 00 ┆3120 Commission = 1% of Kilos ┆
0x1220…1240 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1280…12a0 33 31 33 30 20 4d 6b 74 67 20 3d 20 31 30 30 20 67 72 6f 77 20 62 79 20 31 35 00 00 00 00 00 00 ┆3130 Mktg = 100 grow by 15 ┆
0x12a0…12c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1300…1320 (19,) 33 31 34 30 20 4f 76 65 72 68 65 61 64 73 20 3d 20 32 33 31 20 67 72 6f 77 20 62 79 20 34 25 00 ┆3140 Overheads = 231 grow by 4% ┆
0x1320…1340 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1380…13a0 33 31 35 30 20 54 72 61 6e 73 70 6f 72 74 61 74 69 6f 6e 20 3d 20 31 30 30 20 2b 20 4b 69 6c 6f ┆3150 Transportation = 100 + Kilo┆
0x13a0…13c0 73 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆s ┆
0x13c0…13e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x1400…1420 (20,) 33 31 35 35 20 54 72 61 6e 73 70 6f 72 74 61 74 69 6f 6e 20 3d 20 4d 6b 74 67 20 2a 20 31 30 30 ┆3155 Transportation = Mktg * 100┆
0x1420…1440 20 2f 20 54 72 61 6e 73 70 6f 72 74 61 74 69 6f 6e 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ / Transportation ┆
0x1440…1460 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x1480…14a0 33 31 36 30 20 50 61 79 6d 65 6e 74 20 3d 20 31 35 30 2e 2e 00 00 00 00 00 00 00 00 00 00 00 00 ┆3160 Payment = 150.. ┆
0x14a0…14c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1500…1520 (21,) 33 31 37 30 20 44 65 62 74 20 3d 20 31 30 30 30 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆3170 Debt = 1000 ┆
0x1520…1540 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1580…15a0 33 31 38 30 20 43 6f 6e 73 69 64 65 72 20 51 32 20 74 6f 20 51 34 00 00 00 00 00 00 00 00 00 00 ┆3180 Consider Q2 to Q4 ┆
0x15a0…15c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1600…1620 (22,) 33 31 39 30 20 44 65 62 74 20 3d 20 6c 61 73 74 20 44 65 62 74 20 2d 20 50 61 79 6d 65 6e 74 00 ┆3190 Debt = last Debt - Payment ┆
0x1620…1640 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1680…16a0 33 32 30 30 20 43 6f 6e 73 69 64 65 72 20 61 6c 6c 20 43 6f 6c 75 6d 6e 73 00 00 00 00 00 00 00 ┆3200 Consider all Columns ┆
0x16a0…16c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1700…1720 (23,) 33 32 31 30 20 49 6e 74 65 72 65 73 74 20 3d 20 2e 31 35 20 2a 20 44 65 62 74 20 2f 20 34 20 20 ┆3210 Interest = .15 * Debt / 4 ┆
0x1720…1740 3b 20 71 75 61 72 74 65 72 6c 79 20 69 6e 74 65 72 65 73 74 20 61 74 20 31 35 25 20 61 6e 6e 75 ┆; quarterly interest at 15% annu┆
0x1740…1760 61 6c 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆al ┆
0x1760…1780 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
0x1780…17a0 33 32 32 30 20 54 6f 74 73 61 6c 20 74 6f 20 49 6e 74 65 72 65 73 74 20 3d 20 54 6f 74 73 61 6c ┆3220 Totsal to Interest = Totsal┆
0x17a0…17c0 20 74 6f 20 49 6e 74 65 72 65 73 74 20 72 6f 75 6e 64 20 30 00 00 00 00 00 00 00 00 00 00 00 00 ┆ to Interest round 0 ┆
0x17c0…17e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x1800…1820 (24,) 33 32 33 30 20 43 6f 73 20 3d 20 73 75 6d 20 6f 66 20 50 61 63 6b 61 67 69 6e 67 20 74 6f 20 4f ┆3230 Cos = sum of Packaging to O┆
0x1820…1840 74 68 65 72 20 20 3b 20 72 6f 75 6e 64 20 62 65 66 6f 72 65 20 74 6f 74 61 6c 69 6e 67 00 00 00 ┆ther ; round before totaling ┆
0x1840…1860 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x1880…18a0 33 32 34 30 20 47 72 6f 73 73 20 3d 20 54 6f 74 73 61 6c 20 2d 20 43 6f 73 00 00 00 00 00 00 00 ┆3240 Gross = Totsal - Cos ┆
0x18a0…18c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1900…1920 (25,) 33 32 35 30 20 43 6f 73 74 73 20 3d 20 43 6f 73 20 2b 20 73 75 6d 20 6f 66 20 53 61 6c 61 72 69 ┆3250 Costs = Cos + sum of Salari┆
0x1920…1940 65 73 20 74 6f 20 4d 6b 74 67 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆es to Mktg ┆
0x1940…1960 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x1980…19a0 33 32 36 30 20 4f 70 65 72 20 3d 20 54 6f 74 73 61 6c 20 2d 20 43 6f 73 74 73 00 00 00 00 00 00 ┆3260 Oper = Totsal - Costs ┆
0x19a0…19c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1a00…1a20 (26,) 33 32 37 30 20 54 61 78 20 3d 20 2e 34 20 2a 20 70 6f 73 69 74 69 76 65 20 76 61 6c 75 65 73 20 ┆3270 Tax = .4 * positive values ┆
0x1a20…1a40 6f 66 20 4f 70 65 72 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆of Oper ┆
0x1a40…1a60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x1a80…1aa0 33 32 38 30 20 4e 65 74 74 20 3d 20 4f 70 65 72 20 2d 20 49 6e 74 65 72 65 73 74 20 2d 20 54 61 ┆3280 Nett = Oper - Interest - Ta┆
0x1aa0…1ac0 78 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆x ┆
0x1ac0…1ae0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x1…]
0x1b00…1b20 (27,) 33 33 30 30 20 3b 20 43 61 6c 63 75 6c 61 74 65 20 79 65 61 72 20 74 6f 74 61 6c 73 00 00 00 00 ┆3300 ; Calculate year totals ┆
0x1b20…1b40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1b80…1ba0 33 33 31 30 20 54 6f 74 61 6c 20 3d 20 73 75 6d 20 6f 66 20 51 31 20 74 6f 20 51 34 00 00 00 00 ┆3310 Total = sum of Q1 to Q4 ┆
0x1ba0…1bc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…0x2…]
0x1c00…1c20 (28,) 33 33 32 30 20 4e 65 74 69 63 20 3d 20 4e 65 74 74 20 61 73 20 25 20 6f 66 20 54 6f 74 73 61 6c ┆3320 Netic = Nett as % of Totsal┆
0x1c20…1c40 20 20 3b 20 6e 6f 74 65 20 74 68 69 73 20 69 73 20 64 6f 6e 65 20 41 46 54 45 52 20 63 72 6f 73 ┆ ; note this is done AFTER cros┆
0x1c40…1c60 73 20 74 6f 74 61 6c 73 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆s totals ┆
0x1c60…1c80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ┆ ┆
[…truncated at 200 lines…]