Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

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.Days 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 NameFormula/AmountsRatio Value

1.Gross Profit Percentage

2.Accounts Receivable Turnover Ratio

3.Days 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

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_2

Step: 3

blur-text-image_3

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

Auditing And GRC Automation In SAP

Authors: Maxim Chuprunov

1st Edition

3642353010, 9783642353017

Students also viewed these Accounting questions