Question

In: Accounting

Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project...

Process Cost Excel Project

Create a new Excel spreadsheet and name it “Last name_PC”. You project is to create a model for a production cost report using the weighted average method for the month of May.   Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area. You should also include directions (in a text box) for users.

After completion of the production cost report using the weighted average method, create a new worksheet and label the tab “FIFO”. Create a production cost report using the same information using the FIFO method.

Department Data:

Information about units:

Units in beginning WIP

21,000

Started during the month

240,000

Units in Ending WIP

20,000

Percentage of Completion:

Beginning Inventory:

Direct materials

40%

Conversion

70%

Ending Inventory:

Direct Materials

30%

Conversion

60%

Costs in Beginning WIP:

Direct materials

$210,000

Conversion

$135,000

Costs incurred during the month:

Direct Materials

$1,150,000

Direct Labor

$45,000

Overhead

$605,000

Process Cost Project – non-Excel

Answer questions 1 – 4. Use your Excel spreadsheet to answer questions 5 - 9

Possible Points

Earned

Points

1. Describe how process costing is different than job costing. Identify at least three differences.

3

2. Describe the two basic differences between the weighted average and the FIFO method.

2

3. What is the purpose of a production cost report?

2

4. Describe the concept of an equivalent unit and how to compute equivalent units.

2

5. What is the total cost to be accounted for?

1

6. How much cost will you transfer to the next WIP department using the FIFO method?

2

7. What is the value of materials in beginning inventory at the start of NEXT month for the current process department using weighted average?

2

8. Draw the WIP process T accounts for the two departments, mixing and baking, and show the cost flow from one to the other (do this for both methods – 4 T accounts)

4

9. Do the journal entry transferring costs from one process to the next under both methods.

2

Total

20

Solutions

Expert Solution

PART-1

Process Costing is one method for collecting and assigning manufacturing costs to the units produced.Process costing is a method of costing used mainly in manufacturing where units are continuously mass-produced through one or more processesExamples of this include the manufacture of erasers, chemicals or processed food.

Job Costing is a costing method used to determine the cost of specific jobs, which are performed according to the customer’s specifications. It is a basic costing method which is applicable where work consists of separate projects or contract.It enables management to detect those jobs which are more profitable and unprofitable ones.

Difference Between process and job costing

On the Basis Of Process Costing Job Costing
Uniqueness of product process costing is used for standardized products Job costing is used for unique products

Size of job

process costing is used for large production runs Job costing is used for very small production runs
Record keeping since time and materials must be charged to specific jobs. Process costing aggregates costs, and so requires less record keeping. job costing is required Much more record keeping

  

PART2

FIFO METHOD-FIFO stands for “First-In, First-Out”. It is a method used for cost flow assumption purposes in the cost of goods sold calculation.The FIFO method assumes that the oldest products in a company’s inventory have been sold first.

WEIGHTED AVERAGE METHOD-In the weighted average cost method, the cost of goods available for sale is divided by the number of units available for sale and is commonly used when inventory items are so melded or identical to each other that it is impossible to assign specific costs to single units.

DIFFERENCE BETWEEN FIFO AND WEIGHTED AVERAGE METHOD

FIFO METHOD
The earliest inventory received will be excluded from the business first and the cost will be allocated in accordance. The inventory will be excluded from a business based on an average cost of all goods present in a business.
FIFO method will report higher profits if inflation is rising and vice versa. Weighted average method will report higher profits if inflation is decreasing and vice versa.

PART3

The production cost report. summarizes the production and cost activity within a department for a reporting period. It is simply a formal summary of the four steps performed to assign costs to units transferred out and units in ending work-in-process (WIP) inventory.

PART4

An equivalent unit of production is an expression of the amount of work done by a manufacturer on units of output that are partially completed at the end of an accounting period. Basically the fully completed units and the partially completed units are expressed in terms of fully completed units.

Equivalent units. are calculated by multiplying the number of physical (or actual)units on hand by the percentage of completion of the units.Assume that a manufacturer uses direct labor continuously in one of its production departments. During June, the department began with no units in inventory and then started and completed 10,000 units. In addition, it started 1,000 units but they were only 30% complete at the end of June. The production cost report for this department will indicate that it manufactured 10,300 (10,000 + 300) equivalent units of product during June.


Related Solutions

Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project...
Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project is to create a model for a production cost report using the weighted average method for the month of May.   Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area....
Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project...
Process Cost Excel Project Create a new Excel spreadsheet and name it “Last name_PC”. You project is to create a model for a production cost report using the weighted average method for the month of May.   Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area....
Create an Excel spreadsheet or use the project template to show your computations for the first...
Create an Excel spreadsheet or use the project template to show your computations for the first 10 ratios listed for Apple Inc. and Alphabet Inc., in 2017. Supporting calculations must be shown either as a formula or as text typed into a different cell. Earnings per share of common stock (as given in the income statement) current ratio (current assets divided by current liabilities) gross profit rate (gross profit divided by net sales) profit margin (net income divided by net...
Project 2 Calculations must be done in Excel – You must create your own spreadsheet (do...
Project 2 Calculations must be done in Excel – You must create your own spreadsheet (do not copy and paste someone else’s). This question should be done using Method 1 as outlined in lecture 6 (i.e. Tax Effects, then Cash Flows then NPV) As the financial advisor to All Star Manufacturing you are evaluating the following new investment in a manufacturing project: - The project has a useful life of 12 years. Land costs $6m and is estimated to have...
Create a budget spreadsheet for a hypothetical organization in excel
Create a budget spreadsheet for a hypothetical organization in excel
You will complete a capital budgeting Excel spreadsheet solution based on: Cost of new equipment                          &nb
You will complete a capital budgeting Excel spreadsheet solution based on: Cost of new equipment                                             $14,800,000 Shipping and installation                                                  200,000 Unit sales Year 1           70,000 Year 2          120,000 Year 3          120,000 Year 4            80,000 Year 5            70,000 Sales price = $300 / unit in years 1-4 and $250/unit in year 5 Variable cost = $140 / unit Fixed cost = $700,000 per year for all 5 years Working capital : $200,000 at start of project, recovered at end Depreciation =...
a. Use the multiple regression spreadsheet provided in the Excel spreadsheet to do the following: create...
a. Use the multiple regression spreadsheet provided in the Excel spreadsheet to do the following: create a new data set that is a subset of this larger provided data set. The new data set should include the dependent variable (VALUE) and the following independent variables (AGE, LOTSIZE, RMS, MOD KITCH, MOD BATH, AIRCON and FIREPL). b. For this new data set, use the Correlation option of Data Analysis in Excel and produce the correlation matrix associated with the dependent variable...
Create an Excel spreadsheet in which you use capital budgeting tools to determine the quality of...
Create an Excel spreadsheet in which you use capital budgeting tools to determine the quality of 3 proposed investment projects, as well as a 6-8 page report that analyzes your computations and recommends the project that will bring the most value to the company. I have completed the excel portion of this question Scenario You work as a finance manager for Drill Tech, Inc., a mid-sized manufacturing company located in Minnesota. Three capital project requests were identified as potential projects...
Your task is to create the 2021 Budget in an Excel Spreadsheet.  You only need to prepare...
Your task is to create the 2021 Budget in an Excel Spreadsheet.  You only need to prepare an Income Statement Assume: The company will sell 16,000 bicycles at an average price of $2,500 each Cost of Labor is 20% of Sales Cost of Materials is 10% of Sales Variable Overhead is 6% of Sales Fixed Manufacturing Overhead is $4,000,000 Office Salaries are 5,000,000 Office Deprecation Expense is $500,000 Lease Expense of Corporate Office is $2,000,000 Advertising is $1,000,000 Income Taxes are...
Create a spreadsheet in Excel that lists at least three financing options available to firms. You...
Create a spreadsheet in Excel that lists at least three financing options available to firms. You can find an Excel template of this in the attached Financing options spreadsheet.xlsx. Identify and describe each of the instruments, state who would be the targeted market for this instrument, explain the process that the firm must take to get this financing option and state the regulations related to the option. Financing Options Financing Option Description Market Process Regulations  
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT