ch5-4

Tableau DA 5-1: Quick Study, Analyzing credit terms and computing gross profit LO C1, P1 (similar to QS 5-18) As owner of Telo, a startup business, you are struggling to generate enough gross profit to compete with Creft and Wozz. Also, your business frequently runs low on cash. To help determine how to fix these issues, you review the following Tableau Dashboard. Sales and Costs for Competing Companies Telo Creft Wozz $100,000 $80,000 $50,000 $40,000 $20,000 Ceeft Sales: $78,000 $ 0 0 POS Sales POS Sales Sales Sales discounts sold Cost of goods Sales returns Pawances Sales Ciscounts Sales returns allowances discounts Cost of goods Salesetres ances Cost of gods Teln's Accete Credit Terms (Days) Telo's Assets Amounts at December 31 Supplies Accounts receivable Land Telo Creft Inventory Wozz Cash Buildings, net 70 Telo's Liabilities & Equity 0 10 20 30 40 50 60 Customer Return Policies Across Competitors Amounts at December 31 Wages payable A. Telo, Capital Creft Telo Notes payable Accounts payable Accounts payable Notes payable Wozz tableau bok rint 1. Which company offers customers the fewest days for returns? 2. Which company offers customers the most days to pay for credit sales? 3. Compute gross profit for Telo. rences 1. Fewest days for returns offered by 2. Higher credit period 3. Gross profit Wozz Telo Sales and Cast Tor Completing Companies Telo: Sales: 485,000 Sales discounts: $6,000 Sales retumst Allowances : #15,000 Cost of Goods Sold: 160,000 Cre?: sales $78,000 Sales discounts: $5,000 Sales returns s Allowances : $3,000 4 Cost of Goods Sold: 456,000 Wozz: Sales: $82,000 Sales discounts : 14,000 Sales yeurns: Allowances : $2,000 Cost of Goods Sold: $58,000 Telo's Assets Land : $12,000 Supplies : $3,000 Accounts Recievable : $8,000 Building, net: $24,000 Cash: $2,000 Inventory: 45,000 Credit terms (Days) : Telo: Credit Pened from Suppliers : 30 days credit Denod Given to customers: 75 days Cret: - credit period from Suppliers: 35 days Credit Period Given to customers : 45 days Wozz: - Credit Period from Suppliers: 40 days Credit period Given to customers : 50 50 da Customer Retum Policy Across competitors. Telo: 60 days crett: 15 days Wozz: 10 days Telo's Liabilities & Equity A Telo Capital: $6,000 Wages payable: $2,000 Notes payable; #31,000 Acounts payable: $5,000