Wildhorse Company’s budgeted sales and budgeted cost of goods
sold for the coming year are $144,820,000 and $110,160,000,
respectively. Short-term interest rates are expected to average
10%. If Wildhorse can increase inventory turnover from its present
level of 9 times a year to a level of 12 times per year.
Compute its expected cost savings for the coming year.
As we know
Inventory Turnover = Cost of Goods Sold /Average inventory
110,160,000/Average inventory = 9
Average inventory = 110,160,000/9 = 12,240,000
New inventory Turnover is expected to be 12 times
110,160,000/Average inventory = 12
New Average inventory = 110,160,000/12 = 9,180,000
Cost savings
= (12,240,000 - 9,180,000) * 10%
= 306,000
Wildhorse Company’s budgeted sales and budgeted cost of goods sold for the coming year are $144,820,000...
Williams & Sons last year reported sales of $23 million, cost of goods sold (COGS) of $18 and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up?
Edison Co, reported the following for the current year Net sales Cost of goods sold Net income Beginning balance of total assets Ending balance of total assets $90,000 $65,000 $23,400 $75,000 $81,000 Compute (a) profit margin and (b) return on total assets Complete this question by entering your answers in the tabs below. Profit Margin Ratio Return On Total Assets Compute the profit margin ratio. Choose Numerator: Profit Margin Ratio Choose Denominator - = Profit Margin Ratio Profit margin ratio...
Net Sales Cost of goods sold Average accounts receivable for the year Accounts receivable at year-end Average inventory for the year Inventory at year-end $1,095,000 657,000 44,250 18,000 226,000 158,400 Required: a. Calculate the inventory turnover for 2019. (Round your answer to 2 decimal places.) b. Calculate the number of days' sales in inventory for 2019, using year-end inventories. (Use 365 days a year. Round your answer to 1 decimal place.) c. Calculate the accounts receivable turnover for 2019. (Round...
Arberg Company’s controller prepared the following budgeted income statement for the coming year: Sales $423,000 Variable cost 329,940 Contribution margin $93,060 Fixed cost 51,040 Operating income $42,020 Required: 1. What is Arberg’s variable cost ratio? What is its contribution margin ratio? 2. Suppose Arberg’s actual revenues are $30,100 more than budgeted. By how much will operating income increase? Give the answer without preparing a new income statement. 3. How much sales revenue must Arberg earn to break even? Prepare a...
Hardy Company’s cost of goods sold is consistently 70% of sales. The company plans ending merchandise inventory for each month equal to 30% of the next month’s budgeted cost of goods sold. All merchandise is purchased on credit, and 40% of the purchases made during a month is paid for in that month. Another 45% is paid for during the first month after purchase, and the remaining 15% is paid for during the second month after purchase. Expected sales are:...
Williams & Sons last year reported sales of $108 million, cost of goods sold (COGS) of $90 and an inventory turnover ratio of 5. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Round your answer to the...
Williams & Sons last year reported sales of $16 million, cost of goods sold (COGS) of $12 and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Round your answer to the...
BrambleCorporation had net credit sales of $14100000 and cost of goods sold of $9370000 for the year. The average inventory for the year amounted to $1171250. The inventory turnover for the year is A. 8.0 times. B. 12.0 times. C. 3.3 times. D. 1.5 times. please include equation so I can understand how to solve this. Thank you.
Inventory Management Williams & Sons last year reported sales of $44 million, cost of goods sold (COGS) of $36 and an inventory turnover ratio of 4. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Round your answer...
C Company’s current year income statement reports the following: Sales $825,000 Cost of Goods Sold $550,000 Gross Profit $275,000 C Company’s comparative balance sheets show the following: End of Year Beginning of the Year Accounts receivable $71,000 $60,000 Inventory $109,000 $96,000 Accounts payable $31,000 $37,000 Compute the cash received from customers and the cash paid for inventory purchases.