Problem No. 1

Johnson and Johnson produces products that will be sold to the market, The management required production for Baby powder and Baby soap must at least 400 units Baby powder requires 3 hour of processing time produce per unit and baby soap requires 2 ours of processing time per unit. There are 700 hours of processing time available. The objective of Johnson and Johnson is to satisfy these requirements with a minimum production cost. Production costs are 2 pesos per unit of baby powder and 3 pesos per unit of baby soap. P stand for baby powder and S stand for baby soap.

Requirement:

1. Formulate the linear programming model then identify the following:

a. Objective function

b. Constrain

c. Non-negativity constrain

Problem No. 2.

Fitness Sporting Equipment makes two types of baseball gloves: a regular model and a catcher's model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in the finishing department and 100 hours available in its packaging and shipping department . The production time requirements and the profit contributions as follows:

Particulars	Production time
Regular model	Catcher model
Cutting and sewing	1	3/2
Finishing department	1/2	1/3
Packaging and shipping	1/8	1/4
Profit	5	8

The company is interested in maximizing profit contributions.

Requirements:

1. What is the linear programming model for the problem

2. Develop a spreadsheet model and find the optimal solution using excel solver. How many of each model should Fitness manufacture

3. What is the total profit contribution of Fitness can earn with the optimal production quantities

4. How many hours of production time will be scheduled in each department?

5. What is the slack time in each department