ACC-260 QuickBooks Assignment 2 PURPOSE: The purpose of this assignment is to have students become familiar...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ACC-260 QuickBooks Assignment 2 PURPOSE: The purpose of this assignment is to have students become familiar with an accounting software package that is used in professional practice. Students will enter journal entries related to manufacturing operations; produce standard output reports in QuickBooks; and analyze those reports using ratio analysis. STEP ONE: Enter the following entries for the month of August 2021. A. Purchased raw materials on account, $3,100. B. Selling and Administrative expenses incurred and paid, $1,200. C. Used direct materials, $3,900. D. Used indirect materials, $300. E. Manufacturing wages incurred totaled $4,000, of which 90% was direct labor and 10% was indirect labor. F. Incurred other actual factory overhead on account, $1,300. G. Factory Overhead was allocated to Work in Process Inventory at a predetermined overhead allocation rate of 60% of Direct Labor costs incurred during August. H. The cost of product completed, $10,000. I. Sales on account, $17,500. The cost of the units sold was $9,500. Go to QuickBooks and login to your company. Click the "+ New button at the upper left-hand corner of the screen. Choose Journal Entry" under the Other column. All entries should be dated "August 31, 2021," and should be auto-numbered through QBs. For the "Description," enter "Journal Entry" and the letter of the adjustment from above. (For example, the description of the first Journal Entry would be "Journal Entry A.") STEP TWO: Once you have entered the journal entries in Step One above, prepare and enter the necessary adjusting entry to correct for the overallocated or underallocated Factory Overhead. This entry should be dated August 31, 2021." For the "Description," enter "Journal Entry J." STEP THREE: Prepare the financial statements. Once you have entered the journal entries, choose the "Reports" menu from the left-hand side of the screen. Scroll down to the "Business Overview" menu and choose "Profit and Loss." This is the company's income statement. Choose "Custom" for the date description and enter the dates "8/1/2021" to "8/31/2021." Click "Run Report." Save the Profit and Loss statement as a PDF file named "LastnameFirstinitial. ACC260.QB2.PL." Choose the "Reports" menu from the left-hand side of the screen. Scroll down to the "Business Overview" menu and choose "Balance Sheet." Choose "Custom" for the date description and enter the dates "8/1/2021" to "8/31/2021." Click "Run Report." Save the Balance Sheet as a PDF file named "LastnameFirstinitial.ACC260.QB2.BS." Submit your two financial statement files in the digital classroom. STEP FOUR: Using the information on your August financial statements calculate the following ratios for your company using an Excel spreadsheet: 1. Gross Profit Percentage 2. Accounts Receivable Turnover Ratio 3. Day's Sales in Receivables 4. Debt Ratio 5. Debt to Equity Ratio 6. Profit Margin Ratio 7. Rate of Return on Total Assets 8. Asset Turnover Ratio Show the information in your spreadsheet in three columns: Ratio Name 1. Gross Profit Percentage 2. Accounts Receivable Turnover Ratio 3. Day's Sales in Receivables 4. Debt Ratio 5. Debt to Equity Ratio 6. Profit Margin Ratio 7. Rate of Return on Total Assets 8. Asset Turnover Ratio Formula/Amounts Ratio Value Name the Excel spreadsheet LastnameFirstname.ACC260.QB2. Ratios and submit the file in the digital classroom. ACC-260 QuickBooks Assignment 2 PURPOSE: The purpose of this assignment is to have students become familiar with an accounting software package that is used in professional practice. Students will enter journal entries related to manufacturing operations; produce standard output reports in QuickBooks; and analyze those reports using ratio analysis. STEP ONE: Enter the following entries for the month of August 2021. A. Purchased raw materials on account, $3,100. B. Selling and Administrative expenses incurred and paid, $1,200. C. Used direct materials, $3,900. D. Used indirect materials, $300. E. Manufacturing wages incurred totaled $4,000, of which 90% was direct labor and 10% was indirect labor. F. Incurred other actual factory overhead on account, $1,300. G. Factory Overhead was allocated to Work in Process Inventory at a predetermined overhead allocation rate of 60% of Direct Labor costs incurred during August. H. The cost of product completed, $10,000. I. Sales on account, $17,500. The cost of the units sold was $9,500. Go to QuickBooks and login to your company. Click the "+ New button at the upper left-hand corner of the screen. Choose Journal Entry" under the Other column. All entries should be dated "August 31, 2021," and should be auto-numbered through QBs. For the "Description," enter "Journal Entry" and the letter of the adjustment from above. (For example, the description of the first Journal Entry would be "Journal Entry A.") STEP TWO: Once you have entered the journal entries in Step One above, prepare and enter the necessary adjusting entry to correct for the overallocated or underallocated Factory Overhead. This entry should be dated August 31, 2021." For the "Description," enter "Journal Entry J." STEP THREE: Prepare the financial statements. Once you have entered the journal entries, choose the "Reports" menu from the left-hand side of the screen. Scroll down to the "Business Overview" menu and choose "Profit and Loss." This is the company's income statement. Choose "Custom" for the date description and enter the dates "8/1/2021" to "8/31/2021." Click "Run Report." Save the Profit and Loss statement as a PDF file named "LastnameFirstinitial. ACC260.QB2.PL." Choose the "Reports" menu from the left-hand side of the screen. Scroll down to the "Business Overview" menu and choose "Balance Sheet." Choose "Custom" for the date description and enter the dates "8/1/2021" to "8/31/2021." Click "Run Report." Save the Balance Sheet as a PDF file named "LastnameFirstinitial.ACC260.QB2.BS." Submit your two financial statement files in the digital classroom. STEP FOUR: Using the information on your August financial statements calculate the following ratios for your company using an Excel spreadsheet: 1. Gross Profit Percentage 2. Accounts Receivable Turnover Ratio 3. Day's Sales in Receivables 4. Debt Ratio 5. Debt to Equity Ratio 6. Profit Margin Ratio 7. Rate of Return on Total Assets 8. Asset Turnover Ratio Show the information in your spreadsheet in three columns: Ratio Name 1. Gross Profit Percentage 2. Accounts Receivable Turnover Ratio 3. Day's Sales in Receivables 4. Debt Ratio 5. Debt to Equity Ratio 6. Profit Margin Ratio 7. Rate of Return on Total Assets 8. Asset Turnover Ratio Formula/Amounts Ratio Value Name the Excel spreadsheet LastnameFirstname.ACC260.QB2. Ratios and submit the file in the digital classroom.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Dr. Bold has a personal automobile policy with liability limits as follows: $100,000/$300,000 BI and $50,000 PD. Dr. Bold is held liable in an accident in which he must pay for bodily injuries as...
-
Structural Steel Systems manufactures steel buildings for agricultural and home applications. Currently, managers are trying to decide between two alternatives regarding a major overhead door...
-
Discuss the skills a forensic accountant draws on when reaching a conclusion in a scientific process.
-
Equilibrium for extraction of acetic acid from 3-heptanol into water at \(25^{\circ} \mathrm{C}\) is \(\mathrm{y}=1.208 \mathrm{x}\), where \(\mathrm{y}=\) weight fraction acetic acid in water and...
-
The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per...
-
A US-based Company A would like to take out a 5-year loan in EUR. An EU-based Company B would like take out a 5-year loan in USD. Their borrowing rates in USD and EUR are shown below: Borrowing Rate...
-
This question deals with an inheritance hierarchy involving a class called CreditCard (you can call it Credit, for short). Every credit card has a 16-digit account number, which you should implement...
-
Your friend deposits $10,000 in an account today in hope that it grows to $14,250 in 5 years.What annual compounded rate would she need to earn? (B) Suppose your friend then realizes she can expect...
-
Draw the control flow graph for the following piece of code: Function fn_delete_element (int value, int array_size, int array[]) 1 int i; location array_size + 1; 2 for i=1 to array_size 3 if...
-
You own a bond of the XYZ Corporation. Yesterday after the market closed the company CEO revealed the SEC was investigating the company for accounting irregularities. The perceived credit quality of...
-
The auctions for the next set of t-bills (zero coupon government bonds) are due in 10 days. The bond has a life of 180 days and face value of 100. One of your friends has also suggested an investment...
-
Bex Limited just paid a dividend of $0.50, and dividends are expected to grow at a constant rate of 6.5% per year. The ordinary shares currently sell for $18.00 a share, but to sell a new issue,...
-
Question 1 An asset manager has a long position of 8,500 shares of company QTA. The asset manager wants to hedge 55% of the market risk associated with this position. For that purpose, it has been...
-
MgO prevents premature evaporation of Al in a furnace by maintaining the aluminum as Al2O3. Another type of matrix modifier prevents loss of signal from the atom X that readily forms the molecular...
-
Arich uncle allows you to stipulate which of two ways you receive your inheritance: a. \($850,000\) one year after his death or b. \($250,000\) on his death and \($200,000\) each year at the end of...
-
You have the right to receive \($30,000\) at the end of each of the next four years, and money is worth 8%. Using the PV tables, your financial calculator, or Excel, compute the present value of this...
-
Briefly describe the concept of the time value of money.
Study smarter with the SolutionInn App