What is the Logistics worksheet? Copyright 2003-2017 Bay Area Business Design  
Plan Settings      
Plan Setting Name Value   Description
PS_PlanTitle ACME Consulting ACME Consulting Plan title
PS_ExpenseCategories FALSE FALSE True, if you select YES for expense categories
PS_AdministrativeLabel General and Administrative General and Administrative Expense categories label
PS_SalesMarketingLabel Sales and Marketing Sales and Marketing Expense categories label
PS_ProductionLabel Production Production Expense categories label
PS_OtherLabel Other Other Expense categories label
PS_Startup TRUE TRUE True, for a startup business - False for an ongoing business
PS_Products FALSE FALSE True, if you sell products
PS_NonProfit FALSE FALSE True, if you selected the non-profit business type
PS_Inventory TRUE TRUE True, if you manage inventory
PS_Receivables FALSE FALSE True, if you sell on credit
PS_Accrual TRUE TRUE True, if you selected the standard financials - False if you selected cash-basis
PS_StandardTerm TRUE TRUE True, if you selected a "Standard Term" business plan - False if you selected the "Long-term" plan
PS_StartingMonth 9 9 1 if your starting month is set for January, 3 if it's set for March etc.
PS_StartingYear 2000 2000 The starting year for your plan
PS_Date FALSE FALSE Used to set PS_DateSetting
PS_AnnualDetail FALSE FALSE True, if you selected a 2nd year of monthly data - False, if you didn't
PS_SalesByUnits TRUE TRUE True, if you selected a units-based forecast - False, if you chose to forecast by values
PS_QuickBooks FALSE FALSE True, if you selected "Yes, I use Quickbooks and I plan on importing financial data later."
PS_NetOtherIncome FALSE FALSE True, if you chose to track other income and expenses
PS_Accounting FALSE FALSE True, if you chose to forecast personnel costs by the number of employees and average salaries
PS_PersonnelbyPeople FALSE FALSE True, if you chose to forecast personnel costs by the number of employees and average salaries
PS_Premier TRUE TRUE True, if the workbook was created by the Premier version
PS_ProductServices 1 1
PS_DateSetting 1 Usually set to 2, 1 if you chose to replace month and year labels with non-date specific month and year labels
PS_CellFormat $500.00
Public Names Start Cell
accounts_payable =Balance!$A$21:$AG$21
accounts_receivable =Balance!$A$7:$AG$7
accounts_receivable_lookup ='Receivables Detail'!$B$30:$AB$39
accumulated_depreciation =Balance!$A$14:$AG$14
acid_test =Ratios!$O$55:$AH$55
additional_investment_requirement =Funding!$B$28
assets_to_sales =Ratios!$O$53:$AH$53
average_per_unit_revenue ='Break-even'!$O$7
average_per_unit_revenue_calculated ='Break-even'!$O$16
average_per_unit_variable_cost ='Break-even'!$O$8
average_variable_cost ='Break-even'!$O$9
beginning_payables_balance ='Payment Detail'!$A$7:$AG$7
beginning_receivables_balance ='Receivables Detail'!$A$8:$AG$8
cash =Balance!$A$6:$AN$6
cash_balance_on_starting_date =Funding!$B$10
cash_from_receivables ='Cash Flow'!$A$7:$AG$7
cash_sales ='Cash Flow'!$B$6:$AG$6
cash_spending ='Cash Flow'!$C$24:$AG$24
collection_days =Ratios!$A$38:$AH$38
collection_days_estimator ='Receivables Detail'!$A$3:$AN$3
Collection_Period ='Receivables Detail'!$B$3:$BT$3
cost_of_unit_sales ='P&L'!$A$4:$AN$4
current_borrowing =Balance!$A$22:$AG$22
current_interest_rate =Assumptions!$A$4:$AG$4
depreciation ='P&L'!$A$24:$AN$24
depreciation_actual ='P&L'!$CO$24:$DF$24
depreciation_variance ='P&L'!$DH$24:$DY$24
direct_cost_of_sales ='P&L'!$A$4:$AG$4
dividend_payout =Ratios!$O$57:$AH$57
dividends ='Cash Flow'!$A$36:$AG$36
earnings =Balance!$A$31:$AG$31
ending_inventory_balance ='Inventory Detail'!$A$11:$AG$11
ending_payables_balance ='Payment Detail'!$A$11:$AG$11
ending_receivables_balance ='Receivables Detail'!$A$11:$AG$11
estimated_collection_period_in_days ='Receivables Detail'!$A$3:$AG$3
estimated_monthly_fixed_cost ='Break-even'!$O$10
estimated_monthly_fixed_cost_calculated ='Break-even'!$O$18
estimated_receivables_balance ='Receivables Detail'!$A$27:$AG$27
general_and_administrative_payroll ='P&L'!$A$22:$AG$22
general_and_administrative_percent ='P&L'!$A$31:$AG$31
gross_margin ='P&L'!$A$9:$AG$9
gross_margin_actual ='P&L'!$CO$9:$DF$9
gross_margin_percent ='P&L'!$A$10:$AG$10
gross_margin_variance ='P&L'!$DH$9:$DY$9
include_negative_taxes ='P&L'!$AD$60:$AG$60
include_negative_taxes_2nd_year ='P&L'!$AC$60
include_negative_taxes_first_year ='P&L'!$O$60
interest_expense ='P&L'!$A$44:$AG$44
interest_expense_actual ='P&L'!$CO$44:$DF$44
interest_expense_variance ='P&L'!$DH$44:$DY$44
inventory =Balance!$A$8:$AG$8
inventory_purchase ='Inventory Detail'!$A$10:$BT$10
inventory_purchased_this_period ='Inventory Detail'!$A$10:$AG$10
inventory_turnover =Ratios!$O$39:$AH$39
inventory_used_this_period ='Inventory Detail'!$A$9:$AG$9
less_bill_payments ='Payment Detail'!$A$10:$AG$10
less_cash_spending ='Payment Detail'!$A$9:$AG$9
long_term_assets =Balance!$A$13:$AG$13
long_term_interest_rate =Assumptions!$A$5:$AG$5
long_term_liabilities =Balance!$A$26:$AG$26
long_term_liabilities_principal_repayment ='Cash Flow'!$A$33:$AG$33
minimum_inventory_purchase ='Inventory Detail'!$C$4
monthly_sales_breakeven ='Break-even'!$O$4
monthly_units_breakeven ='Break-even'!$O$3
months_of_inventory_on_hand ='Inventory Detail'!$A$3:$AG$3
net_cash_flow ='Cash Flow'!$A$39:$AG$39
net_other_income ='P&L'!$A$57:$AG$57
net_other_income_actual ='P&L'!$CO$57:$DF$57
net_other_income_variance ='P&L'!$DH$57:$DY$57
net_profit ='P&L'!$A$58:$AG$58
net_profit_actual ='P&L'!$CO$58:$DF$58
net_profit_margin =Ratios!$O$33:$AH$33
net_profit_variance ='P&L'!$DH$58:$DY$58
net_worth =Balance!$A$35:$AG$35
new_accounts_payable ='Payment Detail'!$A$23:$AN$23
new_current_borrowing ='Cash Flow'!$A$13:$AG$13
new_investment_received ='Cash Flow'!$A$18:$AG$18
new_long_term_liabilities ='Cash Flow'!$A$15:$AG$15
new_other_liabilities_interest_free ='Cash Flow'!$A$14:$AG$14
new_payment_obligations_this_period ='Payment Detail'!$A$23:$AG$23
other_current_liabilities =Balance!$A$23:$AG$23
other_liabilities_principal_repayment ='Cash Flow'!$A$32:$AG$32
paid_in_capital =Balance!$A$29:$AG$29
past_capital_assets =Past!$D$21
past_performance_accounts_payable =Past!$D$28
past_performance_accounts_receivable =Past!$D$15
past_performance_accumulated_depreciation =Past!$D$22
past_performance_cash =Past!$D$14
past_performance_collection_days =Past!$D$7
past_performance_current_borrowing =Past!$D$29
past_performance_earnings =Past!$D$38
past_performance_gross_margin =Past!$D$4
past_performance_gross_margin_percent =Past!$D$5
past_performance_inventory =Past!$D$16
past_performance_inventory_turnover =Past!$D$8
past_performance_long_term_liabilities =Past!$D$33
past_performance_operating_expenses =Past!$D$6
past_performance_other_current_assets =Past!$D$17
past_performance_other_current_liabilities =Past!$D$30
past_performance_paid_in_capital =Past!$D$36
past_performance_payment_days =Past!$D$44
past_performance_sales =Past!$D$3
payment_days_estimator ='Payment Detail'!$A$3:$AG$3
payment_delay_in_days ='Payment Detail'!$C$3
payroll =Personnel!$C$72:$AN$72
payroll_expense =Assumptions!$A$11:$AN$11
payroll_taxes ='P&L'!$A$28:$AG$28
Payroll1 =Personnel!$C$3:$AN$3
Payroll2 =Personnel!$C$12:$AN$12
Payroll3 =Personnel!$A$42:$AN$42
Payroll3GA =Personnel!$C$32:$AN$32
Payroll3OTH =Personnel!$C$38:$AN$38
Payroll3P =Personnel!$C$20:$AN$20
Payroll3SM =Personnel!$C$26:$AN$26
Payroll4 =Personnel!$A$68:$AN$68
Payroll4GA =Personnel!$C$59:$AN$59
Payroll4OTH =Personnel!$C$64:$AN$64
Payroll4P =Personnel!$C$49:$AN$49
Payroll4SM =Personnel!$C$54:$AN$54
percent_equity_acquired ='Investment Analysis'!$N$8
plan_month =Assumptions!$A$3:$BT$3
plus_new_payment_obligations ='Payment Detail'!$A$8:$AG$8
principal_repayment_of_current_borrowing ='Cash Flow'!$A$31:$AG$31
production_payroll ='P&L'!$5:$5
profit_before_int_and_taxes ='P&L'!$A$42:$AG$42
profit_before_interest_and_taxes ='P&L'!$A$42:$AG$42
profit_before_interest_and_taxes_actual ='P&L'!$CO$42:$DF$42
profit_before_interest_and_taxes_variance ='P&L'!$DH$42:$DY$42
purchase_long_term_assets ='Cash Flow'!$A$35:$AG$35
purchase_other_current_assets ='Cash Flow'!$A$34:$AG$34
RD_CollectionDays ='Receivables Detail'!$C$3
retained_earnings =Balance!$A$30:$AG$30
sales ='P&L'!$A$3:$AG$3
sales_2 ='P&L'!$A$3:$AG$3
sales_3 ='P&L'!$A$3:$AG$3
sales_4 ='P&L'!$A$3:$AG$3
sales_5 ='P&L'!$A$3:$AG$3
sales_6 ='P&L'!$A$3:$AG$3
sales_actual ='P&L'!$CO$3:$DF$3
sales_and_marketing_percent ='P&L'!$A$19:$AG$19
sales_of_long_term_assets ='Cash Flow'!$A$17:$AG$17
sales_of_other_current_assets ='Cash Flow'!$A$16:$AG$16
sales_on_credit ='Receivables Detail'!$A$9:$AG$9
sales_on_credit_percent ='Receivables Detail'!$A$4:$AG$4
sales_tax_vat_hst_gst_paidout ='Cash Flow'!$A$30:$AG$30
sales_tax_vat_hst_gst_received ='Cash Flow'!$A$12:$AG$12
sales_units_directcosts ='Sales Forecast'!$A$41:$AG$43
sales_units_sales ='Sales Forecast'!$A$30:$AG$32
sales_variance ='P&L'!$DH$3:$DY$3
salesunits ='Sales Forecast'!$A$33:$AG$33
salesunits_actual ='Sales Forecast'!$CO$33:$DF$33
salesunits_variance ='Sales Forecast'!$DH$33:$DY$33
salesvalues ='Sales Forecast'!$A$7:$AG$7
salesvalues_actual ='Sales Forecast'!$CO$7:$DF$7
salesvalues_variance ='Sales Forecast'!$DH$7:$DY$7
Starting_balance_accounts_receivable =Balance!$B$7
starting_balance_inventory =Balance!$B$8
starting_balance_payables =Balance!$B$21
startup_accounts_payable =Funding!$B$19
startup_additional_cash_raised =Funding!$B$9
startup_cash_required ='Start-up'!$B$15
startup_current_borrowing =Funding!$B$17
startup_inventory ='Start-up'!$B$16
startup_long_term_assets ='Start-up'!$B$18
startup_long_term_liabilities =Funding!$B$18
startup_other_current_assets ='Start-up'!$B$17
startup_other_current_liabilities =Funding!$B$20
startup_total_assets ='Start-up'!$B$19
startup_total_capital =Funding!$B$32
startup_total_investment =Funding!$B$29
startup_total_liabilities =Funding!$B$21
startup_total_requirements ='Start-up'!$B$21
subtotal_cash_from_operations ='Cash Flow'!$A$8:$AG$8
subtotal_cash_received ='Cash Flow'!$A$19:$AG$19
subtotal_cash_spent ='Cash Flow'!$A$37:$AG$37
subtotal_current_liabilities =Balance!$A$24:$AG$24
subtotal_direct_cost_of_sales_units ='Sales Forecast'!$A$44:$AG$44
subtotal_direct_cost_of_sales_units_actual ='Sales Forecast'!$CO$44:$DF$44
subtotal_direct_cost_of_sales_units_variance ='Sales Forecast'!$DH$44:$DY$44
subtotal_direct_cost_of_sales_values ='Sales Forecast'!$A$13:$AG$13
subtotal_direct_cost_of_sales_values_actual ='Sales Forecast'!$CO$13:$DF$13
subtotal_direct_cost_of_sales_values_variance ='Sales Forecast'!$DH$13:$DY$13
subtotal_spent_on_operations ='Cash Flow'!$A$26:$AG$26
tax_rate =Assumptions!$A$6:$AG$6
taxes_incurred ='P&L'!$A$45:$AG$45
taxes_incurred_actual ='P&L'!$CO$45:$DF$45
taxes_incurred_variance ='P&L'!$DH$45:$DY$45
total_assets =Balance!$A$16:$AG$16
total_capital =Balance!$A$32:$AG$32
total_cost_of_sales ='P&L'!$A$7:$AG$7
total_cost_of_sales_actual ='P&L'!$CO$7:$DF$7
total_cost_of_sales_variance ='P&L'!$DH$7:$DY$7
total_current_assets =Balance!$A$10:$AG$10
total_expense ='P&L'!$A$30:$AG$30
total_general_and_administrative_expense ='P&L'!$A$30:$AG$30
total_general_and_administrative_expense_actual ='P&L'!$CO$30:$DF$30
total_general_and_administrative_expense_variance ='P&L'!$DH$30:$DY$30
total_liabilities =Balance!$A$27:$AG$27
total_liabilities_and_capital =Balance!$A$33:$AG$33
total_long_term_assets =Balance!$A$15:$AG$15
total_operating_expenses ='P&L'!$A$40:$AG$40
total_operating_expenses_actual ='P&L'!$CO$40:$DF$40
total_operating_expenses_variance ='P&L'!$DH$40:$DY$40
total_other_expense ='P&L'!$A$55:$AG$55
total_other_expense_actual ='P&L'!$CO$55:$DF$55
total_other_expense_variance ='P&L'!$DH$55:$DY$55
total_other_income ='P&L'!$A$50:$AG$50
total_other_income_actual ='P&L'!$CO$50:$DF$50
total_other_income_variance ='P&L'!$DH$50:$DY$50
total_other_operating_expenses ='P&L'!$A$37:$AG$37
total_other_operating_expenses_actual ='P&L'!$CO$37:$DF$37
total_other_operating_expenses_variance ='P&L'!$DH$37:$DY$37
total_sales_and_marketing_expense ='P&L'!$A$18:$AG$18
total_sales_and_marketing_expense_actual ='P&L'!$CO$18:$DF$18
total_sales_and_marketing_expense_variance ='P&L'!$DH$18:$DY$18
total_startup_expenses ='Start-up'!$B$12
total_unit_sales ='Sales Forecast'!$A$22:$AG$22
valuation_earnings_multiple ='Investment Analysis'!$B$14:$AG$14
valuation_sales_multiple ='Investment Analysis'!$B$15:$AG$15
variable_cost_per_unit_calculated ='Break-even'!$O$17