Question

In: Accounting

Question 3 (13 marks) Bergamo Bay Co. uses enterprise resource planning (ERP) system to combine the...

Question 3
Bergamo Bay Co. uses enterprise resource planning (ERP) system to combine the business activities with accounting activities. ERP system provides an integrated and continuously updated view of core business processes. The system can track business resources, i.e. cash, raw materials, etc., and shares data across various departments (manufacturing, purchasing, sales, accounting, etc.), and various stakeholders of the company. The system also can provide timely information and report to variable users within the company. On December 31, 2019 ERP system generated the following trial balance. The company’s manager knows something is wrong with the trial balance because it does not show any balance for Work in Process Inventory but does show a balance for the Factory Payroll and Factory Overhead account.
Debit Credit
Cash $ 57,600
Accounts receivable 50,400
Raw materials inventory 31,200
Work in process inventory 0
Finished goods inventory 10,800
Prepaid rent 3,600
Accounts payable $ 12,600
Notes payable 16,200
Common stock 36,000
Retained earnings 104,400
Sales 216,000
Cost of goods sold
Factory payroll 126,000
19,200
Factory overhead 32,400
Operating expenses 54,000
Totals $ 385,200 $ 385,200
After examining various files, the manager identifies the following six source documents that need to be processed to bring the accounting records up to date.
Materials requisition 21-3010: $ 5,520 direct materials to Job 402
Materials requisition 21-3011: $ 9,120 direct materials to Job 404
Materials requisition 21-3012: $ 2,520 indirect materials
Labor time ticket 6052: $ 6,000 direct labor to Job 402
Labor time ticket 6053: $ 9,600 direct labor to Job 404
Labor time ticket 6054: $ 3,600 indirect labor
Jobs 402 and 404 are the only units in process at year-end. The predetermined overhead rate is 200% of direct labor cost.
Required:
(1) Prepare journal entries to assign the costs below:
(a) Direct materials costs to Work in Process Inventory.
(b) Direct labor costs to Work in Process Inventory.
(c) Overhead costs to Work in Process Inventory.
(d) Indirect materials costs to the Factory Overhead account.
(e) Indirect labor costs to the Factory Overhead account.
(2) According the entries from part (1) related to factory overhead, determine the amount of under- or overapplied overhead for the year.
(3) Prepare the adjusting entry to allocate any over- or underapplied overhead to Cost of Goods Sold, assuming the amount is not material.

Solutions

Expert Solution

1 Ref. General journal Debit Credit
a. Work in process inventory (5520+9120) 14640
Raw materials inventory 14640
(Direct materials costs to WIP Inventory)
b. Work in process inventory (6000+9600) 15600
Factory payroll 15600
(Direct labor costs to WIP Inventory)
c. Work in process inventory (15600*200%) 31200
Factory overhead 31200
(Overhead costs to WIP Inventory)
d. Factory overhead 2520
Raw materials inventory 2520
(Indirect materials costs to the Factory Overhead )
e. Factory overhead 3600
Factory payroll 3600
(Indirect labor costs to the Factory Overhead )
2 Actual factory overhead incurred:
$
Balance 32400
Indirect materials 2520
Indirect labor 3600
Total 38520
Factory overhead applied=$ 31200
Factory overhead applied < Actual FOH
Hence, overhead is under-applied
Under-applied overhead=38520-31200=$ 7320
3 Journal entry:
Account titles Debit Credit
Cost of goods sold 7320
Factory overhead 7320

Related Solutions

Question 3 (13 marks) Bergamo Bay Co. uses enterprise resource planning (ERP) system to combine the...
Question 3 Bergamo Bay Co. uses enterprise resource planning (ERP) system to combine the business activities with accounting activities. ERP system provides an integrated and continuously updated view of core business processes. The system can track business resources, i.e. cash, raw materials, etc., and shares data across various departments (manufacturing, purchasing, sales, accounting, etc.), and various stakeholders of the company. The system also can provide timely information and report to variable users within the company. On December 31, 2019 ERP...
Bergamo Bay Co. uses enterprise resource planning (ERP) system to combine the business activities with accounting...
Bergamo Bay Co. uses enterprise resource planning (ERP) system to combine the business activities with accounting activities. ERP system provides an integrated and continuously updated view of core business processes. The system can track business resources, i.e. cash, raw materials, etc., and shares data across various departments (manufacturing, purchasing, sales, accounting, etc.), and various stakeholders of the company. The system also can provide timely information and report to variable users within the company. On December 31, 2019 ERP system generated...
An enterprise resource planning system (ERP) can be a valuable resource to a company to implement...
An enterprise resource planning system (ERP) can be a valuable resource to a company to implement and evaluate a set of corporate strategies. Comment on advantages and reasons why such a system might fail in some industries.
What is Availability to Promise (ATP) in an Enterprise Resource Planning (ERP) system? Please be detailed...
What is Availability to Promise (ATP) in an Enterprise Resource Planning (ERP) system? Please be detailed in your response.
Clearly define and distinguish Enterprise Resource Planning (ERP), Customer Relationship management (CRM) and Enterprise system (ES)...
Clearly define and distinguish Enterprise Resource Planning (ERP), Customer Relationship management (CRM) and Enterprise system (ES) how do these systems relate to each other?
8. German Company, PAS software is developing an ERP (Enterprise Resource Planning) system for sale to...
8. German Company, PAS software is developing an ERP (Enterprise Resource Planning) system for sale to mid-size companies around the world. Software development started during 2018, during which time $45 million was incurred. During 2019, and additional $60 million was incurred, with $10 million of this incurred after technological feasibility of the new software had been established. Record the journal entry for the 2019 software development costs. Refer back to question 8. Assume this product was released to customers in...
In a recent study of enterprise resource planning​ (ERP) system​ effectiveness, researchers asked companies how they...
In a recent study of enterprise resource planning​ (ERP) system​ effectiveness, researchers asked companies how they assessed the success of their ERP systems. Out of 360 manufacturing companies​ surveyed, they found that 201 used return on investment​ (ROI), 110 used reductions in inventory​ levels,42 used improved data​ quality, and 7 used​ on-time delivery. In a survey of 860 service​ firms,470 used​ ROI,260 used inventory​ levels,100 used improved data​ quality, and 30 used​ on-time delivery. Is there evidence that the measures...
What does enterprise resource planning (ERP) allow an organization to do?
What does enterprise resource planning (ERP) allow an organization to do?
The engineering team at Manuel’s Manufacturing Inc. is planning to purchase an enterprise resource planning (ERP)...
The engineering team at Manuel’s Manufacturing Inc. is planning to purchase an enterprise resource planning (ERP) system. The software and installation from Vendor A costs $380,000 initially and is expected to have revenue $125,000 per year every year.Manuel’s uses a 4-year planning horizon and a 10% per year MARR. What is the discounted payback period of the investment (do linear interpolation to answer)?
The engineering team at Manuel’s Manufacturing, Inc. is planning to purchase an Enterprise Resource Planning (ERP)...
The engineering team at Manuel’s Manufacturing, Inc. is planning to purchase an Enterprise Resource Planning (ERP) system. The software and installation from Vendor A costs $360,000 initially and is expected to increase revenue $120,000 per year every year. The software and installation from Vendor B costs $260,000 and is expected to increase revenue $90,000 per year. Manuel’s uses a 4 year planning horizon and a 10% per year MARR. Based on an internal rate of return analysis which ERP system...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT