Please show all steps and calculations!!
Oriole Inc. is a distributor and processor of a variety of different blends of coffee. The company buys coffee beans from around the world and roasts, blends, and packages them for resale. Oriole Inc. currently offers 10 different coffees in 500-gram bags to gourmet shops. The major cost is raw materials; however, there is a substantial amount of manufacturing overhead the mostly automated roasting and packing process. The company uses relatively little direct labour. Some of the coffees are very popular and sell in large volumes, while a few of the newer blends have very low volumes. Oriole Inc. prices its coffee at total product costs, including allocated overhead, plus a markup of 25%. If prices for certain coffees are significantly higher than market, the prices are adjusted lower. Data for the 2022 budget include manufacturing overhead of $3.8 million, which has been allocated in the existing costing system based on each product's budgeted direct labour cost. The budgeted direct labour cost for 2022 totals $760,000. Purchases and use of materials (mostly coffee beans) are budgeted to total $6 million. The budgeted prime costs for 500-gram bags of two of the company's products are as follows: Vanilla Direct materials Direct labour Mocha $3.20 $0.25 $2.80 $0.25 Data for the 2022 production of Mocha and Vanilla coffee are as follows. There will be no beginning or ending materials inventory for either of these coffees. 1,000 250 3 Expected sales Batch size Set-ups Purchase order size Roasting time Blending time Packaging time Mocha 50,000 kilograms 50,000 kilograms 3 per batch 12,500 kilograms 1 hour/50 kg 0.50 hour/50 kg hour/50 kg Vanilla kilograms kilograms per batch kilograms hour/50 kg hour/50 kg hour/50 kg 250 1.00 0.50 0.10 0.10 Oriole's controller believes the traditional costing system may be providing misleading cost information. He has developed an activity-based analysis of the 2022 budgeted manufacturing overhead costs shown in the following table: Activity Pools Cost Drivers Budgeted Cost Budgeted Units 1,200 Purchase orders $ 1.900 500 Purchasing Material handling Quality control Roasting Blending Packaging Total manufacturing overhead cost Set-ups Batches Roasting hours Blending hours Packaging hours 612,000 646,000 160,000 1,060,000 490,000 106,000 24,500 32,000 800,000 3,768,000 $ (a) Calculate the company's 2022 budgeted manufacturing overhead rate using direct labour costs as the single rate and the 2022 budgeted costs and selling prices of 500 grams of Mocha coffee and 500 grams of Vanilla coffee. (Round intermediate calculations and final answers to 2 decimal places, e.g. 15.25.) Overhead rate % of direct labour cost Mocha Vanilla Selling price $ $
