Applying Managerial Accounting Concepts to the Manufacturing Industry (100 points)

Complete the following questions using Microsoft Excel. No other submission format is allowed. Review the grading rubric to confirm you are meeting the assignment requirements. (All amounts in SAR except units.)

Given the following information for Johnson Corporation:
Advertising costs300,000
Office rent20,000
Direct materials850,000
Delivery vehicle depreciation80,000
Factory repair and maintenance425,000
Sales salary505,000
Indirect labor205,000
Manufacturing equipment depreciation180,000
Administrative salaries320,000
President’s salary650,000
Sales revenue5,400,000
Indirect materials180,000
Direct labor1,400,000
Machine hours2,500
Direct labor hours11,000
Machine hours per unit3
Direct labor hours per unit5
Direct materials per unit?
Units manufactured600
Units sold350

Given the above information for Johnson Corporation:

  1. Create a list that identifies the total period costs.
  2. Calculate overhead per unit based on machine hours.
  3. Calculate the total product cost for units manufactured (“direct materials per unit”).
  4. Calculate total cost of goods sold.
  5. Prepare income statement in good form assuming no beginning inventory.

You must show all your work for credit.Required:

Recommended:

ATTACHMENTS

× How can I help you?