Marquis Company estimated annual operating activity bases are direct labor, direct labor hours, and machine hours. The following estimates are provided.

1 55 Chapter2Problems_Question2 (1) [Protected View] - Excel X File Home Insert Page Layout Formulas Data Review View ACROBAT Power Pivot Tell me what you want to do... Sign in 2 Share PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A1 X fac Formula: Divide; Cell Referencing D E F G H 1 J K L M N O B 1 Form a: Divide; Cell Referencing 2 3 Using Excel To Compute Predetermined Overhead 4 Rates PROBLEM 6 Marquis Company estimated annual operating activity 7 bases are direct labor, direct labor hours, and machine hours. The following estimates are provided. 8 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem as indicated. 5 Compute the predetermined overhead rate for each activity base. 9 10 $ Overhead rate based on direct labor cost 11 Direct labor cost Direct labor hours Machine hours Manufacturing overhead 500,000 50,000 100,000 900,000 12 Overhead rate based on direct labor hours 13 $ 14 Overhead rate based on machine hours 15 16 17 18 19 20 21 22 23 24 25 Enter Answer + Ready 100% e Bi AD 7:08 PM 1/25/2022