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

  Create t accounts for all accounts

Create T accounts for all accounts used in part (a). Enter the trial balance amounts into the T accounts and post the adjusting entries.

  What is the computer cost allocated to division b

Cincinnati Million, Inc. operates two user divisions as separate cost objects. To determine the costs of each division, the company allocates common costs to the divisions. During the past month, the following common costs were incurred: If common co..

  Would you classify a realty business like ruby river

Would you classify a realty business like Ruby River as a manufacturing, merchandising, or service business and analyzing the interrelationships among the four financial statements, determine the proper amounts for (a) through (o).

  Compute the economic value added by each division

Game, LLP, is evaluating the performance of three divisions: Rock, Scissors, and Paper. Using the data that follow, compute the economic value added by each division, and comment on each division's performance.

  Calculate the sales price per unit for both given products

Calculate the sales price per unit for both products using a 35% markup on cost based on the total unit product cost from #1 above.

  Prepare the journal entry necessary

Prepare the journal entry necessary on December 31, 2014 if the company estimates that bad debt expense should be 2% of net credit sales.

  Explain why a difference occurs in the unit costs

Distribute the service department costs, using the direct method - Distribute the service department costs, using the sequential distribution method, with the department servicing the greatest number of other departments distributed first.

  Prepare an income statement in comparative form

Prepare an income statement in comparative form, stating each item for both years as a percent of sales (vertical common-size analysis) and comment on the findings in (a).

  Prepare monthly cash budgets for each of first three months

According to a credit agreement with the company's bank, Kasik promises to have a minimum cash balance of $30,000 at each month-end. In return, the bank has agreed that the company can borrow up to $150,000 at an annual interest rate of 12%, paid ..

  What is the main argument against abc costing

why do you think that the AICPA and US GAAP do not permit ABC costing with Financial reporting for outside investors in 10K reports. What is the main argument against ABC costing? With reference (scholarly article).

  Calculate the fair value of the controlling interest

Calculate the fair value of the controlling interest and the noncontrolling interest in Magnolia as of January 1, 2009 and prepare a schedule for allocating the excess of investment cost (fair value) over the book value.

  Npc might fail as a corporate entity

Identify and evaluate the problems or indicators which could indicate that NPC might fail as a corporate entity - tough economic conditions in NPC's country have led to a decline in advertising revenues since 20X7

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