Question
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.
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
ANSWER To complete these questions in Microsoft Excel well follow these steps List and total period costs Calculate overhead per unit based on machine ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started