The City of Comstock had a total General Fund balance of $1,400,000 at the end of its fiscal year. The year end balance sheet reports inventory of material and supplies of $60,000. City Council passed an ordinance that all revenue received from hotel occupancy taxes must be used for beautification projects in the City. The City received $280,000 in hotel occupancy taxes and spent $225,000 on beautification projects this year. The City received a Federal grant of $120,000 for specifically the purchase of new breathing apparatus for the fire department. Due to a backlog by the manufacturer of the equipment, the equipment has not been purchased by year end.

Which of the following statements are correct regarding the classifiction of fund balance at year end?

QUESTIONS:

(c) Prepare an adjusted trial balance on May 31.

Based on:

The Moto Hotel opened for business on May 1, 2017. Here is its trial balance before adjustment on May 31.

Other data:

1. Draw the decision tables for all the problems below
2. For the decision tables above, reduce the tables if possible.

Problems

1. A month is to be represented as an integer. A valid month is in the range of 1..12. An integer < 1 is invalid, or an integer > 12 is invalid. Consider how this can be simplified or reduced.
2. An employee is either hourly or salaried. An hourly employee is paid by calculating an hourly wage and an hourly employee that works more than 40 hours is paid overtime. An hourly employee that works less than 40 hours must produce an absence report. A salaried employee can work any number of hours.
3. A new program to determine parking rates is to be developed. Users will select (from a dropdown) the classification of the vehicle owner (faculty/staff or student), the location of the parking (garage or open lot) and the type of vehicle (large or small).  Students with a small vehicle pay $250.00 in a lot and $350.00 in a garage.  Students with a large vehicle may park in a lot for $400.00.  Faculty/staff may park small vehicles anywhere for $150.00 and large vehicles in a lot for $200.00.  Large vehicles are not allowed in the garage.

Problem 13: Sam's Cat Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.70 per bag. The following information is available about these bags.

Demand = 90 bags/week

Order Cost= $54/0rder

Annual Holding cost = 27% of cost

Desired cycle-service level = 80%

Lead time = 3 weeks (18 working days)

Standard deviation of weekly demand = 15 bags

Current on-hand inventory is 320 bags, with no open orders or backorders.

Suppose that Sam's Cat Hotel in Problem 13 uses a P system instead of a Q system. The average weekly demand is d = 90 bags and the standard deviation of the weekly demand is σ= 15 bags.

a. What P (in weeks) and T should be used to approximate the cost trade-offs of the EOQ?

b. How much more safety stock is needed than with a Q system?

c. It is time for the periodic review. How much kitty litter should be ordered?"

The management of Arturo’s Water Park is developing an advertising campaign to communicate the intended message, “Your kids will love you more if you take them to Arturo’s Water Park.” (a) For a print ad in this advertising campaign, suggest some wording for the copy in the ad. Then, describe your suggestions for the artwork in the ad. Which of these two parts of the ad – the copy or the artwork – would likely be more effective in communicating the intended message? Use course material to justify your reasoning. (b) For the print ad you described in Part (a), describe a pretest that would be appropriate. Explain why pretesting is important in advertising. (c) If Arturo’s management uses market segmentation to target this print ad, what is the segmentation variable it should use? Explain your reasoning. (d) Design an experiment to test whether or not this print ad is effective. Describe the test group and the control group of the experiment, and describe the time course of events. What is the dependent variable in your experiment? Explain why both the test group and the control group are necessary for this experiment to have validity.

The following tables form part of a database held in a relational DBMS:

Hotel (hotelNo, hotelName, hotelAddress, country)

Room (roomNo, hotelNo, type, price)

Guest (guestNo, guestName, guestAddress, country)

Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

Write the SQL statements for the following questions:

1. List the rooms that are currently unoccupied at the Grosvenor Hotel, for:

(a) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use NOT IN to perform the difference operation

(b) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use NOT EXISTS to perform the difference operation.

(c) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use LEFT JOIN to perform the difference operation.

(d) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use MINUS to perform the difference operation.

DROP DATABASE class;CREATE DATABASE class;Use class;drop table if exists Class;drop table if exists Student;CREATE TABLE Class (CIN int PRIMARY KEY, FirstName varchar(255), LastName varchar(255), Gender varchar(1), EyeColor varchar(50), HairColor varchar(50), HeightInches int,CurrentGrade varchar(1));CREATE TABLE Student (SSN int PRIMARY KEY,FirstName varchar(255),LastName varchar(255), Age int,BirthMonth varchar(255),HeightInches int,Address varchar(255),City varchar(255),PhoneNumber varchar(12),Email varchar(255),FavColor varchar(255),FavNumber int);INSERT INTO Class VALUES(1, "David", "San", "M", "BRN", "BLK", 72, "-");INSERT INTO Class VALUES(2, "Jeff", "Gonzales", "M", "BRN", "BLK", 68, "B");INSERT INTO Class VALUES(3, "Anna", "Grayson", "F", "BRN", "BRN", 62, "A");INSERT INTO Class VALUES(4, "Kathryn", "Moloney", "F", "GRN", "BLK", 68, "B");INSERT INTO Class VALUES(5, "Randy", "Bernard", "M", "GRN", "BRN", 69, "A");INSERT INTO Class VALUES(6, "Andy", "Lam", "M", "BRN", "BLK", 59, "C");INSERT INTO Class VALUES(7, "Makoto", "Yuki", "F", "BRN", "BRN", 61, "A");INSERT INTO Class VALUES(8, "Pranil", "Watakana", "M", "BRN", "BLK", 63, "D");INSERT INTO Class VALUES(9, "Pierce", "Santos", "M", "BRN", "BLK", 74, "B");INSERT INTO Class VALUES(10, "Soliel", "Estrada", "F", "BRN", "BLU", 66, "B");INSERT INTO Class VALUES(11, "Jeff", "Bezos", "M", "BRN", "BRN", 65, "B");INSERT INTO Class VALUES(12, "Andy", "Chen", "M", "BRN", "BLK", 69, "A");INSERT INTO Class VALUES(13, "Makoto", "Amagi", "F", "BRN", "BRN", 64, "C");INSERT INTO Student VALUES(1, "David", "San", 22, "March", 72, "1234", "Flowerville", "231-246-4361", "[email protected]", "Blue", 7);INSERT INTO Student VALUES(2, "Randy", "Bernard", 21, "February", 69, "7123", "Rossette Park", "634-124-7452", "[email protected]", "Green", 12);INSERT INTO Student VALUES(3, "Andy", "Lam", 24, "December", 59, "9072", "Jefferson", "124-564-6354", "[email protected]", "Grey", 32);INSERT INTO Student VALUES(4, "Pranil", "Watakana", 23, "February", 63, "2146", "Rossette Park", "543-325-3521", "[email protected]", "Grey", 3);INSERT INTO Student VALUES(5, "Jeff", "Bezos", 22, "April", 65, "6312", "Grey Valley", "351-532-6439", "[email protected]", "Yellow", 0);INSERT INTO Student VALUES(6, "Makoto", "Amagi", 21, "September", 64, "39857", "Flowerville", "314-352-5321", "[email protected]", "Black", 3);

INSERT INTO Student VALUES(7, "Jeff", "Gonzales", 20, "October", 68, "4361", "Flowerville", "231-342-5467", "[email protected]", "Blue", 21);INSERT INTO Student VALUES(8, "Anna", "Grayson", 21, "January", 62, "6543", "Rossette Park", "634-423-5763", "[email protected]", "Green", 12);INSERT INTO Student VALUES(9, "Kathryn", "Moloney", 24, "May", 68, "5437", "Jefferson", "124-684-4131", "[email protected]", "Grey", 3);INSERT INTO Student VALUES(10, "Makoto", "Yuki", 19, "April", 61, "75632", "Rossette Park", "543-354-6421", "[email protected]", "Grey", 7);INSERT INTO Student VALUES(11, "Pierce", "Santos", 21, "January", 74, "3543", "GreyValley", "351-542-7541", "[email protected]", "Yellow", 10);INSERT INTO Student VALUES(12, "Soliel", "Estrada", 20, "June", 66, "3754", "Flowerville", "314-325-6543", "[email protected]", "Black", 5);INSERT INTO Student VALUES(13, "Andy", "Chen", 22, "September", 69, "3865", "Flowerville", "314-231-4233", "[email protected]", "Black", 3);

-----------------------------------------------------------------------------------------------------------------------

1. Assign grades for students who lived in Rossette Park to be a B
2. Add another table for students who had an altered grade (in this case students who lived in Rossette Park)
3. Add the CIN, FirstName, LastName, Gender, Address, City, and Email of the students who had an altered grade to the table
4. Remove students from the student table who live in Rossette Park
5. Join all 3 tables and display the Names, Gender, and City of the students (Going to need to use ON)

Use
SET SQL_SAFE_UPDATES = 0;
To disable Safe Mode if prompted.

Not sure where to begin, as my instructor taught the theory but never any live coding session.

Is there a difference between the means of the total of rooms per hotel in Crete and Southern Aegean Islands? Answer your question by calculating an appropriate, symmetric, 95% confidence interval using a Z statistic and equal standard deviations in the two populations. Explain your findings.

REGION ID

1= Crete
2=Southern Aegean Islands
3=Ionian Islands

Is there a difference between the means of the total of rooms per hotel in Crete and Southern Aegean Islands? Answer your question by calculating an appropriate, symmetric, 95% confidence interval using a Z statistic and equal standard deviations in the two populations. Explain your findings

REGION ID

1= Crete
2=Southern Aegean Islands
3=Ionian Islands