WP_Question Saved Home Home Insert Draw Page Layout Formulas Data Review View Tell me Sh Liberation Sans 12 23 Text Insert Paste IMDI Milli in BIU v fe Conditional Formatting Format as Table Coll Styles $ % ) O Delete Format EC M7 1 Formula: Divide: Call Referencing Using Excel To Compute Predetermined Overhead Rates Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problemas indicated. Compute the predetermined overhead rate for each activity base Overhead rato based on direct labor cost Overhead rate based on direct labor hours PROBLEM Marquis Company estimated annual operating activity basos are (direct labor, direct labor hours, and machine hours. The following estimates are provided 9 10 Direct labor cost 500.000 11 Direct labor hours 50.000 12 Machine hours 100,000 13 Manufacturing overhead $ 900.000 14 15 16 17 10 per direct labor dollar Overhead rate based on machine hours