Critical Thinking on Applying Managerial Accounting Concepts to the Service Industry

Applying Managerial Accounting Concepts to the Service 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. (All amounts in SAR except units.)
Given the following information for Riyadh Corporation:
Advertising costs 18,000
Administrative salaries 39,000
Delivery vehicle depreciation 12,000
Factory repair and maintenance 55,000
Indirect labor 48,000
Indirect materials 23,000
Manufacturing equipment depreciation 18,000
Office rent 24,000
President’s salary 150,000
Sales revenue 1,000,000
Sales salary 120,000
Direct materials 140,000
Direct labor (10,000 hours) 250,000
Machine hours 1,600
Machine hours per unit 4
Direct labor hours per unit 4
Direct materials per unit ?
Units manufactured 400
Units sold 375
Identify (list) and total period costs
Calculate overhead per unit based on machine hours
Calculate total product costs for units manufactured
Calculate total cost of goods sold
Prepare income statement in good form assuming no beginning inventory
You must show all your work