Question
The Athens store of Gabriel's Corner, a chain of small neighborhood convenience stores, is preparing its activity-based budget for January 2018. Gabriel's Corner has three
The Athens store of Gabriel's Corner, a chain of small neighborhood convenience stores, is preparing its activity-based budget for January 2018. Gabriel's Corner 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 Athens store, the cost drivers and their rates, and the cost-driver amount budgeted to be consumed by each activity in January 2018.
|
| January 2018 | January 2018 Budgeted | ||
|
| Budgeted | Amount of Cost Driver Used | ||
|
| Cost-Driver | Soft | Fresh | Packaged |
Activity | Cost Driver | Rate | Drinks | Snacks | Food |
Ordering | Number of purchase orders | $94 | 15 | 25 | 15 |
Delivery | Number of deliveries | $85 | 11 | 63 | 19 |
Shelf-stocking | Hours of stocking time | $24.00 | 20 | 175 | 94 |
Customer suport | Number of items sold | $0.21 | 4,600 | 34,700 | 10,600 |
Requirement 1. What is the total budgeted indirect cost at the Athens store in January 2018? What is the total budgeted cost of each activity at the Athens 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 suport |
|
|
|
| ||||
Total costs |
|
|
|
| ||||
Percentage of total indirect costs |
| % |
| % |
| % |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started