Cost Accounting

Comprehensive Process Costing Problem Excel Assignment Number 3 (Chapter 6)

Information Given:

Well Products produces an antacid product that goes through two departments – Cooking and Bottling. The company has recently hired a new assistant accountant, who has prepared the following summary of production and costs for the Cooking Department for May using the weighted-average method.

Cooking Department Costs:

*Consists of materials, $39,000; labor $5,000; and overhead, $17,000 Cooking Department costs assigned to:

Quarts completed and transferred to the Bottling Department: 400,000 quarts at ? per quart                                                         ? Work in process inventory, May 31: 50,000 quarts, Materials 70% complete, labor and overhead 40% Complete                                                   ?

Total departmental costs assigned                                                ?

The new accountant has determined the cost per quart transferred to be $2.415, as follows:

        Total departmental costs, 966,010        Quarts completed and transferred, 400,000

However, the new accountant is unsure how to use this unit cost figure in assigning cost to the ending work in process inventory. In addition, the company’s general ledger shows only

$898,460 in costs transferred from the Cooking Department to the Bottling Department, which does not agree with the $966,000 figure above.

The general ledger also shows the following costs incurred in the Bottling Department during May: materials used, $130,000, direct labor cost incurred, $80,000; and overhead cost applied to products, $158,000.

Required:

2. Prepare journal entries as follows to record activity in the company during Key your entries to the letters (a) through (g) below.
   1. Raw materials were issued to the two departments for use in
   2. Direct labor costs were incurred in the two
   3. Manufacturing overhead costs were incurred, $400,000. (Credit Accounts Payable) The company maintains a single manufacturing Overhead account for the entire
   4. Manufacturing overhead cost was applied to production in each department using predetermined overhead rates.
   5. Units completed as to processing in the Cooking Department were transferred to the Bottling Department, $898,460.
   6. Units completed as to processing in the Bottling Department were transferred to Finished Gods, $1,300,000.
   7. Units were sold on account, $2,000,000. The Cost of Goods Sold was $1,250,000.
3. Post the journal entries from (1) above to T-accounts. Balances in selected accounts on May 1 are given below:

After posting the entries to the T-accounts, find the ending balance in the inventory accounts and the Manufacturing Overhead account. Use just one Manufacturing Overhead account, using debit amounts for actual or incurred overhead and credit amounts for assigning or applying overhead.

3. Prepare a production report for the Cooking Department for May using the FIFO method.

4. Using the closeout to the COGS method, determine the over or underapplied overhead and show the journal entry to close the manufacturing overhead account.

IMPORTANT NOTES:

This problem should be worked in an Excel spreadsheet.

MUST organize the Excel spreadsheet IN A WAY THAT it can be easily followed AND the steps to the solutions are clearly defined and shown.

Use the part numbers and letters to organize your answer.