Accounting

Complete the following exercise. Fill in the Excel spreadsheet provided via the link below to provide your answers to parts a and b. Then paste the Excel data into a Word document on which you can also write the answer to part c.

Income Statement

Administrative Expenses $ 70,000
Finished Goods Inventory January 1, 20X3 $120,000
Cost of Goods Manufactured during the year $200,000
Finished Goods Inventory December 31, 20X3 $ 60,000
Selling Expenses $ 40,000
Sales $680,000
Required:

Using the information for Superior Manufacturing Company, prepare the income statement for the year ended December 31, 20X3. (Assume a 30% income tax.)
Provide at least three performance ratios regarding Superior Manufacturing Company, and comment on the company's performance.
Create a report between 200 and 300 words in length for leadership. The topic is the state of this company. Where do you see a problem regarding the company? Make some suggestions if there are areas you feel need to be further investigated.

asked by Jane

Respond to this Question

First Name

Your Answer

Similar Questions

  1. Earth Science

    I need help with the following Lab due tonight, 7/30/12, as I feel completely lost and would appreciate the help. The lab goes as follows: Design an experiment that illustrates the determination of the density of a cylindrical
  2. computers

    The President of the Company has asked you to replace the computers in every department. The researched information must be presented in this format: A memo to the president stating the need to replace the computers. An Excel
  3. Excel, Access, Word

    When you link a worksheet and a chart in a business report as well as on a slide, which Microsoft Office applications are integrated? A. Word, Excel, PowerPoint B. Excel, Access, Word C. Word, Access, PowerPoint D. Excel,
  4. Business Analytics statistics

    I don't under stand ho to get the answer to this excel question can anyone help? and email me back skylerbloo at netscape . net The assignment is in three parts: 1. An analytic section that you will submit as an Excel spread sheet
  5. Statistics

    The assignment is in three parts: 1. An analytic section that you will submit as an Excel spread sheet 2. A PowerPoint presentation of 3 to 5 slides. 3. A narrative section that you will submit as a two to three page Word document
  6. accounting

    Write a 3-4 page paper that summarizes your findings from the four (4) scenarios as well as how using Microsoft Excel helped you with this process, using the following outline: 2. Summarize the various accounting systems that each
  7. basic word & excel

    6. _______ data updates in your destination document if there are changes to the source data. A. Linked B. Integrated C. Embedded D. Field
  8. Computer - Excel Mail Merge

    I have a problem when doing the mail merge with Office 2003. First of all, I wrote a letter in Word 2003 and then try to merge some data from Excel 2003. The data in Excel column was listed as below: A1=101 A2=123 A3=134 A4=148A
  9. Microeconomics

    1. Complete Table-1 (Joseph Farms, Inc., Cost and Revenue Data), either as a Microsoft Excel spreadsheet, or as a Microsoft Word table. Assume that the price is $165 and the fixed costs are $125, at an output level of 1. Also
  10. Excel

    The use of excel Excel is a very necessary tool for all businesses in today's job market. Excel makes it easy to organize, calculate, analyze and chart data. It can be used for both simple and concrete projects. Excels

More Similar Questions