Question: For problem 1, formulate a goal programming model and solve it using Excel Solver. 1. Goal Programming The Oregon Atlantic Company produces two kinds of

For problem 1, formulate a goal programming model and solve it using Excel Solver.

For problem 1, formulate a goal programming model

1. Goal Programming The Oregon Atlantic Company produces two kinds of paper-newsprint and white wrapping paper (butcher paper). It requires 5 minutes to produce a yard of newsprint and 8 minutes to produce a yard of wrapping paper. The company has 4,800 minutes of normal production capacity available each week. The profit is $0.20 for a yard of newsprint and $0.25 for a yard of wrapping paper. The weekly demand is for 500 yards of newsprint and 400 yards of wrapping paper. The company has established the following goals, in order of priority: (1) Limit overtime to 480 minutes. (2) Achieve a profit of $300 each week. (3) Fulfill the demand for the products in order of magnitude of their profits. (4) Avoid underutilization of production capacity. a. Formulate a goal programming model to determine the number of yards of each type of paper to produce weekly to satisfy the various goals. b. Solve the goal programming model by using the computer

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!

The Oregon Atlantic Company produces two kinds of papernewsprint and white wrapping paper (butcher paper). It requires 5 minutes to produce a yard of newsprint and 8 minutes to produce a yard of...

TV (10-yard) lots for shag and 50 (100-yard) lots for sculptured Capel. Meeting demand for shag is more important than meeting demand for sculptured," a ratio of 5 to 2. (3) Limit production overtime...

See Attached You know that the fish requires at least 100 grams of food. At the same time, fish is a strange animal in the sense that if you feed it more food than it needs, then it will eat the...

A bus company which operates a fleet of 80 buses, needs to determine the optimal mix of small, medium and large buses for its fleet. To satisfy customer requirement a minimum of 10% of the fleet must...

The RMC Corporation blends three raw materials to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of 0 . 4 ton of material 1 and 0 . 6 ton of material...

he RMC Corporation blends three raw materials to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of 0 . 4 ton of material 1 and 0 . 6 ton of material...

Statistics Help, Excel QM Only, with Pictures and Explanations Airborne is a company that produces 4 different airplane parts from fabricated sheet metal for several major aircraft companies. The...

An experiment was conducted at a large state university to determine whether two different instructional methods for teaching a beginning statistics course would yield different levels of cognitive...

Perform a multiple regression analysis using the data in Standby and determine the VIF for each independent variable in the model. Is there reason to suspect the existence of collinearity? For...

ProEdge Tech, a leading technology firm, has bluntly stated its pricing objective as: "Charge all the traffic will bear." This is an example of a Question 2 6 options: profit maximization objective....

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...