Please answer these in excel & show the excel formulas please. thank you WILL RATE

1. What is the total budgeted indirect cost at the Jerico store in January 2021 ? What is the total budgeted cost of each activity at the Jerico store for January 2021? What is the budgeted indirect cost of each product category for January 2021 ? (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) 2. Which product category has the largest fraction of total budgeted indirect costs? The Jerico store of Jiffy Mart, a chain of small neighborhood convenience stores, is preparing its activitybased budget for January 2021. 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 2021. 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 or if you type the numbers in, you will be marked wrong. 1. What is the total budgeted indirect cost at the Jerico store in January 2021? What is the total budgeted cost of each activity at the Jerico store for January 2021 ? What is the budgeted indirect cost of each product category for January 2021? (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.)