Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Roxbury store of Family Mart, a chain of small neighborhood convenience stores, is preparing its activity-based budget for January 2018. Family Mart has three

image text in transcribedimage text in transcribed

The Roxbury store of Family Mart, a chain of small neighborhood convenience stores, is preparing its activity-based budget for January 2018. Family 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 Roxbury store, the cost drivers and their rates, and the cost-driver amount budgeted to be consumed by each activity in January 2018. E (Click the icon to view the activity and cost-driver information.) Read the requirements. Requirement 1. What is the total budgeted indirect cost at the Roxbury store in January 2018? What is the total budgeted cost of each activity at the Roxbury store for January 2018? What is the budgeted indirect cost of each product category for January 2018? Complete the following table to determine the total budgeted indirect cost, total budgeted cost of each activity, and budgeted indirect cost of each product category for January 2018. (Round the percentages to the nearest hundredth percent, X.XX%.) Soft Fresh Packaged Drinks Snacks Food Total Ordering Delivery Shelf-stocking Customer support Total costs Percentage of total indirect costs % % % - Requirements Data table January 2018 Budgeted January 2018 Budgeted Amount of Cost Driver Used 1. What is the total budgeted indirect cost at the Roxbury store in January 2018? What is the total budgeted cost of each activity at the Roxbury store for January 2018? What is the budgeted indirect cost of each product category for January 2018? 2. Which product category has the largest fraction of total budgeted indirect costs? Cost-Driver Soft Fresh Packaged Rate Drinks Snacks Food Activity Ordering Delivery Cost Driver Number of purchase orders $ 86 16 28 3. Given your answer in requirement 2, what advantage does Family Mart gain by using an activity-based approach to budgeting over, say, allocating indirect costs to products based on cost of goods sold? 16 Number of deliveries $ 82 9 66 24 Shelf-stocking Hours of stocking time $ 22.00 19 179 96 Customer support Number of items sold $ 0.23 4,500 34,600 10,750 Print Done Drit Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions