Homework: Applying Managerial Accounting Concepts to the Manufacturing Industry
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.
Given the following information for Dorttmund Corporation: Advertising costs 320,000 Office rent 240,000 Direct materials 800,000 Delivery vehicle depreciation 90,000 Factory repair and maintenance 420,000 Sales salary 510,000 Indirect labor 220,000 Manufacturing equipment depreciation 180,000 Administrative salaries 360,000 President's salary 700,000 Sales revenue 5,200,000 Indirect materials 190,000 Direct labor 1,500,000 Machine hours 2,000 Direct Labor hours 10,000 Machine hours per unit 3 Direct labor hours per unit 6 Direct materials per unit? Units manufactured 500 Units sold 350
a. Identify (list) and total period costs
b. Calculate overhead per unit based on machine hours
c. Calculate total product costs for units manufactured
d. Calculate total cost of goods sold
e. Prepare income statement in good form assuming no beginning inventory
Format your homework according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.