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