Find the distribution of the number of shifts

Assignment Help Engineering Mathematics

Reference no: EM131439760

Question: One of PLE's manufacturing plants 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, and the plant operates one shift per day. Because of fluctuations in customers' assembly operations, however, demand fluctuates and is historically between 80 and 130 units per day. To maintain sufficient inventory to meet its just-in-time commitments, PLE's management is considering a policy to run a second shift the next day if inventory falls to 50 or below at the end of a day (after the daily demand is known). 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 + product - demand

Develop a spreadsheet model to simulate 260 working days (1 year), and count the number of additional shifts that are required. Assume that the initial inventory is 100 units. Use Psi functions for all uncertain cells in building your model. Using the number of additional shifts required as the output cell for a Monte Carlo simulation, find the distribution of the number of shifts that the company can expect to need over the next year. Explain and summarize your findings in a report to the plant manager and make a recommendation as to how many shifts to plan in next year's budget.

Reference no: EM131439760

Questions Cloud

How does the pboc avoid this risk : The PBoC's policy of exchanging all US dollars for renminbi could produce inflationary pressures. How does the PBoC avoid this risk?

What is the average hourly production rate of the machine : Average setup time on a certain production machine is 4.0 hr. Average batch size is 48 parts, and average operation cycle time is 4.2 min. The reliability of this machine is characterized by mean time between failures of 37 hr and a mean time to repa..

What is driving marginal benefits : After viewing the video clip from Cool Hand Luke, first consider how marginal benefits and marginal costs fit in to Luke's decision, and how the concept of diminishing marginal utility is at work as Luke eats more and more eggs.

Communication on a major project is suffering : Communication on a major project is suffering because several team members are in the habit of writing cryptic or careless instant messages that often force recipients to engage in several rounds of follow-up messaging to figure out what the sender h..

Find the distribution of the number of shifts : One of PLE's manufacturing plants 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, and the plant operates one shift per day.

Compare and contrast surveys and experiments : Compare and contrast surveys (questionnaires) and experiments in terms of their strengths and weaknesses. Do any of the weaknesses apply to both methods? Do the two methods have any of the same strengths?Are there instances where the strength of o..

Compare and contrast home replication-global-multidomestic : Compare and contrast home replication, global, multidomestic, and transnational strategies( please text not picture)

Rapid prototyping is a methodology : Rapid prototyping is a methodology for:

Who bears the burden of the tariff : Suppose that in Japan, without a tariff 10,000 cars will be sold per year at an equilibrium price of $20,000. With a $5,000 tariff, supply decreases such that 8,000 cars are produced at $22,500 per car.

User Account

All Pages