Question

The Brenmar Sales Company had a gross profit margin​ (gross profits divided by ÷​sales) of 25...

The Brenmar Sales Company had a gross profit margin​ (gross profits divided by ÷​sales) of 25 percent and sales of $ 9.5 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.3 ​million, its current liabilities equal $298,600​, and it has $104,200 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 period to 25 ​days, what will be its new level of accounts​ receivable?

c. Brenmar's inventory turnover ratio is 9.8 times. What is the level of​ Brenmar's inventories?

Homework Answers

Answer #1

a.) Receivables Turnover = Credit Sales/Accounts Receivables = 6,650,000/563,200 = 11.81 times

Average Collection Period = 365/Receivables Turnover = 365/11.81 = 30.91 or approximately 31 days.

b.) Average Collection Period = 25 days = 365/Receivables Turnover

Receivables Turnover = 365/25 = 14.6 times

Receivables Turnover = Credit Sales/Accounts receivables = 6,650,000/Accounts receivables

Accounts receivables = 6,650,000/14.6 = $455,479.45 or $455,480 approximately.

c.) Gross profit margin = Gross profit/Sales

25% of sales = Gross profit

Gross profit = 9,500,000 x .25 = $2,375,000

COGS = Sales - Gross profit = 9,500,000 - 2,375,000 = $7,125,000

Inventory turnover = COGS/Inventory = 7125000/Inventory

Inventory = 7125000/9.8 = $727,040.82 or approximately $727,041

Please let me know in the comment section if you still have any doubts. Hope this helps :)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The Tabor Sales Company had a gross profit margin (gross profits divided by sales) of 30.7...
The Tabor Sales Company had a gross profit margin (gross profits divided by sales) of 30.7 percent and sales of $9.4 million last year. Seventy-five percent of the firm's sales are on credit and the remainder are cash sales. Tabor's current assets equal $2.7 million, its current liabilities equal $283000 , and it has $98000 in cash plus marketable securities. a. If Tabor's accounts receivable are $562500 , what is its average collection period? b. If Tabor reduces its average...
​(Evaluating liquidity​) The Tabor Sales Company had a gross profit margin​ (gross profits divided by ÷​sales)...
​(Evaluating liquidity​) The Tabor Sales Company had a gross profit margin​ (gross profits divided by ÷​sales) of 30.4 percent and sales of ​$9.2 million last year.​ Seventy-five percent of the​ firm's sales are on credit and the remainder are cash sales.​ Tabor's current assets equal ​$2.1 ​million, its current liabilities equal ​$319,000​, and it has ​$99,000 in cash plus marketable securities. a. If​ Tabor's accounts receivable are ​$562,500​, what is its average collection​ period? b. If Tabor reduces its average...
​(Evaluating liquidity​) The Tabor Sales Company had a gross profit margin​ (gross profits divided by ​sales)...
​(Evaluating liquidity​) The Tabor Sales Company had a gross profit margin​ (gross profits divided by ​sales) of 30.0 percent and sales of ​$9.0 million last year.​ Seventy-five percent of the​ firm's sales are on credit and the remainder are cash sales.​ Tabor's current assets equal ​$1.5 ​million, its current liabilities equal ​$300 comma 000​, and it has ​$100 comma 000 in cash plus marketable securities. a. If​ Tabor's accounts receivable are ​$562 comma 500​, what is its average collection​ period?...
The Brenmar Sales Company had a gross profit margin​ (gross profits÷​sales) of 34 percent and sales...
The Brenmar Sales Company had a gross profit margin​ (gross profits÷​sales) of 34 percent and sales of $8.7 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,900​, and it has $109,500 in cash plus marketable securities. a. If​ Brenmar's accounts receivable equal $562,300​, what is its average collection​ period? b. If Brenmar reduces its average collection period to 25...
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin​ (gross profits÷​sales) of 32 percent...
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin​ (gross profits÷​sales) of 32 percent and sales of $9.8 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.4 million, its current liabilities equal $295,600​, and it has $102,300 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 period...
​(Evaluating liquidity​) The Tabor Sales Company had a gross profit margin​ (gross profits ÷ ​sales) of...
​(Evaluating liquidity​) The Tabor Sales Company had a gross profit margin​ (gross profits ÷ ​sales) of 30.0 percent and sales of ​$9.0 million last year.​ Seventy-five percent of the​ firm's sales are on credit and the remainder are cash sales.​ Tabor's current assets equal ​$1.5 ​million, its current liabilities equal ​$300,000​, and it has ​$100,000 in cash plus marketable securities. a. If​ Tabor's accounts receivable are ​$562,500​, what is its average collection​ period? b. If Tabor reduces its average collection...
​(Efficiency analysis)  The Brenmar Sales Company had a gross profit margin​ (gross profitsdivided by÷​sales) of 27...
​(Efficiency analysis)  The Brenmar Sales Company had a gross profit margin​ (gross profitsdivided by÷​sales) of 27 percent and sales of $8.5 million last year.   73 percent of the​ firm's sales are on​ credit, and the remainder are cash sales. ​ Brenmar's current assets equal $1.1 ​million, its current liabilities equal $303,200​, and it has $100,400 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 period to...
?(Evaluatingliquidity?) The Tabor Sales Company had a gross profit margin? (grossprofitsdivided by÷?sales)of 30.3 percent and sales...
?(Evaluatingliquidity?) The Tabor Sales Company had a gross profit margin? (grossprofitsdivided by÷?sales)of 30.3 percent and sales of ?$9.1 million last year.? Seventy-five percent of the? firm's sales are on credit and the remainder are cash sales.? Tabor's current assets equal ?$2.7 ?million, its current liabilities equal ?$310,000 and it has 105,000 in cash plus marketable securities. a. If? Tabor's accounts receivable are ?$562,500 what is its average collection? period? b. If Tabor reduces its average collection period to 24 ?days,...
A Corp. had total sales of $1,000,000 in 2018 (80 % of its sales are credit)....
A Corp. had total sales of $1,000,000 in 2018 (80 % of its sales are credit). The company's gross profit margin is 20%, its ending inventory is $100,000, and its accounts receivable balance is $60,000. What additional amount of cash could the firm have generated if it had increased its inventory turnover ratio to 10.0 and reduced its average collection period to 22.375 days. With the same level of sales?
The average of number days taken to collect debts from credit customers indicates the efficiency of...
The average of number days taken to collect debts from credit customers indicates the efficiency of collection. The shorter the number of days, the greater the efficiency. The average collection period is obtained by dividing the average accounts receivable by the daily average credit sales. For Smith & Co. the average collection period is 28 days and average accounts receivable is $196000. The company’s daily average credit is: 2. When the cost of goods sold is divided by the average...