Scribd Logo
Upload

Welcome to Scribd!

  • 37 views

    Pro-Rpt - Xls Production Report - Weighted Average Method

    Uploaded by

    juvilyn valera
    The document contains production reports using the weighted average and FIFO costing methods. It lists quantity schedules, equivalent units, beginning and ending work-in-process and inventory, unit costs, and cost reconciliations. Numbers are populated throughout tables to calculate total costs to be accounted for, costs transferred out and remaining in work-in-process using the different costing methods.

    Copyright:

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

    Pro-Rpt - Xls Production Report - Weighted Average Method

    Uploaded by

    juvilyn valera
    37 views4 pages
    The document contains production reports using the weighted average and FIFO costing methods. It lists quantity schedules, equivalent units, beginning and ending work-in-process and inventory, unit costs, and cost reconciliations. Numbers are populated throughout tables to calculate total costs to be accounted for, costs transferred out and remaining in work-in-process using the different costing methods.

    Original Description:

    Prorpt

    Original Title

    pro-rpt-1

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains production reports using the weighted average and FIFO costing methods. It lists quantity schedules, equivalent units, beginning and ending work-in-process and inventory, unit costs, and cost reconciliations. Numbers are populated throughout tables to calculate total costs to be accounted for, costs transferred out and remaining in work-in-process using the different costing methods.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    37 views4 pages

    Pro-Rpt - Xls Production Report - Weighted Average Method

    Uploaded by

    juvilyn valera
    The document contains production reports using the weighted average and FIFO costing methods. It lists quantity schedules, equivalent units, beginning and ending work-in-process and inventory, unit costs, and cost reconciliations. Numbers are populated throughout tables to calculate total costs to be accounted for, costs transferred out and remaining in work-in-process using the different costing methods.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    You are on page 1of 4

    Pro-rpt.

    xls
    * Put in 13 required information.
    PRODUCTION REPORT - WEIGHTED AVERAGE METHOD
    Overhead Rate:
    Quantity Schedule and Equivalent Units
    Quantity Percentage Complete:
    Schedule Materials
    Units to be accounted for: Beginning: XXXXXXX *
    Work in process, beginning XXXXXXX *
    Started into production XXXXXXX * Ending: XXXXXXX *
    Total units to be accounted for #VALUE!

    Equivalent Units
    Units accounted for as follows: Materials Labor
    Transferred Out XXXXXXX * #VALUE! #VALUE!
    Work in process, ending XXXXXXX * #VALUE! #VALUE!
    Total units accounted for #VALUE! #VALUE! #VALUE!

    Unit Costs
    Work in process, beginning #VALUE! XXXXXXX * XXXXXXX *
    Cost added by the department #VALUE! XXXXXXX * XXXXXXX *
    Total cost (a) #VALUE! #VALUE! #VALUE!

    Equivalent units (b) #VALUE! #VALUE!


    Unit cost, (a)/(b) #VALUE! = #VALUE! + #VALUE! +

    Cost Reconciliation Equivalent Units (EU)


    Costs
    Cost to be accounted for:
    Work in process, beginning #VALUE!
    Cost added by the department #VALUE!
    Total cost to be accounted for #VALUE!

    Cost accounted for as follows:


    #VALUE! for Transferred Out units #VALUE! XXXXXXX XXXXXXX

    Work in process, ending:


    #VALUE! for Materials per EU #VALUE! #VALUE!
    #VALUE! for Labor per EU #VALUE! #VALUE!
    #VALUE! for Overhead per EU #VALUE!

    Total work in process, ending #VALUE!

    Total cost accounted for #VALUE!

    PRODUCTION REPORT - FIFO METHOD


    Quantity Schedule and Equivalent Units Quantity Percentage Complete:
    Schedule Materials
    Units to be accounted for: Beginning: XXXXXXX
    Work in process, beginning XXXXXXX
    Started into production XXXXXXX Ending: XXXXXXX

    Total units to be accounted for #VALUE!


    Equivalent Units

    Units accounted for as follows: Materials Labor


    Transferred out:
    From beginning inventory XXXXXXX #VALUE! #VALUE!
    Started and completed this period #VALUE! #VALUE! #VALUE!
    Work in process, ending XXXXXXX #VALUE! #VALUE!

    Total units accounted for #VALUE! #VALUE! #VALUE!

    Unit Costs
    Cost added by the department (a) #VALUE! XXXXXXX XXXXXXX
    Equivalent units (b) #VALUE! #VALUE!
    Unit cost, (a)/(b) #VALUE! = #VALUE! + #VALUE! +

    Cost Reconciliation Equivalent Units (EU)


    Costs
    Cost to be accounted for:
    Work in process, beginning #VALUE!
    Cost added by the department #VALUE!

    Total cost to be accounted for #VALUE!

    Cost accounted for as follows:


    Transferred out:
    From beginning inventory:
    Cost in beginning inventory #VALUE!
    Cost to complete these units:
    #VALUE! for Materials per EU #VALUE! #VALUE!
    #VALUE! for Labor per EU #VALUE! #VALUE!
    #VALUE! for Overhead per EU #VALUE!

    Total cost #VALUE!


    Units started and completed #VALUE! #VALUE! #VALUE!
    #VALUE! 14,000 @ $5.61 each
    Total costs transferred #VALUE!

    Work in process, ending:


    #VALUE! for Materials per EU #VALUE! #VALUE!
    #VALUE! for Labor per EU #VALUE! #VALUE!
    #VALUE! for Overhead per EU #VALUE!

    Total work in process, ending #VALUE!

    Total cost accounted for #VALUE!


    d information.

    XXXXXXX *

    Conversion
    XXXXXXX *

    XXXXXXX *

    Overhead
    #VALUE!
    #VALUE!
    #VALUE!

    #VALUE!
    #VALUE!
    #VALUE!

    #VALUE!
    #VALUE!

    lent Units (EU)

    XXXXXXX

    #VALUE!

    Conversion
    XXXXXXX
    XXXXXXX

    Overhead

    #VALUE!
    #VALUE!
    #VALUE!

    #VALUE!

    #VALUE!
    #VALUE!
    #VALUE!

    lent Units (EU)

    #VALUE!

    #VALUE!

    #VALUE!

    You might also like