Mr. Roberts, the CEO of Robust Robots, Inc. has begun a small manufacturing process that will...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 being 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 100% 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 $41,880. Actual factory overhead costs totaled $45,000. The following information is available concerning direct materials. Direct Materials-Plastic Pellets Beginning inventory Purchase of plastic Each robot takes a pound of plastic pellets. O plastic pellets 100,000 pounds @ $10.63 a pound Direct Material-Motors Beginning inventory Purchase of motors O motors 100,000 motors @ $15.00 each Each robot contains one motor. Direct Materials-Wheels Beginning inventory Purchase of wheels O wheels 200,000 wheels @ $5.00 each Each robot needs 2 wheels. 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%. Please prepare a Statement of Cash Flows as shown below in the book using Excel. After you answer all questions on Blackboard please staple the Statement of Cash Flows, prepared in Excel, to the back cover of the practice set. Robust Robots, Inc. Statement of Cash Flows For the Year Ended December 31, 2019 lens Cash Flows from Operating Activities Net Income Adjustments to reconcile net income to Net cash flow from operating activities istot Depreciation Amortization Gain or Loss Changes in current operating assets and liabilities Net Cash Flow from Operating Activities Cash Flows from Investing Activities Cash received from sale Less cash used for purchases Net Cash Flow from Investing Activities Cash Flow from Financing Activities Cash received from sale Less cash paid dividends or long-term debt Net Cash Flow from Financing Activities Increase or decrease in cash Cash at the beginning of the year Cash at the end of the year 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 being 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 100% 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 $41,880. Actual factory overhead costs totaled $45,000. The following information is available concerning direct materials. Direct Materials-Plastic Pellets Beginning inventory Purchase of plastic Each robot takes a pound of plastic pellets. O plastic pellets 100,000 pounds @ $10.63 a pound Direct Material-Motors Beginning inventory Purchase of motors O motors 100,000 motors @ $15.00 each Each robot contains one motor. Direct Materials-Wheels Beginning inventory Purchase of wheels O wheels 200,000 wheels @ $5.00 each Each robot needs 2 wheels. 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%. Please prepare a Statement of Cash Flows as shown below in the book using Excel. After you answer all questions on Blackboard please staple the Statement of Cash Flows, prepared in Excel, to the back cover of the practice set. Robust Robots, Inc. Statement of Cash Flows For the Year Ended December 31, 2019 lens Cash Flows from Operating Activities Net Income Adjustments to reconcile net income to Net cash flow from operating activities istot Depreciation Amortization Gain or Loss Changes in current operating assets and liabilities Net Cash Flow from Operating Activities Cash Flows from Investing Activities Cash received from sale Less cash used for purchases Net Cash Flow from Investing Activities Cash Flow from Financing Activities Cash received from sale Less cash paid dividends or long-term debt Net Cash Flow from Financing Activities Increase or decrease in cash Cash at the beginning of the year Cash at the end of the year
Expert Answer:
Answer rating: 100% (QA)
Robust Robots Inc Cash Flow Statement for the year ended December 31 2019 Particulars Dec 31st 2019 ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A small manufacturing process has two phases: printing department and assembly. The cycle time/unit in printing is P1 minutes and in assembly P2 minutes. The printed units queue in front of assembly...
-
In an injection molding procedure plastic parts are produced by injecting the plastic material into a mold. Some variability is experienced in the resulting weight (or equivalently density) of the...
-
During company estimates that total factory overhead costs will be $750,000 for the year. Direct labor hours are estimated to be 300,000. For Darling company, (a) Determine the predetermined factory...
-
The quarterly sales for a software product over the past three years are given in the table below. 1) Forecast the demand for year 4 using the moving average technique for 3 periods. 1) Compute the...
-
Set out advantages and disadvantages associated with public sector entities using a separate reporting framework. Cite examples in support of each advantage or disadvantage given.
-
Mistral Software is considering a merger with Amsted Technologies. Mistral has 1.2 million shares outstanding with a value of $22, while Amsted has 800,000 shares outstanding with a $23 value. The...
-
Discuss the ratios computed for Tyler Company in problems 13 through 16. What is your assessment of the performance and future potential of Tyler Company? Data From Problem 13:- The following reserve...
-
Gazarra Company is a very profitable small business. It has not, however, given much consideration to internal control. For example, in an attempt to keep clerical and office expenses to a minimum,...
-
Consider the following items for Huskies Insurance Company: 1. Income taxes for the year total $50,000 but won't be paid until next April 15. 2. On June 30, the company lent its chief financial...
-
Jim and Joel have come to you to get an appraisal to lease their property. Using the information below, complete the following questions: Answer the below questions according to the property details...
-
1. A) Vision 2030 emphasises the importance of a change in production structure, a change in export structure, and the contribution to be made to wealth creation by small- and medium-scale...
-
Caso 2 Hulera de Sula S. A. es una empresa dedicada a la importacin de hule natural y sinttico para la produccin de llantas y la fabricacin de diversos productos de hule; su planta est ubicada en la...
-
Mountaineer Outfitters, a fictitious company, has locations in Asheville, NC; Lexington, KY; and Charlottesville, VA. Mountaineer's management wants to evaluate and compare performance at each of the...
-
shorten and reword the following Selling a property is one of the biggest financial transactions you'll make, at OBrien Real Estate we aim to take the stress out of the equation and deliver a result...
-
Because hedge funds are only available to sophisticated investors Question 27 options: they do not need to comply with all of the reporting requirements. they are conservative with investments....
-
The use of a corporation can provide income tax deferral only if the shareholder(s) can afford to leave the after-tax income in the corporation. Question content area bottom Part 1 A. False because...
-
(Sovereign Default Model) Let it be a risk free rate on the T-Bills. Let D, be the amount of debt. When the government issues the amount of debt Dt and defaults on it, the household consumption with...
-
a. Show that the expansion of q(x) in ascending powers of x can be approximated to 10 2x + Bx 2 + Cx 3 where B and C are constants to be found. b. Find the percentage error made in using the series...
-
A high-performance missile for launching a satellite has a unity feedback system with a loop transfer function Sketch the root locus as K varies from 0 K(s 18) (s 2) (s2 2)(s12)
-
A teleported control system incorporates both a person (operator) and a remote machine. The normal teleportation system is based on a one-way link to the machine and limited feedback to the operator....
-
In recent years, many automatic control systems for guided vehicles in factories have been installed. One system uses a magnetic tape applied to the floor to guide the vehicle along the desired lane...
-
Financial items for George Karatsis IT Services on 31 May 2024 are presented below in alphabetical order. Required (a) Prepare a statement of financial position similar to the one in figure 2.2. (b)...
-
During the year ended 30 June 2024, Skilled Services, a provider of temporary secretary personnel, had collected receipts from clients for a total value of \($250000.\) Wages of \($136000\) had been...
-
Rebecca Tallance operates a rent a dress business from her home. She keeps her accounting records for business activities completely separate from her records for personal activities. At 30 June...
Study smarter with the SolutionInn App