Master Budget and Responsibility Accounting Activity-based budgeting The Jerico store of Jiffy Mart, a chain of small neighborhood convenience stores, is preparing its activity-based budget for January 2018. Jiffy Mart 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 Jerico store, the cost drivers and their rates, and the cost- driver amount budgeted to be consumed by each activity in January 2018. January 2018 Budgeted January 2018 Amount of Cost Driver Used Budgeted Soft Fresh Packaged Cost-Driver Rate Drinks Snacks Food $45 24 $41 12 62 19 $10.50 16 172 94 $0.09 4,600 34,200 10,750 14 Activity Cost Driver Ordering Number of purchase orders Delivery Number of deliveries Shelf stocking Hours of stocking time Customer support Number of items sold 14 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Requirements 1 What is the total budgeted indirect cost at the Jerico store in January 2018? What is the total budgeted cost of each activity at the Jerico 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? 1. What is the total budgeted indirect cost at the Jerico store in January 2018? What is the total budgeted cost of each activity at the Jerico store for January 2018? What is the budgeted indirect cost of each product category for January 2018? (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Fresh Snacks Packaged Food Total Soft Drinks $14 12 16 Ordering Delivery Shelf-stocking Customer support Total cost Percentage of total indirect costs 4,600 2. Which product category has the largest fraction of total budgeted indirect costs? Insumes the largest fraction of total budgeted indirect costs