Question

In: Finance

COMPLETE ALL PARTS AND ILL LEAVE YOU A THUMBS UP A retail company is reevaluating its...

COMPLETE ALL PARTS AND ILL LEAVE YOU A THUMBS UP

A retail company is reevaluating its inventory policy for meeting a constant annual demand of 5,200 units

for its top-selling product. The current inventory policy is to order 650 units each time. The company

purchases the product from a manufacturer at a wholesale price of $20 per unit. The company also pays $80 as the ordering cost for each order regardless of the order quantity. The company’s inventory capital is borrowed from a bank at a simple annual interest rate of 10%. In addition, the company must pay a tax of 6% of the annual inventory value and another 3% of the annual inventory value for insurance. The lead time is estimated to be 4 days and the business opens 365 days a year.

ANSWER A-D FOR A THUMBS UP!!

(a) List the given information under the current situation (hint: list both values and units):

A =

Q =

k =

c =

h =

L =

(b) Calculate the total annual holding cost under the current inventory policy:

((c) Calculate the optimal order quantity (Q*) and reorder point (R*):

((d) What will be the reduction in total annual relevant cost (TC) if the company adopts the

optimal inventory policy obtained in (c)?

Solutions

Expert Solution

(a) List the given information under the current situation (hint: list both values and units):

Annual demand, A = 5,200 units
Order quantity, Q = 650 units
Wholesale price per unit, k = $20
Ordering cost for each order, c = $80
Holding cost, h = 10% + 6% + 3% = 19%
Lead time, L = 4 days

(b) Calculate the total annual holding cost under the current inventory policy:

Current Total Holding cost = Ordering cost + Carrying cost
= (A*c)/Q + (Q*h)/2
= (5,200 * 80)/650 + (650*19%)/2
= 640 + 61.75 = $701.75

(c) Calculate the optimal order quantity (Q*) and reorder point (R*)

Q* = (2*A*c/h)^1/2 = (2 * 5,200 * 80 / h)^1/2 = 2093 units
R*
= L * A/365 = 4 * 5,200/365 = 57 units

(d) What will be the reduction in total annual relevant cost (TC) if the company adopts the optimal inventory policy obtained in (c)

When the ordering quantity is 2093 units instead of 650 units, the new cost is:

New total cost = Ordering cost + Carrying cost
= (A*c)/Q* + (Q**h)/2
= (5,200 * 80)/2093 + (2093*19%)/2
= 198.75 + 198.75 = $397.5

Reduction in cost = $701.75 - $397.5 = $304.25


Related Solutions

PLEASE ANSWER ALL PARTS FOR A THUMBS UP RATING, THANK YOU! 1) What are the main...
PLEASE ANSWER ALL PARTS FOR A THUMBS UP RATING, THANK YOU! 1) What are the main elements to take into consideration in preparing a financial forecast? 2) Once you develop an initial set of projected financial statements, what are some things to check to make sure the forecast makes sense? 3) In general, is it easier to plug a cash shortfall with debt or equity? Explain.
***JAVA PLEASE*** All correct and complete responses will receive a thumbs up and positive comment! Thank...
***JAVA PLEASE*** All correct and complete responses will receive a thumbs up and positive comment! Thank you!! Create a simple class that emulates some mathematical functions in relation to complex numbers. A complex number is a number of the form a + bi, where a is a real number and bi is an imaginary number. Create a class Complex having two private data members real and imag of type double. The class has two constructors, one default (no parameters) and...
Ill thumbs up!! please step by step Problem III      Pence Corporation purchased an automobile on...
Ill thumbs up!! please step by step Problem III      Pence Corporation purchased an automobile on January 1, 2018 for $25,000. On January 1, 2020, the Accumulated Depreciation account for the automobile showed a credit of $10,000. Pence sold the automobile that very day for $12,000.      Required:       Make the journal entry for Pence Corporation for the 1/1/20 sale. Problem IV:       On January 1, 2020 Barr and Sessions decided to form a partnership called BS Associates. Barr contributed...
please leave alot of quality information and i will provide a thumbs up in return thank...
please leave alot of quality information and i will provide a thumbs up in return thank you 1. Joan is an Accountant who opposes the introduction of a new financial control system. For 15 years she has worked with a manual system. Now the firm is introducing a new computer-based system. How would you, as her manager, attempt to change Joan's attitude towards the new system? 2. Some people believe that perception is a more important explanation of behavior than...
Please show all work and calculations for a thumbs up! Suppose a company has a forklift...
Please show all work and calculations for a thumbs up! Suppose a company has a forklift but is considering purchasing a new electric lift truck that would cost $230000 and has operating cost of $25000 in the first year. For the remaining years, operating costs increase each year by 5% over the previous year’s operating costs. It loses 15% of its value every year from the previous year’s salvage value. The lift truck has a maximum life of 4 years....
FORECASTING , THE COMPLETE ANSWERS TO THESE QUESTIONS WILL RECEIVE A THUMBS UP! Weekly demand figures...
FORECASTING , THE COMPLETE ANSWERS TO THESE QUESTIONS WILL RECEIVE A THUMBS UP! Weekly demand figures at Hot Pizza are as follows: Week Demand 1 108 2 116 3 118 4 124 5 96 6 119 7 96 8 102 9 112 10 102 11 92 12 91 Estimate demand for the next 4 weeks using a 4-week moving average as well as simple exponential smoothing with α = 0.1. Evaluate the MAD, MAPE, MSE, bias, and TS in each...
PLEASE TYPE all work, and I'll give you a thumbs up! Mean of stock price =...
PLEASE TYPE all work, and I'll give you a thumbs up! Mean of stock price = 1117.64 STDEV (Population) = 67.61 If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $50 of the mean for that year (round to two places)? (Hint: this means the probability of being between 50 below and 50 above the mean). If a person bought 1 share of Google...
PLEASE ANSWER QUESTIONS WITH ALL CALCULATIONS! WILL GIVE THUMBS UP ! THANK YOU ! 6. Use...
PLEASE ANSWER QUESTIONS WITH ALL CALCULATIONS! WILL GIVE THUMBS UP ! THANK YOU ! 6. Use the information below and the Two-stage Growth Model to find Axis Capital’s intrinsic value.  Forecast its cash flows from t+1 to t+3.  If its current price is $37.54, is it over or under valued? t t+1 t+2 t+3 t+4 Beta 0.80 ROE 0.09 0.08 0.08 0.08 DPO 0.37 0.34 0.34 0.34 Div $1.64
Chapter 8: Electron Configurations and Periodicity Complete for a thumbs up! a. Write the electronic configuration...
Chapter 8: Electron Configurations and Periodicity Complete for a thumbs up! a. Write the electronic configuration and draw the orbital diagram of iron. b. Create a table summarizing the group traits of elements. c. Explain why Hund's rule is incredibly important. Use examples or images to help back up your explanation d. In the science field, chemists often use NMR for confirmation of the structure of newly synthesized drugs. This is what MRIs do to humans at hospitals. Please explain...
Scroll down to complete all parts of this task . The Allen Company is a wholesale...
Scroll down to complete all parts of this task . The Allen Company is a wholesale distributor of automotive replacement parts. Initial amounts taken from Allen's accounting records are as follows: Inventory at December 31, Year 5 (based on physical count of goods in Allen's warehouse on December 21, Year 5) $1,250,000 Sales in Year 5 $9,000,000 Accounts payable at December 31, Year 5: Vendor Terms Amount Baker Company 2/10, Net 30 $265,000 Charlie Company Net 30 210,000 Dolly Company...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT