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.

The normal variance for filling a liter Coke bottle is 0.5 ounces. In a recent measurement, variance was found to be 0.8 ounces. Should Coca-Cola's management be concerned? Discuss why or why not. In replies to peers, provide an example to support your position.

There have a thin and symmetry wing. aspect ratio is 10, span is 5m, taper ratio is 0.8 and δ＝τ＝0.055. wing's speed is 180km/h and lift is 1.000N. Determine this wing's angle of attack(air density is 1.23Kg/m³)

1. For each pair of standard scores (z-scores) given, write the proportion that lies between them under the normal curve. (3 points)

1. 1.00 and –1.00? __________

2. 1.96 and –1.96? __________

3. 2.58 and –2.58? __________

4. 0.00 and 1.00? ___________

5. 1.50 and .10? __________

6. 2.00 and 0.8? __________

Your portfolio contains $4,815 worth of PG and $4,397 worth of HD stocks. What is the beta of your portfolio, if PG's beta is 0.8 and HD's beta is 1.5%? Assume that the CAPM holds.

Provide your answer rounded to two decimals.