A B 1 Formula: Divide; Cell Referencing 2 C D E F G H | 3 Using Excel To Compute Predetermined Overhead Rates 4 5 PROBLEM 6 Marquis Company estimated annual operating activity bases are direct 7 labor, direct labor hours, and machine hours. The following estimates 8 are provided. 9 Student Work Area K L M N Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem as indicated. Compute the predetermined overhead rate for each activity base. Overhead rate based on direct labor cost Z$ 012345678901235 Direct labor cost Direct labor hours Machine hours $ 500,000 50,000 100,000 Overhead rate based on direct labor hours Manufacturing overhead $ 900,000 Overhead rate based on machine hours 24 Enter Answer + h h