EMP: NUMBER (4) EMPNO VARCHAR2 (10) ENAME VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7,2) SAL NUMBER (7, 2) COMM NUMBER (2) DEPTNO DEPT: NUMBER (2) DEPTNO VARCHAR2 (14) DNAME VARCHAR2 (13)

Gotham City National Bank is open Monday through Friday from 9 a.m. to 5 p.m. From past experience, the bank knows that it needs the numbers of tellers listed in the file P04_104.xlsx. Gotham City Bank hires two types of tellers. Full-time tellers work 9 a.m. to 5 p.m. five days per week, with one hour off each day for lunch. The bank determines when a full-time employee takes his or her lunch hour, but each teller must go between 12 p.m. and 1 p.m. or between 1 p.m. and 2 p.m. Full-time employees are paid (including fringe benefits) $15 per hour, which includes payment for lunch hour. The bank can also hire part-time tellers. Each part-time teller must work exactly four consecutive hours each day. A part-time teller is paid $9 per hour and receives no fringe benefits. To maintain adequate quality of service, the bank has decided that, at most, six part-time tellers can be hired. Determine how to meet the bank’s teller requirements at minimum cost.

. Employees of a certain firm are paid on hourly basis at the end of each week. If an employee works up to 40hrs, the employee is paid 6 GHS and 7 GHS per hour for a male and female respectively. If an employee works for more than 50 hours then the employee is also paid 2.5 the corresponding regular rate for hours worked in excess of 40. All employees are to pay 10 % of their gross as INCOME TAX and 2.5% towards the NHIS. If an employee has more than 3 children then he or she pays 2 cedis per child in excess of three towards GETFUND. Write a C++ program that can print onto screen the Net Salary of any staff onto screen. NB (NETSALARY is equal to gross salary less all deductions (VAT, NHIS, GETFUND). Write a C++ program and draw a flow chart for a software solution that can solve for the problem above.

The Callaghan family owns 410 acres of farmland in Co. Cork on which they grow wheat and oats. Each acre of wheat costs €105 to plant, cultivate, and harvest; each acre of oats costs €210. The Bradleys have a budget of €52,500 for next year. The government limits the number of acres of oats that can be planted to 100. The profit from each acre of wheat is €300; the profit from each acre of oats is €520. The Callaghans want to know how many acres of each crop to plant in order to maximize their profit. ii. Formulate a linear programming model for this problem.