Question

In: Finance

Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe...

Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe Logan, the president of the company, is thinking about changing the firm's credit policy to attract customers away from competitors. The present policy calls for a 1/10, net 30 cash discount. The new policy would call for a 3/10, net 50 cash discount. Currently, 30 percent of Logan customers are taking the discount, and it is anticipated that this number would go up to 50 percent with the new discount policy. It is further anticipated that annual sales would increase from a level of $397,000 to $615,500 as a result of the change in the cash discount policy.

The increased sales would also affect the inventory level. The average inventory carried by Logan is based on a determination of an EOQ. Assume sales of fans and heaters increase from 14,775 to 22,300 units. The ordering cost for each order is $195, and the carrying cost per unit is $1.45 (these values will not change with the discount). The average inventory is based on EOQ/2. Each unit in inventory has an average cost of $12.

Cost of goods sold is equal to 65 percent of net sales; general and administrative expenses are 15 percent of net sales; and interest payments of 14 percent will only be necessary for the increase in the accounts receivable and inventory balances. Taxes will be 40 percent of before-tax income.

For average collection period, assume the customer pays on the last day possible (if they are getting the discount, that is day 10; if not, that is day 30 with the original policy and day 50 with the proposed policy).


Part A

Compute the accounts receivable balance before and after the change in the cash discount policy. Use the net sales (total sales minus cash discounts) to determine the average daily sales. Round your answer to the nearest whole dollar.

What is the accounts receivable balance before the change?
What is the accounts receivable balance after the change?    

Part B

Determine the EOQ before and after the change in the cash discount policy. Translate this into average inventory (in units and dollars) before and after the change in the cash discount policy. Round your answer to the nearest whole unit.

What was the EOQ prior to the change?
What is the EOQ after the change?        
What was the average inventory prior to the change?
What is the average inventory after the change?        

Part C

Determine the income after taxes before and after the new plan. Round your answer to the nearest whole dollar.

This income statement cannot be filled in online; it is provided as a possible approach to solving this problem.

Before Policy Change After Policy Change
Net sales (Sales - Cash discount)
Cost of goods sold (65%)
Gross Profit
Genreal and admin. expense (15%)
Operating profit
* Interest on increase in accounts receivable and inventory (14%)
Income before taxes
Taxes (40%)
Income after taxes
What was the income after taxes prior to the change?
What was the income after taxes after to the change?      
Part D

True or false: the firm should use the new cash discount policy.

Solutions

Expert Solution

Part A
Accounts receivables=Av. Collection period*Av. Daily sales
Before Policy Change
Av. Collection period:
30%*10 days 3
70%*30 days 21
Total 24 days
Av. Daily sales= (Total sales-Cash discounts)/360
(397000-(397000*30%*1%))/360=
1099.47
So,
Accounts receivables=1099.47*24=
26387.28
After Policy Change
Av. Collection period:
50%*10 days 5
50%*50 days 25
Total 30 days
Av. Daily sales= (Total sales-Cash discounts)/360
(615500-(615500*50%*3%))/360=
1684.08
So,
Accounts receivables=1684.08*30=
50522.4
Part B... EOQ=((2*Demand*Ordering Cost/unit)/Carrying cost/unit)^(1/2)
Av. Inventory= EOQ/2.
Before policy change After policy change
EOQ= ((2*14775*195)/1.45)^(1/2)= ((2*22300*195)/1.45)^(1/2)=
(in Units) 1993.48 2449.07 Answer
Av. Inventory= EOQ/2. 1993.48/2= 2449.07/2
(in Units) 996.74 1224.54 Answer
Av. Cost(given) $ 12 12
Cost of av. Inventory$ 11960.88 14694.42 Answer
Part-C Before Policy Change After Policy Change Increase
Net sales (Sales - Cash discount)--------## 395809 606267.50 210458.50
Cost of goods sold (65%) 257275.85 394073.88 136798.03
Gross Profit 138533.15 212193.625 73660.48
Genreal and admin. expense (15%) 59371.35 90940.125 31568.78
Operating profit 79161.8 121253.5 42091.70
**Interest on increase in accounts receivable and inventory (14%) 3761.61 3761.61
Income before taxes 79161.80 117491.89 38330.09
Taxes (40%) 31664.72 46996.76 15332.04
Income after taxes 47497.08 70495.13 22998.05
## Net sales (Sales - Cash discount) (397000-(397000*30%*1%))= (615500-(615500*50%*3%))=
395809 606267.5
Increase
**A/R 26387.28 50522.4 24135.12
Inv. 11960.88 14694.42 2733.54
Total 38348.16 65216.82 26868.66
3761.61
Part D
True : the firm should use the new cash discount policy.
Reason being:
The after-tax Income is increasing by nearly 23000 compared to the interest costs on funds held-up in receivables & inventory , 3762.----justifies the cash discount policy

Related Solutions

Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe...
Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe Logan, the president of the company, is thinking about changing the firm's credit policy to attract customers away from competitors. The present policy calls for a 1/10, net 30 cash discount. The new policy would call for a 3/10, net 50 cash discount. Currently, 30 percent of Logan customers are taking the discount, and it is anticipated that this number would go up to...
Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe...
Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe Logan, the president of the company, is thinking about changing the firm's credit policy to attract customers away from competitors. The present policy calls for a 1/10, net 30 cash discount. The new policy would call for a 3/10, net 50 cash discount. Currently, 30 percent of Logan customers are taking the discount, and it is anticipated that this number would go up to...
Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe...
Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe Logan, the president of the company, is thinking about changing the firm's credit policy to attract customers away from competitors. The present policy calls for a 1/10, net 30 cash discount. The new policy would call for a 3/10, net 50 cash discount. Currently, 30 percent of Logan customers are taking the discount, and it is anticipated that this number would go up to...
Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe...
Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe Logan, the president of the company, is thinking about changing the firm's credit policy to attract customers away from competitors. The present policy calls for a 1/10, net 30 cash discount. The new policy would call for a 3/10, net 50 cash discount. Currently, 30 percent of Logan customers are taking the discount, and it is anticipated that this number would go up to...
HOT AIR Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe...
HOT AIR Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe Smith, the president of the company, is thinking about changing the firm’s credit policy to attract customers away from competitors. The present policy calls for a 1/10, net 30 cash discount. The new policy would call for a 3/10, net 50 cash discount. Currently, 30 percent of Hot Air customers are taking the discount, and it is anticipated that this number would go up...
Omega Distributing Company Omega Distributing Company specializes in supplying fragrances to retail outlets such as Goody’s...
Omega Distributing Company Omega Distributing Company specializes in supplying fragrances to retail outlets such as Goody’s and JCPenney. One of its products is Smelgud. Smelgud has generated significant revenue in the past, however top management is concerned as to whether its pricing and advertising policies are optimal for the demand. Partnering with some of its retail outlets Omega has undertaken to conduct a statistical study of consumer demand for Smelgud. Omega’s analyst believe that the principal determinant of consumer demand...
Purpose Ltd manufactures and sells plastic storage containers through associated retail outlets throughout Australia. To compete...
Purpose Ltd manufactures and sells plastic storage containers through associated retail outlets throughout Australia. To compete more effectively it has recently introduced a budgetary control system to assist with planning and control of operations. Detailed below is the original static budget set at the start of the month, actual performance figures and the flexed budget for their most popular storage container sold for the month of December 2018, BUDGET (static)                      ACTUAL                     FLEXED Output (production and sales)    3000 Units                               4,500 Units                 ...
Purpose Ltd manufactures and sells plastic storage containers through associated retail outlets throughout Australia. To compete...
Purpose Ltd manufactures and sells plastic storage containers through associated retail outlets throughout Australia. To compete more effectively it has recently introduced a budgetary control system to assist with planning and control of operations. Detailed below is the original static budget set at the start of the month, actual performance figures and the flexed budget for their most popular storage container sold for the month of December 2018, BUDGET (static) ACTUAL FLEXED Output (production and sales) 3000 Units 4,500 Units...
Zear Company produces an electronic processor and sells it wholesale to manufacturing and retail outlets at...
Zear Company produces an electronic processor and sells it wholesale to manufacturing and retail outlets at $10 each. In Zear"s Year 8 fiscal period, it sold 700,000 processors. Fixed costs for Year 8 total $1,500,000, including interest costs on its 7.5% debentures. Variable costs are $4 per processor for materials. Zear employs about 20 hourly paid plant employees, each earning $35,000 in Year 8. Zear is currently confronting labor negotiations. The plant employees are requesting substantial increases in hourly wages....
QUESTION THREE Cartlidge Ltd manufactures and sells plastic kitchen containers through associated retail outlets throughout Australia....
QUESTION THREE Cartlidge Ltd manufactures and sells plastic kitchen containers through associated retail outlets throughout Australia. To compete more effectively it has recently introduced a budgetary control system to assist with planning and control of operations. Detailed below are the budgeted and actual performance figures for their most popular plastic container sold for the month of December 2018,                                                 BUDGET (static)                     ACTUAL Output (production and sales)    3000 Units                                3,300 Units                                                 $                                              $                      Sales                                        $45,000                                    $47,850                                                 (3,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT