Question

In: Finance

1.1 REQUIRED Use the information provided below to calculate the cost to Umhlali Stores (as a...

1.1 REQUIRED Use the information provided below to calculate the cost to Umhlali Stores (as a percentage) of not accepting the discount. (Assume a 365-day year.) (5) INFORMATION Jehcon Manufacturers’ credit terms to Umhlali Stores are 60 days but the manufacturer is prepared to allow a 2.5% rebate if Umhlali Stores pays the account within 10 days.

1.2 Use the information given below to calculate the:

1.2.1 EOQ (4)

1.2.2 Reorder point (4) INFORMATION Gem Enterprises intends purchasing 7 200 units of product Nutri per month during 2021 at R30 per unit. The following additional information is available: Ordering cost Stock holding cost Lead time for delivery of an order Workdays for 2021 R30 per order 10% of the purchase price 10 days 250 days

1.3 REQUIRED Use the information provided below to calculate the cash conversion cycle. (Assume a 365-day year.) (7)

INFORMATION The following information was obtained from the records of Coastal Traders for 2019:

Credit sales for the year R1 380 000 Credit purchases for the year R990 000 Inventories on 31 December 2019 R27 000 Amount owing by debtors on 31 December 2019 R150 000 Amount owing to creditors on 31 December 2019 R42 000 Average age of inventories 15 days

Solutions

Expert Solution

a) 1.1)

Discount term = 2.5/10, net 60

Cost of not accepting discount= [Discount rate / (100 -Discount rate )] * (365 / Number of days beyond disc. Period)

Discount rate = 2.5%
Number of days beyond discount Period = 60 - 10 = 50days

Cost of not accepting discount= [ 2.5 / 100 -2.5 ] * [ 365 / 50 ]

= 0.02564 * 7.3

= 0.1871 or 18.71%

__________________________________________________________________________________

b) 1.2)

1.2.1 ) EOQ =

where,

D= Annual quantity demanded

S = Cost per order

H= Holding Cost

now,

given;

D= 7200

S= 30

H= 10% of purchase price i.e. 10% of 30 = 3

now,

EOQ =

= 379.47 or 379

1.2.2) Working days= 250 days
Lead time= 10 days

Re-order point ( without safety stock ) = Lead time * Average daily usage

Average daily usage= Annual Demand / No. of working days

Average Daily usage= 7200 / 250
= 28.8 units

Re-order point = 10 * 28.8
= 288

[Note: there is no additional information given for calculating safety stock. That's why calculated reorder point without safety stock]

_____________________________________________________________________________________

c) 1.3 )

Cash conversion cycle = Days Inventory Outstanding + Days Sales Outstanding – Days Payable Outstanding

Days Inventory Outstanding= (Average Inventory / COGS ) * days

= ( 27 000 / 990 000 ) * 365

= 9.95 days

Days Sales Outstanding = (Average Accounts Receivable / Credit Sales) * days

= ( 150 000 / 1380 000) * 365

= 39.67 days

Days Payable Outstanding = ( Average Accounts Payable / COGS ) * days

= ( 42 000 / 990 000 ) *365

= 15.48 days

Cash Conversion Cycle = 9.95 + 39.67 + 15.48

= 65.1 days

  


Related Solutions

REQUIRED Use the information provided below to answer each of the following questions independently: 1.1 Calculate...
REQUIRED Use the information provided below to answer each of the following questions independently: 1.1 Calculate the break-even value using the marginal income ratio. 1.2 The sales manager proposes a R2 per unit reduction in selling price with the expectation that this would increase sales by 2 000 units. Is this a good idea? Motivate your answer. 1.3 Determine the selling price per unit if a net profit of R486 000 is desired. INFORMATION The following forecasts for January 2021...
3.1 REQUIRED Use the information provided below to calculate the profit to Mersat Stores if: 3.1.1...
3.1 REQUIRED Use the information provided below to calculate the profit to Mersat Stores if: 3.1.1 All the sales are for cash. (1 mark) 3.1.2 Seventy percent (70%) of the sales are on credit and the balance is for cash. All accounts are paid in 30 days. 3.1.3 All the sales are on credit and the credit terms are 4/10 net 30 days. Suppose this discount applies to 75% of the credit sales. INFORMATION Mersat Stores expects to sell 10...
REQUIRED Use the information provided below to calculate the following: 5.1.1 Payback Period of Project A...
REQUIRED Use the information provided below to calculate the following: 5.1.1 Payback Period of Project A (answer expressed in years and months) 5.1.2 Net Present Value (NPV) of both projects (amounts rounded off to the nearest Rand). INFORMATION Slater Limited is looking at the possibility of investing in one of two new projects, Project A or Project B. Project A would cost R600 000, and its net cash flows are estimated to be R200 000 per year, except for the...
1.2 REQUIRED: Use the information provided below to calculate the following: 1.2.1 Idle time variance (3)...
1.2 REQUIRED: Use the information provided below to calculate the following: 1.2.1 Idle time variance (3) 1.2.2 Labour mix variance (7) 1.2.3 Labour yield variance (3) Indicate whether each variance is favourable or unfavourable. INFORMATION : Standard labour costs for Electro Manufacturers to manufacture 2 000 units: 400 hours at R70 per hour 200 hours at R35 per hour Actual labour costs incurred to produce 1 900 units: 290 hours at R R65 per hour 170 hours at R32 per...
1.2 REQUIRED: Use the information provided below to calculate the following: 1.2.1 Idle time variance (3)...
1.2 REQUIRED: Use the information provided below to calculate the following: 1.2.1 Idle time variance (3) 1.2.2 Labour mix variance (7) 1.2.3 Labour yield variance (3) Indicate whether each variance is favourable or unfavourable. INFORMATION: Standard labour costs for Electro Manufacturers to manufacture 2 000 units: 400 hours at R70 per hour 200 hours at R35 per hour Actual labour costs incurred to produce 1 900 units: 290 hours at R R65 per hour 170 hours at R32 per hour...
1.2 REQUIRED: Use the information provided below to calculate the following: 1.2.1 Idle time variance (3)...
1.2 REQUIRED: Use the information provided below to calculate the following: 1.2.1 Idle time variance (3) 1.2.2 Labour mix variance (7) 1.2.3 Labour yield variance (3) Indicate whether each variance is favourable or unfavourable. INFORMATION: Standard labour costs for Electro Manufacturers to manufacture 2 000 units: 400 hours at R70 per hour 200 hours at R35 per hour Actual labour costs incurred to produce 1 900 units: 290 hours at R R65 per hour 170 hours at R32 per hour...
3.1 REQUIRED Use the information provided below to prepare the Bank account in the ledger of...
3.1 REQUIRED Use the information provided below to prepare the Bank account in the ledger of Prince Stores showing all the entries that would have been made in the cash journals. Clearly show the contra account for each entry. Balance the account. The cash journals are not required. Use the following format: General ledger DR BANK CR 2020 Jan 31 2020 Jan 31 INFORMATION When comparing the bank statement with the cash journals of Prince Stores for January 2020 the...
Use the following information to answer the questions below that are required to ultimately calculate a...
Use the following information to answer the questions below that are required to ultimately calculate a company’s WACC: - Long-term bonds: 3,500 bonds outstanding with 7.20% p.a. coupons paid semi-annually, $1000 face value, 25 years to maturity, current market yield is 5.72% p.a. - Preference shares: pay a dividend of 8% p.a. forever on a $15 face value, 45,000 outstanding, currently selling for $14.20 per share. - Ordinary shares: 175,000 shares outstanding selling for $37 per share with beta of...
Use the following information to answer the questions below that are required to ultimately calculate a...
Use the following information to answer the questions below that are required to ultimately calculate a company’s WACC: - Long-term bonds: 3,500 bonds outstanding with 7.20% p.a. coupons paid semi-annually, $1000 face value, 25 years to maturity, current market yield is 5.72% p.a. - Preference shares: pay a dividend of 8% p.a. forever on a $15 face value, 45,000 outstanding, currently selling for $14.20 per share. - Ordinary shares: 175,000 shares outstanding selling for $37 per share with beta of...
REQUIRED Use the information provided below to prepare the following for March 2020: 2.1. Flexible budget...
REQUIRED Use the information provided below to prepare the following for March 2020: 2.1. Flexible budget for two different activity levels i.e. 18 000 and 25 000 units (9) 2.2. Performance report (11) 2.3. Comment on the following variances: 2.3.1. Sales (1) 2.3.2. Direct Material (2) 2.3.3. Fixed overheads (2) INFORMATION Widget Ltd manufactures a single product. It originally planned to produce and sell 12 000 units during the year but the actual activity level was 14 000 units. The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT