k k As a newly appointed Chief Supply Chain Officer at YS Medical Devices, you want to figure out the company's cash-to-cash conversion cycle and make decision(s) to improve the company's performance. Here are pieces of financial data you may utilize: Sales: $23.5 million Cost of goods sold: $20.8 million Operating weeks a year: 50 Total average on-hand inventory (average inventory value): $2,150,000 Accounts receivable: $2,455,000 Accounts payable: $3,695,000

k k As a newly appointed Chief Supply Chain Officer at YS Medical Devices, you want to figure out the company's cash-to-cash conversion cycle and make decision(s) to improve the company's performance. Here are pieces of financial data you may utilize: Sales: $23.5 million Cost of goods sold: $20.8 million Operating weeks a year: 50 Total average on-hand inventory (average inventory value): $2,150,000 Accounts receivable: $2,455,000 Accounts payable: $3,695,000

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 84PSA

See similar textbooks

Similar questions

K .1 As a newly appointed Chief Supply Chain Officer at YS Medical Devices, you want to figure out the company's cash-to-cash conversion cycle and make decision(s) to improve the company's performance. Here are pieces of financial data you may utilize: Sales: $23.5 million Cost of goods sold: $20.8 million Operating weeks a year: 50 Total average on-hand inventory (average inventory value): $2,150,000 Accounts receivable: $2,455,000 Accounts payable: $3,695,000
Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.
Additional Activities Now that you have learned how to forecast revenues and cost of the business, investigate how these concepts are being applied by existing businesses in your community. Using the table below, fill in the necessary information based on your investigation. Daily Revenue and Cost Name of Business: Projected Projected Volume Revenue Projected Cost Mark-up Selling (D) (E) Costs of per Unit Price Average Merchandisel Purchases (A) (B) (C) No. of Products (Daily) (Daily) Items Sold (Daily) (B)= (A x C =A + E = C x D K = (A x D) .50) B Ex. Bag 150.00 75.00 225.00 10 2250 1500 yd belugm COLLEC tol elubom r borlain even uoy Jar wo Aan pese
You have just been appointed as financial manager of Slow-Moving-Stock Limited. One of your main focus areas is to improve the inventory management system that the company currently has in place. You have extracted the following records from the Inventory Management Software. ITEM X4355 January February March April May June July August September October November December Normal days for delivery Maximum days for delivery Cost of placing an order Carrying cost of a unit per year Total Sales (u) 1500 1300 1200 1100 1100 1100 1500 1600 1700 1800 2500 1900 18300 a) Determine and comment on the inventory days ratio. ( b) Determine the appropriate reorder level for Item X4355. c) Determine the Economic order quantity for Item X4355. ( 5 8 R850 R250 Trading days 20 18 20 19 20 21 22 20 20 21 22 17 240 You also found that total purchases for all items for the year was R55 000 000 with the end of year inventory value being R26 000 000.
Current Attempt in Progress You are considering investing in the grocery sector and have identified two companies for further analysis. Financial information for the two companies is as follows: (in thousands) Company Crane Company Cullumber Sales $1,940,000 $1,750,000 Cost of goods sold 1,746,000 1,505,000 Net income 103,000 99,000 Average inventory 151,000 218,000 Average total assets 786,000 755,476 (a) Calculate and compare the following ratios for the two companies: (Round inventory turnover to 2 decimal places, e.g. 15.25 and other answers to 1 decimal place, e.g. 18.4 or 15.3%.) i. Return on assets Homework Assignment Question 10 of 30 > Company Crane Company Cullumber Return on assets % Gross margin Profit margin Inventory turnover % % times % di % % times Days to sell inventory days days -/1
Problem Solving. Raymar Alison Trading has the following transactions during the fiscal year 2021. Cash sales 100,0000. Credit Sales 200,000. Total Sales 300,000. Cost of Goods Sold 150,000. Gross Margin 150,000. Beg. Accounts Receivable 25,000. End. Accounts Receivable 15,000. Beg. Inventory 35,000. End. Inventory 25,000. Total Expenses 50,000. 28. What is Inventory Turnover? * 5 10 15 20
Problem Solving. Raymar Alison Trading has the following transactions during the fiscal year 2021. Cash sales 100,0000. Credit Sales 200,000. Total Sales 300,000. Cost of Goods Sold 150,000. Gross Margin 150,000. Beg. Accounts Receivable 25,000. End. Accounts Receivable 15,000. Beg. Inventory 35,000. End. Inventory 25,000. Total Expenses 50,000. 27. What is Days Sales Outstanding? (360 days) * 18 24 36 72
Your boss asks you to compute your company's cash conversion cycle. Looking at the financial statements, you see that the average inventory for the year was $24,800, accounts receivable averaged $18,700, and accounts payable averaged $16,100. You also see that the company had sales of $138,000 and that cost of goods sold was $110,400. Calculate firm's cash conversion cycle. (Use 365 days for calculation. Round intermediate calculations and final answer to 1 decimal place, e.g. 15.1.)
Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Opening and closing accounts $300,000 Issuing monthly statements 450,000 Processing transactions 3,075,000 Customer inquiries 600,000 Providing automatic teller machine (ATM) services 1,680,000 Total cost $6,105,000 Additional data concerning the usage of the activities by the various customers are also provided: Account Balance Low Medium High Number of accounts opened/closed 22,500 4,500 3,000 Number of statements issued 675,000 150,000 75,000 Processing transactions 27,000,000 3,000,000 750,000 Number of telephone minutes 1,500,000 900,000 600,000 Number of ATM transactions 2,025,000…
Consider a telecommunication service provider. You have the following quarterly data: STATISTICS TYPICAL CONSUMER Number of referrals per period (n=n1+ n2) 5 of which, customers that joined due to the referral (n1) 3 of which, customers that would have joined anyway (n2) 2 Marketing cost per period (Mty) $30 Average gross margin (Aty) $78 Cost of referral (aty) $15 Acquisition cost savings (ACQ1ty and ACQ2ty) $10 Yearly discount rate (r) 15% Calculate CRV of a typical customer for one year (over 4 quarters).
Problem Solving. Raymar Alison Trading has the following transactions during the fiscal year 2021. Cash sales 100,0000. Credit Sales 200,000. Total Sales 300,000. Cost of Goods Sold 150,000. Gross Margin 150,000. Beg. Accounts Receivable 25,000. End. Accounts Receivable 15,000. Beg. Inventory 35,000. End. Inventory 25,000. Total Expenses 50,000. 29. What is Days Inventory Outstanding? (360 days) 18 24 36 72
Identify the activity ratio of a computer shop is its Cost of Goods Sold is P12 million and the Average Inventory is P24 million. Analyze and interpret your answer. Compute the return on investment of AR Grocery Store if the net profit after taxes is P10 million and its total assets is P100 million. Analyze and interpret your answer.