Master Budget and Responsibility Accounting Kaizen approach to 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). Jiffy Mart has a Kaizen (continuous improvement) approach to budgeting monthly activity costs for each month of 2018. Each successive month, the budgeted cost-driver rate decreases by 0.4% relative to the preceding month. So, for example, February's budgeted cost-driver rate is 0.996 times January's budgeted cost-driver rate, and March's budgeted cost-driver rate is 0.996 times the budgeted February rate. Jiffy Mart assumes that the budgeted amount of cost-driver usage remains the same each month. 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. Cost Driver Activity Ordering Delivery Shelf stocking Customer support January 2018 Budgeted Cost-Driver Rate $45 $41 $10.50 $0.09 Number of purchase orders Number of deliveries Hours of stocking time Number of items sold January 2018 Budgeted Amount of Cost Driver Used Soft Fresh Packaged Drinks Snacks Food 14 24 14 12 62 19 16 172 94 4,600 34,200 10,750 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. Requirement What are the total budgeted cost for each activity and the total budgeted indirect cost for March 2018