Please complete the excel table shown, boxes that are yellow are the ones needing help with! $5-40$ Activity$-$Based Costing; Customer Group Cost Analysis Franklin Furniture Inc. $($FFI$)$ manufactures bedroom furniture in sets $($a

set includes a dresser, two queen$-$size beds, and one bedside table$)$ for use in motels and hotels. FFI has three customer groups, which

it calls the value, quality, and luxury groups. The value products are targeted to low$-$price motels that are looking for simple furniture,

while the luxury furniture is targeted to the very best hotels. The quality line is attractive to a variety of hotels and motels that

appreciate the combination of quality and value. Currently there has been a small increase in the quality and value lines, and an

appreciable increase in demand in the luxury line, reflecting cyclical changes in the marketplace. Luxury hotels are now in more

demand for business travel, while a few years ago, the value segment was the most popular for business travelers. FFI wants to be able

to respond to the increased demand with increased production but worries about the increased production cost and about price setting

as its mix of customers and production changes. FFI has used a volume$-$based overhead allocation rate based on direct labor hours for

some time. Direct labor cost is $$15$ per hour.

The budgeted production data for the three product lines follow.

Required

Determine the cost per set and the total production cost of each of the three customer groups using activity$-$based costing.

Determine the production cost for each of the three customer groups using FFI's current volume$-$based approach.