Can you post a explanation how it would look like in Excel.

The HITEC Company manufactures multimedia equipment designed to be sold to universities. The company's southeastern plant has undergone production changes that have resulted in decreased usage of direct labor and increased usage of automated processes. As a result, management no longer believes that its overhead allocation method is accurate and is considering changing from a traditional overhead allocation to an activity-based method. The controller has chosen the following activity centers and cost drivers for overhead: Required: A. Calculate the overhead rate for each cost driver. B. An order of 1,000 video projectors had the following requirements: How much total overhead should be assigned to this order. C. If materials used were $35,000. And HITEC wants adds a 20% markup to each projector, what will the price of one projector be? The HITEC Company manufactures multimedia equipment designed to be sold to universities. The company's southeastern plant has undergone production changes that have resulted in decreased usage of direct labor and increased usage of automated processes. As a result, management no longer believes that its overhead allocation method is accurate and is considering changing from a traditional overhead allocation to an activity-based method. The controller has chosen the following activity centers and cost drivers for overhead: Required: A. Calculate the overhead rate for each cost driver. B. An order of 1,000 video projectors had the following requirements: How much total overhead should be assigned to this order. C. If materials used were $35,000. And HITEC wants adds a 20% markup to each projector, what will the price of one projector be