Question

In: Accounting

1. Consider a retail store importing unlocked smart phones from overseas. The monthly demand for phones...

1. Consider a retail store importing unlocked smart phones from overseas. The monthly demand for phones is 100. The store carries half the lead time demand as safety inventory. Each phone costs $450 and the annual holding cost is estimated at 20% of phone value. Assume that the retail store owns the pipeline inventory and that there are 30 days per month. The manufacturer of the phones offers two different shipment options:

i. Ocean freight: Each container carries 500 phones and the cost is $2000 per container. The delivery lead time for this option is 30 days.

ii. Air freight: The total annual cost (inventory + transportation) of this option is $20,000.

a. If cost is the only criterion for the store, which transportation option should they choose?

b. Is your answer to part (a) likely to change if the product in question were a toy that cost $10 per unit? Please answer this question qualitatively without solving the problem again.

Solutions

Expert Solution

Question a

The question essentially is economic order quantity.

Monthly Demand = 100 units

Annual Demand = 1200 units

Ordering Cost = $2000 per order

Holding Cost = 20% * 450 = $90

EOQ = squareroot(2 * Demand * order cost/Annual holding cost)

Under Ocean Freight

The economic order quantity = squareroot(2*1200*2000/90)= 231 units

This would mean 1200/231 = 5.2 or 6 orders would need to be placed during the year. Hence the total ordering cost would amount to $2000*6 = $12,000

The holding costs would is the (lead time inventory + safety stock) X holding cost per unit

= (231/2 + 50) X 90 = $14,892.30

Total Cost = 26,892.30

If the company chooses Air Freight the total cost would be only $20,000. Hence it is advisable to use Air freight.

Question b

Yes. If the cost per unit of the product decrease the carrying cost per unit will fall as well. This would increase the economic order quantity and in turn reduce the number of orders. As a result the total ordering cost will decrease. The Total Carrying cost will also decrease. Hence the answer is likely to change to Ocean freight in case the value of the product is $10.


Related Solutions

1. From the data shown in the table below about demand for smart phones, calculate the...
1. From the data shown in the table below about demand for smart phones, calculate the price elasticity of demand (using the arc method) from: 1.1. Point B to point C 1.2. Point D to point E 1.3. Point G to point H Classify the elasticity at each point as elastic, inelastic or unit elastic. Points P Q A 60 3,000 B 70 2,800 C 80 2,600 D 90 2,400 E 100 2,200 F 110 2,000 G 120 1,800 H...
QUESTION ABC Group manufactures smart phones that can be sold directly to retail outlets or to...
QUESTION ABC Group manufactures smart phones that can be sold directly to retail outlets or to the Mother Company for further processing and eventual sale by them as a completely different model. The demand function for each of these markets is: Retail Outlets: P1 = 60 - 2Q1 Mother Company: P2 = 40 - Q2 where P1 and P2 are the prices charged and Q1 and Q2 are the quantities sold in the respective markets. ABC’s total cost function for...
Samsung is interested in the elasticity of demand in the smart phones market, so it hired...
Samsung is interested in the elasticity of demand in the smart phones market, so it hired an economist to estimate the demand for smart phones. She found that, in the short run, demand is Qd=100-0.5P, and in the long run, demand is Qd=120-0.6P. In both the long run and the short run, P=$50 a. What is the price elasticity of demand in the short run? b. What is the price elasticity of demand in the long run? c. Given your...
In ABC City, the average demand of SMART PHONES is 600 units. The May monthly index is 1.5. what is the seasonally adjusted sales forecast for May?
In ABC City, the average demand of SMART PHONES is 600 units. The May monthly index is 1.5. what is the seasonally adjusted sales forecast for May?A.1200 unitsB.400 unitsC.900 unitsD.No sufficient data to calculate
Consider Retail Store database which store the details of different items available in the store and...
Consider Retail Store database which store the details of different items available in the store and the sales of these items to different customers: Schema: Item(ItemNo, ItemName, Category, UnitPrice) Sales(SalesNo, ITemNo, SalesDate, CustomerNo, Qty) Customer(CustomerNo, CustomerName, City, Income, MobileNo) Write the following queries in Relational Algebra: a) List the No. and Name of items in ‘ABC’ category. b) Count the No. of categories from which the items were bought by the customer ‘Mohan Kumar’ c) List the customers who has...
1. An operations manager at a factory that produces rechargeable batteries for smart phones wants to...
1. An operations manager at a factory that produces rechargeable batteries for smart phones wants to determine if the new brand of battery that they are producing is superior to their original design. Sample Average Life Standard Dev. Old 25 6.5 hours 1.25 hours New 35 7.2 hours 0.75 hours Using a 0.01 level of significance and assuming equal variances, identify the alternative hypothesis to these the claim that the new brand of batteries is superior to the original design....
1. An operations manager at a factory that produces rechargeable batteries for smart phones wants to...
1. An operations manager at a factory that produces rechargeable batteries for smart phones wants to determine if the new brand of battery that they are producing is superior to their original design. Sample Average Life Standard Dev. Old 25 6.5 hours 1.25 hours New 35 7.2 hours 0.75 hours Using a 0.01 level of significance and assuming equal variances, identify the alternative hypothesis to these the claim that the new brand of batteries is superior to the original design....
A new retail store is analyzing their monthly revenues per shopper to quantify the effect of...
A new retail store is analyzing their monthly revenues per shopper to quantify the effect of the age of the shopper and the number of (monthly) shoppers on their monthly revenue. The owner feels that the revenue received per shopper increases with the age of the shopper and with the number of shoppers but wants a more quantitative explanation. The multiple regression output is shown below. answer with the help of excel Summary output Multiple R 0.8391 R-Square 0.7841 Adj...
Consider monthly demand for the ABC Corporation as shown below. Forecast the monthly demand for Year...
Consider monthly demand for the ABC Corporation as shown below. Forecast the monthly demand for Year 6 using the 3-period moving average and 4-period moving average. Evaluate the bias, TS, MAD, MAPE and MSE. Evaluate the quality of the forecast Sales Year 1 Year 2 Year 3 Year 4 Year 5 JAN 2000 3000 2000 5000 5000 FEB 3000 4000 5000 4000 2000 MAR 3000 3000 5000 4000 3000 APR 3000 5000 3000 2000 2000 MAY 4000 5000 4000 5000...
A Company produces and sells two types of smart phones. The price of Type-1 and Type...
A Company produces and sells two types of smart phones. The price of Type-1 and Type –II smart phone assigned by Hamza is Rs. 120,000 per unit and 135,000 respectively. Variable cost for producing type-I phone is Rs. 150,000 and type –II is Rs. 300,000. Suppose there is Rs. 500,000 fixed cost.1. Formulate revenue and cost function for type-I and type-II smart phone jointly.2. Formulate total profit function3. What will be the total profit if Hamza produces and sells 500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT