Customer profitability, distribution. Green Paper Delivery has decided to analyze the profitability of five new customers. It buys recycled paper at $20 per case and sells to retail customers at a list price of $26 per case. Data pertaining to the five customers are:Green Paper Delivery’s five activities and their cost drivers are:Compute the customer-level operating income of each of the five retail customers now being examined (1, 2, 3, 4, and 5). Comment on the results.What insights do managers gain by reporting both the list selling price and the actual selling price for each customer?What factors should managers consider in deciding whether to drop one or more of the five customers? Customer2341,83031,2001,950Cases sold6,78044,500$26$26$26$26$26List selling priceActual selling price$26$25.20$24.30$25.80$23.90Number of purchase orders1018351635Number of customer visits3512412Number of deliveries1228652535Miles traveled per delivery14645Number of expedited deliveries ActivityCost Driver Rate$90 per purchase order$75 per customer visit$3 per delivery mile traveled$1.20 per case sold$250 per expedited deliveryOrder takingCustomer visitsDeliveriesProduct handlingExpedited deliveries

Customer 2 3 4 1,830 31,200 1,950 Cases sold 6,780 44,500 $26 $26 $26 $26 $26 List selling price Actual selling price $26 $25.20 $24.30 $25.80 $23.90 Number of purchase orders 10 18 35 16 35 Number of customer visits 3 5 12 4 12 Number of deliveries 12 28 65 25 35 Miles traveled per delivery 14 6 45 Number of expedited deliveries Activity Cost Driver Rate $90 per purchase order $75 per customer visit $3 per delivery mile traveled $1.20 per case sold $250 per expedited delivery Order taking Customer visits Deliveries Product handling Expedited deliveries

Customer 2 3 4 1,830 31,200 1,950 Cases sold 6,780 44,500 $26 $26 $26 $26 $26 List selling price Actual selling price $26 $25.20 $24.30 $25.80 $23.90 Number of purchase orders 10 18 35 16 35 Number of customer visits 3 5 12 4 12 Number of deliveries 12 28 65 25 35 Miles traveled per delivery 14 6 45 Number of expedited deliveries Activity Cost Driver Rate $90 per purchase order $75 per customer visit $3 per delivery mile traveled $1.20 per case sold $250 per expedited delivery Order taking Customer visits Deliveries Product handling Expedited deliveries

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter5: Operating Activities: Purchases And Cash Payments

Section: Chapter Questions

Problem 2.10C

See similar textbooks

Similar questions

The following relates to a single sale of goods made by Spurs in 2023: Selling price P500,000Freight costs 5,000Terms 3/15, n/30Shipping Date December 28, 2023Date goods received by the customer January 3, 2024Date payment is received by Spurs January 5, 2024 Question:9. If the term is FOB destination, how much sales should be recorded by Spurs for the year ended December 31, 2023? a. P0b. P490,000c. P495,000d. P500,000
March1 Beginning Inventory 60 units @ $15 per unit 5 Purchase 140 units @ $15.5 per unit 14 Sales 190 units @ $19 per unit 27 Purchase 70 units @ $16 per unit 29 Sales 30 units @ 19.50 per unit find the weighted average cost of good sale $1120 $4190 $3220 $3414
lf the cost of purchases 130 000 lD., sales revenue 200 000 lD.,beginning inventory 20 000 lD.,sales discount 25 000 lD.,sales returns 50 000 lD.,ending inventory 25 000 lD . , the cost of goods sold are :- * 220 000 lD. 195 000 lD . 125 000 lD . 70 000 lD .
SCRUMPTIOUS CUPCAKESProfit and loss accountfor the year ended 30 April 20202020£SalesSales 220,000Cost of sales 120,000Gross Profit 100,000ExpensesSalaries 24,000Other Fixed cost 4,800Distribution 3,000Advertising 4,500Rent 13,200AHUtilities 3,600Other Cost 4,00057,100Operating Profit 42,900 SCRUMPTIOUS CUPCAKESBalance Sheetas at 30 April 20202020£Fixed assetsIntangible assets -Tangible assets 35,000Investments -35,000Current assetsStocks 3,000Debtors 10,000Cash at bank and in hand 6,30019,300Written ReportsCreditors: amounts falling duewithin one year (11,300)Net Current Assets 8,000Total assets less currentliabilities 43,000Net Assets 43,000Capital and reservesCalled up share capital 100Profit and loss account 42,900Shareholders' funds 43,000 please calculate the folliwing ratios: Profitability Ratios – Gross Profit Margin, Net Profit Margin and ROCE● Liquidity – Current Test and Acid Test● Gearing● Activity/Performance – Stock Turnover, Debtors’ Collection Period and AssetTurnover…
GB SalesRevenue 16800 Purchases 12800 Gross Profit 4000 Selling Expenses 2000 Admin Cost 7200 Operating Loss 5200 b) Calculate mark-up (in percentage to 2 decimal places) c) Calculate the margin as a % to 1 decimal place d) What is the operating profit margin percentage if the admin cost is reduced by 60%? Show this to 1 decimal place e) Define the following and provide respective examples with numeric calculations where possible: Trade discountBulk discountEarly settlement discount f) If a company has a mark-up of 37% and sales revenue of £163,970, then what is the cost of sales in whole £’s? g) If a company has a net margin of 15%, gross margin of 35% and costs of sale of £25,000, then what is the sales revenue and overhead?
lf the cost of purchases 130 000 lD., sales revenue 200 000 lD.,beginning inventory 20 000 lD.,sales discount 25 000 lD.,sales returns 50 000 lD.,ending inventory 25 000 lD . , the cost of goods sold are :- *
('$) ('$) Unit Total Balance Date Explanation Units Cost Cost in Units Jun-01 Beginning inventory 50 1.0 50 50 Jun-06 Purchase 50 1.2 60 100 Jun-10 Sales 60 40 Jun-13 Purchase 150 1.4 210 190 Jun-20 Purchase 100 1.6 160 290 Jun-25 Purchase 150 1.8 270 440 Jun-30 Sales 150 290 Round your answer to the nearest dollar. (eg $54.4 ....input as 54 , $54.5 input as 55 ) (do not input comma "," , dollar sign "$" for numerical figures) FIFO Periodic System COGS $ Ending Inventory $ Average Cost Periodic System COGS $ Ending Inventory $ FIFO Perpetual System COGS $ Ending Inventory $ Average Cost Perpetual System COGS $ Ending Inventory $ ('$) ('$) Unit Total BalanceDate Explanation Units Cost Cost in UnitsJun-01 Beginning inventory 50 1.0 50 50Jun-06 Purchase 50 1.2 60 100Jun-10 Sales 60 40Jun-13 Purchase 150 1.4 210 190Jun-20 Purchase 100 1.6 160…
J Gross Sales Sales Return & Allowances Sales Discounts Cost of Merchandise Sold 33,000 O $87,000 O $46,000 100,000 Given the above values, determine Net Sales. O $67,000 10,000 O $54,000 3,000 Need help? Review these concept resources.
Excellent Company manufactures a product that is packaged and sold. A plate is offered to customers sending in three wrappers accompanied by a remittance of P20. Data with respect to the premium offer are summarized below: Sales Purchase of premium, P50 per plate Number of plates distributed as 3,800,000 4,000,000 380,000 560,000 premium 4,500 8,000 Estimated number of plates to be distributed in subsequent period 2,500 3,500 Distribution cost P10 per plate Required: Prepare journal entries that would be made in 2020 and 2021 to record sales, premium purchases and redemptions, and year-end adjustments.
March1 Beginning inventory = 29 units @ $5.90 March3 Purchased 15 units @ 3.70 March9 Sold 23 units @ 8.90 1)What is the cost of goods sold for Julia & Company assuming it uses LIFO? Date Transaction Numberof Units UnitCost March 1 Beginning inventory 930 7.22 March 10 Purchase 550 7.64 March 16 Purchase 760 8.14 March 23 Purchase 580 8.54 2)Marvin sold 1,900 units of inventory during the month. Cost of goods sold assuming FIFO would be: 3)A company's sales equal $60,000 and cost of goods sold equals $20,000. Its beginning inventory was $1,600 and its ending inventory is $2,400. The company's inventory turnover ratio equals:
he company has these parties of goods on hand: 10x1.000 TL; 20x900 TL; 10x800 TL; 10x700 TL. If 37 items are sold with 20% profit margin (COGS +20% Profit), what is COGS and Sales Revenue in LIFO? a. COGS: 9.400 TL; Sales Revenue: 11.280 TL b. COGS: 33.600 TL; Sales Revenue: 40.320 TL c. COGS: 30.300 TL; Sales Revenue: 36.360 TL d. COGS: 12.700 TL; Sales Revenue: 15.240 TL
P8.6 (LO 3) (Compute FIFO, LIFO, Average-Cost—Periodic and Perpetual) Ehlo Company is a multi product firm. Presented below is information concerning one of its products, the Hawkeye.Date Transaction Quantity Price/Cost1/1 Beginning inventory 1,000 $122/4 Purchase 2,000 182/20 Sale 2,500 304/2 Purchase 3,000 2311/4 Sale 2,200 33Instructions Compute ending inventory AND cost of goods sold, assuming Ehlo uses: a. Periodic system, FIFO cost flow. b. Perpetual system, FIFO cost flow. c. Periodic system, LIFO cost flow. d. Perpetual system, LIFO cost flow. e. Periodic system, weighted-average cost flow. f. Perpetual system,…