|
DataMuseum.dkPresents historical artifacts from the history of: Christian Rovsing CR7, CR8 & CR16 CP/M |
This is an automatic "excavation" of a thematic subset of
See our Wiki for more about Christian Rovsing CR7, CR8 & CR16 CP/M Excavated with: AutoArchaeologist - Free & Open Source Software. |
top - download
Length: 3072 (0xc00)
Types: TextFile
Names: »EX02.TXT«
└─⟦ed6270ad1⟧ Bits:30005316 PLAN80 Version 2.6
└─ ⟦this⟧ »EX02.TXT«
:TITLES
1 "PLAN80 EXAMPLE #2"
2 "Projected Sales and Gross Margin"
:COLUMNS
YEAR1 "Act" "YEAR1"
YEAR2 "Est" "YEAR2"
YEAR3 " ----- Projected -----" "YEAR3"
YEAR4..5
YEAR6 (P) " ----------------- Projected ---------------" "YEAR6"
YEAR7..11
:ROWS
MARKET1 "Total Market Units (Millions)"
" Product 1"
MARKET2 " Product 2"
MARKET3 " Product 3"
MARKET99 " Total"
SHARE1 "ABC Share (Percent)"
" Product 1"
SHARE2 " Product 2"
SHARE3 " Product 3"
SHARE99 " Total"
UNITS1 "ABC Units (Millions)"
" Product 1"
UNITS2 " Product 2"
UNITS3 " Product 3"
UNITS99 " Total"
PRICE1 "Average Unit Price"
" Product 1"
PRICE2 " Product 2"
PRICE3 " Product 3"
PRICE99 " Average"
DOLLAR1 "Sales Dollars (Millions)"
" Product 1"
DOLLAR2 " Product 2"
DOLLAR3 " Product 3"
DOLLAR99 " Total"
COST1 "Average Unit Cost"
" Product 1"
COST2 " Product 2"
COST3 " Product 3"
COST99 " Total"
AGM1 "Average Gross Margin (Percent)"
" Product 1"
AGM2 " Product 2"
AGM3 " Product 3"
AGM99 " Average"
:EDITING
SHARE1..AGM99 .*
PRICE1..PRICE99 .***
COST1..COST99 .***
MARKET99 O A
SHARE99 O A
UNITS99 O A
PRICE99 O A
DOLLAR99 O A
COST99 O A
AGM99 O
:DATA
MARKET1 = 110 115 (*1.04)
MARKET2 = 88 103 (*1.08)
MARKET3 = 28 41 (*1.12)
SHARE1 = .30 .31 .32 .33 .34 .35 +
SHARE2 = .15 .18 (+.015)
SHARE3 = .20 .20 .19 .18 .17 .16 +
PRICE1 = .885 .903 (*1.10)
PRICE2 = .510 .550 (*1.08)
PRICE3 = 1.30 1.45 (*1.12)
COST1 = .502 .558 (*1.09)
COST2 = .317 .310 (*0.92)
COST3 = .704 .664 (*1.05)
:RULES
: Total Units
MARKET99 = @SUM(MARKET1..MARKET3)
: ABC Units = Total Units * Share
UNITS1 = MARKET1 * SHARE1
UNITS2 = MARKET2 * SHARE2
UNITS3 = MARKET3 * SHARE3
UNITS99 = @SUM(UNITS1..UNITS3)
: Total Unit Share
SHARE99 = UNITS99 / MARKET99 * 100
SHARE1 = SHARE1 * 100
SHARE2 = SHARE2 * 100
SHARE3 = SHARE3 * 100
: Sales Dollars = Units * Price
DOLLAR1 = UNITS1 * PRICE1
DOLLAR2 = UNITS2 * PRICE2
DOLLAR3 = UNITS3 * PRICE3
DOLLAR99 = @SUM(DOLLAR1..DOLLAR3)
: Average Price = Dollars / Units
PRICE99 = DOLLAR99 / UNITS99
: Cost = Units * Unit Cost
AGM1 = UNITS1 * COST1
AGM2 = UNITS2 * COST2
AGM3 = UNITS3 * COST3
AGM99 = @SUM(AGM1..AGM3)
: Average Cost = Cost / Units
COST99 = AGM99 / UNITS99
: Gross Margin = Marginal Revenue / Sales
AGM1 = DOLLAR1-AGM1 / DOLLAR1 * 100
AGM2 = DOLLAR2-AGM2 / DOLLAR2 * 100
AGM3 = DOLLAR3-AGM3 / DOLLAR3 * 100
AGM99 = DOLLAR99-AGM99 / DOLLAR99 * 100
:OPTIONS
ROWWID(30)
:DISPLAY
«eof»