Category : Lotus and other Spreadsheets
Archive : POWERWKS.ZIP
Filename : PROFIT.WKS
Output of file : PROFIT.WKS contained in archive : POWERWKS.ZIP
BE_UNITS BLANK , , BLANK_COL CASE_A CASE_B CASE_C CASE_D COPYRIGHT COPYRIGHT_P1 COST_FORMULA f f COST_FORMULAS f l COST_TITLE p p COST_TITLES p v CURR_COL DF_LOW Y Y FIXED_COST FIXED_FORMULA h h FIXED_FORMULAS f l FIXED_TITLE r r FIXED_TITLES p v GET_INPUT 2 2 GRAPH 8 8 GRAPHSAVE a a GRAPH_DATA > > GRAPH_TITLE \ \ HILIM R R HIVAL W W HOME_SCREEN INTERVAL U U INTERVALS R W LOLIM Q Q LOVAL V V MARGIN MARGIN_FORMULA j j MARGIN_FORMULAS f l MARGIN_TITLE t t MARGIN_TITLES p v MENU # # OPTION þ þþ þ PBT
PLOT_FORMULAS f l PLOT_TITLES p v PRINT 2 2 PROFIT_FORMULA i i PROFIT_FORMULAS f l PROFIT_TITLE s s PROFIT_TITLES p v REVNU_FORMULA g g REVNU_FORMULAS f l REVNU_TITLE q q REVNU_TITLES p v SALES_FORMULA k k SALES_FORMULAS f l SALES_MARGIN SALES_PBT SALES_TITLE u u SALES_TITLES p v SCALE S S SEL_PLOTITEM A A SEL_VARYITEM I I SETGRAPH Z Z SET_GRAPHLIMS R R TABLE TBL_COL1 TBL_COL2 TBL_FORMULA TBL_INPUT TEMP UNITS_MARGIN UNITS_PBT UNIT_COST UNIT_FORMULA l l UNIT_FORMULAS f l UNIT_REVENUE UNIT_TITLE v v UNIT_TITLES p v \0 \B \M ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ v 0 ÿÿÿÿÿÿÿÿ ÿÿ ÿÿ ÿÿ ÿÿ # ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ $ ÿ% ò & ò PROFIT Worksheet Listing ' ( (
n B ) '* ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ- µÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ROFITABILITY ANALYSIS GRAPH ($) sdfghasdfgh qq ÿ \= ÿ \= ÿ \= ÿ \= ÿ \= ÿ \=
ÿ 'PROFIT 7 ' Copyright (c) 1984, Wildfire Technology Inc. ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- ÿ \- / ÿ ' Profitability Analysis Worksheet ÿ \= ÿ \= ÿ \= ÿ \= ÿ \= ÿ \=
ÿ "Case A
ÿ "Case B
ÿ "Case C
ÿ "Case D
ÿ "BLANK: ÿ "CURR_COL: ÿ 'Cost Per Unit
"
"
"
"
"
" ÿ 'Revenue Per Unit
"
"
"
"
"
" ÿ 'Fixed Costs
' ÿ
'Breakeven Sales - $ 5
ðÿ& ý¿ ü¿ ÿ¿ ý¿ ý¿ ü¿
; 5
ðÿ& ý¿ ü¿ ÿ¿ ý¿ ý¿ ü¿
; 5
ðÿ& ý¿ ü¿ ÿ¿ ý¿ ý¿ ü¿
; 5
ðÿ& ý¿ ü¿ ÿ¿ ý¿ ý¿ ü¿
; 5
ðÿ& ý¿ ü¿ ÿ¿ ý¿ ý¿ ü¿
; 5
«ªªªªFÐ@& ý¿ ü¿ ÿ¿ ý¿ ý¿ ü¿
; ÿ ' - Units & ðÿ ü¿ ÿ¿ ü¿ ; & ðÿ ü¿ ÿ¿ ü¿ ; & ðÿ ü¿ ÿ¿ ü¿ ; & ðÿ ü¿ ÿ¿ ü¿ ; & ðÿ ü¿ ÿ¿ ü¿ ; & «ªªªª
ª@ ü¿ ÿ¿ ü¿ ; ÿ
'Profit Before Tax ($)
ÿ 'Required Sales - $ < ðÿ- ù¿ ø¿ ÿ¿ û¿ ù¿ ù¿ ø¿
; < ðÿ- ù¿ ø¿ ÿ¿ û¿ ù¿ ù¿ ø¿
; < ðÿ- ù¿ ø¿ ÿ¿ û¿ ù¿ ù¿ ø¿
; < ðÿ- ù¿ ø¿ ÿ¿ û¿ ù¿ ù¿ ø¿
; < ðÿ- ù¿ ø¿ ÿ¿ û¿ ù¿ ù¿ ø¿
; < jØ@- ù¿ ø¿ ÿ¿ û¿ ù¿ ù¿ ø¿
; ÿ ' - Units & ðÿ ø¿ ÿ¿ ø¿ ; & ðÿ ø¿ ÿ¿ ø¿ ; & ðÿ ø¿ ÿ¿ ø¿ ; & ðÿ ø¿ ÿ¿ ø¿ ; & ðÿ ø¿ ÿ¿ ø¿ ; & ³@ ø¿ ÿ¿ ø¿ ; ÿ 'Margin Before Tax (%)
ÿ 'Required Sales - $ S ðÿD õ¿d ÿ¿
d ô¿ ÷¿ õ¿ õ¿d ÿ¿
d ô¿
; S ðÿD õ¿d ÿ¿
d ô¿ ÷¿ õ¿ õ¿d ÿ¿
d ô¿
; S ðÿD õ¿d ÿ¿
d ô¿ ÷¿ õ¿ õ¿d ÿ¿
d ô¿
; S ðÿD õ¿d ÿ¿
d ô¿ ÷¿ õ¿ õ¿d ÿ¿
d ô¿
; S ðÿD õ¿d ÿ¿
d ô¿ ÷¿ õ¿ õ¿d ÿ¿
d ô¿
; S nÛ¶mÛæÛ@D õ¿d ÿ¿
d ô¿ ÷¿ õ¿ õ¿d ÿ¿
d ô¿
; ÿ ' - Units ' ðÿ ô¿ ÿ¿ ô¿ ; ' ðÿ ô¿ ÿ¿ ô¿ ; ' ðÿ ô¿ ÿ¿ ô¿ ; ' ðÿ ô¿ ÿ¿ ô¿ ; ' ðÿ ô¿ ÿ¿ ô¿ ; ' %I$IR¶@ ô¿ ÿ¿ ô¿ ;
ÿ 'TABLE: ÿ 'COPYRIGHT: 7 ' Copyright (c) 1984, Wildfire Technology Inc.
ÿ '\0: \B: \M: ÿ 'BEEP: ÿ 'TEMP:
3 ÿ '{esc}{esc}{esc}{esc}{esc}{esc}{home}/XMmenu~ ÿ '//{esc}/XR '
ÿ 'AGENDA:
ÿ 'No
ÿ 'Yes
< ÿ 'Do not erase this worksheet. Return to the main menu. E ÿ 'Erase this worksheet and go to the worksheet selection agenda.
ÿ '/XMmenu~ ÿ '/FRagenda~
ÿ " 'MENU: ÿ # 'Input ÿ # 'Blank ÿ # 'Graph ÿ # 'Print
ÿ # 'Agenda ÿ # 'Quit ( ÿ $ 'Input data and calculate results. ( ÿ $ 'Blank out input and result areas. ÿ $ 'Display graphs. $ ÿ $ 'Print input data and results. , ÿ $ 'Return to worksheet selection agenda. ÿ $ 'Exit to 1-2-3 READY mode.
ÿ % '{home}
ÿ % '{home} ÿ % '/XMgraph~ ÿ % '/XGprint~ ÿ % '/XMagenda~ ÿ & '/XGget_input~ ÿ & '/XMblank~
ÿ + 'BLANK:
ÿ , 'A_Case
ÿ , 'B_Case
ÿ , 'C_Case
ÿ , 'D_Case ÿ , 'Quit # ÿ - 'Blank out column for case A. # ÿ - 'Blank out column for case B. # ÿ - 'Blank out column for case C. # ÿ - 'Blank out column for case D. 8 ÿ - 'Do not blank out any column. Return to main menu. $ ÿ . '/RUcase_a~/Cblank_col~case_a~ $ ÿ . '/RUcase_b~/Cblank_col~case_b~ $ ÿ . '/RUcase_c~/Cblank_col~case_c~ $ ÿ . '/RUcase_d~/Cblank_col~case_d~ ÿ . '/XMmenu~ ÿ / '/XMmenu~ ÿ / '/XMmenu~ ÿ / '/XMmenu~ ÿ / '/XMmenu~ ÿ 1 'GET_INPUT:
ÿ 1 'PRINT: ÿ 2 '/RPcopyright_p1~ ) ÿ 2 '/XLAlign paper. Press ENTER.~temp~ ÿ 3 '/RIhome_screen~ ÿ 3 '/PPOH{?}~F{?}~Q ÿ 4 '/RUcopyright_p1~ ÿ 4 'Rhome_screen~ ÿ 5 '/XMmenu~ ÿ 5 'AGPQ ÿ 6 '/XMmenu~
ÿ 7 'GRAPH:
ÿ 8 'A_Case
ÿ 8 'B_Case
ÿ 8 'C_Case
ÿ 8 'D_Case ÿ 8 'Quit ÿ 9 'Graph data for case A. ÿ 9 'Graph data for case B. ÿ 9 'Graph data for case C. ÿ 9 'Graph data for case D. . ÿ 9 'Do not graph data. Return to main menu. % ÿ : '/RUcurr_col~/Ccase_a~curr_col~ % ÿ : '/RUcurr_col~/Ccase_b~curr_col~ % ÿ : '/RUcurr_col~/Ccase_c~curr_col~ % ÿ : '/RUcurr_col~/Ccase_d~curr_col~ ÿ : '/XMmenu~ ÿ ; '/XGgraph_data~ ÿ ; '/XGgraph_data~ ÿ ; '/XGgraph_data~ ÿ ; '/XGgraph_data~ ÿ = 'GRAPH_DATA: ÿ = 'BAD_COMBO: = ÿ > '/GRGQ/XMsel_plotitem~ 7 ÿ > '/XCbeep~/XLThis combination not permitted.~temp~ ÿ ? '/XGgraph_data~ ÿ @ 'SEL_PLOTITEM: ÿ A 'Cost ÿ A 'Revenue ÿ A 'Fixed
ÿ A 'Profit
ÿ A 'Margin ÿ A 'Sales ÿ A 'Units ÿ A 'Quit * ÿ B 'Dependent Factor is: cost per unit. - ÿ B 'Dependent Factor is: revenue per unit. ( ÿ B 'Dependent Factor is: fixed costs. 0 ÿ B 'Dependent Factor is: $ profit before tax. , ÿ B 'Dependent Factor is: profit margin %. $ ÿ B 'Dependent Factor is: $ sales. ' ÿ B 'Dependent Factor is: unit sales. ÿ B 'Return to main menu. 6 ÿ C '/RUplot_formulas~/Ccost_formulas~plot_formulas~ 7 ÿ C '/RUplot_formulas~/Crevnu_formulas~plot_formulas~ 7 ÿ C '/RUplot_formulas~/Cfixed_formulas~plot_formulas~ 8 ÿ C '/RUplot_formulas~/Cprofit_formulas~plot_formulas~ 8 ÿ C '/RUplot_formulas~/Cmargin_formulas~plot_formulas~ 7 ÿ C '/RUplot_formulas~/Csales_formulas~plot_formulas~ 6 ÿ C '/RUplot_formulas~/Cunit_formulas~plot_formulas~ ÿ C '/XMmenu~ 0 ÿ D '/RUplot_titles~/Ccost_titles~plot_titles~ 1 ÿ D '/RUplot_titles~/Crevnu_titles~plot_titles~ 1 ÿ D '/RUplot_titles~/Cfixed_titles~plot_titles~ 2 ÿ D '/RUplot_titles~/Cprofit_titles~plot_titles~ 2 ÿ D '/RUplot_titles~/Cmargin_titles~plot_titles~ 1 ÿ D '/RUplot_titles~/Csales_titles~plot_titles~ 0 ÿ D '/RUplot_titles~/Cunit_titles~plot_titles~ ÿ D '/XMmenu~ ÿ E '/GOTYUnit Cost ($)~QQ ÿ E '/GOTYUnit Revenue ($)~QQ ÿ E '/GOTYFixed Costs ($)~QQ $ ÿ E '/GOTYProfit Before Tax ($)~QQ ! ÿ E '/GOTYPre-tax Margin (%)~QQ ÿ E '/GOTYTotal Sales ($)~QQ ÿ E '/GOTYUnit Sales~QQ ÿ F '/XMsel_varyitem~ ÿ F '/XMsel_varyitem~ ÿ F '/XMsel_varyitem~ ÿ F '/XMsel_varyitem~ ÿ F '/XMsel_varyitem~ ÿ F '/XMsel_varyitem~ ÿ F '/XMsel_varyitem~ ÿ H 'SEL_VARYITEM: ÿ I 'Cost ÿ I 'Revenue ÿ I 'Fixed
ÿ I 'Profit
ÿ I 'Margin ÿ I 'Sales ÿ I 'Units ÿ I 'Quit ( ÿ J 'Control Factor is: cost per unit. + ÿ J 'Control Factor is: revenue per unit. & ÿ J 'Control Factor is: fixed costs. . ÿ J 'Control Factor is: $ profit before tax. * ÿ J 'Control Factor is: profit margin %. " ÿ J 'Control Factor is: $ sales. % ÿ J 'Control Factor is: unit sales. ÿ J 'Return to main menu. + ÿ K '/XI@ISNA(cost_formula)~/XGbad_combo~ , ÿ K '/XI@ISNA(revnu_formula)~/XGbad_combo~ , ÿ K '/XI@ISNA(fixed_formula)~/XGbad_combo~ - ÿ K '/XI@ISNA(profit_formula)~/XGbad_combo~ - ÿ K '/XI@ISNA(margin_formula)~/XGbad_combo~ , ÿ K '/XI@ISNA(sales_formula)~/XGbad_combo~ + ÿ K '/XI@ISNA(unit_formula)~/XGbad_combo~ ÿ K '/XMmenu~ 1 ÿ L '/RUtbl_formula~/Ccost_formula~tbl_formula~ 2 ÿ L '/RUtbl_formula~/Crevnu_formula~tbl_formula~ 2 ÿ L '/RUtbl_formula~/Cfixed_formula~tbl_formula~ 3 ÿ L '/RUtbl_formula~/Cprofit_formula~tbl_formula~ 3 ÿ L '/RUtbl_formula~/Cmargin_formula~tbl_formula~ 2 ÿ L '/RUtbl_formula~/Csales_formula~tbl_formula~ 1 ÿ L '/RUtbl_formula~/Cunit_formula~tbl_formula~ / ÿ M '/RUgraph_title~/Ccost_title~graph_title~ 0 ÿ M '/RUgraph_title~/Crevnu_title~graph_title~ 0 ÿ M '/RUgraph_title~/Cfixed_title~graph_title~ 1 ÿ M '/RUgraph_title~/Cprofit_title~graph_title~ 1 ÿ M '/RUgraph_title~/Cmargin_title~graph_title~ 0 ÿ M '/RUgraph_title~/Csales_title~graph_title~ / ÿ M '/RUgraph_title~/Cunit_title~graph_title~ ÿ N '/GOTXUnit Cost ($)~QQ ÿ N '/GOTXUnit Revenue ($)~QQ ÿ N '/GOTXFixed Costs ($)~QQ $ ÿ N '/GOTXProfit Before Tax ($)~QQ ! ÿ N '/GOTXPre-tax Margin (%)~QQ ÿ N '/GOTXTotal Sales ($)~QQ ÿ N '/GOTXUnit Sales~QQ ÿ O '/XGset_graphlims~ ÿ O '/XGset_graphlims~ ÿ O '/XGset_graphlims~ ÿ O '/XGset_graphlims~ ÿ O '/XGset_graphlims~ ÿ O '/XGset_graphlims~ ÿ O '/XGset_graphlims~ ÿ Q 'SET_GRAPHLIMS:
ÿ Q "LOLIM:
Q ÿ Q 'INTERVALS: 1 ÿ R '/XNEnter control factor low limit. ~lolim~
ÿ R "HILIM:
R
ÿ R
ÿ R 2 ÿ S '/XNEnter control factor high limit. ~hilim~
ÿ S "SCALE: 9 ÿ S * {®Gáz? ÿ¿ þ¿
T$" ÿ¿ þ¿
ÿ S
ÿ S Q ÿ T '/XIhilim<=lolim~/XCbeep~/XLHigh limit <= low limit.~temp~/XGset_graphlims~ ÿ T "ARGUMENT: & ÿ T "@ þ ý
ÿ
ÿ T
ÿ T @ - ÿ U '{calc}{goto}df_low~+loval{calc}{home}' ÿ U "INTERVAL: O ÿ U ð?@
S
T T R W U T T R W U;
ÿ U @
ÿ U ) ÿ V '{down}{down}+interval{calc}{home}'
ÿ V "LOVAL: " ÿ V @ U Q U "
ÿ V
ÿ V
' ÿ W '{down}{down}+hival{calc}{home}'~
ÿ W "HIVAL: , ÿ W &@ U R U +ÙÎ÷ï? "
ÿ W 333333$@ ÿ X '{goto}table~/DFa23..a33~ Y ÿ Y 'SETGRAPH: ÿ Z '~ % ÿ Z '{home}/GTXXtbl_col1~Atbl_col2~ [ ' # ÿ [ 'OTFPROFITABILITY ANALYSIS~TS ÿ \ '~ ÿ \ ' ] ' ÿ ] '~QVQ ÿ ^ '~ ÿ ^ '/XMgraphsave~ / ÿ _ '/RNCtable~{bs}.{down}{end}{down}{right}~ ÿ ` '/DT1table~tbl_input~ ÿ ` 'GRAPHSAVE: + ÿ a '{down}/RNCtbl_col1~{bs}.{end}{down}~ ÿ a 'No
ÿ a 'Yes 9 ÿ b '{right}/RNCtbl_col2~{bs}.{left}{end}{down}{right}~ < ÿ b 'Do not save this graph on disk. Return to graph menu. 5 ÿ b 'Save this graph on disk (for future printing). ÿ c '/XGsetgraph~ ÿ c '/XMgraph~
ÿ c '/GS ÿ e 'FORMULAS: õ f ðÿ ! õ f @ " õ f «ªªªªFÐ@
( õ f ¬ªªªª
º@
9 õ f D@* d
( õ f Ã@
" õ f @@
! õ g À
õ g ðÿ " õ g «ªªªª
ºÀ
( õ g «ªªªªFÐÀ
9 õ g ð* d
( õ g
" õ g ³À
! õ h @
! õ h @ õ h ðÿ ( õ h Ã@
9 õ h N@* d
( õ h
" õ h
( õ i @
( õ i @ ( õ i LÍ@
õ i ðÿ % õ i d / õ i «ªªªªFÐ@
) õ i «ªªªª
ª@
6 õ j
@' {®Gáz?
7 õ j @( {®Gáz?
7 õ j ܶmÛ¶½Ð@( {®Gáz?
% õ j d õ j ðÿ 6 õ j «ªªªªFÐ@' {®Gáz?
7 õ j «ªªªª
ª@( {®Gáz?
( õ k ð
( õ k
( õ k
. õ k ÃÀ
3 õ k ð$ d
õ k ðÿ õ k ! õ l ð
! õ l ð " õ l
( õ l ÃÀ
6 õ l ð' d
õ l õ l ðÿ ÿ o 'TITLES: ÿ o 'PLOT_TITLES: ÿ p ðÿ * ÿ p 'Unit Revenue Required to Break Even ) ÿ p 'Fixed Costs Required to Break Even ! ÿ p 'Profit for Given Unit Cost ! ÿ p 'Margin for Given Unit Cost # ÿ p 'Sales Required to Break Even ( ÿ p 'Unit Sales Required to Break Even ' ÿ q 'Unit Cost Required to Break Even ÿ q ðÿ ) ÿ q 'Fixed Costs Required to Break Even $ ÿ q 'Profit for Given Unit Revenue $ ÿ q 'Margin for Given Unit Revenue # ÿ q 'Sales Required to Break Even ( ÿ q 'Unit Sales Required to Break Even ' ÿ r 'Unit Cost Required to Break Even * ÿ r 'Unit Revenue Required to Break Even ÿ r ðÿ # ÿ r 'Profit for Given Fixed Costs # ÿ r 'Margin for Given Fixed Costs # ÿ r 'Sales Required to Break Even ( ÿ r 'Unit Sales Required to Break Even ( ÿ s 'Unit Cost to Produce Given Profit + ÿ s 'Unit Revenue to Produce Given Profit * ÿ s 'Fixed Costs to Produce Given Profit ÿ s ðÿ ÿ s 'Margin for Given Profit & ÿ s 'Sales Required for Given Profit " ÿ s 'Unit Sales for Given Profit ( ÿ t 'Unit Cost to Produce Given Margin + ÿ t 'Unit Revenue to Produce Given Margin * ÿ t 'Fixed Costs to Produce Given Margin ' ÿ t 'Profit Required for Given Margin ÿ t ðÿ & ÿ t 'Sales Required for Given Margin " ÿ t 'Unit Sales for Given Margin ' ÿ u 'Unit Cost Required to Break Even * ÿ u 'Unit Revenue Required to Break Even ) ÿ u 'Fixed Costs Required to Break Even ÿ u 'Profit for Given Sales $ ÿ u 'Margin for Given Sales $ ÿ u ðÿ ÿ u 'Sales Units vs. Sales $ ' ÿ v 'Unit Cost Required to Break Even * ÿ v 'Unit Revenue Required to Break Even ) ÿ v 'Fixed Costs Required to Break Even # ÿ v 'Profit for Given Sales Units # ÿ v 'Margin for Given Sales Units ! ÿ v 'Sales $ Versus Sales Units ÿ v ðÿ
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/