Production-inventory planning

Assignment Help Basic Statistics
Reference no: EM131939407

Production/Inventory Planning

A manufacturing plant supplies various engine components to manufacturers of motorcycles on a just-in-time basis. Planned production capacity for one component is 100 units per shift. Because of fluctuations in customers' assembly operations, demand fluctuates and is historically between 80 and 130 units per day. To maintain sufficient inventory to meet its just-in-time commitments, Tracway's management is considering a policy to run a second shift if inventory falls to 50 or below. For the annual budget planning process, managers need to know how many additional shifts will be needed. The fundamental equation that governs this process each day is:

Ending inventory = Beginning inventory + Production - Demand

Develop an Excel spreadsheet model to simulate 260 working days (one year) and count the number of additional shifts that are required. Use this variable as a forecast cell for a Crystal Ball simulation of the model to find a distribution of the number of shifts required over the next year. Then use the Crystal Ball Bootstrap tool to find the sampling distribution of the maximum number of additional shifts required and compute a 95% confidence interval for this statistic. Summarize your findings in a report to the plant manager.

Reference no: EM131939407

Questions Cloud

What is effective annual yield : TD Bank pays an annual dividend of $2.12 at the rate of $0.53 quarterly. The stock is trading at $63.21. What is the effective annual yield?
Simulation for a two-month period : The store manager wants to minimize the total supply chain costs. Develop a model for this supply chain, run the simulation for a two-month period
What are the effective interest rates on these loans : Magic Pumpkin's bank has offered to finace the purchase with an installment loan, What are the effective interest rates on these loans
Relationship between the cost of debt and levered equity : Explain the probable forms of the cost-of-debt function and the reasons for a specific relationship between the cost of debt and levered equity.
Production-inventory planning : A manufacturing plant supplies various engine components to manufacturers of motorcycles on a just-in-time basis. Planned production capacity for one
Respect to market intervention and financial institutions : What lessons have we learned over the past six years with respect to market intervention, Financial Institutions, and regulations?
Develop a model that will yield a valid set : Develop a model that will yield a valid set of weights to maximize Korey's score for the course.
Use frosts assertion into discussion : Write about a poem, you are, in some ways, providing a guide for a place that might otherwise seem unfamiliar and remote. Put simply, writing enables you
Explain the reduced cost associated with standard desks : Implement your model on a spreadsheet and find an optimal solution. Explain the reduced cost associated with standard desks.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Potential between the amorphous and crystallinc phases

Glass crystallizes as it ages. What does that say about the change in chemical potential between the amorphous and crystallinc phases?

  Specify the values and the areas

Are there any (finite) values for which the area above that value is the same for all t-distributions? If so, specify the value(s) and the area(s). If not, explain why not.

  Non rejection region under curve of t distribution

If level of significance ( α ) is 0.005 in two-tail test, how large is non rejection region under curve of the t distribution?

  What is the probability that a simple random sample of 100

businessweek conducted a survey of graduates from 30 top mba programs businessweek september 22 2003. on the basis of

  Negative-edge-triggered flip-flop

Write a Verilog description for a JK negative-edge-triggered flip-flop with clock CLK. Compile and simulate your description. Apply a sequence that causes all eight combinations of inputs J and K and stored value Q to be applied in some clock cycle..

  Setting up null hypothesis for associated f test

Set up null hypothesis for associated F test.

  How conditional probabilities are related to sampling

Explain how conditional probabilities are related to sampling without replacement. Distinguish between sampling where order matters and sampling.

  Is the sampling distribution of the sample mean normal

When sampling is from a normal population with an unknown variance, is the sampling distribution of the sample mean normal? Explain.

  Compute number of one a day users expected to be selected

Simmons Market Research conducted a national consumer study of 13,787 respondents. The respondents were asked to indicate the primary source of the vitamins.

  Question regarding the withdrawals or deposits

After two years, he stops making monthly contributions, because the interest rate changes to 15% per year compounded every two months, if no withdrawals or deposits are made for 4 years, what will the balance be in this account?

  What is the standard deviation of the distribution

The population average for SAT score is 1020, with a population standard deviation of 100.

  Find the mean volume of sales for a sample

The mean volume of sales for a sample of 100 sales representatives is $25,350 per month. The sample standard deviation is $7,490.

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