Tho Miton storo of Henderson Mart, a chain of small noi hborhood oonvenienco stores is proparing its activity-based budget for January 2015. Henderson Mart has throo product categories soft drinks 35% of oost of goods sold COGS ), rest snacks 25% of COGS and packaged food 40% of COGS The following table shows the our activities that consume indirect resources at the Milton store, the cost drivers and their rates, and the cost driver amount budgeted to be consumed by each activity January 2015 (Click the icon to view the activity and cost-driver inform ason.) 1. What is the total budgeted indirect cost at the Milton store in January 2015? What is the total budgeted cost of each activity at the Milton store for January 2015? What is the budgeted indirect cost of cach product category for January 2015? 2. Which product category has the largest fraction of total budgeted indirect costs? 3. Given your answer in requirement 2, what advantage does Henderson Mart gain by using an activity-based approach to budgeting over, say, allocating indirect costs to products based on cost of goods sold? Requirement 1. What is the total budgeted indirect cost at the Miton store in January 2015? What is the total budgated cost of each activity at the Milkon store for January 2015? What is the budgeted indirect cost of each product category tor January 2015? 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 2015. (Round the percentages to the nearest hundredth peroent, X.XX%) Fresh Packaged Drinks Snacks Food Data Table 470 $ 1,520 $ 5,510 1,638 2.156 1,520 S 2, Delivery 1,092 4,992 7,722 6,534 January 2015 Budgoted Cost-Driver Rate January 2015 Budgeted Amount of Cost Driver Used Soft 765 5,882 Customer support 3,861 S 17,238 Total costs Fresh Packagec Percentage of total indirect costs Cost Driver Drinks Snacks Food Number of purchase orders Number of deliveries Hours of stocking time Number of items sold 16 16 21 98 10,750 95 26 78 64 $ 22.00 Shelf-stocking Customer support $ 0.17 4,500 34,600 Print Done