Question 4 Multi-period Inventory Control (9 marks) A retailer operates 365 days of the year. It...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 4 Multi-period Inventory Control (9 marks) A retailer operates 365 days of the year. It has an annual demand of food products of 60,000 units with an equal daily demand across the year with the standard deviation of the daily demand of 60 units. The supplier of the products charges the retailer the base rate of the products' price for $200 per unit and the base rate for the ordering cost (including delivery) of $500 per order. The supplier has agreed that it will take four days to fulfil (deliver) the orders for the retailer. The products are kept at the retailer's storage area, and the annual holding cost per unit is 5% of the product's unit price. As part of building a long-term relationship, the supplier offers discounted prices for different order quantities. Any order quantity below 2,000 units, the products and the ordering cost will be priced at the base rate. For any order quantity between 2,000 and 4,999 units, the retailer will receive a 5% discount on the base rate of the products' price and a 10% discount on the base rate of the ordering cost. For any order quantity of 5,000 units or more, the 2 retailer will receive a 10% discount on the base rate of the product's price and a 20% discount of the base rate of the ordering cost. a. Calculate the minimum total inventory costs for each order quantity range, and determine the order quantity that produces the lowest total inventory cost (2 marks) b. Determine the order quantity that has the lowest total cost of the products for the whole year by comparing order quantities of the other ranges. Which order quantity would you recommend to the retailer? (2 marks) c. If the retailer currently sets the service level at 80%, what will be the amount of the safety stock and the re-order point of the products? (1 mark) d. If the retailer wants to increase the service level by 10%, suggest two possible options that it can take to achieve the goal without changing the demand. Show the calculations to support your suggestion as well as (any) factors that need to be considered in the suggestion. (4 marks) Question 4 Multi-period Inventory Control (9 marks) A retailer operates 365 days of the year. It has an annual demand of food products of 60,000 units with an equal daily demand across the year with the standard deviation of the daily demand of 60 units. The supplier of the products charges the retailer the base rate of the products' price for $200 per unit and the base rate for the ordering cost (including delivery) of $500 per order. The supplier has agreed that it will take four days to fulfil (deliver) the orders for the retailer. The products are kept at the retailer's storage area, and the annual holding cost per unit is 5% of the product's unit price. As part of building a long-term relationship, the supplier offers discounted prices for different order quantities. Any order quantity below 2,000 units, the products and the ordering cost will be priced at the base rate. For any order quantity between 2,000 and 4,999 units, the retailer will receive a 5% discount on the base rate of the products' price and a 10% discount on the base rate of the ordering cost. For any order quantity of 5,000 units or more, the 2 retailer will receive a 10% discount on the base rate of the product's price and a 20% discount of the base rate of the ordering cost. a. Calculate the minimum total inventory costs for each order quantity range, and determine the order quantity that produces the lowest total inventory cost (2 marks) b. Determine the order quantity that has the lowest total cost of the products for the whole year by comparing order quantities of the other ranges. Which order quantity would you recommend to the retailer? (2 marks) c. If the retailer currently sets the service level at 80%, what will be the amount of the safety stock and the re-order point of the products? (1 mark) d. If the retailer wants to increase the service level by 10%, suggest two possible options that it can take to achieve the goal without changing the demand. Show the calculations to support your suggestion as well as (any) factors that need to be considered in the suggestion. (4 marks)
Expert Answer:
Answer rating: 100% (QA)
a The minimum total inventory costs for each order quantity range Order Quantity Range 01999 Total Inventory Cost Product Price x 200 Order Cost x 500 ... View the full answer
Related Book For
Advanced Accounting
ISBN: 978-1259444951
13th edition
Authors: Joe Ben Hoyle, Thomas Schaefer, Timothy Doupni
Posted Date:
Students also viewed these accounting questions
-
Pharoah Company began operations on January 1, 2017. The following information is available for Pharoah Company on December 31, 2017. Accounts payable $9,700 Notes payable $16,400 Accounts receivable...
-
The preparation of financial statements in accordance with AASB standards is one of the most important government regulations imposed on many companies in Australia. According to Australian...
-
Rainmaker Company prepares its financial statements in accordance with IFRS. In 2020, Rainmaker recorded the following revaluation adjustments related to its buildings and land: The companys building...
-
In Exercises 13 through 24, compute the derivative of the given function and find the equation of the line that is tangent to its graph for the specified value x = c. f(x) = -2 X ; c = - 1
-
A major bank is concerned about the amount of debt being accrued by customers using its credit cards. The Board of Directors voted to institute an expensive monitoring system if the mean for all of...
-
If a comparable property is 19% superior to the subject property and the comparable sold for $207,693, what is the indicated value of the subject?
-
The chance that it will rain tomorrow is 25%. Classify the statement as an example of classical probability, empirical probability, or subjective probability. Explain your reasoning.
-
A severe winter ice storm has swept across North Carolina and Virginia followed by more than a foot of snow and frigid, single-digit temperatures. These weather conditions have resulted in numerous...
-
Find the arclength of the curve r(t) = (-2 sint, 5t, -2 cost), -2t2
-
Journalize all these transactions into a general ledger. Transactions May 1 Purchased merchandise from Keys Wholesale on account for $735.30, Invoice No 91 Dated May 1, terms 2/10, n30 May 2...
-
The formula contained in the yellow highlighted cell ( I 3 9 ) is = _ _ _ ( _ _ _ , I 9 , I 2 4 ) . This formula can be copied over to the entire live scenario section without any manual...
-
Ohio governor vetoes Ohio bill on Lake Erie water use In 2008, the eight U.S. states and two Canadian provinces adjoining the lakes negotiated the Great Lakes Compact to prevent the regions water...
-
In 2007, Americans downloaded 800 million singles at 99 each and 40 million albums at $10 each. They also bought 3 million singles on a disc at $4.75 each and 500 million albums on discs at $15. What...
-
In a week, Erin buys 1 six-pack of soda and sees 2 movies when a movie ticket is $10, soda is $5 a six-pack, and she has $25 to spend. If her budget increases and she has $50 to spend on soda and...
-
Novartis International AG, a global healthcare company based in Switzerland, is considering producing either a generic multivitamin or a specific blend of vitamins A, C, and D. Novartis expects both...
-
Geniaware is considering two capital structures. The key information is shown in the following table. Assume a 24% tax rate. a. Calculate the EBIT-EPS coordinates for each of the structures for EBIT...
-
Canary owns a zinc mine costing $480,000 on which he has claimed $120,000 in depletion in prior years. At the beginning of the current year, it was estimated that 600,000 tons of zinc remained in the...
-
Could the owner of a business prepare a statement of financial position on 9 December or 23 June or today?
-
A company believes that there might be substantial doubt that it can meet its financial obligations as they come due for one year from the issuance of its financial statements. What plans might...
-
On January 1, Tesco Company spent a total of $4,384,000 to acquire control over Blondel Company. This price was based on paying $424,000 for 20 percent of Blondels preferred stock and $3,960,000 for...
-
What are the differences in accounting for a forward contract used as a fair value hedge of (a) a foreign currency denominated asset or liability and (b) a foreign currency firm commitment?
-
An extremely intriguing feature of quantum entanglement is a property that has been called the "monogamy of entanglement": a particle can only be maximally entangled with precisely one other...
-
We had mentioned that from the partition function \(Z\), all possible thermodynamical quantities can be determined. In this problem, we will use the harmonic oscillator's partition function of Eq....
-
Let's consider the harmonic oscillator immersed in a heat bath of temperature \(T\). For any Hermitian operator \(\hat{A}\), we can define its thermal average denoted as...
Study smarter with the SolutionInn App