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.

1. Purchased raw materials on account, $3,100.
2. Selling and Administrative expenses incurred and paid, $1,200.
3. Used direct materials, $3,900.
4. Used indirect materials, $300.
5. Manufacturing wages incurred totaled $4,000, of which 90% was direct labor and 10% was indirect labor.
6. Incurred other actual factory overhead on account, $1,300.
7. Factory Overhead was allocated to Work in Process Inventory at a predetermined overhead allocation rate of 60% of Direct Labor costs incurred during August.
8. The cost of product completed, $10,000.
9. Sales on account, $17,500. The cost of the units sold was $9,500.

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 Name Formula/Amounts Ratio 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