Complete the following questions using Microsoft Excel

Subject:FinancePrice:11.86 Bought3

Share With

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 costs	300,000
Office rent	20,000
Direct materials	850,000
Delivery vehicle depreciation	80,000
Factory repair and maintenance	425,000
Sales salary	505,000
Indirect labor	205,000
Manufacturing equipment depreciation	180,000
Administrative salaries	320,000
President's salary	650,000
Sales revenue	5,400,000
Indirect materials	180,000
Direct labor	1,400,000
Machine hours	2,500
Direct labor hours	11,000
Machine hours per unit	3
Direct labor hours per unit	5
Direct materials per unit	?
Units manufactured	600
Units sold	350

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.

SEU ACT500 Critical Thinking Quantitative Rubric – Module 02 Exceeds Expectation Meets Expectation Below Expectation Limited Evidence 15-20 Points 9-14 Points 4-9 Points 0-3 Points Includes all of the required components, as specified in the assignment. Includes most of the required components, as specified in the assignment. 12 - 16 Points 8-11 Points Content, Research, and Analysis Requirements Problem 2-1 All components are correct, with no errors or omissions. 12 - 16 Points Problem 2-2 All components are correct, with no errors or omissions. 12 - 16 Points Problem 2-3 All components are correct, with no errors or omissions. 12 - 16 Points Problem 2-4 All components are correct, with no errors or omissions. 12 - 16 Points Problem 2-5 All components are correct, with no errors or omissions. Total points possible = 100 Some significant but not major errors exist. 8-11 Points Some significant but not major errors exist. 8-11 Points Some significant but not major errors exist. 8-11 Points Some significant but not major errors exist. 8-11 Points Some significant but not major errors exist. Includes some of the required components, as specified in the assignment. 4-7 Points Some major errors or omissions exist. 4-7 Points Some major errors or omissions exist. 4-7 Points Some major errors or omissions exist. 4-7 Points Some major errors or omissions exist. 4-7 Points Some major errors or omissions exist. Includes few of the required components, as specified in the assignment. 0-3 Points Fails to demonstrate adequate comprehension of the concept. 0-3 Points Fails to demonstrate adequate comprehension of the concept. 0-3 Points Fails to demonstrate adequate comprehension of the concept. 0-3 Points Fails to demonstrate adequate comprehension of the concept. 0-3 Points Fails to demonstrate adequate comprehension of the concept.