Efficiency analysis) The Brenmar Sales Company had a gross profit margin (gross
profitsdivided by÷sales) Of 27 percent and sales of 9.1 million last year.
71percent of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $1.5 million, its current liabilities equal $ 297,700 and it has $ 107,200 in cash plus marketable securities.
a. If Brenmar's accounts receivable equal $562,500, what is its average collection period?
b. If Brenmar reduces its average collection period to 15 days, what will be its new level of accounts receivable?
c. Brenmar's inventory turnover ratio is 9.6 times. What is the level of Brenmar's inventories?
Ans. | Total Sales = $9,100,000 | ||
Credit sales = $9,100,000 * 71% = | $6,461,000 | ||
Gross profit = Total sales * Gross profit margin | |||
$9,100,000 * 27% = | $2,457,000 | ||
Cost of goods sold = Total sales - Gross profit | |||
$9,100,000 - $2,457,000 = | $6,643,000 | ||
Ans. A | Average collection period = Accounts recievable / Credit sales * Number of days in year | ||
$562,500 / $6,461,000 * 365 | |||
31.78 | days | ||
Ans. B | Average collection period = Accounts recievable / Credit sales * Number of days in year | ||
15 = Accounts recievables / $6,461,000 * 365 | |||
Accounts receivables = 15 * $6,461,000 / 365 | |||
$265,520.55 | |||
Ans. C | Inventory turnover = Cost of goods sold / Inventory | ||
9.6 = $6,643,000 / Inventory | |||
Inventory = $6,643,000 / 9.6 | |||
$691,979.17 | |||
Efficiency analysis) The Brenmar Sales Company had a gross profit margin (gross profitsdivided by÷sales) Of 27 percen...
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin (gross profits = sales) of 28 percent and sales of $8.9 million last year. 78 percent of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $1.2 million, its current liabilities equal $299,900, and it has $109,300 in cash plus marketable securities. a. If Brenmar's accounts receivable equal $563,300, what is its average collection period? b. If Brenmar reduces its average collection...
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin (gross profits ÷ sales) of 34 percent and sales of $8.4 million last year. 70 percent of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $1.2 million, its current liabilities equal $297,500, and it has $104,400 in cash plus marketable securities. a. If Brenmar's accounts receivable equal $562,000, what is its average collection period? b. If Brenmar reduces its average collection period to...
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin (gross profitsdivided by÷sales) of 32 percent and sales of $9.8 million last year. 79 percent of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $1.7 million, its current liabilities equal $297,000, and it has $107,400 in cash plus marketable securities. a. If Brenmar's accounts receivable equal $562,100, what is its average collection period? b. If Brenmar reduces its average collection...
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin (gross profits divided by÷sales) 26 percent and sales of $ 9.9 million last year. 78 percent of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $1.8 million, its current liabilities equal $ 300,700, and it has $100,100 in cash plus marketable securities.a. If Brenmar's accounts receivable equal $563,200, what is its average collection period?b. If Brenmar reduces its average collection...
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin (gross profits ÷ sales) of 26 percent and sales of $8.3 million last year. 70 percent of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $1.4 million, its current liabilities equal $295,500, and it has $109,900 in cash plus marketable securities. a. If Brenmar's accounts receivable equal $561,700, what is its average collection period? b. If Brenmar reduces its average collection period to...
The Brenmar Sales Company had a gross profit margin (gross profits divided by sales) of 25 percent and sales of $ 8.1 million last year. 75 percent of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $ 1.3 million, its current liabilities equal $ 301300, and it has $ 102900 in cash plus marketable securities. a. If Brenmar's accounts receivable equal $ 562400, what is its average collection period? b. If...
The Brenmar Sales Company had a gross profit margin (gross profits divided by sales) of 29 percent and sales of $8.1 million last year. 78 percent of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $1.8 million, its current liabilities equal $298,800 and it has $107,300 in cash plus marketable securties. A. If Brenmar's accounts receivale equal $561,600, what is is average collection period? B. If Brenmar reduces its average collection period...
The Jones Sales Company had a gross profit margin of 26% and sales of $9.2 million last year. 76% of the firm's sales are on credit, and the remainder are cash sales. Jones current assets equal $1.7 million, its current liabilities equal $295,400, and it has $108,300 in cash plus marketable securities. If Jones accounts receivable equal $563,200 what is its average collection period? If Jones reduces its average collection period to 25 days, what will be its new level...
(Efficiency analysis) ALei Industries has credit sales of $160 million a year. ALei's management reviewed its credit policy and decided that it wants to maintain an average collection period of 45 days. a. What is the maximum level of accounts receivable that ALei can carry and have a 45-day average collection period? b. If Alei's current accounts receivable collection period is 60 days, how much would it have to reduce its level of accounts receivable in order to achieve its goal of...
Return on Assets Net Sales Gross Profit Margin Cost of Goods Operating Net Profit Before Tax PI Expense Accounts Receivable Return On Assets + Merchandise Inventory Total Current Assets Asset Turnover Cash Total Assets Fixed Assets Other Current Assets Use the charts on the following page to calculate Net Profit Margin % for each scenario: Scenario 1 Scenario 2 Income Statement Income Statement Sales Sales Gross Sales $200,000 Gross Sales $100,000 Promotional Allowances $25,000 Promotional Allowances $15,000 Customer Returns -$15,000...