Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Qing Enterprises Ltd. a wholesaler that provides a variety of products to retailers In Manitoba and Saskatchewan. owners purchased Qing , and are unhappy with

Qing Enterprises Ltd. a wholesaler that provides a variety of products to retailers In Manitoba and Saskatchewan. owners purchased Qing , and are unhappy with the internal reports available to themOne concem that there is no process place to evaluate the profitability of individual customers. The following information has been gathered a) When an order is received from a customer, the credit status of the customer must be checked before the order acceptedOnce accepted, the items ordered are entered into the system and the quantities ordered compared to the quantities on hand. A picking document created for the warehouse stafflisting the quantity ordered or on hand, whichever fewer b) Warehouse staff then retrieves the inventory items from the warehouse and packages them on pallets for shipment. The pallets are then shipped to the customers using Qing trucks. There are established routes, so that each location has Inventory delivered once per weekShipments in Manitoba are made Mondays, Wednesdays and Fridays, with Saskifichewan shipments occurring on Tuesdays and Thursdays. If the customer requires a shipment between normal shipping dates, it can normally be accommodated but requires the driver to extend the route on the shipping date nearest the customer, which lengthens the trip significantly. The cost is dependent upon the extra time taken to deliver to the customer who placed the rush order c) Customer support provided through salespeople; each customer has a specific salesperson assigned. Meetings with salespeople have been carried out online during covid.

image text in transcribed
Activity Total cost of Cost driver Total volume activity of cost driver Order acceptance $27,000 # of orders received 6,000 Order entry $63,000 # of different products 180,000 Picking inventory $162,000 # of different products 180,000 Packing for shipment $81,000 # of pallets delivered 9,000 Shipping costs $168,000 # of kms driven 150,000 Rush shipments $10,000 # of hours to customer 200 Salesperson support $300,000 # of customers 240 Total overhead costs $811,000 Two customers have been selected for evaluation, and totals have been calculated for the year ended September 30, 2021.yGillespie's Lid. purchased items with a selling price of $210,000 from Qing Qing. @lag Qing paid $130,000 to acquire these inventory items. Claridge Corp. purchased items with a selling price of $80,000 from Qing Qing Qing Qing paid $42,000 for these items. The difference in gross profit earned from each customer is due to Gillespie's receiving a discount in selling price for purchasing more than $200,000 during the year. The following information was gathered on the use of each cost driver by each customer. Cost driver activity Gillespie's Claridge # of orders received from 25 52 Average # of different products purchased on 100 20 EACH order Average # of pallets sent for EACH order # of kms driven to deliver EACH order 500 500 Total time taken for delivery of rush orders in year 0 16 Required: 2 a) If activity-based costing is to be used to assign costs to customers, should the order acceptance and order processing functions be considered one activity or two? Explain your reasoning. 3.5 b) Calculate the cost per unit of cost driver for each activity pool. 8.5 c) Calculate the gross profit and overall profitability of Gillespie's and of Claridge, separately. Which customer is the more desirable customer for Qing Qing? 2 d) Provide one reasonable suggestion to management to make the less desirable of the two customers more profitable. Explain how this can be presented to the customer in a way that will reduce the probability the customer will change to another supplier

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Finance

Authors: Arthur Keown, John Martin, J. Petty

10th Edition

0136102654, 9780136102656

More Books

Students also viewed these Accounting questions

Question

2. What do the others in the network want to achieve?

Answered: 1 week ago

Question

1. What do I want to achieve?

Answered: 1 week ago