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

  Create a project schedule and align resources

Create a project schedule and align resources, Analyze project schedule and resource allocation

  Managerial roles and gap analysis

Write a report on Managerial Roles and Gap Analysis

  Questionaire on project management

Questionaire on Project Management

  Describe the market growth rate for product

Describe the market growth rate for product and service.

  Prepare a work plan and project schedule - gantt chart

Design an online system for the human resources department to manage available job positions.

  Project risk management approach

How does a project risk management approach pro-vide an early warning signal for impending problems or issues

  Black-scholes options pricing model

Calculate the payoff and the profits for investments

  Describe the features or characteristics of product

Describe the features or characteristics of your product or service.

  Write paper on inventory management system

Write paper on Inventory Management System.

  Analysis of the overall project risk

Analysis of the overall project risk

  Investment and performance analysis

Evaluate the usefulness of ROCE

  Distribution strategy and project management

Distribution strategy and project management

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