Question

In: Finance

1. Grannie’s Jelly Beans currently has an inventory turnover of 36.5, a payables turnover of 18.25,...

1. Grannie’s Jelly Beans currently has an inventory turnover of 36.5, a payables turnover of 18.25, and a receivables turnover of 24.33. How many days are in the cash cycle (to the nearest whole year and please show how you arrive at your answer)

2. A grocery store sells 43,000 cans of peas per year at an average price of $0.95 per can. The carrying cost per can is $0.05. The store orders 2,000 cans at a time and the fixed order cost of $4.80 per order. The peas are sold out before they are restocked. What is the economic order quantity that the store should order?

3. Clap Off manufacturing uses 1,150 switch assemblies per week, and then reorders another 1,150 for the next week. If the carrying cost per unit is $5.50 and the fixed order cost is $62.50:

a) What is the annual cost of restocking inventory each week?

b) What is the annual carrying cost of the average inventory of switches?

Is Clap Off using an efficient inventory management system, or can they lower the annual cost of inventory? If so, how? (in words – no calculation)

Solutions

Expert Solution

Part 1:

?Investory Turnover = 36.5

Days of inventory outstanding = 365/Inventory Turnover 36.5 = 10 days

Paybles Turnover = 18.25

Days of paybles outstanding = 365 / Paybles Turnover 18.25 = 20 days

Receivables turnover = 24.33

Days of receivables outstanding = 365 / Receivables turnover 24.33 = 15 days

Cash Cycle = Days of receivables outstanding 15 + Days of inventory outstanding 10 - Days of paybles outstanding 20

Cash Cycle = 5 days

Part 2:

Economic order quantity =

Economic order quantity =

Economic order quantity = 2032 units

Part 3:

a) Annual cost of restocking per week = Fixed cost of order $62.50 * Number of week 52

Annual cost of restocking per week = $3250

b) Annual carrying cost = Average inventory / week 1150 * Carrying cost per unit $5.50 * Number of weeks 52

Annual carrying cost = $328,900

c) Efficient inventory system should be based on the economic order quantity =

Economic Order Quantity = 825 units

Since the EOQ is different than current inventory management system hence the company is going to lower annual cost of inventory my shifting into EOQ.


Related Solutions

A company which produces jelly beans claims that the amount, in ounces, of jelly beans in...
A company which produces jelly beans claims that the amount, in ounces, of jelly beans in their bags is uniformly distributed on the interval 14 to 18 ounces. (a) On average, how many ounces of jelly beans are there in a bag? What is the standard deviation? (b) Assuming that the claim of the company is true, what is the probability that a randomly selected bag contains less than 16.25 ounces? c) A consumer watch group wants to investigate the...
Suppose that a jar contains 8 green jelly beans and 10 blue jelly beans. Answer the...
Suppose that a jar contains 8 green jelly beans and 10 blue jelly beans. Answer the following questions. Round your answers to four decimal places. (a) How many ways can you randomly pick out four beans from the jar? (b) What is the probability that you randomly pick out four beans and exactly two of them are green jelly beans? (c) What is the probability that you pick up a green jelly bean (without putting it back into the jar),...
1. ABC Corporation currently has an Inventory Turnover of 13.99, an Accounts Receivable Turnover of 24.52,...
1. ABC Corporation currently has an Inventory Turnover of 13.99, an Accounts Receivable Turnover of 24.52, and an Accounts Payable Turnover of 19. How many days are in the operating cycle? 2. Indicate the effect of the following on the cash cycle: Accounts Receivable Period (AR Period) goes up Note: AR Period is also called as the Average Collection Period Group of answer choices * No change * Increase * Decrease
You take a random sample of 12 bags (16 oz. each) of jelly beans. In your...
You take a random sample of 12 bags (16 oz. each) of jelly beans. In your study, the average number of jelly beans in a bag is 395 with a standard deviation of 35 beans. Because these bags are filled by a machine, these are known to be taken from a normal population. Find and interpret a 96% confidence interval for the true mean number of jelly beans per 16 oz bag.
Assume we have a small jar full of 140 perfectly shaped jelly beans. Fifty of the...
Assume we have a small jar full of 140 perfectly shaped jelly beans. Fifty of the jelly beans are red, 45 of the jelly beans are green, and 35 of the jelly beans are purple and 20 are black. If you randomly select one jelly bean, then … What is the probability the jelly bean is red? What is the probability the jelly bean is black? What is the probability the jelly bean is green? What is the probability the...
Average Inventory, Inventory Turnover Ratio, Inventory Turnover in Days Belt Company had net sales of $1,891,675,000...
Average Inventory, Inventory Turnover Ratio, Inventory Turnover in Days Belt Company had net sales of $1,891,675,000 and cost of goods sold of $1,713,635,000. Belt had the following balances: January 1 December 31 Inventories $301,500,000 $385,000,000 Required: Assume 365 days per year. 1. Calculate the average inventory. $ 2. Calculate the inventory turnover ratio. Round to two decimal places. times 3. Calculate the inventory turnover in days. Round to two decimal places. days
Determine Rowan's Inventory turnover
The following is a portion of the condensed income statement for Rowan, Inc., a manufacturer of plastic containers:ParticularsAmount$Amount$Net Sales 2,460,000Less : Cost of goods sold :  Inventory,January 16,30,000 Net purchases1,900,000 Inventory,December 316,90,0001,840,000Gross profit $6,20,000(1) Determine Rowan's Inventory turnover
Creditors would prefer a firm to have 1.       inventory turnover of 3.0 2.        Inventory turnover of 2.0 3.       Times-interest-earned...
Creditors would prefer a firm to have 1.       inventory turnover of 3.0 2.        Inventory turnover of 2.0 3.       Times-interest-earned of 3.0 4.       Times-interest earned of 5.0 a.       1 and 3 b.       1 and 4 c.        2 and 3 d.        2 and 4
Imagine that you really love jelly beans and stock pile them after Easter every year.  The best...
Imagine that you really love jelly beans and stock pile them after Easter every year.  The best variety is Brach’s Jelly Eggs which has seven varieties: Red, Pink, White, Black, Purple, Green, and Yellow.  In one bag, you find 32 Red, 27 Pink, 30 White, 12 Black, 25 Purple, 26 Green, and 27 Yellow. What is the probability that the first jelly bean you draw is pink? QUESTION 2 Imagine that you really love jelly beans and stock pile them after Easter...
A company has increasing accounts receivable, increasing inventory and decreasing accounts payables year over year on...
A company has increasing accounts receivable, increasing inventory and decreasing accounts payables year over year on the balance sheet.  Which of the following is correct about the impact operating cash flow? a. None of these b. Increase in inventory is a source of cash c. Increase in accounts receivable is a source of cash d. Decreasing accounts payable is a source of cash
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT