Purchase Solution

Preparing ABC Analysis Report

Not what you're looking for?

Ask Custom Question

Information attached in spreadsheet

As You Like It Gardening is a small gardening service that uses activity-based costing to estimate costs for pricing and other purposes. The proprietor of the company believes that costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the number of customers. In addition, the cost of maintaining garden beds depends on whether the beds are low-maintenance beds (mainly ordinary trees and shrubs) or high-maintenance beds (mainly flowers and exotic plants). Accordingly, the company uses the five activity cost pools listed below:

Activity Cost Pool
Activity Measure

Caring for lawn
Square feet of lawn

Caring for garden beds-low maintenance
Square feet of low-maintenance beds

Caring for garden beds-high maintenance
Square feet of high-maintenance beds

Travel to jobs
Miles

Customer billing and service
Number of customers

--------------------------------------------------------------------------------

The company has already carried out its first-stage allocations of costs. The company's annual costs and activities are summarized as follows:

Activity cost Pool_____Estimated Overhead Cost____Expected Activity

Caring for lawn____$77,400___180,000 square feet of lawn

Caring for garden beds-low maintenance____$30,000___24,000 square feet of low-maintenance beds

Caring for garden beds high maintenance___$57,600___18,000 square feet of high-maintenance beds

Travel to jobs___$4,200___15,000 miles

Customer billing and service___$8,700___30customers

Determine the Appropriate Selling Price for a single Job with the following dimensions:
-Lawn:200,000 square feet
-High Maintenance Garden: 20000 square feet
-Travel 200 miles
-Number of Customers: 1 customer (assume a 10% profit margin and a cost-based pricing model)

Attachments
Purchase this Solution
Solution Preview

Determine the Appropriate Selling Price for a single Job with the following ...

Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

View More Free Quizzes
Related BrainMass Solutions

  • Accounting Problem

    Based on what you have learned regarding ABC costing, please help Mary prepare a revised cost report by: a. Computing the overhead rate for various activities in the spirit of ABC b. Preparing a new cost report for the three products c.

  • Bond - Selling price, amortization and retirement

    ABC uses the effective interest method of amortization. Bond issue costs were incurred in preparing and selling the bond issue. The bonds can be called by ABC at 101 at any time on or after March 1, 2006. Instructions: a.)

  • Profitability report

    294061 Profitability report family supermarkets Please see attachment. Family Supermarkets (FS) operates at capacity and decides to apply ABC analysis to three product lines: baked goods, milk and fruit juice, and frozen foods. 1.

  • Activity-Based Costing vs. Traditional Costing

    Be sure to provide appropriate quantitative analysis in your explanation.

  • Developing financial plans

    The operating report plays an important role for the marketing and creates awareness among customers about the ABC services. Cost of operating report is found in the income statement under operating expenses.

  • ABC Corp Case Analysis

    614291 ABC Corp Case Analysis Consider the following scenario: On July 15th, Mr. Jones talks to the president of ABC Corp about the possibility of selling a property owned by ABC. Mr.

  • Article Analysis Summary

    Hence ABC is more accurate cost management system as it is used to identify, describe, assign costs to, and report on agency operations.

  • Activity based costing

    Wedig hires a consulting firm to perform an ABC analysis of its overhead costing methodology.

  • Scorekeeping, Attention Directing, and Problem Solving

    Problem solving - Analysis helps the superintendent assess the impact of his decision to purchase the new equipment. 3. Preparing a scrap report for the finishing department of a Toyota parts factory.

View More Related Solutions