Complete the following questions using Microsoft Excel. No other submission format is allowed. Review the...

60.1K

Verified Solution

Question

Accounting

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

  1. Identify (list) and total period costs
  2. Calculate overhead per unit based on machine hours
  3. Calculate total product costs for units manufactured
  4. Calculate total cost of goods sold
  5. Prepare income statement in good form assuming no beginning inventory
  6. You must show all your work

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students