21 NOV 2010 P&L Inputs 0 Inputs MONTHS - Start with any month of a 12 month period. Select your Start month from the drop-down menu. It will be displayed on all screens. Estimated SALES - Enter @Retail, without sales tax. Round all entries to the thousands. Examples: $42,385.22 becomes 42.4; $5,787.92 becomes 5.8; $385.33 becomes 0.4 GROSS MARGIN % - Enter estimated Gross Margin (Gross Profit) percent for each month of the 12 month period. Enter maintained margin, after markdowns. Can be up to one decimal place (tenths of percent). Examples: Enter 44, becomes 44.0%; enter 38.5, becomes 38.5% EXPENSES - The Calculator needs just one entry for each expense "bucket". Variable expenses are entered as a percent of sales. Use whole numbers to one decimal place Examples: Enter 12.5, becomes 12.5%; enter 10, becomes 10% Fixed expenses are a flat $ amount for each month. (Take totals for the year and divide by 12 to get an estimate of yours.) Round all $ entries to nearest thousand. Examples: $8,673 becomes 8.7; $12,229 becomes 12.2 (See details in About "Expense Buckets" link.) BUYING PLAN Inputs Beginning Inventory @Cost - Enter the approximate amount of total inventory on hand at the start of your 12 month planning period. Close counts! Round $ entries to nearest thousand Targeted Inventory Turns - Choose your targeted inventory turnover rate from the drop-down menu. Short- and Long-Term DEBT Obligations Current Inventory Payables - Estimate of your total Accounts Payable for inventory (only) purchases. Close counts! Round $ entry to nearest thousand. Example: Enter $127,835 as 127.8 Other Payables - Estimate the total of all other payables. Round $ entry to nearest thousand. Example: Enter $25,450 as 25.5 Long Term Loan Payments - Enter monthly payments (principal only) for any existing Long Term loans. Round $ entry to nearest thousand. CASH on Hand - Estimate of cash available at beginning of the 12 month planning period you are using. Close counts! May also be a negative entry to reflect payments/checks waiting to clear. Round $ entry to nearest thousand.