Q4. Please refer the below table:
Particulars | Source | Step Reference | Credit Policy | |||
Current | A | B | C | |||
Current Sales (Rs.) | Given in the question | (I) | 300,000,000 | 300,000,000 | 300,000,000 | 300,000,000 |
Additional Sales (Rs.) | Given in the question | (II) | - | 1,200,000 | 2,700,000 | 4,700,000 |
Expected Sales (Rs.) | Computed as given in 'Step Reference' | (III) = (I)+(II) | 300,000,000 | 301,200,000 | 302,700,000 | 304,700,000 |
Selling price per unit (Rs.) | Given in the question | (IV) | 10 | 10 | 10 | 10 |
Quantity Sold | Computed as given in 'Step Reference' | (V) = (III) / (IV) | 30,000,000 | 30,120,000 | 30,270,000 | 30,470,000 |
Variable cost per unit (Rs.) | Given in the question | (VI) | 6 | 6 | 6 | 6 |
Variable cost (Rs.) | Computed as given in 'Step Reference' | (VII) = (V) * (VI) | 180,000,000 | 180,720,000 | 181,620,000 | 182,820,000 |
Contribution (Rs.) | Computed as given in 'Step Reference' | (VIII) = (III) - (VII) | 120,000,000 | 120,480,000 | 121,080,000 | 121,880,000 |
Fixed Cost (Rs.) | Given in the question | (IX) - refer working # 1 | 60,000,000 | 60,000,000 | 60,000,000 | 60,000,000 |
Profit (Rs.) | Computed as given in 'Step Reference' | (X) = (VIII) - (IX) | 60,000,000 | 60,480,000 | 61,080,000 | 61,880,000 |
Current Credit period (days) | Given in the question | (XI) | 25 | 25 | 25 | 25 |
Incremental Credit period (days) | Given in the question | (XII) | - | 15 | 25 | 35 |
Revised Credit period (days) | Computed as given in 'Step Reference' | (XIII) = (XI) + (XII) | 25 | 40 | 50 | 60 |
Required rate of return | Given in the question | (XIV) | 12% | 12% | 12% | 12% |
Less: Notional interest cost (Rs.) | Computed as given in 'Step Reference' | (XV) = (III)*(XIII)/365*(XIV) | 2,465,753 | 3,960,986 | 4,975,890 | 6,010,521 |
Revised Profit (Rs.) | Computed as given in 'Step Reference' | (XVI) = (X) - (XV) | 57,534,247 | 56,519,014 | 56,104,110 | 55,869,479 |
Incremental Profit / (Loss) over current profit | (XVII) | - | (1,015,233) | (1,430,137) | (1,664,767) |
Workings:
# 1 Fixed Cost
Average total Cost per unit = Rs.8
Variable Cost per unit = Rs.6
Fixed Cost per unit = Rs.8 - Rs.6 = Rs.2
Quantity sold currenty = 3 Crores
Total Fixed Cost = Rs. 3 crores * Rs.2 per unit = Rs.6 Crores (this remains same irrespective of change in volume)
Recommendation:
As can be seen in table (Step Reference - (XVII)any change from the current credit policy results in incremental loss to the company. Hence, ideally, no change is to be made. However, since the credit policy change is proposed to boost the sales, option A is to be chosen as under this option, the incremental loss is the lowest.
Please solve question 4 11:21 in O LT. 81% Read Only - You can't save changes...
11:39 O. Read Only - You can't save changes to this fi... 3. Why MSME require innovative approach of marketing their products? SECTION.B Case Study (50 Marks) Balance of Payment (DOP) is a statement which records all the monetary transactions made between residents of a country and the rest of the world during any given period. This statement includes all the transactions made by to Individuals, corporates and the government and helps in monitoring the flow of funds to develop...
Initiating a cash discount Gardner Company currently makes all sales on credit and offers no cash discount. The firm is considering offering a 4% cash discount for payment within 15 days. The firm's current average collection period is 60 days, sales are 40,000 units, selling price is $48 per unit, and variable cost per unit is $30. The firm expects that the change in credit terms will result in an increase in sales to 41,000 units, that 70% of the...
7-3 Corner Creations by Dana, Inc. has sales of $12.5 million a year and credit sales account for 80 percent of this amount (or $10.0 million). The vice president of mar- keting believes that sales could be increased very sharply if the company relaxes its credit policy. The company's average collection period is currently 36 days, its selling price per unit is $1,000, and its variable cost per unit is $800. The adoption of a new credit policy under consideration...
The following companies are trying to decide whether to change their accounts receivables collection ?? ach company Three Rivers Industries Twin Peaks Ltd. Single Signals Inc. Current receivables policy Unit sale price Contribution margin per unit Units sold per year on credit Average collection period in days Bad debts per year nterest rate on line of credit ts cash flow e controller $125 $ 50 120,000 72 $175,000 11% $250 75,000 $149,000 $550 $140 25,000 100 $160,000 9% 7% Proposed...
Essence of Skunk Fragrances, Ltd., sells 6,700 units of its perfume collection each year at a price per unit of $215. All sales are on credit with terms of 1/10, net 30. The discount is taken by 60 percent of the customers a. What is the amount of the company's accounts receivable? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. In reaction to sales by its main competitor, Sewage Spray, Essence of...
both are the same i checked and rechecked the question.
Intro Morgan Valley Inc. has current sales of $460,000. All of its sales are on credit and there is no default. It currently sells on terms of net 30 and has an accounts receivable balance of $60,000 The company is considering a new credit policy with terms of net 60. Under the new policy, sales are expected to increase to $520,000, and accounts receivable are expected to increase to $120,000...
can you please help me solve this question. this is
the third time I am posting the question .the question is asking
for the net income statement. please stop providing me with wrong
answers. you can use excel to solve for it
this is the full question. thank you
tightening the credit terms to 30 days would reduce annual sales to $1,735,000, but accounts receivable would drop to 35 days of sales and the savings on investment in them should...
11. You have the following balance sheet and income statement information for Epic Corp.: Balance sheet $ Accounts receivable (A/R) 1,800 Inventory 3,600 Accounts payable (A/P) 760 Income statement $ Sales 7,200 Cost of goods sold (COGS) 5,760 All sales and purchases were on credit. a. How long is the days inventory outstanding (in days)? b. How long is the collection period (in days)? c. How long is the payables period (in days)? d. How long is the cash conversion...
solve part 1 and 2 of question no. 2 and show the
calculations
Note: To receive the full credit, you must show all your work (formula or inputs for a financial will not award full credit for a correct answer if you do not show your for an incorrect answer if I cannot follow your work b) What is the cost of the lockbox system in todary's saive (5 paint) work and I cannot award partial credit . (10 paint)...