Computer Production Planning via Linear Programming
Not what you're looking for?
A laptop manufacturer is developing a production schedule for the next four quarters. Demands for this manufacturer's laptop computer are forecasted to be 1200 in quarter 1; 2100 in quarter 2; 1500 in quarter in 3; and 600 in quarter 4. Assume that it costs this manufacturer $1200 to produce each laptop computer. At the end of each quarter, a holding cost of $300 per computer left in inventory is incurred. Increasing production from quarter to the next incurs costs for hiring and training new employees. It is estimated that a cost of $2100 per computer is incurred if production is increased from one quarter to the next. Decreasing production from one quarter to the next incurs costs for lying off employees, loss of morale, and so forth. It is estimated that a cost of $1800 per computer is incurred if production is decreased from one quarter to the next. All demands must be met on time, and the units produced in one quarter can be used to meet demand for the current quarter as well as for future quarters. During the quarter immediately preceding quarter 1 (e.g., the most recent quarter), 1000 laptop computers were produced. Assume that at the beginning of quarter 1 no computers are in inventory.
Objective:
Help the computer manufacturer formulate and solve a linear programming spreadsheet model to find the production schedule that minimizes total cost over the given planning horizon.
Purchase this Solution
Solution Summary
The expert examines computer production planning via linear programming. How to minimize total cost over the planning horizon.
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Lean your Process
This quiz will help you understand the basic concepts of Lean.