please help and show work
Venus 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. Revenues Direct materials costs Direct labor costs Overhead costs Operating income (loss) Commercial $357,500 $30,000 140,000 97,500 267,500 $90,000 Residential $460,500 $50,000 260,000 170,500 480,500 $(20,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 Scheduling and travel Setup time Supervision $97.500 110,500 60,000 Cost Drivers Hours of travel Number of setups Direct labor cost 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: Activity Cost Pools Scheduling and travel Setup time Supervision Estimated Overhead $97,500 110,500 60,000 Cost Drivers Hours of travel Number of setups Direct labor cost Estimated Use of Cost Drivers per Product Commercial Residential Scheduling and travel 800 700 Setup time 400 250 Compute the activity-based overhead rates for each of the three cost pools. (Round overhead rate for supervision to 2 decimal places, eg. 0.38.) Overhead Rates 65.00 $ Scheduling and travel per dollar $ 170.00 per setup Setup time 0.15 per dollar Supervision Determine the overhead cost assigned to each product line. Commercial Residential Scheduling and travel $ Setup time Supervision $ Total cost assigned