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. (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:
a.Create a list that identifies the total period costs.
b.Calculate overhead per unit based on machine hours.
c. Calculate the total product cost for units manufactured (“direct
materials per unit”).
d.Calculate total cost of goods sold.
e. Prepare income statement in good form assuming no beginning
inventory.

You must show all your
work for credit.

Readings
Required:
Chapter 2 in Managerial Accounting
Hill, M. S., Ruch, G. W., & Taylor, G. K. (2019). Research and development expense and analyst forecast errors: An underestimation of sales or overestimation of expenses? Journal of Accounting, Auditing & Finance, 34(4), 667–684. http://doi.org/10.1177/0148558X18799003
Recommended:
Chapter 2 PowerPoint slides SEU_ACT500_Module02_PPT_Ch02.pptx - Alternative Formats in Managerial Accounting
ŁAZARCZYK, D. (2020). The role of costs’ knowledge in the contemporary enterprises. Ekonomia i Prawo, 19(4), 725–737. https://apcz.umk.pl/czasopisma/index.php/EiP/article/view/EiP.2020.047/27739