Can someone help me fill out the table correctly? Im using excel to solve this.
1 Master Budget and Responsibility Accounting Activity-based budgeting The Jerico store of Jiffy M 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 package the four activities that consume indirect resources at the Jerico store, the cost the cost-driver amount budgeted to be consumed by each activity in January 2018. art, a chain of small neighborhood convenience stores, is preparing its activity- he following table shows drivers and their rates, and d food (40% of COGS). T January 2018 Budgeted Amount of Cost Driver Used Soft Fresh Packaged January 2018 Budgeted Cost-Driver Rate Drinks SnacksFood Cost Driver Activity 24 62 172 14 19 94 $45 $41 $10.50 14 12 16 Number of purchase orders Number of deliveries Hours of stocking time Number of items sold Ordering Delivery Shelf stocking Customer support 10 12 13 14 15 Use the blue shaded areas on the ENTERANSWERS tab for inputs. S0.09 4,600 34,20010,750 Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from 16 the Instruction tab you will be marked wrong. 17 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 9 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 1 cost of each product cate ory for lanuary 2018? 2 copy/paste from the Instruction tab you will be marked wrong.) If you Always use cell references and formulas where appropriate to receive full credit Soft Fresh Packaged Drinks SnacksFoodTotal 6 Ordering 7 Delivery 8 Shelf-stocking 9 Customer support 10 Total cost 11 Percentage of total indirect costs 13 2. Which product category has the largest fraction of total budgeted indirect costs? 14 15 Fresh Snacks 16 17 consumes the largest fraction of total budgeted indirect costs. 18