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 |
|
|
|
|
|
|
|
|