The pt-100 and pt-200 battery packs are produced using similar production equipment available at both plants. however, each plant has a limited capacity for the total number of pt-100 and pt-200 battery packs produced. the combined pt-100 and pt-200 production capacities are 175,000 units at the philippines plant and 160,000 units at the mexico plant. the pt-300 production capacities are 75,000 units at the philippines plant and 100,000 units at the mexico plant. the cost of shipping from the philippines plant is $0.15 per unit, and the cost of shipping from the mexico plant is $0.08 per unit.

Employees at a library check out books to patrons. books have an isbn and a name. the library sometimes has multiple copies of the same book. books have one or more authors. a patron is an individual who has an active (non-expired) library card. for each library card, we store the person's first and last names and their address. for each employee, we store their employee id, current salary, first and last name and their address. we also store the employee id of their current manager. each time we check out a book to a patron we need to store the date of the transaction, the employee who checked out the book to the patron, and the library card of the patron. some employees have library cards. if an employee patron turns in a book late, the fine that they pay is a percentage of their salary. some employees are authors who have library cards—they are allowed to check out as many books as they like.