Production schedule to minimize total cost

Assignment Help Operation Management

Reference no: EM131283235

Northwest Pipe (NP) makes water pipe. NP is planning production for the next seven months, March through September. The forecast demands (in thousands of feet) are, respectively, 40, 60, 70, 80, 90, 100, and 80. NP can make 75,000 feet of pipe per month using regular time production, at a cost of $1.25 per foot. It can make up to an additional 15,000 feet using overtime production at a cost of $1.50 per foot. Any pipe made in one month and sold in a later month incurs an inventory holding cost of $0.15 per foot, per month. NP expects to end February with 5000 feet of pipe and would like to plan to end September with 10,000 feet in inventory. NP would like to plan its production schedule to minimize total cost during the next seven months.

(a) Formulate an LP to minimize total costs.

(b) Set up and solve the problem on a spreadsheet.

Reference no: EM131283235

Questions Cloud

Each of her programmers busy coding : Camile owns Crunch Code, a company that provides quick programming solutions. Clients send Crunch projects via their webpage and Crunch bangs out the needed code as quickly as possible. Camile has five programmers who do all of the coding. Camile wan..

Offers real-time high-performance computing services : CPU-on-Demand (CPUD) offers real-time high-performance computing services. CPUD owns 1 supercomputer that can be accessed through the Internet. Their customers send jobs that arrive on average every 7 hours. The standard deviation of the interarrival..

Do you like working or studying in groups : Do you like working or studying in groups? Why or why not? What are the advantages and disadvantages of working in groups? Log in and explain in detail. You must also respectfully comment on another student's answer to this question.

Entrepreneurship with working in corporate environment : Compare and contrast entrepreneurship with working in a corporate environment as a department head. What are some responsibilities, rewards, and risks associated with each role? How does this affect your decision to be an entrepreneur instead of work..

Production schedule to minimize total cost : Northwest Pipe (NP) makes water pipe. NP is planning production for the next seven months, March through September. The forecast demands (in thousands of feet) are, respectively, 40, 60, 70, 80, 90, 100, and 80. NP can make 75,000 feet of pipe per mo..

About the institutionalized plagiarism : In some “real-world” contexts, plagiarism is not only acceptable but is expected. Brian Martin calls this “institutionalized plagiarism.” Plagiarism is as tied to context as every other aspect of language use. In our everyday conversations—and lectur..

Discuss the characteristics of successful persuasive speech : What defines e-commerce, m-commerce, digital good and digital markets. Explain fiduciary duty and how it applies in business ethics. Should a speaker feel defeated if his or her speech fails to persuade every listener? Discuss the characteristics of ..

Media advertising-personal selling and sales promotion : The four basic elements of any promotional campaign are media advertising, personal selling, sales promotion, and publicity. Discuss how you will use these four elements (you can skip publicity if you want to) to create an integrated promotional camp..

Resource pool presented greatest management challenge : Using SIM Project as your guide, what characteristics of a resource are important to develop a good project team? Which of the resources from the resource pool presented the greatest management challenge and how did you try to manage those resource(s..

User Account

All Pages