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 C.
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 C.
Solution
To calculate the operating profit generated by customer C, we need to consider both the revenues and the costs associated with this customer.
-
Calculate the revenue: The revenue is the price per unit sold times the number of units sold. However, since there is a discount given per unit, we need to subtract this from the list price before multiplying by the number of units sold. Revenue = (List price - Discount) * Units sold Revenue = (0.40) * 1,500 Revenue = 5,400
-
Calculate the cost of goods sold (COGS): COGS = Cost per unit * Units sold COGS = 4,500
-
Calculate the other costs:
- Order-taking costs = Number of orders * Cost per order Order-taking costs = 27 * 2,160
- Delivery vehicle costs = Miles travelled per delivery * Number of deliveries * Cost per mile Delivery vehicle costs = 30 * 26 * 780
- Sales visits costs = Number of sales visits * Cost per visit Sales visits costs = 1 * 90
- Product packaging costs = Units sold * Cost per unit Product packaging costs = 1,500 * 75
- 'Fast' order costs = Number of 'fast' orders * Cost per 'fast' order 'Fast' order costs = 1 * 150
Total other costs = Order-taking costs + Delivery vehicle costs + Sales visits costs + Product packaging costs + 'Fast' order costs Total other costs = 780 + 75 + 3,255
-
Calculate the total cost: Total cost = COGS + Total other costs Total cost = 3,255 = $7,755
-
Finally, calculate the operating profit: Operating profit = Revenue - Total cost Operating profit = 7,755 = -$2,355
So, the operating profit generated by customer C is -$2,355. This means the company is operating at a loss with respect to customer C.
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.