Ecxel with formulas. Please and thank you.

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 Amount of Cost Driver Used SoftFresh Packaged January 2018 Budgeted Cost-Driver Rate Drinks Snacks Food Activit Cost Driver Ordering Delivery Shelf stocking Customer support Number of purchase orders Number of deliveries Hours of stocking time Number of items sold 24 62 172 14 19 94 0.09 4,600 34,200 10,750 45 14 12 16 $10.50 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 Instruction tab you will be marked wrong 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 Instruction tab you will be marked wrong.) Soft esh Packaged Drinks Snacks Food Total Ordering Delivery Shelf-stocking Customer support Total cost Percentage of total indirect costs 2. Which product category has the largest fraction of total budgeted indirect costs? consumes the largest fraction of total budgeted indirect costs