Assignment - AquaDrench CPA analysis based on sales

Assignment Help Accounting Basics
Reference no: EM132452944

Assignment -

Part A - AquaDrench CPA analysis (based on sales)

AquoDrench manufactures water pistols for sale in leading toy retailers by far their most popular model is the 'Amphitrite'. The product features of this model include a 10 litre water storage capacity (this is strapped to the user's back) and an automatic rapid fire option for pure drenching power. AquaDrench also produces a second model, the 'Poseidon', which is reputed to be the longest shooting water pistol on the market. The price (wholesales price to the toy stores] and cost of goods sold per unit for each of these products are as follows"

 

Amphitrite

Poseidon

Price per unit

$100

$50

Cost of goods sold per unit

60

40

Gross profit per unit

$40

$10

In addition, the company incurs customer-related selling & general admin. (SG&A) expenses of $450,000. The company wishes to assign these costs to its three retail customers, Tru Kids, Toyworld. and Kidstuffs. The annual volumes to these customers (in units) are:

Retailer

Amphitrite Sales Volume

Poseidon Sales Volume

Tru Kids

9,500

5,000

Toyworld

10,000

7,000

Kidstuffs

4,500

4,500

Required - Prepare a report showing the relative profitability of each customer, allocating customer-related expenses based on sales dollar. Compare the relative contribution of each customer to gross profit before and after the allocation of customer-related expenses (as a percentage of the total amount). How would you rank these customers based on this report?

Part B - AquaDrench CPA analysis {using activity-based-information)

Further analysis has revealed that the customer-related expenses ($450,000) are related to three major activities: customer service, sales order processing (the retailers manually order stock and when they require it), and advertising support. The advertising support is in the form of advertisement that are places by AquaDrench to support the retailer's further sales of AquaDrench products to customers. The full-time equivalent (FTE) and activity drivers associated with these activities are:

 

FTE

Activity Driver

Customer service

50

No. of service requests

Sales order processing

40

No. of Sales Orders

Advertising support

10

No. of Ads Placed

Total

100

 

Toyworld require extensive support in the form of sales order processing 9 orders are received from each individual store rather than from central point of contact) service, and advertising support, as can be seen from the following activity information:

 

Tru Kids

Toyworld

Kidstuffs

Total

No. of service requests

10

55

185

250

No. of Sales Orders

12

48

90

150

No. of Ads Placed

20

50

130

200

Required -

a. Prepare a customer profitability report using activity-based information.

b. How does your assessment of profitability differ from the previous report?

c. If the relative profitability of the three customer has changes, why is that the case?

d. What recommendations would you make regarding the management of each of these three customers?

Reference no: EM132452944

Questions Cloud

Personal finances of applicants and current employees : Should employers concern themselves with the personal finances of applicants and current employees?
Demonstrate careful consideration of the various risks : Demonstrate careful consideration of the various risks, and how they would affect the outcome,Provide trigger points and contingency actions to allow future
Discuss the organization that had a cyber breach : Research recent cyber breaches that have occurred with different companies. Select a company that had a cyber breach and consider what happened.
Defines Ethnic Identity and Sexual Identity : describe how author of your textbook defines Ethnic Identity and Sexual Identity. describe difference between intuitionism, subjectivism, and transsubjectivism
Assignment - AquaDrench CPA analysis based on sales : Part A - AquaDrench CPA analysis (based on sales). Prepare a report showing the relative profitability of each customer, allocating customer-related expenses
Discuss analysis is simply a process of identifying risks : Evaluating investment opportunities. Investment analysis is simply a process of identifying risks and opportunities, developing and analyzing viable alternative
Statement for an argument for change in workplace : Include your thesis statement for an argument for change in your workplace, and identify at least three search terms you can use in the Internet search
Rules governing estates are state-based : As previously discussed, rules governing estates are state-based and thus, each state could have a different set of rules.
Bombing of hiroshima : A 4-5 page paper (APA format) starting with when the first nuclear weapon was created, up to the bombing of Hiroshima.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd