Chrome File Edit View History Bookmarks Profiles Tab Window Help Q 8 Wed Aug 9 5:26 PM P Exercises X + - > C plus.pearson.com/products/ebfc6258-1d5b-471d-a1b4-e5bb756c87e0/pages/urn:pearson:entity:66584377-a754-4d7e-aee0-Obdd88bddefb?iesCo... Q " * = I k Update Assignment Material SJ 6-26 Activity-based budgeting. [Excel template] (LO 5) The Parksville location of Your Mart (YM), a chain of small neighbourhood grocery stores, is preparing its activity-based budget for January 2022. YM has three product categories: (0 > soft drinks, fresh produce, and packaged food. The following table shows the four activities that consume indirect resources at the Parksville store, the cost drivers and their rates, and the cost driver amount budgeted to be consumed by each activity in January 2022. January 2022 January 2022 Budgeted Amount O Budgeted of Cost Driver Used Cost Driver Soft Fresh Packaged Activity Cost Driver Rate Drinks Produce Food Ordering Number of purchase orders $90.00 14 24 Delivery Number of deliveries 82.00 12 62 19 AA Shelf-stocking Hours of stocking time 21.00 16 172 94 Customer support Number of items sold 0.18 4 600 34.200 10.750 Required 1. What is the total budgeted indirect cost at the Parksville store in January 2022? What is the total budgeted cost of each activity at the Parksville store for January 2022? What is the budgeted indirect cost of each product category for January 2022? 2. Which product category has the largest fraction of total budgeted indirect costs? 3. Given your answer in requirement 2, what advantage does YM gain by using an activity-based approach to budgeting over, say, allocating indirect costs to products based on cost of goods sold? X 214 AUG 8,743 9 O OWE 4 tv Q X