Question

In: Accounting

14. In the Excel, or spreadsheet, approach to recording financial transactions, if manufacturing overhead is underapplied...

14. In the Excel, or spreadsheet, approach to recording financial transactions, if manufacturing overhead is underapplied by X dollars, the Manufacturing Overhead account is closed out by deducting X dollars in the Manufacturing Overhead column and deducting X dollars in the Retained Earnings column.

True or false

16. In the Excel, or spreadsheet, approach to recording financial transactions, expired insurance coverage on factory equipment is recorded as a decrease in the Prepaid Insurance column and as a decrease in the Retained Earnings column.

True or False

Solutions

Expert Solution

14. In the Excel, or spreadsheet, approach to recording financial transactions, if manufacturing overhead is underapplied by X dollars, the Manufacturing Overhead account is closed out by deducting X dollars in the Manufacturing Overhead column and deducting X dollars in the Retained Earnings column.
True
The journal entry will be
Debit     Cost of Goods sold
Credit    Manufacturing Overhead a/c
So, Mfg. OH a/c is reduced & Retained earnings is reduced as COGS increases.
16. In the Excel, or spreadsheet, approach to recording financial transactions, expired insurance coverage on factory equipment is recorded as a decrease in the Prepaid Insurance column and as a decrease in the Retained Earnings column.
True
The journal entry will be
Debit     Insurance expense
Credit    Prepaid Insurance
So, Prepaid insurance is reduced & Retained earnings is reduced as Insurance expense increases.

Related Solutions

In the Excel, or spreadsheet, approach to recording financial transactions, manufacturing overhead applied is recorded as...
In the Excel, or spreadsheet, approach to recording financial transactions, manufacturing overhead applied is recorded as an increase in the Work in Process column and as a decrease in the Manufacturing Overhead column. True or False
Develop and use accounting information for daily recording of business financial transactions in a manufacturing environment,...
Develop and use accounting information for daily recording of business financial transactions in a manufacturing environment, and construct and use operational budgets for a manufacturing company
What is the difference between overapplied and underapplied manufacturing overhead? please explain and use easier explanation...
What is the difference between overapplied and underapplied manufacturing overhead? please explain and use easier explanation for understanding the difference.
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the following investments. Investment A B Initial Investment $                8,500.00 $      9,500.00 End of Year Income 1 $                2,500.00 $      2,000.00 2 $                2,500.00 $      2,500.00 3 $                2,500.00 $      3,000.00 4 $                2,500.00 $      3,500.00 5 $                2,500.00 $      4,000.00
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the following​ investments: The Yield for Investment A: The Yield for Investment B: A B Initial Investment 6,400 9,535 Year 1 $1,822.65 $2,200 Year 2 $1,822.65 $2,500 Year 3 $1,822.65 $3,100 Year 4 $1,822.65 $3,600 Year 5 $1,822.65 $4,100
chapter 14 Create an Excel spreadsheet to organize your answers to the following problem, and submit...
chapter 14 Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have $25 million of bonds at 8% interest and 1,000,000 common shares outstanding, whereas the second would have $47.5 million of bonds at 8% interest and only 750,000 shares outstanding. The company is in...
​Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator
Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel).13. You are told that if you invest $15,000 per year for10 years (all payments made at the end of each year), you...
Two positions have normally been taken with respect to the recording of fixed manufacturing overhead as...
Two positions have normally been taken with respect to the recording of fixed manufacturing overhead as an element of the cost of plant assets constructed by a company for its own use: (a) It should be excluded completely. (b) It should be included at the same rate as is charged to normal operations. What are the circumstances or rationale that support or deny the application of these methods?
Using Excel prepare a spreadsheet to show the profit and loss figure for the last financial...
Using Excel prepare a spreadsheet to show the profit and loss figure for the last financial year. The profit and loss should be shown as dollars and as a percentage. Enter the raw data below, applying as many presentation Features (Font, Font Size, Font Color, Number Formats and Color, Cell Shading, Text Rotation, etc) to it as you wish. Apply appropriate number formats to your numbers. Center your spreadsheet horizontally on the page Give your spreadsheet an appropriate title and...
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel)...
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel) to solve the problem related to the cost of capital. You are required to show the following 3 steps for the problem. (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Submit all answers as percentages and round to two decimal places. Problem: Cosa Nostra...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT