W E6-31 (similar to) Question Help The Stowe store of Family Mart, a chain of small neighborhood convenience stores, has a Kaizen (continuous improvement) approach to budgeting monthly activity costs for each month of 2018. Family Mart has three product categories: soft drinks (35% of cost of goods sold [COGS]), fresh snacks (25% of COGS), and packaged food (40% of COGS). The following table shows the four activities that consume indirect resources at the Stowe store, the cost drivers and their rates, and the cost-driver amount budgeted to be consumed by each activity in January 2018. (Click the icon to view the four activities and their cost data.) (Click the icon to view additional cost driver information.) Read the requirements. Requirement 1. What are the total budgeted costs for each activity and the total budgeted indirect cost for March 2018? Begin by calculating the budgeted cost-driver rates for February, then calculate March. (Round your answers to five decimal places, X.XXXXX.) Budgeted Cost-Driver Rates January February March $ 95.00 $ 94.81000 $ 94.62038 78.00 77.84400 77.68831 16.00 15.96800 15.93606 0.23 0.22954 0.22908 i Activity Ordering Delivery Shelf-stocking Customer support More Info Now calculate total budgeted cost for each activity and the total budgeted indirect cost for March. (Use the rates you calculated above in your calculations. Round your answers to the nearest whole number.) Each successive month, the budgeted cost-driver rate decreases by 0.2% relative to the preceding month. So, for example, February's budgeted cost-driver rate is 0.998 times January's budgeted cost-driver rate, and March's budgeted cost-driver rate is 0.998 times the budgeted February rate. Family Mart assumes that the budgeted amount of cost-driver usage remains the same each month. Soft Drinks Fresh Snacks Packaged Food Total i Data Table Print Done Activity Ordering Delivery Shelf-stocking Customer support Total Activity Cost Driver Ordering Number of purchase orders Delivery Number of deliveries Shelf-stocking Hours of stocking time Customer support Number of items sold January 2018 Budgeted Cost-Driver Rate $ 95 $ 78 $ 16.00 $ 0.23 January 2018 Budgeted Amount of Cost Driver Used Soft Fresh Packaged Drinks Snacks Food 15 28 14 65 1 9 1 21 4,400 34,800 11,100