CASE STUDY GIVEN THIS SCENARIO: Mr. and Mrs. Reyes died in a tragic accident when they went to a private island for a vacation. Authorities found that they have a lot of money in the bank and bought treasury bills in the stock market. The couple is known to have a son, from whom they are estranged. This man is the sole heir to the Reyes’ fortune. Five men showed up, each claiming to be the couple’s long-lost son who ran away after a misunderstanding with his father. You are called in as a genetics expert to decide who the rightful heir is. You will need to develop a Punnett square based on the genotype of the deceased to eliminate the imposters. A successful result will identify the true heir. Sex-Linked Inheritance Mr. Reyes Color-blind Mrs. Reyes Homozygous for normal vision Manuel Color-blind Oscar Normal vision So who gets the money? Justify your answer.

Harris Company manufactures and sells a single product. A partially completed schedule of the company’s total costs and costs per unit over the relevant range of 30,000 to 50,000 units is given below: Required : 1. Complete the above schedule of the company’s total costs and costs per unit. 2. Assume that the company produces and sells 45,000 units during the year at a selling price of $16 per unit. Prepare a contribution format income statement for the year. Transcribed Image Text: Units Produced and Sold
30,000
40,000
50,000
Total costs:
Variable cost
$180,000
?
?
…
Fixed cost…
300,000
?
Total cost
$480,000
?
?
Costs per unit:
Variable cost
?
?
Fixed cost….
Total cost per unit
?
?
?
?
?

2.1. Find the least number of cables required to connect 100 computers to 20 printers to guarantee that every subset of 20 computers can directly access 20 different printers. Justify your answer. 2.2. The English alphabet contains 21 consonants and five vowels. How many strings of six lowercase letters of the English alphabet contain 2.2.1. Exactly one vowel? 2.2.2. Exactly two vowels? 2.2.3. At least one vowel? 2.2.4. At least two vowels? 2.3. What are the values of these sums? Transcribed Image Text: Department of Computer Science and Information Technology
2.3.1.
2.3.2.
E(-2y
(21+1 – 2/)
2.3.3.
2.3.4.

USE THE FOLLOWING SCHEMA TO WRITE SQL STATEMENTS FOR QUESTIONS 5-11 BELOW Branch( branch_id:integer , branch_name:varchar(50), branch_location:varchar(40), money_on_hand:numeric(15,2) create table Branch (branch_id                              integer, branch_name                                 varchar(50), branch_location                 varchar(40), money_on_hand                 numeric(15,2), primary key (branch_id)); Loan( loan_number:integer , branch_id:integer, amount:numeric(8,2)) foreign key branch_id references Branch(branch_id) create table Loan (loan_number            integer, branch_id                                  integer, amount                                     numeric(8,2), primary key (loan_number), foreign key (branch_id) references Branch (branch_id)); Customer( customer_id:integer , customer_last_name:varchar(35),customer_first_name:varchar(25), customer_street:varchar(30), customer_zip:integer) create table Customer (customer_id              integer, customer_last_name          varchar(35), customer_first_name         varchar(25), customer_street                 varchar(30), customer_zip                      integer, primary key (customer_id)); Borrower( customer_id:integer , loan_number:integer) foreign key (customer_id) references Customer(customer_id) foreign key (loan_number) references Loan(loan_number) create table Borrower (customer_id              integer, loan_number                            integer, primary key (customer_id, loan_number), foreign key (customer_id) references Customer (customer_id), foreign key (loan_number) references Loan (loan_number)); Depositor( customer_id:integer , account_number:integer) foreign key (customer_id) references Customer(customer_id) foreign key (account_number) references Account(account_number) Note: as the Account table is a referenced table, you have to create that table first. create table Depositor (customer_id              integer, account_number                      integer, primary key (customer_id, account_number), foreign key (customer_id) references Customer (customer_id), foreign key (account_number) references Account (account_number)); Account( account_number:integer , branch_id:integer, balance:numeric(8,2)) foreign key branch_id references Branch(branch_id) create table Account (account_number                  integer, branch_id                                  integer, balance                                     numeric(8,2), primary key (account_number), foreign key (branch_id) references Branch (branch_id)); 5- Find Customer ID, Customer name and Customer City for all accounts, sorted by Customer City, then Customer Last name. 6- Find Customer ID, Customer name and the number of loans for each Customer. 7- Find Loan number and Customer Id of the loan with the lowest amount. 8- Create a view called Gary_Branch_V that contains Branch Id, Branch name, and number of loans for each Branch that is in the city of Gary. 9- For each Customer in Hopkins, find the balance in their account(s). 10- Find how many different accounts each customer has at each Branch. The output should be a list of Customer ID and for each Customer ID, the number of accounts for this customer by Branch ID. 11- Find the branch with the highest or largest Average loan amount.  List the Branch ID, Branch Name, and the Highest Average loan amount.

Three years ago, Linda Williams and her brother-in-law Robert Jones opened Marin Department Store. For the first 2 years, business was good, but the following condensed income statement results for 2022 were disappointing. MARIN DEPARTMENT STORE Income Statement For the Year Ended December 31, 2022 Net sales $730,000 Cost of goods sold 584,000 Gross profit 146,000 Operating expenses Selling expenses $103,750 Administrative expenses 20,750 124,500 Net income $21,500 Linda believes the problem lies in the relatively low gross profit rate of 20%. Robert believes the problem is that operating expenses are too high. Linda thinks the gross profit rate can be improved by making two changes. (1) Increase average selling prices by 15%; this increase is expected to lower sales volume so that total sales dollars will increase only 4%. (2) Buy merchandise in larger quantities and take all purchase discounts. These changes to purchasing practices are expected to increase the gross profit rate from its current rate of 20% to a new rate of 25%. Linda does not anticipate that these changes will have any effect on operating expenses. Robert thinks expenses can be cut by making these two changes. (1) Cut 2023 sales salaries of $62,250 in half and give sales personnel a commission of 2% of net sales. (2) Reduce store deliveries to one day per week rather than twice a week; this change will reduce 2023 delivery expenses of $41,500 by 40%. Robert feels that these changes will not have any effect on net sales. Linda and Robert come to you for in deciding the best way to improve net income. Answer the following. Prepare a condensed income statement for 2023 assuming Linda’s changes are implemented.