Computer production planning by linear programming

Assignment Help Project Management
Reference no: EM1323427

Computer Production Planning via Linear Programming

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.

Reference no: EM1323427

Questions Cloud

Overall description of company history : Company Research of five companies is provided in the structured manner in this response. The answer includes references employed.
Who should be responsible for security : Who should be responsible for security- the government or individuals? Why do you think that?
Linear programming using manual computation and excel solver : Formulate linear programming model for this problem. Mention the objective function (minimize or maximize) and all model constraints. Solve this model graphically. Identify the following: each constraint line, feasible solution area, x1, x2 and Z..
Decision making models memo : For this assignment, you must submit a memo consisting of 900-1,300 words in which you discuss your experience using the 3 decision-making models.
Computer production planning by linear programming : 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.
The importance of organizational testing methodologies : The Importance of Organizational Testing Methodologies - This solution describes the importance of testing in organizations.
Determining business research and methodology : How are Hypothesis Development and Theoretical Framework employed in Healthcare? How does the Measurement of Variables (Operation Definition) play a role in Healthcare Field.
Two variables and two constraints : Develop your own original Linear Programming problem with the minimum of two variables and two constraints.
Technology and innovation management research : This activity requires you to write down a Research Paper on the subject of your choice in Technology and Innovation Management.

Reviews

Write a Review

Project Management Questions & Answers

  Calculate potential financial implication

Develop a plan to calculate potential financial implications for a nationwide company of your choice. Provide a scenario in which a break-even sales analysis for reactive pricing would be the best option for a company.

  Construct a network diagram

The resource-based view of the firm is one of the most influential current theories in operations strategy (Slack, 2007). Critically evaluate and argue how firms' should consider resource based view during the location selection process?

  Question in project management overview

Identify the types of professional environments where you would expect to find project management techniques being used. Choose one environment you are familiar with and describe how a project manager has led effectively.

  Capital revenue in the public sector

Specification Stage, Design Stage, Build Stage, Capital revenue in the Public Sector, recurrent revenue in the Public Sector, Policy Framework (PF),  Vision Statement, Mission Statement

  Effective project manager

Determine which of the eight traits or skills associated with being an effective project manager would be the most effective when managing a group of newly hired engineers. Justify your position.

  Criticism of traditional measures of performance

Criticism of traditional measures of performance

  Compute the designed capacity and effective capacity

Describe and compute the Designed Capacity and Effective Capacity - Find out and interpret the significance of each three elements in a project

  Define a project and describe its characteristics

Define a project and describe its characteristics and What are the necessary competencies and skills of a project Manager?

  Net present value of final total

Suppose that you are interested in buying yourself a new computer. Create a cost-benefit analysis that illustrates the return on investment that you would receive from purchasing a computer

  Prepare a project report

Prepare a project Report - This indicates the major and minor sections and outlines the structure. It should also contain a list of diagrams, tables, charts and so on.

  Test hypothesis using data

A writing an article about call centre working conditions a reporter has claimed that the average tenure is no more than two years. Formulate and test a hypothesis using these data to determine if this claim can be disputed.

  Data warehousing and storage systems

Write a minimum of a 650 word essay in APA format describing how "data warehousing and storage systems" can be used within the organization.

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