Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    02 Heys BudGET

    Uploaded by

    sadeq770113

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    02 Heys BudGET

    Uploaded by

    sadeq770113
    8 views7 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    8 views7 pages

    02 Heys BudGET

    Uploaded by

    sadeq770113

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 7

    Sales Budget

    Q1 Q2 Q3 Q4
    expected sales unit 3,000 3,500 4,000 4,500 5,000
    expected price /unit 60 60 60 60
    total sales 180,000 210,000 240,000 270,000 900,000

    Production Budget
    Sales Unit 3,000 3,500 4,000 4,500 5,000
    Desired Ending Finished Goods 700 800 900 1,000 -
    Total Unit 3,700 4,300 4,900 5,500
    Less Beginning Finished Goods 600 700 800 900
    Required Production Unit 3,100 3,600 4,100 4,600

    Direct material Budget


    Required Prod. Unit 3,100 3,600 4,100 4,600 -
    Raw material Required /Pound 2 2 2 2
    Total Material required 6,200 7,200 8,200 9,200 -
    Desired Ending Direct Material 720 820 920 1,020
    Total Material required 6,920 8,020 9,120 10,220
    Less Beginning Direct material 620 720 820 920
    net Required Material 6,300 7,300 8,300 9,300
    Cost per pound 4 4 4 4
    required material to be purchased 25,200 29,200 33,200 37,200
    Labor Budget Year
    Units to be produced 3,100 3,600 4,100 4,600 15,400
    Labor hour per pound 2 2 2 2
    total hours 6,200 7,200 8,200 9,200
    Cost per hour 10 10 10 10
    total labor cost 62,000 72,000 82,000 92,000

    Manufacturing Overhead Budget


    Variable Cost
    indirect material @ $1 6,200 7,200 8,200 9,200 30,800
    indirect labor @ $1.40 8,680 10,080 11,480 12,880 43,120
    utilities $.04 2,480 2,880 3,280 3,680 12,320
    Maintained @ 0.20 1,240 1,440 1,640 1,840 6,160
    Total Variable Cost 18,600 21,600 24,600 27,600 92,400
    Fixed Cost
    Salaries 20,000 20,000 20,000 20,000 80,000
    Depreciation 3,800 3,800 3,800 3,800 15,200
    Tax 9,000 9,000 9,000 9,000 36,000
    maintained 5,700 5,700 5,700 5,700 22,800
    38,500 38,500 38,500 38,500 154,000
    57,100 60,100 63,100 66,100 246,400
    Manufacturing Overhead per labor Hour 8
    Selling and Administrative Expense Budget
    Variable Cost
    sales commissions $3 9,000 10,500 12,000 13,500 45,000
    freight-out $1 3,000 3,500 4,000 4,500 15,000
    Tot Variable Cost 12,000 14,000 16,000 18,000 60,000
    Fixed Cost
    Advertising 5,000 5,000 5,000 5,000 20,000
    Sales salaries 15,000 15,000 15,000 15,000 60,000
    Office salaries 7,500 7,500 7,500 7,500 30,000
    Depreciation 1,000 1,000 1,000 1,000 4,000
    Property taxes and insurance 1,500 1,500 1,500 1,500 6,000
    42,000 44,000 46,000 48,000 180,000
    Total Selling and Administrative Expense Budget
    240,000
    Budgeted Income Statement
    cost element Hours Cost Per Hr Total Cost
    Direct Material 2 4 8
    labor 2 10 20
    mfg. cost 2 8 16
    total cost 44
    Budgeted Income Statement-Activity
    Sales 900,000
    COGS 660,000
    Gross profit 240,000
    depreciation 4,000
    S&A 180,000
    EBIT 60,000
    interest 100
    EBT 59,900
    TAX 12,000
    NET INCOME 47,900
    Collection Plan
    Sales Q1 Q2 Q3 Q4
    60,000
    q1 180,000 108,000 72,000
    q2 210,000 126,000 84,000
    q3 240,000 144,000 96,000
    q4 270,000 162,000 64,800
    168,000 198,000 228,000 258,000

    Accounts Payables
    Q1 Q2 Q3 Q4
    10,600
    Q1 25,200 12,600 12,600
    Q2 29,200 14,600 14,600
    Q3 33,200 16,600 16,600
    Q4 37,200 18,600
    Total Payments 23,200 27,200 31,200 35,200
    Cash Budget
    Q1 Q2 Q3 Q4
    beginning Cash Balance 38,000 25,500 15,000 19,400
    Collection
    Collection from Customers 168,000 198,000 228,000 258,000
    Sales Invs 2,000
    Total Collecton 208,000 223,500 243,000 277,400

    Less Cash Disbursement


    Purchasing Payment 23,200 27,200 31,200 35,200
    Direct Labor 62,000 72,000 82,000 92,000
    Mfg OH 53,300 56,300 59,300 62,300
    Selling Admin 41,000 43,000 45,000 47,000
    Truck - 10,000
    Tax 3,000 3,000 3,000 3,000
    Total Disbursement 182,500 211,500 220,500 239,500
    Exces (diff) of avail cash 25,500
    Financing - 3,000
    Payment of Loan and Int. 3,100
    Ending Cash Balance 25,500 15,000 19,400 37,900
    Balance Sheet
    Current Asset
    Cash 37,900
    A/R 108,000
    Finished Goods Inv. 44,000
    Raw Material Inv. 4,080
    Current Asset 193,980
    PP&E 192,000
    Depr 48,000
    Net Fixed Assets 144,000
    Total Assets 337,980
    Liab& Equity
    Current Liab
    A/P 18,600
    Equity
    Common Stock 225,000
    Retained Earning 94,380
    Total Equity 319,380
    Total liab and equity 337,980

    You might also like