Question

Revenues - $330,000 Cost of goods sold 55 % of revenues Salaries and wages 26% of revenues Additional costs: Operating Costs
26 % , how much would 2. Assuming COGS 55% and Salaries revenues have to be to earn $75,000 net income? 3. Assuming COGS 50 %
0 0
Add a comment Improve this question Transcribed image text
Answer #1

A.

Income Statement
Particulars Amount $
Revenue    330,000.00
Less: COGS(330000*55/100)    181,500.00
Less: Salaries & Wages (26% of 330000)      85,800.00
Less: Operating Cost      12,300.00
Gross Profit      50,400.00
Less: Depreciation        2,160.00
Bad Debt Exp (330000*0.6*0.02)        3,960.00
Profit before Interest      44,280.00
Less: Interest Expense            875.00
Profit after Interest      43,405.00

B.

Income Statement Situation1 % to Revenue Situation2 % to Revenue Situation3 % to Revenue
Particulars Amount $ Amount $ Amount $
Revenue    330,000.00    330,000.00    330,000.00
Less: COGS    164,905.00 49.97%    149,905.00 45.43%    181,500.00
Less: Salaries & Wages      85,800.00      85,800.00      54,205.00 16.43%
Less: Operating Cost      12,300.00      12,300.00      12,300.00
Gross Profit      66,995.00      81,995.00      81,995.00
Less: Depreciation        2,160.00        2,160.00        2,160.00
Bad Debt Exp        3,960.00        3,960.00        3,960.00
Profit before Interest      60,875.00      75,875.00      75,875.00
Less: Interest Expense            875.00            875.00            875.00
Profit after Interest      60,000.00      75,000.00      75,000.00

C.

Income Statement Situation1 % to Revenue Situation2 % to Revenue Situation3 % to Revenue Situation 4 % to Revenue
Particulars Amount $ Amount $ Amount $ Amount $
Revenue    330,000.00    330,000.00    330,000.00    330,000.00
Less: COGS    178,202.50 54.00%    165,702.50 50.21%    132,000.00 40.00%    198,000.00 60.00%
Less: Salaries & Wages      82,502.50 25.00%      70,002.50 21.21%      33,000.00 10.00%      99,000.00 30.00%
Less: Operating Cost      12,300.00      12,300.00      12,300.00      12,300.00
Gross Profit      56,995.00      81,995.00    152,700.00      20,700.00
Less: Depreciation        2,160.00        2,160.00        2,160.00        2,160.00
Bad Debt Exp        3,960.00        3,960.00        3,960.00        3,960.00
Profit before Interest      50,875.00      75,875.00    146,580.00      14,580.00
Less: Interest Expense            875.00            875.00            875.00            875.00
Profit after Interest      50,000.00      75,000.00    145,705.00      13,705.00

D.

Income Statement Situation1 % to Revenue Situation2 % to Revenue Situation3 % to Revenue Situation4 % to Revenue Situation5 % to Revenue
Particulars Amount $ Amount $ Amount $ Amount $ Amount $
Revenue    364,710.53    389,710.53    375,122.11    353,239.47    356,886.58
Less: COGS    200,590.79 55.00%    200,590.79 55.00%    182,355.26 50.00%    164,119.74 45.00%    164,119.74 45.00%
Less: Salaries & Wages      94,824.74 26.00%      94,824.74 26.00%      98,471.84 27.00%      94,824.74 26.00%      98,471.84 27.00%
Less: Operating Cost      12,300.00      12,300.00      12,300.00      12,300.00      12,300.00
Gross Profit      56,995.00      81,995.00      81,995.00      81,995.00      81,995.00
Less: Depreciation        2,160.00        2,160.00        2,160.00        2,160.00        2,160.00
Bad Debt Exp        3,960.00        3,960.00        3,960.00        3,960.00        3,960.00
Profit before Interest      50,875.00      75,875.00      75,875.00      75,875.00      75,875.00
Less: Interest Expense            875.00            875.00            875.00            875.00            875.00
Profit after Interest      50,000.00      75,000.00      75,000.00      75,000.00      75,000.00
Add a comment
Know the answer?
Add Answer to:
Revenues - $330,000 Cost of goods sold 55 % of revenues Salaries and wages 26% of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Use the following estimated information for Super Shirts, Inc. to perform the analyses: Revenues s215,000 Cost of goods sold-20% of revenues Salaries and wages-20% of revenues Additional costs O...

    Use the following estimated information for Super Shirts, Inc. to perform the analyses: Revenues s215,000 Cost of goods sold-20% of revenues Salaries and wages-20% of revenues Additional costs Operating Costs-$39,000 Depreciation $2,400 Bad debts expense-1% of 70% of revenues Interest expense - $525 REQUIRED: On the basis of the facts as given above, prepare the following schedules using a spreadsheet software package: A. Super Shirts would like to be more profitable. Use Goal Seek in Excel to determine the following...

  • Use the following estimated information for the Barkery to perform the analyses: Revenues $300,000 Cost of...

    Use the following estimated information for the Barkery to perform the analyses: Revenues $300,000 Cost of goods sold 60% of revenues Salaries and wages 22% of revenues Additional costs: Operating Costs - $12,600 Depreciation -$2,100 Bad debts expense-3 % of 70 % of revenues Interest expense - $1,125 . REQUIRED; On the basis of the facts as given above, prepare the following schedules using a spreadsheet software package: A. Prepare an income statement based on the information above. B. The...

  •     Year 2 Year 1 Sales $ 529,000 $ 420,000 Cost of goods sold 330,000 268,000...

        Year 2 Year 1 Sales $ 529,000 $ 420,000 Cost of goods sold 330,000 268,000 Gross profit $ 199,000 $ 152,000 Operating expenses 130,000 116,000 Net income $ 69,000 $ 36,000 a. Prepare common size income statements for Price Company, a sole proprietorship, for the two years shown as above by converting the dollar amounts into percentages. For each year, sales will appear as 100 percent and other items will be expressed as a percentage of sales. (Income taxes...

  • Year 2 Year 1 Sales $ 489,000 $ 393,000 Cost of goods sold 330,000 268,000 Gross...

    Year 2 Year 1 Sales $ 489,000 $ 393,000 Cost of goods sold 330,000 268,000 Gross profit $ 159,000 $ 125,000 Operating expenses 130,000 116,000 Net income $ 29,000 $ 9,000 a. Prepare common size income statements for Price Company, a sole proprietorship, for the two years shown as above by converting the dollar amounts into percentages. For each year, sales will appear as 100 percent and other items will be expressed as a percentage of sales. (Income taxes are...

  • 0 Income statement 2016 2015 Sales revenues Less: Cost of goods sold Gross profit Less: Operating...

    0 Income statement 2016 2015 Sales revenues Less: Cost of goods sold Gross profit Less: Operating expenses Operating income Less: Interest expense Income before income taxes (amounts in thousands) 2017 211,400 $ 182,910 105,000 96,000 106,400 $ 86,910 53,000 46,000 53.400 $ 40,910 5.385 6,459 48,015 $ 34,451 22.617 16. 160 Print Done i Income statement JJUJ 0,435 LESS. Merest expense Income before income taxes 48,015 $ 22,647 25,368 $ 34,451 16,160 Less: Income tax expense Net income 18,291 Additional...

  • 9. Your pro forma income statement shows sales of $2.300,000, cost of goods sold as $980,000,...

    9. Your pro forma income statement shows sales of $2.300,000, cost of goods sold as $980,000, depreciation expense of $600,000, and taxes of $216,000 due to a of 30%. What are your pro forma earnings? What is your pro tax rate forma free cash flow? 10. You are forecasting incremental free cash flows for Daily Enterprises. Based on the associated information in Problems 1 and 2, what are the incremental free cash flows with the new machine? software for video...

  • resented below is information for Swifty Company for the month of March 2020. Cost of goods sold $218,520...

    resented below is information for Swifty Company for the month of March 2020. Cost of goods sold $218,520 Rent expense $30,370 Freight-out 6,450 Sales discounts 7,050 Insurance expense 5,410 Sales returns and allowances 12,910 Salaries and wages expense 58,680 Sales revenue 386,090 (a) Prepare a multiple-step income statement. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) SWIFTY COMPANY Income Statement March 31, 2020For the Year Ended March 31, 2020For the Month...

  • Common-size financial statements are often used by auditors in a process called “analytical procedures” or “analytical...

    Common-size financial statements are often used by auditors in a process called “analytical procedures” or “analytical review.” Unusual relationships or patterns can be identified because of the percentages—these would be harder to see if the amounts were just kept as dollars. You will be looking for percentages that seem very unstable over the times periods (the percentages jump around too much). What are some of the unusual relationships you see? Please identify and discuss at least two unusual relationships. Please...

  • Show me the formulas and steps, please!! $ Younge Company provided the following data for the...

    Show me the formulas and steps, please!! $ Younge Company provided the following data for the year ended September 30. Figures are all in $1,000. Younge closes any under-or over-applied overhead costs to cost of goods sold at the end of the year. SG&A expense $ 370 Manufacturing overhead applied to WIP $ 339 Actual manufacturing overhead cost 358 Total manufacturing cost for the year $ 675 Cost of goods available for sale during the year $ 730 Cost of...

  • Paragraph IS Styles Profit and Loss Statement Revenues Cost of Goods Sold GROSS PROFIT March April...

    Paragraph IS Styles Profit and Loss Statement Revenues Cost of Goods Sold GROSS PROFIT March April $11,685 $11,801 2,415 2,608 ID May $12,391 2,634 1 Selling and General expenses Rent, Lease, Depreciation Other Operating Expenses OPERATING EXPENSES 901 753 1,119 1 1,000 768 1,287 1,129 837 1,377 OPERATING INCOME Interest Expense Other Expenses EARNINGS BEFORE TAXES 161 1,146 TO 169 1,260 1 190 1,272 Income Taxes 1,029 1,163 1,186 NET EARNINGS 10 TO 1. What is the percentage change for...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT