BUSINESS PLAN WORKSHOP

FOR A RETAIL STORE

The DISKETTE included with your BUSINESS PLAN WORKSHOP FOR A RETAIL STORE contains over 100 preformulated schedules and graphs to provide all of the reports you must have to effectively run your business.

The schedules and graphs that develope within the BUSINESS PLAN WORKSHOP FOR A RETAIL STORE center around four files created on LOTUS 123 (use LOTUS 123 version 2.0 or higher). They can easily be imported into most other spreadsheet programs including Microsoft's Excel. These schedules and graphs were designed to give you the most information with a minimum amount of time spent inputting data.

SALES

SALES.WK1 requires daily input of total sales and register key/product line sales.

COSTS

COSTS.WK1 requires monthly input of operating costs and inventory markups.

CASHFLOW

CASHFLOW.WK1 requires daily input. It tracks the store's daily cash flow and forecasts what cash will be available in the future.

FINANCE

FINANCE.WK1 requires monthly input of data, most of which feeds from the other three files.

The following schedules and graphs are all configured automatically within the four files SALES, COSTS, CASHFLOW and FINANCE. ***N O * A D D I T I O N A L * I N P U T*** is required on your part. They are available for you to use as tools for effectively operating your business.

SALES SCHEDULES AND GRAPHS

Line Graph: Total Daily Sales - A seperate graph for each month.
Line Graph: Average Dollar Value Per Sale - A seperate graph for each month.
Pie Graph: Register Key # % of Sales - A seperate graph for each month.
Schedule: Monthly Sales by Product Line - Quarterly totals also.
Line Graph: Total Monthly Sales
Pie Graph: Monthly Sales as a % of Total Year
Line Graph: Average Daily Sales by Month
Line Graph: Average Dollar Value Per Sale
Line Graph: Average # of Sales Per Day
Pie Graph: Annual Register Key # % of Sales

COSTS SCHEDULES AND GRAPHS

Pie Graph: Worker Type % of Total Gross Salaries - A seperate graph every month.
Pie Graph: Worker Type % of Total Hours Worked - A seperate graph every month.
Line Graph: Total Monthly Payroll
Pie Graph: Monthly Payroll as a % of Total Year
Line Graph: Monthly Salaries by Worker Type
Pie Graph: Worker Type % of Total Hours Worked
Line Graph: Quarterly Salaries by Worker Type
Pie Graph: Worker Type % of Total Gross Salaries
Line Graph: Monthly Hours Worked by Worker Type
Line Graph: Average Hourly Wage
Line Graph: Monthly Payroll Taxes by Worker Type
Line Graph: Monthly Occupancy Costs
Pie Graph: Expense Type % of Total Occupancy
Pie Graph: Fixed/Variable % of Total Occupancy
Pie Graph: Fixed Type % of Total Fixed Costs
Pie Graph: Variable Type % of Total Variable Costs
Line Graph: Monthly Utility Costs
Line Graph: Monthly Maintenance Costs
Line Graph: Monthly Heating Fuel Costs
Pie Graph: Inventory % Markup on Goods Sold
Schedule: Contribution/Break Even Analysis
Line Graph: Contribution Analysis/Break Even Point
Line Graph: Monthly Inventory Purchases
Pie Graph: Monthly Inventory Purchases % of Year
Pie Graph: Vendor Purchases % of Total Purchases

FINANCE SCHEDULES AND GRAPHS

Line Graph: Monthly Net Income (Loss)
Line Graph: Month End Quick Assets
Line Graph: Month End Inventory Balances
Line Graph: Month End Current Liabilities
Line Graph: Ownership Equity
Schedule: Monthly Cash Flow Statement
Schedule: Standard Financial Ratios
Line Graph: Profitability Ratios
Line Graph: Liquidity Ratios
Line Graph: Asset Management Ratios
Line Graph: Debt Management Ratios
Line Graph: Cash Flow Ratios

BACK TO THE BUSINESS PLAN WORKSHOP HOME PAGE

This web site was constructed by Thomas Fischer. To find out about having him design or assist you with your site, just click here.

business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan business plan