please help
Concord Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The following information relates to its budgeted operations for the current year. Commercial Revenues $348,000 Residential $514,000 $50,000 $45,000 Direct materials costs Direct labor costs Overhead costs 110,000 290,000 108,000 263.000 199,000 539,000 Operating income (loss) $85,000 $125,000) The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window coverings are less complex for residential customers. In addition, the residential client base resides in close proximity to the company office, so travel costs are not as expensive on a per client visit for residential customers. As a result, she has decided to take a closer look at the overhead costs assigned to the two product lines to determine whether a more accurate product costing model can be developed. Here are the three activity cost pools and related information she developed: Estimated Overhead Activity Cost Pools $108,000 Scheduling and travel Setup time Cost Drivers Hours of travel Number of setups Direct labor cost 119,000 Supervision 80,000 Estimated Use of Cost Drivers per Product Commercial Residential Scheduling and travel 800 550 Setup time 450 250 Compute the activity based overhead rates for each of the three cost pools. (Round overhead rote for supervision to 2 decimal places, es. 0.38) Overhead Rates Scheduling and travel $ per hour Setup time $ per setup Supervision $ per dollar eTextbook and Media Determine the overhead cost assigned to each product line. Commercial Residential $ $ Scheduling and travel $ $ Setup time $ $ Supervision $ $ Total cost assigned e Textbook and Media Compute the operating income for each product line, using the activity based overhead rates Operating income (loss) Commercial $ Residential $ e Textbook and Media