Applied Overhead is applied at $180 per direct labor hour.

What is the total job cost for Job 12336?

Round your final answer to 2 decimal places

What is the total $ amount of direct materials used?

Round only your final answer to 2 decimal places.

What is the total $ amount of Direct Labor?

Round your answer to 2 decimal places.

Manufacturing Overhead is applied on the basis of $180 per direct labor hour. What is your total amount of Applied Manufacturing Overhead? Round only your final answer to 2 decimal places.

What is the total cost for all jobs? Round only your final answer to 2 decimal places.

Instead of direct labor hours as the driver for Applied Manufacturing Overhead, the company has decided to use 25% of direct material dollars.

What is the total job cost now for Job 12328? Round your final answer to 2 decimal places.

Instead of direct labor hours as the driver for Applied Manufacturing Overhead, the company has decided to use 25% of direct material dollars. What is the percentage change in job costs for all jobs compared to when they applied overhead on the basis of direct labor hours?

Show an increase as just the number. Use a negative sign in your answer for a decrease. Round your answer to 2 decimal places. Examples:

• If your answer is an increase of 0.12345 which is the same as 12.345%, you will type in 12.35 for your answer
• If your answer is a decrease of 0.12345 (the same as -0.12345) which is the same as -12.345%, you will type in -12.35 for your answer.

Please help me using EXCEL, if possible show me the formulas that you used, so that I can better understand the material.