Question: Instructions: . Put all your work in one Excel file and email it to me. Name your file LP assignment-LastnameFirstname The Excel file should include:

Instructions: . Put all your work in one Excel

Instructions: . Put all your work in one Excel file and email it to me. Name your file "LP assignment-LastnameFirstname" The Excel file should include: 1. Mathematical formulations of the problem (score = 3% of the total grade) a. A description of decision variables (you must specify the units) b. Objective function C. Constraints 2. Setup of the formulations in Excel (score = 1%) 3. Answer report (score = 1%) Missed or late submission counts as a zero. Assignment: Formulate an LP model for the following problem, and solve the problem for the optimal solutions using Excel Solver. A firm that assembles computers and computer equipments is about to start production of two new types of microcomputers. Each type will require assembly time, inspection time, and storage space (table 1). The amounts of each of these resources that can be devoted to the production of the microcomputers is limited (table 2). The manager of the firm would like to determine the quantity of each microcomputer to produce in order to maximize the profit generated by sales of these microcomputers. Table 1: Type 1 Type 2 Profit per unit $60 $50 Assembly time per unit 4 hours 10 hours Inspection time per unit 2 hours 1 hour Storage space per unit 3 cubic feet 3 cubic feet Table 2: Resource Assembly time Inspection time Storage space Amount available 100 hours 22 hours 39 cubic feet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!