Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

plz help!!! The financial information for the past two years (2018 and 2017) is provided. Using a spreadsheet application, such as Microsoft Excel, and the

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

plz help!!!

The financial information for the past two years (2018 and 2017) is provided. Using a spreadsheet application, such as Microsoft Excel, and the information from the previous years, provide the following: 1. Prepare a Statement of Cash Flows for the current year using the indirect method. 2. Using horizontal analysis, prepare a Comparative Balance Sheet. 3. Using vertical analysis, prepare an Income Statement. 4. Using the textbook, calculate the ratios set out below and round to two decimals. Do the ratios for both years unless the ratio needs an average-then only do.it for the current year: a. Current Ratio b. Quick ratio c. . Accounts Receivable Turnover d. Days Sales in Receivables e. Inventory Turnover f. Days Sales in Inventory g. Working Capital h. Liabilities to Stockholders' Equity i. Earnings Per Share 5. Acting as an accounting advisor to the firm, prepare a memo in which you analyze the financial statements you prepared in step two and prepare an analysis of the company's financial position. Identify two strengths and two weaknesses in the company. Make two recommendations to improve the company's financial position. Be specific in each of the recommendations and use the ratios to support-your analysis. The company has a credit policy of 1/10,n/30 and uses this as part of its evalution. The length should be no more than one page. If there are any grammatical or spelling errors you will not receive credit for the memo. 6. Please have the following information complete before entering your answers onto blackboard: a. Statement of Cash Flows b. Balance Sheet with horizontal analysis c. Income Statement with vertical analysis d. Worksheet showing your ratios e. Memo analyzing the company's strengths and weaknesses with two recommendations Comparative Balance Sheet CC Statement of Retained Earnings Part Two Instructions Using a spreadsheet and based on the information provided in the next section, complete the following requirements: 1. Determine the started and completed units by using the following formula: Started - Ending = Completed and Transferred Out Beginning 2. Prepare an equivalent units schedule. The schedule should follow the format below; you may add additional information if you would like. (Remember that the schedule is for units of cars, not aluminum and wheels.) 3. Calculate the total cost and the cost per equivalent unit for the direct materials aluminum. If the number is not exact round to the nearest cent. 4. Calculate the total cost and the cost per equivalent unit for the direct materials wheels. If the number is not exact round to the nearest cent. 5. Calculate the predetermined overhead rate. If the number is not exact round to the nearest cent. 6. Determine the total conversion cost by using the predetermined rate and the direct labor cost and the cost per equivalent unit for the conversion cost per car. If the number is not exact round to the nearest cent. 7. Determine the unit cost per car. 8. Prepare a Cost of Production report rounding to the nearest cent. This report should show all costs transferred into Work-in-Process and the costs transferred to Finished Goods by using the Equivalent Units Schedule. This process uses FIFO costing.. 9. Determine the amounts for the following before entering your answers onto blackboard. a) Ending Work-in-Process Inventory in Units AND Dollars b) Ending Finished Goods Inventory in Units AND Dollars c) Cost of Goods Sold d) Over/Under Applied Manufacturing Overhead e) Show and calculate an Income Statement f) Gross Profit g) Net Income 10. Prepare the necessary Journal Entries related to the manufacturing cycle for this accounting period and use the account numbers as listed below instead of account names. 11. Chart of Accounts Example: Sales on Account would be Debit 11000, Credit 40000. a. In the first journal entry record the purchase of the aluminum and the wheels using cash. b. Record the materials transferred to WIP. Again use one journal entry to record the transfer of the aluminum and the wheels. c. Record the direct labor into WIP using wages payable. d. Record the applied FOH. Record the actual FOH using cash, Record the over or under applied FOH. 5. Record the sale of the goods on account along with the cost of the inventory that was sold. Combine both into one journal entry showing the sale first and inventory second. All sales were made on account, aluminum and wheels and wages were paid on account. The actual FOH was paid using cash. Make sure all numbers are rounded to the nearest cent. 12. Use n Excel spreadsheet to calculate your answers before you enter your answers onto blackboard. Make sure to follow all the examples on blackboard when entering your answers and enter your answers exactly as given to you on blackboard. Manufacturing Process Information Carlo started a small manufacturing plant that fabricates small scale crazy cars that race and spin. The manufacturing process starts with aluminum pellets being put into an aluminum molding machine. After the cars are shaped in the mold, they are cooled and then inspected. If the car passes inspection, the wheels are added at the end and they are transferred to finished goods. This process is completely automated. Direct material aluminum is added 100% at the beginning of the process; direct material wheels are added 100% as the last step in the process. Conversion costs are added equally throughout the process. Conversion is 45% complete for the beginning inventory work in process and 55% complete for the ending inventory work in process. At the beginning of the accounting period, Carlo estimated that prduction would be 6,500cars. Estimated factory overhead is $3,250. This information is to be used to determine the application rate for overhead. Estimated and actual direct labor costs totaled $2,200. Actual factory overhead costs totaled \$2,500. Selling and Administrative Expenses totaled \$1,500 The following information is available concerning the direct materials. Direct Materials-Aluminum One pound of aluminum pellets makes 4 cars Direct Materials- Wheels (there are four wheels for each car) The work in process account has the following information Beginning Work in Process contains 0 cars Ending work in process contains 380 cars The finished goods account has the following Information

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

Step: 3

blur-text-image

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

Fundamentals Of Oil And Gas Accounting

Authors: Charlotte J. Wright, Rebecca A. Gallun

5th Edition

1593701373, 978-1593701376

More Books

Students also viewed these Accounting questions

Question

Repeat Exercise 8.16 for 99% confidence intervals.

Answered: 1 week ago

Question

What are the 4 ( including APIPA ) IPv 4 private address ranges?

Answered: 1 week ago

Question

5. How can we use language to enhance skill in perceiving?

Answered: 1 week ago

Question

What actions might have prevented Bobs resignation?

Answered: 1 week ago