Question

In: Accounting

ABC discount store has the following product line in its product line; toys, apparels, kitchenware, food,...

ABC discount store has the following product line in its product line; toys, apparels, kitchenware, food, jewelry, furniture, health and fitness, consumer electronics, Giftware and Fashion Apparel.

The annual demand of toys segment is 48000 units. The average lead time is 4 weeks. The standard deviation of demand during the average lead time is 75 units / week. The cost of ordering is Rs. 400 per order. The cost of purchase of the product is Rs. 10 per unit. The cost of carrying per unit per year is 15% of the purchase price. The maximum delay in lead time is 2 weeks and the probability of this delay is 0.25. Assume a service level of 0.95.

The average price per toy is Rs. 13. The minimum usage per week is 600 units and the minimum lead time is 3 weeks. The average usage per week is 900 units.

(a) Find out EOQ, Reorder level, Total Cost of inventory at EOQ, gross margin at EOQ and average inventory per year for toy category.

(b) Calculate the GMROI (gross margin return on investment) for toys category.

Solutions

Expert Solution


Related Solutions

Toys is a large discount toy store in Valley Wood Mall. The store typically has slow...
Toys is a large discount toy store in Valley Wood Mall. The store typically has slow sales in the summer months that increase dramatically and rise to a peak at Christmas. During the summer and fall, the store must build up its inventory to have enough stock for the Christmas season. To purchase and build up its stock during the months when its revenues are low, the store borrows money. Following is the store’s projected revenue and liabilities schedule for...
A pet food company has a business objective of expanding its product line beyond its current...
A pet food company has a business objective of expanding its product line beyond its current kidney and shrimp-based cat foods. The company developed two new products, one based on chicken liver and the other based on salmon.  The company conducted an experiment to compare the two new products with its existing ones , as well as a generic beef-based product sold at a supermarket chain. For the experiment, a sample of 35 cats from the population at a local animal...
8. A pet food company has a business objective of expanding its product line beyond its...
8. A pet food company has a business objective of expanding its product line beyond its current kidney- and shrimp-based cat foots. The company developed two new products, one based on chicken liver and the other based on salmon. The company conducted an experiment to compare the two new products with its two existing ones, as well as a generic beef-based product sold in supermarket chains. For the experiment, a sample of 50 cats from the population at a local...
A pet food company has a business objective of expanding its product line beyond its current...
A pet food company has a business objective of expanding its product line beyond its current kidney and shrimp-based cat foods. The company developed two new products, one based on chicken liver and the other based on salmon. The company conducted an experiment to compare the two new products with its two existing ones, as well as a generic beef-based product sold at a supermarket chain. For the experiment, a sample of 50 cats from the population at a local...
A pet food company has a business objective of expanding its product line beyond its current...
A pet food company has a business objective of expanding its product line beyond its current kidney- and shrimp-based cat foots. The company developed two new products, one based on chicken liver and the other based on salmon. The company conducted an experiment to compare the two new products with its two existing ones, as well as a generic beef-based product sold in supermarket chains. For the experiment, a sample of 50 cats from the population at a local animal...
CVP – ABC Company The following information pertains to ABC Company and its product – Product...
CVP – ABC Company The following information pertains to ABC Company and its product – Product Z: Selling Price per unit. $45.00 Direct Material Cost per kg $2.00 Direct Labour Cost per unit $1.20 Variable Overhead cost per unit $0.80 Material required per unit. 2KGS Other variable expenses per unit. $0.60 Annual Fixed Costs: Advertising. $15,000 Fixed Manufacturing. $60,000 Other Fixed Expenses. $8,000 Required: What is the Breakeven Point in both units and sales dollars? For this you will need...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store is considering dropping the clothing line because the income statement shows that it is operating at a loss. Note the income statement for these product lines below: Hardware Clothing Sporting Goods Total Sales $10,000 $15,000 $25,000 $50,000 Less: Variable costs $6,000 $8,000 $12,000 $26,000 Contribution Margin $4,000 $7,000 $13,000 $24,000 Less: Fixed costs Direct $2,000 $6,500 $4,000 12,500 Allocated $1,000 $1,500 $2,500 $5,000 Total...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store is considering dropping the clothing line because the income statement shows that it is operating at a loss. Note the income statement for these product lines below: Hardware Clothing Sporting Goods Total Sales $10,000 $15,000 $25,000 $50,000 Less: Variable costs $6,000 $8,000 $12,000 $26,000 Contribution Margin $4,000 $7,000 $13,000 $24,000 Less: Fixed costs Direct $2,000 $6,500 $4,000 12,500 Allocated $1,000 $1,500 $2,500 $5,000 Total...
ABC Company is considering adding a new line to its product mix, and the capital budgeting...
ABC Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by Jameel, a recently graduated MBA. The production line would be set up in unused space in the main plant. The machinery’s invoice price would be approximately Rs 5,000,000, another Rs 250,000 in shipping charges would be required, and it would cost an additional Rs 750,000 to install the equipment. The machinery has an economic life of 4 years, and...
The Schmedley Discount Department Store has approximately 300 customers shopping in its store between 9 A.M....
The Schmedley Discount Department Store has approximately 300 customers shopping in its store between 9 A.M. and 5 P.M. on Saturdays. In deciding how many cash registers to keep open each Saturday, Schmedley’s manager considers two factors: customer waiting time (and the associated waiting cost) and the service costs of employing additional checkout clerks. Checkout clerks are paid an average of $8 per hour. When only one is on duty, the waiting time per customer is about 10 minutes (or...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT