Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need the help to find answer of 2 - 9. Part Two Instructions ACCOUNTING Using a spreadsheet and based on the information provided in

I need the help to find answer of 2 - 9.

image text in transcribed

image text in transcribed

Part Two Instructions ACCOUNTING Using a spreadsheet and based on the information provided in the next section, complete the following SOCIETY requirements: 1. Determine the predetermined overhead rate. 50,000/100,000 = 50.50 2. Determine the total number of robots to account for 3. Prepare an equivalent unit's schedule. The schedule should follow the format below. You may add additional information if you would like. Whole Equivalent Units Units (Actual) Direct Direct Direct Materials Conversion Material Material Plastic Parts Costs Motor Beginning XXX Wheels XXX XXX XXX XOOX Start/Completed XXX XXX XXX Completed/ XXX XOOX XXX XOOX Transferred Out XXX Ending XXX XXX XOXOX xox 4. Determine the total cost for the plastic and the unit amount for the plastic for one robot 5. Determine the total cost for the motors and the unit cost for each motor 6. Determine the total cost for the wheels and the unit cost for the wheels for the robot. 7. Determine the total conversion cost and the conversion cost per robot 8. Determine the total equivalent cost per robot. 9. Prepare a cost of Production report. This report should show all costs transferred into Work in Process and the costs transferred to Finished Goods. This process uses FIFO costing Manufacturing Process Information Mr. Roberts, the CEO of Robust Robots, Inc. has begun a small manufacturing process that will manufacture simple functioning robots and then sell the robots to merchandising companies. The manufacturing process starts with plastic beine formed into parts through injection molding After the parts are cooled and inspected the parts are assembled. The first step is attaching the dome to the body, attach the legs, then insert the motor and fasten the wheels. Once completed the robots are then transferred to finished goods. This is a process cost system and the company elects to use the FIFO method of accounting for product costs Direct material plastic is added 100% at the beginning of the process for all parts. Direct material motors and wheels are added 1001 as the last step in the manufacturing process At the beginning of the accounting period, Mr. Roberts estimates that production will be 100,000 robots during the year. Estimated factory overhead is $50,000. This information is to be used to determine the application rate for the manufacturing overhead. Estimated and actual direct labor costs totaled S41,880. Actual factory overhead costs totaled $45,000 The following information is available concerning direct materials. Direct Materials-Plastic Pellets Beginning inventory O plastic pellets Purchase of plastic 100,000 pounds @ $10.63 a pound Each robot takes a pound of plastic pellets. Direct Material Motors Beginning inventory Purchase of motors Each robot contains one motor. O motors 100,000 motors @ $15.00 each Direct Materials-Wheels Beginning inventory Purchase of wheels Each robot needs 2 wheels. O wheels 200,000 wheels @ $5.00 each The Work-in-Process account has the following information: Ending work in process inventory has 17,000 units that are 100% complete as to plastic parts, 25% complete as to conversion costs and 0% complete as to motors and wheels. The Finished Goods account has the following Information: The finished goods inventory at January 1, 2019 had a balance of 2,000 robots at a cost of $140,000 and on December 31, 2019 had an ending balance of 3,000 robots. The selling price of the robot is $70.00. Selling and Administrative Costs totaled $100,000; tax rate is 35%. Part Two Instructions ACCOUNTING Using a spreadsheet and based on the information provided in the next section, complete the following SOCIETY requirements: 1. Determine the predetermined overhead rate. 50,000/100,000 = 50.50 2. Determine the total number of robots to account for 3. Prepare an equivalent unit's schedule. The schedule should follow the format below. You may add additional information if you would like. Whole Equivalent Units Units (Actual) Direct Direct Direct Materials Conversion Material Material Plastic Parts Costs Motor Beginning XXX Wheels XXX XXX XXX XOOX Start/Completed XXX XXX XXX Completed/ XXX XOOX XXX XOOX Transferred Out XXX Ending XXX XXX XOXOX xox 4. Determine the total cost for the plastic and the unit amount for the plastic for one robot 5. Determine the total cost for the motors and the unit cost for each motor 6. Determine the total cost for the wheels and the unit cost for the wheels for the robot. 7. Determine the total conversion cost and the conversion cost per robot 8. Determine the total equivalent cost per robot. 9. Prepare a cost of Production report. This report should show all costs transferred into Work in Process and the costs transferred to Finished Goods. This process uses FIFO costing Manufacturing Process Information Mr. Roberts, the CEO of Robust Robots, Inc. has begun a small manufacturing process that will manufacture simple functioning robots and then sell the robots to merchandising companies. The manufacturing process starts with plastic beine formed into parts through injection molding After the parts are cooled and inspected the parts are assembled. The first step is attaching the dome to the body, attach the legs, then insert the motor and fasten the wheels. Once completed the robots are then transferred to finished goods. This is a process cost system and the company elects to use the FIFO method of accounting for product costs Direct material plastic is added 100% at the beginning of the process for all parts. Direct material motors and wheels are added 1001 as the last step in the manufacturing process At the beginning of the accounting period, Mr. Roberts estimates that production will be 100,000 robots during the year. Estimated factory overhead is $50,000. This information is to be used to determine the application rate for the manufacturing overhead. Estimated and actual direct labor costs totaled S41,880. Actual factory overhead costs totaled $45,000 The following information is available concerning direct materials. Direct Materials-Plastic Pellets Beginning inventory O plastic pellets Purchase of plastic 100,000 pounds @ $10.63 a pound Each robot takes a pound of plastic pellets. Direct Material Motors Beginning inventory Purchase of motors Each robot contains one motor. O motors 100,000 motors @ $15.00 each Direct Materials-Wheels Beginning inventory Purchase of wheels Each robot needs 2 wheels. O wheels 200,000 wheels @ $5.00 each The Work-in-Process account has the following information: Ending work in process inventory has 17,000 units that are 100% complete as to plastic parts, 25% complete as to conversion costs and 0% complete as to motors and wheels. The Finished Goods account has the following Information: The finished goods inventory at January 1, 2019 had a balance of 2,000 robots at a cost of $140,000 and on December 31, 2019 had an ending balance of 3,000 robots. The selling price of the robot is $70.00. Selling and Administrative Costs totaled $100,000; tax rate is 35%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Federal Budget Politics Policy Process

Authors: Allen Schick

3rd Edition

0815777353, 9780815777359

More Books

Students also viewed these Accounting questions

Question

How are the derivatives of sin -1 x and cos -1 x related?

Answered: 1 week ago

Question

Contrast positive motivation with negative motivation.

Answered: 1 week ago

Question

a sin(2x) x Let f(x)=2x+1 In(be)

Answered: 1 week ago