Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show excel steps to help me better understand You must decide on how much safety stock to carry. Past records indicate that the standard

Please show excel steps to help me better understand

You must decide on how much safety stock to carry. Past records indicate that the standard deviation of demand is 33 units per week. The item you are investigating is sourced overseas and arrives via barge, which on average takes half a year. If you desire to have a 95% service level, how much safety stock would you recommend? Round the safety stock to the nearest unit (0 dp*)

If a company has a safety stock of 543 units for a product that has a standard deviation of demand of 222.7 units per day and a lead time of one week, what is their average service level in decimal percentage rounded to 4 decimal places?

What is the recommended safety stock for a firm that desires a 98% service level when the average lead time is one month and yearly demand over the last 10 years is as follows?

31 260 278 181 222 118 166 81 281 288

Round the safety stock to the nearest unit (0 dp)

If the current safety stock level is found to be 27 units, what service level is the firm

currently working at? (decimal format of the percentage rounded to 4 dp)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Assurance And Risk

Authors: W Robert Knechel, Steven E Salterio

4th Edition

1315531720, 9781315531724

More Books

Students also viewed these Accounting questions

Question

Does your product/program have a descriptive and memorable slogan?

Answered: 1 week ago

Question

How does this compare with the Fog Index for your written message?

Answered: 1 week ago