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.

The Somerset Furniture Company was founded in 1957 in Randolph County, Virginia. It traditionally has manufactured large, medium-priced, ornate residential wood furniture such as bedroom cabinets and chests of draws, and dining and living room cabinets, tables, and chairs, at its primary manufacturing facility in Randolph County. It employed a marketing strategy of rapidly introducing new product lines every few years. Over time it developed a reputation for high-quality, affordable furniture for a growing U.S. market of homeowners during the last half of the twentieth century. The company was generally considered to be an innovator in furniture manufacturing processes and in applying QM principles to furniture manufacturing. However, in the mid-1990s, faced with increasing foreign competition, high labor rates, and diminishing profits, the Somerset Company contracted to outsource several of its furniture product lines to manufacturers in China, simultaneously reducing the size of its own domestic manufacturing facility and labor force. This initially proved to be very successful in reducing costs and increasing profits, and by 2000 Somerset had decided to close its entire manufacturing facility in the United States and outsource all of its manufacturing to suppliers in China. The company set up a global supply chain in which it arranges for shipments of wood from the United States and South America to manufacturing plants in China where the furniture products are produced by hand by Chinese laborers. The Chinese manufacturers are very good at copying the Somerset ornate furniture designs by hand without expensive machinery. The average labor rate for furniture manufacturing in the United States is between $9 and $20 per hour, whereas the average labor rate for furniture manufacturers in China is $2 per day. Finished furniture products are shipped by container ship from Hong Kong or Shanghai to Norfolk, Virginia, where the containers are then transported by truck to Somerset warehouses in Randolph County. Somerset supplies retail furniture stores from this location. All hardware is installed on the furniture at the retail stores in order to reduce the possibility of damage during transport.

The order processing and fulfillment system for Somerset includes a great deal of variability, as do all aspects of the company's global supply chain. The company processes orders weekly and biweekly. In the United States it takes between 12 and 25 days for the company to develop a purchase order and release it to its Chinese suppliers. This process includes developing a demand forecast, which may take from one to two weeks; converting the forecast to an order fulfillment schedule; and then developing a purchase order. Once the purchase order is processed overseas by the Chinese manufacturer, which may take 10 to 20 days depending on the number of changes made, the manufacturing process requires approximately 60 days. The foreign logistics process requires finished furniture items to be transported from the manufacturing plants to the Chinese ports, which can take up to several weeks depending on trucking availability and schedules. An additional 5 to 10 days are required to arrange for shipping containers and prepare the paperwork for shipping. However, shipments can then wait from one day to a week for enough available containers. There are often too few containers at the ports because large U.S. importers, like “Big W” discount stores in the United States, reserve all the available containers for their continual stream of overseas shipments. Once enough containers are secured, it requires three to six days to optimally load the containers. The furniture pieces often have odd dimensions that result in partially filled containers. Since 9/11, random security checks of containers can delay shipment another one to three weeks, and smaller companies like Somerset are more likely to be extensively checked than larger shippers like Big W, whom the port authorities don't want upset with delays. The trip overseas to Norfolk requires 28 days. Once in port, one to two weeks are required for a shipment to clear customs and to be loaded onto trucks for transport to Somerset's warehouse in Randolph County, which takes from one to three days. When a shipment arrives, it can take from one day up to a month to unload a trailer, depending on the urgency to fill store orders from the shipment.

Because of supply chain variability, shipments can be off schedule (i.e., delayed) by as much as 40%. The company prides itself on customer service and fears that late deliveries to its customers would harm its credibility and result in cancelled orders and lost customers. At the same time, keeping excess inventories on hand in its warehouses is very costly, and since Somerset redesigns its product lines so frequently a real problem of product obsolescence arises if products remain in inventory very long. Somerset has also been experiencing quality problems. The Chinese suppliers employ quality auditors who rotate among plants every few weeks to perform quality control tests and monitor the manufacturing process for several days before visiting another plant. However, store and individual customer complaints have forced Somerset to inspect virtually every piece of furniture it receives from overseas before forwarding it to stores. In some instances, customers have complained that tables and chairs creak noisily during use. Somerset subsequently discovered that the creaking was caused by humidity differences between the locations of the Chinese plants and the geographic areas in the United States where their furniture is sold. Replacement parts (like cabinet doors or table legs) are difficult to secure because the Chinese suppliers will only agree to provide replacement parts for the product lines currently in production. However, Somerset provides a one-year warranty on its furniture, which means that they often need parts for a product no longer being produced. Even when replacement parts were available, it took too long to get them from the supplier in order to provide timely customer service.

Provide a clear flowchart of all activities included in one complete purchase
“cycle”. The graphical representation must be self-explanatory. In other words, you
must use symbols and their labels/identification in the flowchart, so that NO
ADDITIONAL wording/explanations be necessary outside the flowchart. The time
or time-range for each step of the purchase cycle must also be found on the
flowchart.
2. Calculate the range of days (minimum to maximum) of the variable timeline for
product lead time in this case. Start with the initiation and development of the
purchase order and end when the product is received and warehoused. Itemize
activities with their variable times, and provide the range for the total lead time.
3. Out of the activities identified above, mark with an asterisk, or by using special font
(e.g., bold) those activities whose durations might be reduced with help from
international trade specialists, or trade logistics companies (please do not use any
coloured highlights)
4. Pinpoint at least 7 problems that are prevalent (typical, characteristic) when
manufacturing is outsourced to other countries and appear to be present in this
company’s global supply chain.
5. Highlight two issues that you found of special interest in this case and are not
directly related to the discussion questions above. In other words, DO NOT just
repeat a “problem” stated in the mini-case, but share the “insights” that you may
have gained from examining this real business story.

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