1. What is the total budgeted indirect cost at the Elmore store in January 2018​? What is the total budgeted cost of each activity at the Elmore store for January 2018​? What is the budgeted indirect cost of each product category for January 2018​?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

 

1.
What is the total budgeted indirect cost at the
Elmore
store in January
2018​?
What is the total budgeted cost of each activity at the
Elmore
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?
3.
Given your answer in requirement​ 2, what advantage does
Maclin's Corner
gain by using an​ activity-based approach to budgeting​ over, say, allocating indirect costs to products based on cost of goods​ sold?

 

### Activity-Based Budgeting Example for January 2018

#### Overview

The Elmore store at Maclin's Corner, a neighborhood convenience store chain, is preparing its activity-based budget for January 2018. The store has three main product categories:

- **Soft Drinks** (35% of Cost of Goods Sold - COGS)
- **Fresh Produce** (25% of COGS)
- **Packaged Food** (40% of COGS)

Four key activities consume indirect resources at the Elmore store. These activities, along with their cost drivers and rates, are outlined in the data table below.

#### Task

**Requirement 1**: 
- Determine the total budgeted indirect cost at the Elmore store for January 2018.
- Calculate the budgeted cost for each activity.
- Find the budgeted indirect cost for each product category for January 2018.

Complete the table to determine the following:
- Total budgeted indirect cost for each activity.
- Budgeted indirect cost for each product category for January 2018.
- Calculate the percentage of total indirect costs.

*(Round percentages to the nearest hundredth percent, X.XX%.)*

#### Data Table

For January 2018, the cost drivers for each activity are as follows:

| **Activity**        | **Cost Driver**             | **Rate ($)** | **Soft Drinks** | **Fresh Snacks** | **Packaged Food** |
|---------------------|-----------------------------|--------------|-----------------|-----------------|------------------|
| **Ordering**        | Number of purchase orders   | 86           | 14              | 29              | 14               |
| **Delivery**        | Number of deliveries        | 85           | 10              | 68              | 20               |
| **Shelf-stocking**  | Hours of stocking time      | 24.00        | 19              | 178             | 98               |
| **Customer support**| Number of items sold        | 0.17         | 4,100           | 34,100          | 11,000           |

This data will help calculate the total indirect costs attributed to each activity and product category, providing a detailed breakdown of financial planning based on the activity-based budget approach.
Transcribed Image Text:### Activity-Based Budgeting Example for January 2018 #### Overview The Elmore store at Maclin's Corner, a neighborhood convenience store chain, is preparing its activity-based budget for January 2018. The store has three main product categories: - **Soft Drinks** (35% of Cost of Goods Sold - COGS) - **Fresh Produce** (25% of COGS) - **Packaged Food** (40% of COGS) Four key activities consume indirect resources at the Elmore store. These activities, along with their cost drivers and rates, are outlined in the data table below. #### Task **Requirement 1**: - Determine the total budgeted indirect cost at the Elmore store for January 2018. - Calculate the budgeted cost for each activity. - Find the budgeted indirect cost for each product category for January 2018. Complete the table to determine the following: - Total budgeted indirect cost for each activity. - Budgeted indirect cost for each product category for January 2018. - Calculate the percentage of total indirect costs. *(Round percentages to the nearest hundredth percent, X.XX%.)* #### Data Table For January 2018, the cost drivers for each activity are as follows: | **Activity** | **Cost Driver** | **Rate ($)** | **Soft Drinks** | **Fresh Snacks** | **Packaged Food** | |---------------------|-----------------------------|--------------|-----------------|-----------------|------------------| | **Ordering** | Number of purchase orders | 86 | 14 | 29 | 14 | | **Delivery** | Number of deliveries | 85 | 10 | 68 | 20 | | **Shelf-stocking** | Hours of stocking time | 24.00 | 19 | 178 | 98 | | **Customer support**| Number of items sold | 0.17 | 4,100 | 34,100 | 11,000 | This data will help calculate the total indirect costs attributed to each activity and product category, providing a detailed breakdown of financial planning based on the activity-based budget approach.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education