Calculate the safety stock quantities and the inventory cost

Assignment Help Cost Accounting
Reference no: EM131354820

Safety Stock and Reorder Point

Consider the following data.

Inventory Item

Average Demand (Annual)

Sigma (Std. Dev.) of Demand During Lead Time

Item Unit Cost

F-11001

15,000

100

$250.00

K-12002

100,000

300

$2.00

L-13003

250,000

200

$0.20

N-14004

300,000

400

$1.00

P-21001

50,000

60

$125.00

S-22002

80,000

75

$30.00

Note: All items are independent demand items.

Based on the above data:

• Calculate the safety stock quantities and the inventory cost associated with safety stock (based on the item unit cost) for the inventory items at four different service levels (50%, 80%, 90%, and 95%).

• Develop a table to present the inventory quantities and the safety stock costs at each service level.

• Assuming that demand occurs at a steady pace every month (in other words, there is no seasonality or cyclical change in the level of demand), calculate the reorder point for each item assuming a lead time of two months and a service level of 90%.

• Develop a table to present the reorder points for all products under these conditions (two month lead time and service level of 90%).

Attachment:- Template.xlsx

Reference no: EM131354820

Questions Cloud

Difference between the annual inflation rates : Suppose the spot and three-month forward rates for the yen are ¥79.30 and ¥78.72, respectively. What would you estimate is the difference between the annual inflation rates of the United States and Japan?
Identify one current struggling consumer product : Identify one current struggling consumer product.- Present a rebranding strategy for the product, including the new name,-Changes in packaging and The price point.
Contrast parametric and non-parametric statistical inference : "Non-parametric inference is proper statistical inference within the Fisher paradigm." Discuss.
What is the market to book value ratio : Goldman Sachs & Co. sold a 12.5% interest in its annual profits to Sumitomo Bank Ltd of Japan in return for a capital investment of $500 million. Sumitomo was one of the world’s largest commercial banks, with assets of 172 billion. Under the agreemen..
Calculate the safety stock quantities and the inventory cost : Calculate the safety stock quantities and the inventory cost associated with safety stock (based on the item unit cost) for the inventory items at four different service levels (50%, 80%, 90%, and 95%).
Revenue generation for piece of equipment : The plan, in essence, outlines the pathway between the two. Making it successful depends on how the market is defined, and whether or not the right questions are being asked. To determine the long-term cost of operation and potential revenue gener..
Compute the composite rating for each location : A location analysis for Cook Controls, a small manufacturer of parts for high-technology cable systems, has been narrowed down to four locations. Compute the composite (weighted average) rating for each location. Which site would you choose
What are the roles of behavior change and self-care : It stated that "an estimated 30-60% of patients are not compliant with their physicians-directed treatment or medication regimens. Because of the serious clinical and cost concerns this raises, behavior modification has become recognized as an int..
Momentum cyclicals cost of common equity capital : You know that the return of Momentum Cyclicals common shares is 1.6 times as sensitive to macroeconomic information as the return of the market. If the risk-free rate of return is 2.80 percent and market risk premium is 5.71 percent, what is Momentum..

Reviews

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd