Prepare production cost reports using the weighted average and FIFO methods of process costing

Prepare production cost reports using the weighted average and FIFO methods of process costing with the data below.  You may use the template available on Blackboard, modify the template, or create your own design.  If you use the template, delete any unused worksheets.

Use the Individual Input Information worksheet to calculate the numbers to use in your production cost reports.  Type these numbers in your input section.  You should have only formulas or cell references in your output area (the production cost reports).  I will deduct points for typed or hardcoded numbers anywhere except the given information in the input worksheet.

Create a summary table in the input worksheet with the following information referenced from the production cost reports.

Answer the following questions in a separate worksheet.  Create a formatted table with the questions in one column and the answers in a separate column.  Expand the columns and wrap the text to make the information easy to read.  Do not merge columns.

1. Describe at least three ways that process costing and job costing differ.
2. Describe at least two ways that weighted average and FIFO process costing methods differ.
3. What is the purpose of a production cost report?
4. Describe the concept of an equivalent unit and how to compute equivalent units.

Check the accessibility of your spreadsheet by typing “Accessibility Checker” in the “Tell me what you  want to do” search.  Make all identified corrections.  Do this for each worksheet in your workbook.  Save your Excel file with the name, “Last name First initial PC”.