Please use Visual Basic

Hotel Occupancy

The Hotel has 8 Floors and 30 rooms on each floor. Create an application that calculates the occupancy rate for each floor, and the overall occupancy rate for the hotel. The occupancy rate is the percentage of rooms occupied, and may be calculated by dividing the number of rooms occupied by the number of rooms.

For example, if 18 rooms on the 1^st floor are occupied, the Occupancy Rate is as follows:

18/30=0.6 or 60%

For the Overall Occupancy Rate, using the above example,

18/(8*30)=0.075 or 7.5%

Another example for Overall Occupancy Rate:

If 1^st floor, 18 rooms occupied.

2^nd floor, 30 rooms occupied, then the calculation is:

(18+30) /(8*30)   or (18+30)/240 =0.2 or 20%

You will need to use Name Constants for Rooms (30 rooms), and Floors (8 floors).

Some variables and Constants you will need to declare in class level to do the Overall Total and Overall Occupancy Rate calculation.

Some variables you will need to use in the local level.

The application’s form should appear similar to the one shown below.

In the form load event handler, use a loop to populate floor 1 to 8 in combo box. (Do NOT create floor 1 to 8 at design time using the Items property)

On startup, “Select the floor” combo box should default to floor 1. Each time the user enters the occupancy for a single floor and clicks the Save button, the floor number in the Drop-Down List ComboBox should increment automatically (just add 1 to its SelectedIndex property), and a new line should appear in the ListBox with the percentage occupancy. Also, the contents of the TextBox at the top of the form should clear automatically when the user clicks the Save button, so the user does not accidentally enter the same data twice in a row.

The Restart button should clear all the appropriate controls on the form. “Select the floor” combo box should default to floor 1.

The Exit button should end the application.

The Save button should do all input validation and all other calculations. (Do NOT use a loop in the btnSave_click event handler)

Input Validation: Be sure to check for a non-integer value in TextBox using the Integer.TryParse method and notify the user if there is an error. Since each floor has only 30 rooms, you need to do the range check to prevent user enter a value is greater than 30 or a negative number. A zero is allowed to input since it may have no occupancy for the whole floor.

Use the values below to confirm that your application is performing the correct calculations.

Use access key for all buttons’ control.   

Georges Hotel has the following sales procedures: The hotel uses duplicated and pre-numbered guest checks to record customers’ orders; the manager is in charge of monitoring the guest checks. She stores them in a storage container which is kept locked until she is ready to issue them to the servers. At the beginning of each shift, the manager issues the guest checks to the servers and records the amount given to each person on a blank sheet of paper. The server takes the order from the customers and records the information on the guest checks. She then presents the kitchen with one copy of the guest check for them to prepare the order and she keeps the other copy to be handed in at the end of the shift. The server informs the cashier of the order by word of mouth. In the event that there were any errors during the shift, servers are allowed to destroy the guest checks.

1. Identify three problems in the sales procedure of the Hotel, explain how they could be detrimental and suggest a control procedure that could be used to address each problem

2. Name three key personnel normally involved in a Hotel’s front office accounting functions. Of the three, chose one and briefly describe their role.

IKEA’s decision to redesign its European-style sofas to better meet the needs of its American consumers

Multiple Choice

• created value for U.S. buyers.

• allowed for premium pricing.

• increased value creation but decreased production costs.

• generated the average consumer price between U.S. buyers and European buyers.

• resulted in a standardized design for U.S. and European buyers.

IKEA’s ability to design functional, attractive furniture at a reasonable price that can be sold in a similar way across multiple countries is an example of

Multiple Choice

• a core competence.

• a low cost strategy.

• perceived value.

• value.

• a differentiation strategy.

IKEA maintains a global network of suppliers across 50 countries. This benefit of this strategy is that it allows IKEA to

Multiple Choice

• eliminate head-to-head competition in local markets.

• improve the functional design of its product line.

• avoid maintaining physical locations near competitors.

• achieve the location economies associated with producing its product in the optimal location.

• quickly design its products.

In China, IKEA has opened stores near public transportation, while in most Western countries, IKEA’s stores are located in suburban shopping areas. This strategy is consistent with

Multiple Choice

• a differentiation strategy.

• a low cost strategy.

• global standardization.

• pressures for local responsiveness.

• pressures for cost reduction.

Consider the following gas-phase reaction:

C₂H₂(g) + 4 Cl₂(g) 2 CCl₄(g) + H₂(g)

Using data from Appendix C of your textbook calculate the temperature, T_o, at which this reaction will be at equilibrium under standard conditions (G^o = 0) and choose whether >G^o will increase, decrease, or not change with increasing temperature from the pulldown menu.

T_o = K, and G^o will

---Select---

increase

decrease

not change with increasing temperature.

For each of the temperatures listed below calculate G^o for the reaction above, and select from the pulldown menu whether the reaction under standard conditions will be spontaneous, nonspontaneous, or near equilibrium ("near equilibrium" means that T is within 5 K of T_o).

(a) At T = 1282 K G^o = kJ/mol, and the reaction is

---Select---

spontaneous

nonspontaneous

near equilibrium under standard conditions.

(b) At T = 1923 K G^o = kJ/mol, and the reaction is

---Select---

spontaneous

nonspontaneous

near equilibrium under standard conditions.

(c) At T = 641 K G^o = kJ/mol, and the reaction is

---Select---

spontaneous

nonspontaneous

near equilibrium under standard conditions.

Forecasting labour costs is a key aspect of hotel revenue management that enables hoteliers to appropriately allocate hotel resources and fix pricing strategies. Mary, the President of Hellenic Hoteliers Federation (HHF) is interested in investigating how labour costs (variable L_COST) relate to the number of rooms in a hotel (variable Total_Rooms). Suppose that HHF has hired you as a business analyst to develop a linear model to predict hotel labour costs based on the total number of rooms per hotel using the data provided.

3.1 Use the least squares method to estimate the regression coefficients b0 and b1

3.2 State the regression equation

3.3 Plot on the same graph, the scatter diagram and the regression line

3.4 Give the interpretation of the regression coefficients b0 and b1 as well as the result of the t-test on the individual variables (assume a significance level of 5%)

3.5 Determine the correlation coefficient of the two variables and provide an interpretation of its meaning in the context of this problem 3.6 Check statistically, at the 0.05 level of significance whether there is any evidence of a linear relationship between labour cost and total number of rooms per hotel

I need only the 3.4 and 3.5 questions.

Total_Rooms   L_COST
412   2.165.000
313   2.214.985
265   1.393.550
204   2.460.634
172   1.151.600
133   801.469
127   1.072.000
322   1.608.013
241   793.009
172   1.383.854
121   494.566
70   437.684
65   83.000
93   626.000
75   37.735
69   256.658
66   230.000
54   200.000
68   199.000
57   11.720
38   59.200
27   130.000
47   255.020
32   3.500
27   20.906
48   284.569
39   107.447
35   64.702
23   6.500
25   156.316
10   15.950
18   722.069
17   6.121
29   30.000
21   5.700
23   50.237
15   19.670
8   7.888
20  
11  
15   3.500
18   112.181
23  
10   30.000
26   3.575
306   2.074.000
240   1.312.601
330   434.237
139   495.000
353   1.511.457
324   1.800.000
276   2.050.000
221   623.117
200   796.026
117   360.000
170   538.848
122   568.536
57   300.000
62   249.205
98   150.000
75   220.000
62   50.302
50   517.729
27   51.000
44   75.704
33   271.724
25   118.049
42  
30   40.000
44  
10   10.000
18   10.000
18  
73   70.000
21   12.000
22   20.000
25   36.277
25   36.277
31   10.450
16   14.300
15   4.296
12  
11  
16   379.498
22   1.520
12   45.000
34   96.619
37   270.000
25   60.000
10   12.500
270   1.934.820
261   3.000.000
219   1.675.995
280   903.000
378   2.429.367
181   1.143.850
166   900.000
119   600.000
174   2.500.000
124   1.103.939
112   363.825
227   1.538.000
161   1.370.968
216   1.339.903
102   173.481
96   210.000
97   441.737
56   96.000
72   177.833
62   252.390
78   377.182
74   111.000
33   238.000
30   45.000
39   50.000
32   40.000
25   61.766
41   166.903
24   116.056
49   41.000
43   195.821
9  
20   96.713
32   6.500
14   5.500
14   4.000
13   15.000
13   9.500
53   48.200
11   3.000
16   27.084
21   30.000
21   20.000
46   43.549
21   10.000

Forecasting labour costs is a key aspect of hotel revenue management that enables hoteliers to appropriately allocate hotel resources and fix pricing strategies. Mary, the President of Hellenic Hoteliers Federation (HHF) is interested in investigating how labour costs (variable L_COST) relate to the number of rooms in a hotel (variable Total_Rooms). Suppose that HHF has hired you as a business analyst to develop a linear model to predict hotel labour costs based on the total number of rooms per hotel using the data provided.

3.1 Use the least squares method to estimate the regression coefficients b0 and b1

3.2 State the regression equation

3.3 Plot on the same graph, the scatter diagram and the regression line

3.4 Give the interpretation of the regression coefficients b0 and b1 as well as the result of the t-test on the individual variables (assume a significance level of 5%)

3.5 Determine the correlation coefficient of the two variables and provide an interpretation of its meaning in the context of this problem 3.6 Check statistically, at the 0.05 level of significance whether there is any evidence of a linear relationship between labour cost and total number of rooms per hotel

Total_Rooms   L_COST
412   2.165.000
313   2.214.985
265   1.393.550
204   2.460.634
172   1.151.600
133   801.469
127   1.072.000
322   1.608.013
241   793.009
172   1.383.854
121   494.566
70   437.684
65   83.000
93   626.000
75   37.735
69   256.658
66   230.000
54   200.000
68   199.000
57   11.720
38   59.200
27   130.000
47   255.020
32   3.500
27   20.906
48   284.569
39   107.447
35   64.702
23   6.500
25   156.316
10   15.950
18   722.069
17   6.121
29   30.000
21   5.700
23   50.237
15   19.670
8   7.888
20  
11  
15   3.500
18   112.181
23  
10   30.000
26   3.575
306   2.074.000
240   1.312.601
330   434.237
139   495.000
353   1.511.457
324   1.800.000
276   2.050.000
221   623.117
200   796.026
117   360.000
170   538.848
122   568.536
57   300.000
62   249.205
98   150.000
75   220.000
62   50.302
50   517.729
27   51.000
44   75.704
33   271.724
25   118.049
42  
30   40.000
44  
10   10.000
18   10.000
18  
73   70.000
21   12.000
22   20.000
25   36.277
25   36.277
31   10.450
16   14.300
15   4.296
12  
11  
16   379.498
22   1.520
12   45.000
34   96.619
37   270.000
25   60.000
10   12.500
270   1.934.820
261   3.000.000
219   1.675.995
280   903.000
378   2.429.367
181   1.143.850
166   900.000
119   600.000
174   2.500.000
124   1.103.939
112   363.825
227   1.538.000
161   1.370.968
216   1.339.903
102   173.481
96   210.000
97   441.737
56   96.000
72   177.833
62   252.390
78   377.182
74   111.000
33   238.000
30   45.000
39   50.000
32   40.000
25   61.766
41   166.903
24   116.056
49   41.000
43   195.821
9  
20   96.713
32   6.500
14   5.500
14   4.000
13   15.000
13   9.500
53   48.200
11   3.000
16   27.084
21   30.000
21   20.000
46   43.549
21   10.000

A highway is to be built between two towns, one of which lies 33.5 km south and 70.8 km west of the other. (a) What is the shortest length of highway that can be built between the two towns, and (b) at what angle would this highway be directed, as a positive angle with respect to due west?

why have oligopoly tech firms ( microsoft, apple) with near monopolies in their own sectors sought to compete with tech firms that have extremely strong, near monopoly positions in other sectors. Does this defy game theory or support it? Explain

Mikes Pizza Parlor chains operates restaurants located in a five state area. The most successful locations for Mike’s Pizza Parlor are near college campuses. The managers believe that quarterly sales for these restaurants are related positively to the size of the student population. In other words, restaurants located near campuses with a large population tend to generate more sales than those located near campuses with smaller populations. Using regression analysis, what is the dependent and independent variable to use? Explain. Then, provide a separate example on your own.

1. The mass of Earth is 5.972 * 10²⁴ kg, and the radius of Earth is 6,371 km. The mass of the moon is 7.348 * 10²² kg, and the radius of the moon is 1,737 km. The centers of the Earth and the moon are separated by 384,400 km.

2. (3A) What is the magnitude of the gravitational acceleration (in m/s²) due to the moon at the near-side surface of Earth? (Hint: The correct answer is between 0.000001 and 5).
3. (3B) How does the gravitational acceleration due to the moon at the near-side surface of Earth compare to the gravitational acceleration due to Earth at the surface of Earth (i.e., what value is g_{moon at surface of Earth} / g_{Earth at surface of Earth})?
4. (3C) What is the magnitude of the gravitational acceleration (in m/s²) due to the moon at the surface of the moon? (Hint: The correct answer is between 0.1 and 50).
5. (3D) What is the magnitude of the gravitational acceleration (in m/s²) due to Earth at the near-side surface of the moon? (Hint: The correct answer is between 0.0001 and 5).
6. (3E) How does the gravitational acceleration due to Earth at the near-side surface of the moon compare to the gravitational acceleration due to the moon at the surface of the moon (i.e., what value is g_{Earth at surface of moon} / g_{moon at surface of moon})? (Hint: The correct answer is between 0.00001 and 5).
7. (3F) Which force is stronger, the gravitational force due to the moon at the near-side surface of Earth, or the gravitational force due to Earth at the near-side surface of the moon?