Question

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 collection period to 24 days, what will be its new level of accounts receivable?

c. Tabor's inventory turnover ratio is 9.5 times. What is the level of Tabor's inventories?

Homework Answers

Answer #1

Gross profit margin = 30.7%

Gross profit / Sales = 30.7%

Gross profit = Sales * 30.7%

= $9,400,000 * 30.7%

= $2,885,800

Cost of goods sold = Sales - Gross profit

= $9,400,000 - $2,885,800

= $6,514,200

Credit sales = Sales * 75%

= $9,400,000 * 75%

= $7,050,000

a.

Accounts receivable turnover = Credit sales / Accounts receivable

= $7,050,000 / $562,500

= 12.53

Average collection period = 365 / Accounts receivable turnover

= 365 / 12.53

= 29 days

b.

Average collection period = 365 / Accounts receivable turnover

24 = 365 / Accounts receivable turnover

Accounts receivable turnover = 365 / 24

= 15.21

Accounts receivable turnover = Credit sales / Accounts receivable

15.21 = $7,050,000 /  Accounts receivable

Accounts receivable = $7,050,000 / 15.21

= $463,511

c.

Inventory turnover ratio = Cost of goods sold / Inventory

9.5 = $6,514,200 / Inventory

Inventory = $685,705

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
​(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?...
​(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...
?(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,...
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...
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...
​(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...
ALei Industries has credit sales of $143 million a year. ? ALei's management reviewed its credit...
ALei Industries has credit sales of $143 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 55 ?days, how much would it have to reduce its level of accounts receivable in order to achieve its goal of 45...
ALei Industries has credit sales of $ 153 million a year. ​ ALei's management reviewed its...
ALei Industries has credit sales of $ 153 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 55 ​days, how much would it have to reduce its level of accounts receivable in order to achieve its...