C Save The Athens store of Gabriel's Comer, a chain of small neighborhood convenience stores, in preparing its activity-based budget for January 2018, Gabriel's Comer has three product categories soft drinks (35% of cost of goods sold (COGS), fresh produce (25% of COGS), and packaged food (40% of COGS). The following table shows the four activities that consume indirect resources at the Athens store the cost drivers and their rates, and the cost-driver amount budgeted to be consumed by each activity in January 2018. (Click the icon to view the activity and cost-driver information.) Read the quirements Requirement 1. What is the total budgeted indirect cost at the Athens store in January 20187 What is the total budgeted cost of each activity at the Athens store for January 2018? What is the budgeted indirect cost of each product category for January 2018? Complete the following table to determine the total budgeted indirect cost, total budgeted cost of each activity, and budgeted indirect cost of each product category for January 2018 (Round the percentages to the nearest hundredth percent, XXX%) Ordering Delivery Shelf-stocking Customer support Soft Fresh Packaged Drinks Snacks Food Total Data table January 2018 Budgeted January 2018 Budgeted Amount of Cost Driver Used Cost-Driver Soft Fresh Packaged Activity Cost Driver Rate Drinks Snacks Food Ordering Number of purchase orders $ 90 14 24 14 Delivery Number of deliveries 85 11 61 Shelf-stocking Hours of stocking time 22.00 21 177 22 23 96 Customer support Number of items sold 0.17 4,100 34,600 10,900 Requirements 1. What is the total budgeted indirect cost at the Athens store in January 2018? What is the total budgeted cost of each activity at the Athens store for January 2018? What is the budgeted indirect cost of each product category for January 2018? 2. Which product category has the largest fraction of total budgeted indirect costs? 3. Given your answer in requirement 2, what advantage does Gabriel's Corner gain by using an activity-based approach to budgeting over, say, allocating indirect costs to products based on cost of goods sold? Print Done