Please attach excel screenshots or link to an excel document. Thanks

The Pic Frame Company manufactures two types of frames, the Standard and the Deluxe. They estimate that they will incur a total of $175,075 in manufacturing overhead costs this fiscal year. Today, they apply overhead to products on the basis of direct labour hours. Production data for the Standard and the Deluxe models follow: Standard Deluxe Expected production volumes 5,200 units 6,700 units Direct labour hours per unit 1.50 hours 2.10 hours Direct materials cost per $8.67 $13.89 unit Direct labour cost per unit $16.75 $19.50 a) Using the current costing method, calculate the predetermined overhead rate and the unit product cost for each model. b) The Pic Frame Company is considering implementing an activity-based costing system to calculate unit product costs rather than its current costing system based on direct labour hours. The activity-based costing system is based on the following four activity cost pools. Data for the current period's activities are provided below: Estimated Expected Activity Activity Cost Pools Cost Driver Overhead Costs Standard Deluxe Total Woodworking Labour Hours 27,800 700 950 1,650 Number of Product Assembly 65,990 275 380 655 Frames Product Packaging Number of Boxes $ 42,175 138 225 363 Order Fulfillment Order Volume 59,230 1,550 2,575 4,125 195,195 Determine the unit product cost of each product for the current period using the activity-based costing approach. NOTE re. ROUNDING: Round any calculations to two decimal places