----Please help me to using EXCEL sheet and show/explain detail solution----. Thank you very much for your help.

It helps me a lot to learn this course. This way I can study myself. I really appreciate for your help.

I need to answer bottom of excel sheet on by one. Thank you so much.

Overtime Allocation Prince Machine Tool Company produces tools on a job order basis. During May, two jobs were completed, and the following LO3 costs were incurred: Job 401 Job 402 $28,000 $37,000 23,000 6,000 18,000 Overtime premium Other factory costs for the month totaled $16,800. Factory over- head costs are allocated one-third to Job 401 and two-thirds to Job 402. a. Describe two alternative methods for assigning the overtime premium cost to Jobs 401 and 402 and explain how the appropriate method would be determined. b. Compute the cost of Job 401 and Job 402 under each of the two methods described in part a