Question

In: Accounting

Accounting records for NIC Enterprises (NICE) for September show the following (each entry is the total...

Accounting records for NIC Enterprises (NICE) for September show the following (each entry is the total of the actual entries for the account for the month).

Account Titles Debit Credit
Work-in-process Inventory (Direct Labor) 80,000
Wages Payable 80,000
Direct Materials Inventory 1,057,000
Accounts Payable 1,057,000
Finished Goods Inventory 1,520,000
Work-in-process Inventory 1,520,000
Cost of Goods Solda 1,460,000
Finished Goods Inventory 1,460,000

aThis entry does not include any over- or underapplied overhead. Over- or under applied overhead is written off to Cost of Goods Sold once for the month. For September, the amount written off was 2 percent of overhead applied for September. Overhead is applied on the basis of direct labor costs.

The Work-in-process ending account balance on September 30 was 125 percent of the beginning balance. The direct material ending inventory balance on September 30 was $25,000 less than the beginning balance. The finished goods beginning balance on September 1 was $148,000.

The September income statement shows revenues of $2,300,000 and a gross profit of $850,000.

Required:

a. What was the finished goods inventory on September 30?

b. How much manufacturing overhead was applied for September?

c. What was the manufacturing overhead rate for September?

d. How much manufacturing overhead was incurred for September?

e. What was the Work-in-process beginning inventory balance?

f. What was the Work-in-process ending inventory balance?

Solutions

Expert Solution

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
NIC Enterprises (NICE)
Answer a Amount $ Note
Finished goods balance on September 1        148,000.00
Add: Finished Goods Inventory during the year     1,520,000.00
Less: Finished goods sold     1,460,000.00
Finished goods balance on September 30        208,000.00 A
Answer b Amount $
Revenues     2,300,000.00
Less: Gross Profit        850,000.00
Cost of goods sold- adjusted     1,450,000.00 B
Less: Cost of goods sold- Unadjusted (as per journal entry)     1,460,000.00 C
Amount written off/ Over applied overhead          10,000.00 D=C-B
Amount written off % of manufacturing overhead applied 2% E
Manufacturing overhead applied        500,000.00 F=D/E
Answer c Amount $
Manufacturing overhead applied        500,000.00 See F
Direct Labor cost           80,000.00 G
Manufacturing overhead rate 625.00% H=F/G
Answer d Amount $
Manufacturing overhead applied        500,000.00 See F
Less: Amount written off/ Over applied overhead           10,000.00 See D
Manufacturing overhead incurred        490,000.00 I=F-D
Answer e
Work in process beginning + Manufacturing costs= Work in process ending + Transferred to Finished Goods Inventory
But, Work in process ending = 1.25 x Work in process beginning.
Therefore, Work in process beginning + Manufacturing costs= 1.25 x Work in process beginning + Transferred to Finished Goods Inventory
0.25 x Work in process beginning Manufacturing costs- Transferred to Finished Goods Inventory
We know the amount of direct labor, but not the amount of direct materials transferred into production. For this, we use the inventory equation for direct materials.
Direct materials beginning + Purchases = Direct materials ending + Transfers out
Direct materials ending = Direct materials beginning – $25,000, so
Transfers out = $1,057,000 + $25,000 = $1,082,000.
Again,
0.25 x Work in process beginning = Manufacturing costs- Transferred to Finished Goods Inventory
0.25 x Work in process beginning = $1,082,000 (direct materials) + $80,000 (direct labor) + $500,000 (applied manufacturing overhead) – $1,520,000 (transferred out)
So, Work in process beginning = $142,000 ÷ 0.25 = $568,000.
Answer f Amount $ Note
Work in process beginning        568,000.00 J
Work in process ending        710,000.00 K=J*125%

Related Solutions

Hess Company's inventory records show the following data for the month of September:                             &
Hess Company's inventory records show the following data for the month of September:                                                                                       Units                          Unit Cost Inventory, September 1                     100                            $3.00 Purchases: September 8                   450                              3.50                    September 18                    300                              3.70 A physical inventory on September 30 shows 150 units on hand. a. Calculate the value of ending inventory and cost of goods sold if the company uses FIFO inventory costing and a periodic inventory system. b. Calculate the value of ending inventory and cost of goods sold if...
Shellhammer Company's inventory records show the following data for the month of September: Units Unit Cost...
Shellhammer Company's inventory records show the following data for the month of September: Units Unit Cost Inventory, September 1 100 $3.34 Purchases: September 8 450 3.50 September 18 350 3.70 A physical inventory on September 30 shows 200 units on hand. Calculate the value of the ending inventory and cost of goods sold if the company uses weighted average inventory costing and a periodic inventory system. (Round cost per unit to 2 decimal places and ending inventory and cost of...
The following selected data were taken from the accounting records of Colorado Enterprises: Month Machine Hours...
The following selected data were taken from the accounting records of Colorado Enterprises: Month Machine Hours Manufacturing Overhead May 47,000 $ 899,000 June 60,400 1,134,000 July 70,000 1,295,700 August 53,000 982,000 Manufacturing overhead consists of three different costs; (1) machine supplies (variable), (2) property taxes (fixed), and (3) plant maintenance (semivariable). July's overhead costs were $171,500 for machine supplies, $24,200 for property taxes, and $1,100,000 for plant maintenance. Required: Determine the machine supplies and property taxes for May. By using...
The accounting records of Perkins Inc. show the following data for 2019. Pretax financial income was...
The accounting records of Perkins Inc. show the following data for 2019. Pretax financial income was $640,000. Life insurance expense on officers was $16,000. Equipment was acquired in early January for $450,000, straight-line depreciation over 5 year life is used, with no salvage value. For tax purposes, Perkins Inc. used a 40% rate to calculate depreciation. Product warranties were estimated to be $75,000 in 2018. Actual repair and labor costs related to the warranties in 2019 were $15,000 and the...
The accounting records of Marin Inc. show the following data for 2017 (its first year of...
The accounting records of Marin Inc. show the following data for 2017 (its first year of operations). 1. Life insurance expense on officers was $9,500. 2. Equipment was acquired in early January for $307,000. Straight-line depreciation over a 5-year life is used, with no salvage value. For tax purposes, Marin used a 30% rate to calculate depreciation. 3. Interest revenue on State of New York bonds totaled $3,700. 4. Product warranties were estimated to be $50,900 in 2017. Actual repair...
[The following information applies to the questions displayed below.] The accounting records of Nettle Distribution show...
[The following information applies to the questions displayed below.] The accounting records of Nettle Distribution show the following assets and liabilities as of December 31, 2016 and 2017. December 31 2016 2017 Cash $ 42,759 $ 6,324 Accounts receivable 23,210 18,197 Office supplies 3,661 2,682 Office equipment 112,390 119,717 Trucks 43,980 52,980 Building 0 146,610 Land 0 36,583 Accounts payable 61,020 30,264 Note payable 0 83,193 Required: 1. Prepare balance sheets for the business as of December 31, 2016 and...
QUESTION The following misstatements are included in the accounting records of a manufacturing company. For each...
QUESTION The following misstatements are included in the accounting records of a manufacturing company. For each misstatement classify each misstatement as either a fraud or an error; give one or more controls to prevent each error/fraud from occurring, and identify the audit evidence to uncover each error/fraud. Misstatements Classify as fraud or error Give one or more controls to prevent each error/fraud from occurring Identify the audit evidence to uncover each error/fraud A sales invoice was incorrectly recorded by $1000...
Show the following transactions that should be recorded in U.S. BoP using double-entry accounting system: A.)...
Show the following transactions that should be recorded in U.S. BoP using double-entry accounting system: A.) Newmont Mining—a U.S. mining concern—exports $400 million worth of copper to China and is paid in the form of a payment drawn on a U.S. bank B.) Dupont expands its plastics manufacturing capacity in its Polish plant by investing $250 million financed by a dollar bond issue in London (United Kingdom C.) The U.S. government provides food assistance to Sudanese refugees in the amount...
The Accounting Equation Ginger Enterprises began the year with total assets of $505,000 and total liabilities...
The Accounting Equation Ginger Enterprises began the year with total assets of $505,000 and total liabilities of $227,000. Using this information and the accounting equation, answer each of the following independent questions. 1. What was the amount of Ginger's owners' equity at the beginning of the year? $ 2. If Ginger's total assets increased by $101,000 and its total liabilities increased by $71,000 during the year, what was the amount of Ginger's owners' equity at the end of the year?...
Records at Hal’s Accounting Services show the following costs for year 1: Direct materials and supplies...
Records at Hal’s Accounting Services show the following costs for year 1: Direct materials and supplies $ 47,000 Employee costs 2,900,000 Total overhead 1,300,000 Production was 25,000 billable hours. Fixed overhead was $760,000. Assuming no change in billable hours in year 2, direct materials and supplies costs are expected to increase by 10 percent. Direct labor costs are expected to increase by 15 percent. Variable overhead per billable hour is expected to remain the same, but fixed overhead is expected...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT