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.

Q1A 4-poles, wave wound, 600 conductors DC long shunt generator has the armature, series and shunt resistances are 0.15 ohm, 0.18 ohm and 200 ohm respectively. It runs at 1500 rpm. Calculate the following if it is required supply to the load resistance of 20ohm with flux per pole as 8.33 mWb. Take the Iron and Frictional losses as 550 W.(i)Induced Emf(ii)Terminal Voltage(iii)Output Power(iv)Input Power(v)Efficiency

Q2Write short notes on following characteristics of dc generator(i) Open Circuit Characteristics (OCC)(ii) Load Characteristics

Q3A dc short shunt generator supply 500V to a 20 kW load. Its armature, series and shunt resistance are 0.8 , 0.6 and 700 respectively. Calculate the armature current, induced emf, input power, torque supplied by the prime mover and efficiency if its speed and mechanical losses are 1500 rpm and 910W respectively.

Q4A 500V, 4 poles, wave-wound DC Series Motor has 900 conductors on its armature. It has armature and series field resistance of 0.6, and 0.8respectively. The motor takes a current of 40A. Estimate the speed and gross Torque developed if it has a flux per pole of 20mWb.

Q5A dc shunt motor takes a no load current of 5 A at 300V. Its armature and shunt resistances are 0.45 ohm and 0.68 ohm respectively. Calculate the Constant Loss (Iron and Frictional Loss) of the machine.

Q6A dc series motor operates at 1000 rpm with a line current of 82A from 250V mains. its armature circuit resistance is 0.2and its field resistance is 0.6. Find the speed at which the motor runs at a line current of 65A, assuming that the flux at this current is 33% of the flux at 82A.

Q7A 3 phase, 50Hz, 4 poles induction motor runs at 1440 rpm. Calculate the following i.Synchronous speedii.Slipiii.Slip speediv.Rotor frequency while runningv.Rotor cu loss if mechanical power developed is 16 kW.

Q8A 40 kW (Rated Output), 415V, 50Hz, 3 phase, star connected induction motor has a synchronous speed of 1800 rpm. The full load slip is 4% and full load power factor is 0.9 lagging. Stator Cu losses are 2500 W. Iron losses are 2000W. Rotational losses are 1400 W. Calculate i.Shaft or Net Torque developedii.Mechanical power developediii.Power inputiv.Efficiencyv.Supply current

Q9The following are the equivalent circuit parameters of a 3phase, star connected 415V, 50Hz, 4 poles Induction Motor:R1= 0.5, R'2= 0.4/s , X1= 0.9, X'2= 0.8, Xm= 50,(neglect Ro)Calculate the input impedance, motor current, power input, power supplied to the rotor, power developed and efficiency if its rotational losses are 1200W. It runs at 1410 rpm.

Q10A 415-V, 29.84 kW, 50 Hz, delta-connected 3-phase induction motor gave the following test data:No load test:415V, 15A, 2000 WLocked rotor test:125V, 40A, 4000 WConstruct the circle diagram and determine the line current and power factor for the rated output. Assume stator and rotor Cu losses equal at standstill.Q11With a aid of neat circuit diagram, explain the working principle of Automatic star-delta starter of three phase induction motor

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? __________