Scribd Logo
Upload

Welcome to Scribd!

  • 1K views

    Liquor Store Proforma

    Uploaded by

    pkruggel
    The document provides weekly, monthly, and yearly sales, cost of goods sold, gross margin, and operating expense figures for a business. It also includes projected weekly sales amounts and labor costs. Total sales for the week were $10,160 with net profit of $1,140 or 11.22% of sales. Labor costs for one employee working 82 hours at $9 per hour were $738 for the week.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Liquor Store Proforma

    Uploaded by

    pkruggel
    1K views3 pages
    The document provides weekly, monthly, and yearly sales, cost of goods sold, gross margin, and operating expense figures for a business. It also includes projected weekly sales amounts and labor costs. Total sales for the week were $10,160 with net profit of $1,140 or 11.22% of sales. Labor costs for one employee working 82 hours at $9 per hour were $738 for the week.

    Original Description:

    An Excel spreadsheet I did for a liquor store start-up.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides weekly, monthly, and yearly sales, cost of goods sold, gross margin, and operating expense figures for a business. It also includes projected weekly sales amounts and labor costs. Total sales for the week were $10,160 with net profit of $1,140 or 11.22% of sales. Labor costs for one employee working 82 hours at $9 per hour were $738 for the week.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    1K views3 pages

    Liquor Store Proforma

    Uploaded by

    pkruggel
    The document provides weekly, monthly, and yearly sales, cost of goods sold, gross margin, and operating expense figures for a business. It also includes projected weekly sales amounts and labor costs. Total sales for the week were $10,160 with net profit of $1,140 or 11.22% of sales. Labor costs for one employee working 82 hours at $9 per hour were $738 for the week.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 3

    Week Month Year WEEKLY

    Sales $10,160 $44,027 $528,320


    COGS $7,722 $33,460 $401,523 Monday
    Gross Margin % 24% 24% 24% Tuesday
    Gross Margin $2,438 $10,566 $126,797 Wednesday
    Thursday
    Wage Expense $738 $3,198 $38,376 Friday
    Payroll Taxes @ Saturday
    15% $111 $480 $5,756 Sunday
    Heat $69 $300 $3,600
    Electric $58 $250 $3,000
    Phone/Cable/Internet $23 $100 $1,200
    Credit Card Processing $23 $100 $1,200
    Insurance $35 $150 $1,800
    Bookkeeper $46 $200 $2,400
    Maintenance/Repairs $92 $400 $4,800
    Cleaning/Supplies $23 $100 $1,200 SALES P
    Parking Rent $23 $100 $1,200
    Advertising/Marketing $58 $250 $3,000 Monday
    Tuesday
    Total Operating Expenses $1,299 $5,628 $67,532 Wednesday
    EBITDA $1,140 $4,939 $59,264 Thursday
    Friday
    Depreciation $0 $0 $0 Saturday
    Profit Before Interest and Taxes $1,140 $4,939 $59,264 Sunday

    Interest Expense $0 $0 $0
    Taxes Incurred $0 $0 $0
    Net Profit $1,140 $4,939 $59,264
    Net Profit/Sales 11.22% 11.22% 11.22%
    WEEKLY LABOR COST Weeks per year
    Open Close Hours Employees Man Hrs Weeks per month
    9:00 AM 10:00 PM 13 1 13
    9:00 AM 10:00 PM 13 1 13
    9:00 AM 10:00 PM 13 1 13
    9:00 AM 10:00 PM 13 1 13 Submittal to City
    9:00 AM 12:00 AM 15 1 15 Video Surveillance
    9:00 AM 12:00 AM 15 1 15 Signage
    Shelving
    Coolers
    Weekly Hours 82 82 Ice machine or bin
    Cigarette Rack
    Hourly Wage $9.00 $738.00 POS
    Drop Safe
    Credit Card Vendor
    Window Bars
    SALES PROJECTION Secure Back Door
    Cust/Hr. Avg. Sale Sales Vendors!
    8 $10.00 $1,040.00 Ashley
    8 $10.00 $1,040.00 Jerry Young
    8 $10.00 $1,040.00 Bookkeeper 777-3788
    8 $10.00 $1,040.00 Lottery?
    20 $10.00 $3,000.00 Get carpet cleaned
    20 $10.00 $3,000.00 Water leak above?
    lights outside front of liquor store
    replace toilet up front
    Weekly Sales $10,160.00 tear out back bathroom
    paint ceiling
    52
    4.333333

    Allegany Business Consulting

    ront of liquor store

    You might also like