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?
Assignment 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 is 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 customers has changes, why is that the case?
d. What recommendations would you make regarding the management of each of these three customers?
Exhausted of spending hours and reading books to complete your assignments? Get the most précised Customer Profitability Assignment Help service in the region!
Tags: Customer Profitability Assignment Help, Customer Profitability Homework Help, Customer Profitability Coursework, Customer Profitability Solved Assignments, Customer Expenses Assignment Help, Customer Expenses Homework Help