Answered step by step
Verified Expert Solution
Question
1 Approved Answer
just 9 and 10 please CCOUNTENG OCIETY Part Two Instructions Using a spreadsheet and based on the information provided in the next section, complete the
just 9 and 10 please
CCOUNTENG OCIETY Part Two Instructions Using a spreadsheet and based on the information provided in the next section, complete the following requirements Determine the started and completed units by using the followine 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 trucks not plastic and wheels.) Equivalent Units Whole Units Conversion Costs (Actual) Direct Materials- Plastic Direct Materials- Wheels Xxx XXx XXX XXX Beginning Start/Completed Completed/Transferred Out Ending Total XXx XXX XXX XXX XXX XXX XXX XXX XXX XXX XXX XXX 3. Calculate the total cost and the cost per equivalent unit for the direct materials plastic. 4. Calculate the total cost and the cost per equivalent unit for the direct materials wheels. 5. Calculate the predetermined overhead rate. 6. Determine the total conversion cost by using the predetermined rate and the direct labor rate. Then determine the conversion cost per truck 7. Determine the unit cost per truck. 8. Prepare a Cost of Production report. 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. Determine the amounts for the following. 9. 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) Over or Under applied COGS Gross Profit h) Net Income 8 I Page ACCOUNTING SoctETY OC 10. Prepare the necessary Journal Entries related to the manufacturing cycle using the chart of account numbers instead of account names when entering the journal entries, A chart of Accounts is shown below. For example: Instead of Debit Raw Materials-Plastic I would debit account number 12000 $5,000 and credit 10000 $5,000 when purchasing the raw materials plastic for cash. An example will be provided for each journal entry. Please follow instructions carefully Assets 10000 Cash 11000 Accounts Receivable 12000 Raw Materials- Plastic Raw Materials - Wheels Work in 12100 12200 process Factory Overhead Finished Goods 12300 12400 Liabilities Accounts Payable 20000 Wages Payable 21000 Revenues Sales 40000 Expenses COGS 50000 11. Once you have completed the work you will enter the information on Blackboard. An example will be provided on Blackboard for you to follow. Make sure that you follow the formatting exactly as given in the example, such as commas, dollar signs, spacing etc. If you format the answer in a manner not consistent with the example it will be counted incorrect and you will not receive the necessary points. Enter all answers carefully. Ex: Dr 10000 $5,000.00 Cr 40000 $5,000.00. (Note that the cents in all dollar amounts are included and that are no periods after Dr or Cr. 9IPag CCOUNTING OCTETY Manufacturing Process Information Teddy started a small manufacturing plant that fabricates small scale trucks. The manufacturing process starts with plastic pellets being put into a plastic molding machine. After the trucks are shaped in the mold, they are cooled and then inspected. If the truck passes inspection, the wheels are added at the end and they are transferred to finished goods. This process is completely automated. Direct material plastic 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 5 % complete for the ending inventory work in process. At the beginning of the accounting period, Teddy started 5,200 trucks into production. Estimated factory overhead is $1.300. This information is to be used to determine the application rate for overhead Estimated and actual direct labor costs totaled $2.000. Actual factory overhead costs totaled $1,500. Selling and Administrative Expenses totaled $1,000 The following information is available concerning the direct materials. Direct Materials-Plastic 0 pounds@$2.50 a pound 2,800 pounds @$2.50 a pound 200 pounds @ $2.50 a pound Beginning inventory Purchase of plastic Ending Inventory One pound of plastic makes 2 trucks Direct Materials- Wheels (there are four wheels for each truck) 0 wheels @$0.10 a wheel 20,800 wheels @ $0.10 a wheel Beginning inventory Purchase of wheels The work in process account has the following information Beginning Work in Process contains 0 trucks Ending work in process contains 300 trucks The finished goods account has the following Information Beginning Finished Goods Ending Finished Goods 0 trucks 2,000 trucks Tax rate is 35 % 2900 trucks were sold at $6.50. 10 | Page CCOUNTENG OCIETY Part Two Instructions Using a spreadsheet and based on the information provided in the next section, complete the following requirements Determine the started and completed units by using the followine 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 trucks not plastic and wheels.) Equivalent Units Whole Units Conversion Costs (Actual) Direct Materials- Plastic Direct Materials- Wheels Xxx XXx XXX XXX Beginning Start/Completed Completed/Transferred Out Ending Total XXx XXX XXX XXX XXX XXX XXX XXX XXX XXX XXX XXX 3. Calculate the total cost and the cost per equivalent unit for the direct materials plastic. 4. Calculate the total cost and the cost per equivalent unit for the direct materials wheels. 5. Calculate the predetermined overhead rate. 6. Determine the total conversion cost by using the predetermined rate and the direct labor rate. Then determine the conversion cost per truck 7. Determine the unit cost per truck. 8. Prepare a Cost of Production report. 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. Determine the amounts for the following. 9. 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) Over or Under applied COGS Gross Profit h) Net Income 8 I Page ACCOUNTING SoctETY OC 10. Prepare the necessary Journal Entries related to the manufacturing cycle using the chart of account numbers instead of account names when entering the journal entries, A chart of Accounts is shown below. For example: Instead of Debit Raw Materials-Plastic I would debit account number 12000 $5,000 and credit 10000 $5,000 when purchasing the raw materials plastic for cash. An example will be provided for each journal entry. Please follow instructions carefully Assets 10000 Cash 11000 Accounts Receivable 12000 Raw Materials- Plastic Raw Materials - Wheels Work in 12100 12200 process Factory Overhead Finished Goods 12300 12400 Liabilities Accounts Payable 20000 Wages Payable 21000 Revenues Sales 40000 Expenses COGS 50000 11. Once you have completed the work you will enter the information on Blackboard. An example will be provided on Blackboard for you to follow. Make sure that you follow the formatting exactly as given in the example, such as commas, dollar signs, spacing etc. If you format the answer in a manner not consistent with the example it will be counted incorrect and you will not receive the necessary points. Enter all answers carefully. Ex: Dr 10000 $5,000.00 Cr 40000 $5,000.00. (Note that the cents in all dollar amounts are included and that are no periods after Dr or Cr. 9IPag CCOUNTING OCTETY Manufacturing Process Information Teddy started a small manufacturing plant that fabricates small scale trucks. The manufacturing process starts with plastic pellets being put into a plastic molding machine. After the trucks are shaped in the mold, they are cooled and then inspected. If the truck passes inspection, the wheels are added at the end and they are transferred to finished goods. This process is completely automated. Direct material plastic 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 5 % complete for the ending inventory work in process. At the beginning of the accounting period, Teddy started 5,200 trucks into production. Estimated factory overhead is $1.300. This information is to be used to determine the application rate for overhead Estimated and actual direct labor costs totaled $2.000. Actual factory overhead costs totaled $1,500. Selling and Administrative Expenses totaled $1,000 The following information is available concerning the direct materials. Direct Materials-Plastic 0 pounds@$2.50 a pound 2,800 pounds @$2.50 a pound 200 pounds @ $2.50 a pound Beginning inventory Purchase of plastic Ending Inventory One pound of plastic makes 2 trucks Direct Materials- Wheels (there are four wheels for each truck) 0 wheels @$0.10 a wheel 20,800 wheels @ $0.10 a wheel Beginning inventory Purchase of wheels The work in process account has the following information Beginning Work in Process contains 0 trucks Ending work in process contains 300 trucks The finished goods account has the following Information Beginning Finished Goods Ending Finished Goods 0 trucks 2,000 trucks Tax rate is 35 % 2900 trucks were sold at $6.50. 10 | Page Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started