15 The Mit store of Garis Comer a chain of small neighborhood convenience stores, is preparing its activity based budget for January 2018 Gabriel's Comer has three product categones soft drinks (35% of cost of goods sold (COGS)). tresh produce COGS), and packaged food (40% of COGS). The following table shows the four activities that consumendiet resources at the Miton 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 cont driver information) Read the requirements Requirement 1. What is the total budgeted indirect cost at the Miton store in January 2018? What is the total budgeted cont of each activity at the Milton 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 cont, 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%) Sort Fresh Packaged Drinks Snacks Food Total Ordering Delivery Shelf-stocking Customer support Total costs Percentage of total indirect costs 1. Data Table January 2018 Budgeted Cost-Driver Activity Cost Driver Rate Ordering Number of purchase orders $ 92 Delivery Number of deliveries $ Shelf-stocking Hours of stocking time $ 16.00 Customer support Number of items sold 5 0.19 January 2018 Budgeted Amount of Cost Driver Used Soft Fresh Packaged Drinks Snacks Food 13 26 13 10 65 23 16 172 97 4,500 34 500 10.700 2 Requirements 1. What is the total budgeted indrect cost at the Miten store in January 2018? What is the total budgeted cost of each activity at the Milton store for January 2018? What is the budgeted indirect cost of each product category for Janusy 2 Which product category has the largest fraction of total budgeted indirect costs? 3. Given your answer in requirement, what advantage does Gabriels Corretgain by using an activity-boned approach to budgeting over say, allocating indirect costs to products based on cost of goods sold? 2018