Question

In: Accounting

Construct a profit and loss statement using the following departmental figures and show the dollar amounts...

Construct a profit and loss statement using the following departmental figures and show the dollar amounts for net sales, total cost of goods sold, gross margin, expenses, and profit.

Gross sales $82,000

Customer returns and allowances $4,000

Inward freight $2,000

Workroom costs $1,000

Opening inventory at cost $17,000

Closing inventory at cost $14,000

Purchases at cost $36,000

Cash discounts 8%

Advertising $5,000

Rent $12,000

Salaries $17,000

Miscellaneous expenses $2,500

Solutions

Expert Solution

Profit and Loss Statement
Net Sales:
Gross sales $             82,000
Less: Customer returns and allowances $                4,000
Less: Cash discounts [(82000-4000)*8%] $                6,240
Net sales $          71,760
Cost of goods sold:
Opening inventory $             17,000
Add: Purchases $             36,000
Add: Inward freight $                2,000
Cost of goods available for sale $             55,000
Less: Closing inventory $             14,000
Cost of goods sold $          41,000
Gross margin $          30,760
Expenses:
Workroom costs $                1,000
Advertising $                5,000
Rent $             12,000
Salaries $             17,000
Miscellaneous expenses $                2,500
Total expenses $          37,500
Net loss $          (6,740)

Related Solutions

Please construct a Profit & Loss Statement for the first six months of the year 2015,...
Please construct a Profit & Loss Statement for the first six months of the year 2015, on Jeff's Auto Repair with the following information:    Purchase of spare parts                                                                   $65,000    Salary paid to mechanics                                                                $127,000    Commission paid to marketing agents                                        $18,000    Money received for cars repaired                                                  $245,000    Money received for storage of cars                                              $45,000    Sales of tires                                                                                       $84,000    Rent of shop paid to landlord                                                          $28,000    Other expenses paid out                                                                   $23,000    Tax bracket                                                                                            ...
For the answers to this question, round dollar figures to the nearest dollar and show all...
For the answers to this question, round dollar figures to the nearest dollar and show all percents to two decimal points. Set up a skeletal statement using the following figures: Net sales $286,800 Gross margin $145,121 Profit 2.80%
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...
1. On a Profit & Loss statement, you wish to show only line items with transactions...
1. On a Profit & Loss statement, you wish to show only line items with transactions for the period. How can you do this? A. Filter the report for amounts greater than zero. B. Select the Advanced Option titled Include In Use. C. Collapse the report to show just parent accounts. D. Select the Advanced Option titled Display Rows > Active. 2. You want to see the line “See Accompanying Notes” at the bottom of the Profit & Loss statement....
Construct an Iron Butterfly strategy using a table and draw the profit-loss diagram. An Iron Butterfly...
Construct an Iron Butterfly strategy using a table and draw the profit-loss diagram. An Iron Butterfly requires that one buy an OTM put with X1 , sell another ATM put with X2 , sell an ATM call with X2 , and buy an OTM call with X3 . X1 , X2 , and X3 are evenly spaced. Explain what are the similarities and differences between a Butterfly and an Iron Butterfly
Explain the purpose and use of the Statement of profit or loss, Statement of changes in...
Explain the purpose and use of the Statement of profit or loss, Statement of changes in equity, Statement of financial position (also known as the Balance Sheet) and of the Statement of cash flows. Explain why the Statement of cash flows differs from the Statement of profit or loss (125 words).
The profit before tax, as reported in the statement of profit or loss and other comprehensive...
The profit before tax, as reported in the statement of profit or loss and other comprehensive income of Andreas Ltd for the year ended 30 June 2020, amounted to $85 000, including the following revenue and expense items: Rent revenue $4 500 Bad debts expense 6 000 Depreciation of plant 5 000 Annual leave expense Long service leave expense 2 500 3 500 Entertainment costs (non-deductible) 2 800 Depreciation of buildings (non-deductible) 800 Fines and penalties (non-deductible) 1 500 The...
The profit before tax, as reported in the Statement of Profit or Loss and Other Comprehensive...
The profit before tax, as reported in the Statement of Profit or Loss and Other Comprehensive Income of Diamond Ltd for the year ended 30 June 2019, amounted to $50,000 including the following revenue and expense items. June 2019 $ Interest revenue 4,000 Bad debts expense 4,000 Depreciation expense - plant 5,000 Annual Leave Expense 3,000 Long service leave expense 2,500 Fines and Penalties (non-deductible) 600 Depreciation expense - buildings (non-deductible) 1,000 Government grant (exempt from tax) 3,000 The Statement...
The profit before tax, as reported in the statement of profit and loss for Aileen Ltd...
The profit before tax, as reported in the statement of profit and loss for Aileen Ltd for the year ended 30 June 2020, amounted to $150,000, including the following revenue and expense items: Revenues Sales revenue $600,000 Interest revenue 60,000 Government grant 40,000 Expenses Cost of goods sold 300,000 Bad debts expense 8,000 Depreciation expense – equipment 6,000 Depreciation expense – plant 25,000 Research and development expense 51,000 Wages expense 120,000 Long service leave expense 40,000 The draft statement of...
Profit or Loss Account (Income Statement) of a business shows a net profit of 500,000. The...
Profit or Loss Account (Income Statement) of a business shows a net profit of 500,000. The owner of the business says, ‘Where is the money? My business does not have an increase in cash by $500,000 in the bank account. Where is the $500,000 profit? Required: Provide an explanation to the owner of the business about why net profit of a Profit or Loss Account (Income Statement) is not necessarily equal to the cash inflow. Your explanation must include two...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT