A company allows its sales representatives discretion to offer price discounts below its $4 list price per unit sold. Details relating to three key customers for the month are listed below: Customers A B CUnits sold 10,000 15,000 1,500Discount given per unit $0.30 $0.10 $0.40Number of purchase orders 25 30 27Number of deliveries 52 20 26Number of sales visits 2 1 1Miles travelled per delivery 12 35 30Number of 'fast' orders 1 4 1 Additional information: A 'fast' order is an emergency order, outside of normal delivery schedules, and incurs a total cost of $150. Other cost-driver rates are detailed as follows: Activity Area Cost-Driver RateOrder-taking $80 per orderDelivery vehicle costs $1 per mile travelledSales visits $90 per visitProduct packaging $0.05 per unit sold Assuming the cost of goods sold is $3 per unit, calculate the operating profit generated by customer B.
Question
A company allows its sales representatives discretion to offer price discounts below its 0.30 0.40Number of purchase orders 25 30 27Number of deliveries 52 20 26Number of sales visits 2 1 1Miles travelled per delivery 12 35 30Number of 'fast' orders 1 4 1 Additional information: A 'fast' order is an emergency order, outside of normal delivery schedules, and incurs a total cost of 80 per orderDelivery vehicle costs 90 per visitProduct packaging 3 per unit, calculate the operating profit generated by customer B.
Solution
To calculate the operating profit generated by customer B, we need to consider both the revenue generated and the costs incurred.
Step 1: Calculate the revenue The revenue is calculated by multiplying the number of units sold by the price per unit. However, since the company allows its sales representatives to offer price discounts, we need to subtract the discount from the list price before multiplying by the number of units sold.
Revenue = (List price - Discount) * Units sold Revenue = (0.10) * 15,000 Revenue = 58,500
Step 2: Calculate the cost of goods sold The cost of goods sold is calculated by multiplying the number of units sold by the cost per unit.
Cost of goods sold = Cost per unit * Units sold Cost of goods sold = 45,000
Step 3: Calculate the other costs The other costs include the cost of taking orders, delivery vehicle costs, sales visits, product packaging, and 'fast' orders.
Order-taking costs = Cost-driver rate * Number of orders Order-taking costs = 2,400
Delivery vehicle costs = Cost-driver rate * Miles travelled per delivery * Number of deliveries Delivery vehicle costs = 700
Sales visits costs = Cost-driver rate * Number of sales visits Sales visits costs = 90
Product packaging costs = Cost-driver rate * Units sold Product packaging costs = 750
'Fast' orders costs = Cost of 'fast' order * Number of 'fast' orders 'Fast' orders costs = 600
Total other costs = Order-taking costs + Delivery vehicle costs + Sales visits costs + Product packaging costs + 'Fast' orders costs Total other costs = 700 + 750 + 4,540
Step 4: Calculate the operating profit The operating profit is calculated by subtracting the total costs (cost of goods sold + other costs) from the revenue.
Operating profit = Revenue - Total costs Operating profit = 45,000 + 58,500 - 8,960
Therefore, the operating profit generated by customer B is $8,960.
Similar Questions
In addition to the regular trade discount of 25% and a volume purchase discount of 813%813% from the manufacturer, Appliance Warehouse is offered a further 5% discount for orders placed in January. (Use five decimal places for repeating decimals.)a. What is the net price after all three trade discounts on refrigerators listed at $1,195? (Round your answer to the nearest cent.)
32. If a merchandise is sold on account to a customer for P10,000, terms FOB shipping point, 1/10, n/30, and the seller prepays the transportation costs of P500, the amount of the discount for early payment would be:*a. P 0b. P50c. P100d. P105
Multiple Choice QuestionA company receives a special order of 10,000 units of product. The potential customer is willing to pay $0.75 per unit. Current sales are $90,000 and current costs are $75,000 for 90,000 units. If the order is accepted, costs will increase to $82,000. If the company has the capacity to accept the order without affecting current sales, the company should:Multiple choice question.reject the order, because income will decrease by $500reject the order, because the sales price of $0.75 per unit is less than current costs of $0.83 per unitaccept the order, because income will increase by $500accept the order, because sales will increase by $7,500
Merchandise is sold for $10,400, terms 1/10, n/30. Prior to payment, the customer returned $760 of the merchandise. If the invoice is paid within the discount period the amount of the sales discount is:
A quantity discount is a price reduction to buyers who purchase: A. Frequently B. Large volumes C. Close outs D. Inferior merchandise
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.