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_calcula | ='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_repayme | ='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_receivabl | =Past!$D$15 | |||

past_performance_accumulated_depre | =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_perc | =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_expense | =Past!$D$6 | |||

past_performance_other_current_asse | =Past!$D$17 | |||

past_performance_other_current_liabil | =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_borro | ='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_act | ='P&L'!$CO$42:$DF$42 | |||

profit_before_interest_and_taxes_vari | ='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_a | ='Sales Forecast'!$CO$44:$DF$44 | |||

subtotal_direct_cost_of_sales_units_v | ='Sales Forecast'!$DH$44:$DY$44 | |||

subtotal_direct_cost_of_sales_values | ='Sales Forecast'!$A$13:$AG$13 | |||

subtotal_direct_cost_of_sales_values | ='Sales Forecast'!$CO$13:$DF$13 | |||

subtotal_direct_cost_of_sales_values | ='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_exp | ='P&L'!$A$30:$AG$30 | |||

total_general_and_administrative_exp | ='P&L'!$CO$30:$DF$30 | |||

total_general_and_administrative_exp | ='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_actu | ='P&L'!$CO$37:$DF$37 | |||

total_other_operating_expenses_varia | ='P&L'!$DH$37:$DY$37 | |||

total_sales_and_marketing_expense | ='P&L'!$A$18:$AG$18 | |||

total_sales_and_marketing_expense_a | ='P&L'!$CO$18:$DF$18 | |||

total_sales_and_marketing_expense_v | ='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 |