Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    Buat Pandu

    Uploaded by

    Gusti Pandu
    The document provides a flexible budget performance report for Wafflio for the month of February 2021. It shows revenue, expenses, variances from budget, and unit production and sales. It also includes income statements for Aequilibrium Inc using absorption and variable costing for January 2021, showing sales, costs, expenses, gross margin, BEP in units and dollars.

    Copyright:

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

    Buat Pandu

    Uploaded by

    Gusti Pandu
    14 views5 pages
    The document provides a flexible budget performance report for Wafflio for the month of February 2021. It shows revenue, expenses, variances from budget, and unit production and sales. It also includes income statements for Aequilibrium Inc using absorption and variable costing for January 2021, showing sales, costs, expenses, gross margin, BEP in units and dollars.

    Original Title

    Buat Pandu(1)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides a flexible budget performance report for Wafflio for the month of February 2021. It shows revenue, expenses, variances from budget, and unit production and sales. It also includes income statements for Aequilibrium Inc using absorption and variable costing for January 2021, showing sales, costs, expenses, gross margin, BEP in units and dollars.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    14 views5 pages

    Buat Pandu

    Uploaded by

    Gusti Pandu
    The document provides a flexible budget performance report for Wafflio for the month of February 2021. It shows revenue, expenses, variances from budget, and unit production and sales. It also includes income statements for Aequilibrium Inc using absorption and variable costing for January 2021, showing sales, costs, expenses, gross margin, BEP in units and dollars.

    Copyright:

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

    Wafflio

    Flexible Budget Performance Report


    For the Mont Ended February 28, 2021
    Revenue/Cost Revenue and
    Particular Actual Result
    Formulas Spending Variance
    Units 120

    Sales $150q $ 17,500 $ -500 U

    Expenses:
    Wage and salaries $2,000 + $5q $ 2,700 $ 100 U
    Material $10q $ 800 $ -400 F
    Office rent $1,500 $ 1,500 $ - None
    Supplies $800 $ 1,000 $ 200 U
    Insurance $200 $ 300 $ 100 U
    Depreciation on e $500 $ 500 $ - None
    Total Expenses $ 6,800 $ - None
    Operating Expenses $ 10,700 $ -500 U
    mance Report
    uary 28, 2021
    Flixible Planning
    Activity Variance
    Budget Budget
    120 100

    $ 18,000 $ 3,000 F $ 15,000

    $ 2,600 $ 100 U $ 2,500


    $ 1,200 $ 200 U $ 1,000
    $ 1,500 $ - None $ 1,500
    $ 800 $ - None $ 800
    $ 200 $ - None $ 200
    $ 500 $ - None $ 500
    $ 6,800 $ 300 U $ 6,500
    $ 11,200 $ 2,700 F $ 8,500
    Unit produce 4,800
    Unit sold 4,600
    Selling price per unit $ 250
    Variable per unit cost:
    Direct materials $ 50
    Direct labor $ 25
    Manufacturing overhead $ 30
    Sales commision $ 5
    Office expenses $ 15
    Fixed cost per month:
    Manufacturing overhead $ 84,000
    Selling expenses $ 2,000
    Administrative expenses:
    Office building are $ 4,000
    Office are $ 10,000
    Factory are $ 7,200

    Aequilibrium Inc
    Income Statement - Absorption Costing
    For the Month Ended January 31, 2021
    Sales Revenue $ 1,150,000
    Less: Cost of Good Sold
    Beginning Inventory -
    Cost of Good Manufacturing $ 588,000
    Add: Beginning WIP, Jan 1 $ 10,000
    Less: Beginning WIP, Jan 31 $ 20,000
    Goods Avaibale for sale $ 578,000
    Less: Ending Inventory $ 4,000
    Cost of Good Sold $ 574,000
    Gross Margin $ 576,000
    Less: Selling & Adminitrative Expenses
    Variable $ 92,000
    Fixed $ 23,200
    $ 115,200
    Net Operating Income $ 460,800
    BEP in Unit = $ 107,200
    123
    = 868 Units

    BEP in Dollar = $ 217,042

    Desired in Sales Unit = $ 1,107,200


    123
    = 8,967 Units
    Cost Per Unit
    Unit Product Absorption Variable
    Direct materials $ 50 $ 50
    Direct labor $ 25 $ 25
    Manufacturing overhead $ 30 $ 30
    Fixed manufacturing overhead $ 18 -
    Cost per unit $ 123 $ 105

    Aequilibrium Inc
    Income Statement - Variable Costing
    For the Month Ended January 31, 2021
    Sales Revenue $ 1,150,000
    Less: Variable expenses
    Beginning Inventory -
    Cost of Good Manufacturing $ 504,000
    Add: Beginning WIP, Jan 1 $ 10,000
    Less: Beginning WIP, Jan 31 $ 20,000
    Goods Avaibale for sale $ 494,000
    Less: Ending Inventory $ 4,000
    Cost of Good Sold $ 490,000
    Selling & Administrative Expenses $ 92,000
    Variable expenses $ 582,000
    Gross Margin $ 568,000
    Less: Selling & Adminitrative Expenses
    Variable $ 84,000
    Fixed $ 23,200
    $ 107,200
    Net Operating Income $ 460,800

    You might also like