Sam's Cat Hotel operates 52 weeks per year, 7 days per week, and uses a continuous review inventory system. It purchases kitty litter for $10.75 per bag. The following information is available about these bags. Refer to the standard normal table for z-values.
>Demand 95 bags/week
>Order cost $56/order
>Annual holding cost = 30 percent of cost
>Desired cycle-service level = 99 percent
>Lead time = 4 week(s) (28 working days)
>Standard deviation of weekly demand = 20 bags
>Current on-hand inventory is 325 bags, with no open orders or backorders

a. What is the EOQ?
Sam's optimal order quantity is _______ bags. (Enter your response rounded to the nearest whole number.)
What would be the average time between orders (in weeks)?
The average time between orders is _______ weeks. (Enter your response rounded to one decimal place.)
b. What should R be? The reorder point is 118 bags. (Enter your response rounded to the nearest whole number.)
c. An inventory withdrawal of 10 bags was just made. Is it time to reorder?
It is not time to reorder.
d. The store currently uses a lot size of 490 bags (i.e., Q 490). What is the annual holding cost of this policy?
The annual holding cost is $ 817.08. (Enter your response rounded to two decimal places.)
What is the annual ordering cost?
The annual ordering cost is $ 615.51. (Enter your response rounded to two decimal places.)
Without calculating the EOQ, how can you conclude from these two calculations that the current lot size is too large?
A. There is not enough information to determine this.
B. When Q 490, the annual holding cost is less then the ordering cost, therefore Q is too small.
C. When Q 490, the annual holding cost is larger than the ordering cost, therefore Q is too large.
D. Both quantities are appropriate
e. What would be the annual cost saved by shifting from the 490-bag lot size to the EOQ?
The annual holding cost with the EoQ is S 708.69. (Enter your response rounded to two decimal places.)
The annual ordering cost with the EOQ is $ 709.65. (Enter your response rounded to two decimal places.)
Therefore, Sam's Cat Hotel saves $ 14.25 by shifting from the 490-bag lot size to the EOQ. (Enter your response rounded to two decimal places.)
In: Other
Q: During a televised, title prize fight at a Las Vegas hotel, Luis threw a punch which hit Michael in the face. As a result:
a: This would ordinarily be an act of negligence, however since Michael consented to the fight, he has no viable legal action against Luis. INCORRECT
b: This would ordinarily constitute strict liability for engaging in an inherently dangerous activity, however since Michael consented to the fight, he has no viable legal action against Luis.
c: This would ordinarily be an action of intentional infliction of emotional distress, however since Michael consented to the fight, he has no viable legal action against Luis.
d: This would ordinarily be a battery, however since Michael consented to the fight, he has no viable legal action against Luis.
In: Finance
Problem 8-21 (Algorithmic)
Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business. The profit per night for each type of room and rental class is as follows:
| Rental Class | ||||
Room |
Super Saver | Deluxe | Business | |
| Type I | $36 | $38 | — | |
| Type II | $15 | $26 | $38 | |
Type I rooms do not have wireless Internet access and are not available for the Business rental class.
Round Tree's management makes a forecast of the demand by rental class for each night in the future. A linear programming model developed to maximize profit is used to determine how many reservations to accept for each rental class. The demand forecast for a particular night is 140 rentals in the Super Saver class, 60 rentals in the Deluxe class, and 40 rentals in the Business class. Round Tree has 125 Type I rooms and 135 Type II rooms.
| Variable | # of reservations |
|---|---|
| SuperSaver rentals allocated to room type I | |
| SuperSaver rentals allocated to room type II | |
| Deluxe rentals allocated to room type I | |
| Deluxe rentals allocated to room type II | |
| Business rentals allocated to room type II |
| Rental Class | # of reservations |
|---|---|
| SuperSaver | |
| Deluxe | |
| Business |
In: Operations Management
Hanson Inn is a 96-room hotel located near the airport and convention center in Louisville, Kentucky. When a convention or a special event is in town, Hanson increases its normal room rates and takes reservations based on a revenue management system. The Classic Corvette Owners Association scheduled its annual convention in Louisville for the first weekend in June. Hanson Inn agreed to make at least 50% of its rooms available for convention attendees at a special convention rate in order to be listed as a recommended hotel for the convention. Although the majority of attendees at the annual meeting typically request a Friday and Saturday two-night package, some attendees may select a Friday night only or a Saturday night only reservation. Customers not attending the convention may also request a Friday and Saturday two-night package, or make a Friday night only or Saturday night only reservation. Thus, six types of reservations are possible: convention customers/two-night package; convention customers/Friday night only; convention customers/Saturday night only; regular customers/two-night package; regular customers/Friday night only; and regular customers/Saturday night only.
The cost for each type of reservation is shown here:
| Two-Night Package |
Friday Night Only |
Saturday Night Only |
|
| Convention | $225 | $123 | $130 |
| Regular | $295 | $146 | $152 |
The anticipated demand for each type of reservation is as follows:
| Two-Night Package |
Friday Night Only |
Saturday Night Only |
|
| Convention | 40 | 20 | 15 |
| Regular | 20 | 30 | 25 |
Hanson Inn would like to determine how many rooms to make available for each type of reservation in order to maximize total revenue.
| Let | CT = number of convention two-night rooms |
| CF = number of convention Friday only rooms | |
| CS = number of convention Saturday only rooms | |
| RT = number of regular two-night rooms | |
| RF = number of regular Friday only rooms | |
| RS = number of regular Saturday only room |
| CT | + | CF | + | CS | + | RT | + | RF | + | RS |
| CT | + | CF | + | CS | + | RT | + | RF | + | RS |
| S.T. |
| 1) | CT | ||||||||
| 2) | CF | ||||||||
| 3) | CS | ||||||||
| 4) | RT | ||||||||
| 5) | RF | ||||||||
| 6) | RS | ||||||||
| 7) | CT | + | CF | ||||||
| 8) | CT | + | CS | ||||||
| 9) | CT | + | CF | + | RT | + | RF | ||
| 10) | CT | + | CS | + | RT | + | RS | ||
| 11) | CT, | CF, | CS, | RT, | RF, | RS | 0 |
| Variable | Value |
| CT | |
| CF | |
| CS | |
| RT | |
| RF | |
| RS |
In: Advanced Math
A hotel has 100 rooms. On any given night, it takes up to 105 reservations, because of the possibility of no-shows. Past records indicate that the number of daily reservations is uniformly distributed over the range 96-105. That is, each integer number in this range has a probability of 10%, of showing up. The no-shows are represented by the distribution in the table below.
| Number of No-Shows | Probability |
| 0 | 15% |
| 1 | 20% |
| 2 | 35% |
| 3 | 15% |
| 4 | 15% |
Based on your thirty simulations, determine the following measures of performance of this booking system: the expected number of rooms used per night and the percentage of nights when more than 100 rooms are claimed. (Show your simulations and any other information used in the analysis. Don’t send any worksheet.)
In: Finance
Scenario: Chief Complaint: Fever , AIDS. 40 year old white male resides at the hotel and lives on social security disability; diagnosed with AIDS, end stage, addiction, and agoraphobia presents with fever X2 weeks, no thermometer available, diarrhea daily. He tends to miss appointments because of his extreme anxiety in public places. He has not been on antiretroviral therapy due to his inability to regularly take medications. He is not in contact with case management, but there is a special hospice for homeless people with AIDS and perhaps it might be time to consider a referral for more supportive services.
Vital signs: 100/70 64 18 99.8 BMI:17 Gen: thin white male
skin: dry and flacking multiple nevi ruddy complexion, red flaky, rash on naso/ labial folds, and scalp + DANDROFF
HEENT: Poor definition, gengevitus, shotty lymph nodes posterior / Anterior cervical.
Question: How would APRN (Nurse practitioner) prepare for home visit? Explore the practical concerns, the equipment APRN need to bring, and goals for the patient’s care.
Question: What might you want as Nurse practitioner to know from the case management and supportive services team?
Question: What specific things would you assess as Nurse practitioner at this visit?
Question: What are the essential elements of the history and physical today?
Question: What is your assessment as Nurse Practitioner ?
Question: What is your plan?
In: Nursing
HomeSuites is a chain of all-suite, extended-stay hotel properties. The chain has 20 properties with an average of 150 rooms in each property. In year 1, the occupancy rate (the number of rooms filled divided by the number of rooms available) was 70 percent, based on a 365-day year. The average room rate was $215 for a night. The basic unit of operation is the “night,” which is one room occupied for one night.
The operating income for year 1 is as follows:
| HomeSuites | |||
| Operating Income | |||
| Year 1 | |||
| Sales revenue | |||
| Lodging | $ | 138,130,000 | |
| Food & beverage | 22,995,000 | ||
| Miscellaneous | 12,264,000 | ||
| Total revenues | $ | 173,389,000 | |
| Costs | |||
| Labor | $ | 58,142,500 | |
| Food & beverage | 18,396,000 | ||
| Miscellaneous | 13,797,000 | ||
| Management | 2,516,000 | ||
| Utilities, etc. | 37,500,000 | ||
| Depreciation | 10,500,000 | ||
| Marketing | 11,000,000 | ||
| Other costs | 4,200,000 | ||
| Total costs | $ | 156,051,500 | |
| Operating profit | $ | 17,337,500 | |
In year 1, the average fixed labor cost was $416,000 per property. The remaining labor cost was variable with respect to the number of nights. Food and beverage cost and miscellaneous cost are all variable with respect to the number of nights. Utilities and depreciation are fixed for each property. The remaining costs (management, marketing, and other costs) are fixed for the firm.
At the beginning of year 2, HomeSuites will open six new properties with no change in the average number of rooms per property. The occupancy rate is expected to remain at 70 percent. Management has made the following additional assumptions for year 2:
The average room rate will increase by 8 percent.
Food and beverage revenues per night are expected to decline by 15 percent with no change in the cost.
The labor cost (both the fixed per property and variable portion) is not expected to change.
The miscellaneous cost for the room is expected to increase by 20 percent, with no change in the miscellaneous revenues per room.
Utilities and depreciation costs (per property) are forecast to remain unchanged.
Management costs will increase by 6 percent, and marketing costs will increase by 8 percent.
Other costs are not expected to change.
The managers of HomeSuites are considering different pricing strategies for year 2. Under the first strategy (“High Price”), they will work to maintain an average price of $285 per night. They realize that this will reduce demand and estimate that the occupancy rate will fall to 60.0 percent with this strategy. Under the alternative strategy (“High Occupancy”), they will work to increase the occupancy rate by lowering the average price. They estimate that with an average nightly rate of $194, they can achieve an occupancy rate of 80 percent. The current estimated profit is $75,358,035.
Required:
a. Prepare a budgeted income statement for year 2 if the “High Price” strategy is adopted. (Round your per unit average cost calculations to 2 decimal places.)
b. Prepare a budgeted income statement for year 2 if the “High Occupancy” strategy is adopted. (Round your per unit average cost calculations to 2 decimal places.)
c. Which is the correct pricing strategy for year 2.
| High Price Strategy | |
| High Occupancy Strategy | |
| Current Strategy |
In: Accounting
A hotel has 8 air conditioners that each have a pre- determined area liberation rate. The carbon dioxide (COx) emission rates (in ppm) are measured for each. The pollution rate is expected to be a linear function of the area liberation rate.
(a) Write out the equation of the regression line. Interpret the slope and intercept in the context of this problem. Do they make sense? Include a scatter plot of the data with the correct regression line added.
(b) Test the hypothesis that the linear relationships exist between the predictor and response variable (ANOVA, t-test for β1, t-test for ρ, or a confidence interval for β1).
(c) What is the R2 for the SLR you have obtained? What does the value mean? Use it to evaluate the linear model.
(d) Plot the standardized residuals against the independent variable. What can you say about the regression using this graph? (HINT: Are there outliers? Does it seem reasonable to claim the data has a linear fit?)
|
Area Liberation Rate |
Carbon Dioxide Emission Rate |
|
100 |
131 |
|
100 |
133 |
|
125 |
169 |
|
125 |
178 |
|
150 |
207 |
|
150 |
203 |
|
175 |
256 |
|
175 |
257 |
|
200 |
306 |
|
200 |
298 |
|
225 |
341 |
|
225 |
350 |
|
250 |
399 |
|
250 |
387 |
|
275 |
437 |
|
275 |
426 |
|
300 |
483 |
|
300 |
478 |
|
350 |
565 |
|
350 |
564 |
|
400 |
654 |
|
400 |
655 |
|
450 |
737 |
|
450 |
745 |
In: Statistics and Probability
HomeSuites is a chain of all-suite, extended-stay hotel properties. The chain has 24 properties with an average of 200 rooms in each property. In year 1, the occupancy rate (the number of rooms filled divided by the number of rooms available) was 80 percent, based on a 365-day year. The average room rate was $220 for a night. The basic unit of operation is the “night,” which is one room occupied for one night.
The operating income for year 1 is as follows.
| HomeSuites | |||
| Operating Income | |||
| Year 1 | |||
| Sales revenue | |||
| Lodging | $ | 138,170,000 | |
| Food & beverage | 29,433,600 | ||
| Miscellaneous | 14,016,000 | ||
| Total revenues | $ | 181,619,600 | |
| Costs | |||
| Labor | $ | 66,144,000 | |
| Food & beverage | 21,024,000 | ||
| Miscellaneous | 14,016,000 | ||
| Management | 2,520,000 | ||
| Utilities, etc. | 38,400,000 | ||
| Depreciation | 12,000,000 | ||
| Marketing | 14,000,000 | ||
| Other costs | 7,000,000 | ||
| Total costs | $ | 175,104,000 | |
| Operating profit | $ | 6,515,600 | |
In year 1, the average fixed labor cost was $420,000 per property. The remaining labor cost was variable with respect to the number of nights. Food and beverage cost and miscellaneous cost are all variable with respect to the number of nights. Utilities and depreciation are fixed for each property. The remaining costs (management, marketing, and other costs) are fixed for the firm.
At the beginning of year 2, HomeSuites will open four new properties with no change in the average number of rooms per property. The occupancy rate is expected to remain at 80 percent. Management has made the following additional assumptions for year 2.
The managers of HomeSuites are considering different pricing strategies for year 2. Under the first strategy (“High Price”), they will work to maintain an average price of $230 per night. They realize that this will reduce demand and estimate that the occupancy rate will fall to 70.0 percent with this strategy. Under the alternative strategy (“High Occupancy”), they will work to increase the occupancy rate by lowering the average price. They estimate that with an average nightly rate of $190, they can achieve an occupancy rate of 90 percent. The current estimated profit is $259,025,200.
Required:
a. Prepare a budgeted income statement for year 2 if the “High Price” strategy is adopted.
b. Prepare a budgeted income statement for year 2 if the “High Occupancy” strategy is adopted.
c. Which is the correct pricing strategy for year 2.
In: Accounting
The Sandhill Hotel opened for business on May 1, 2022. Here is
its trial balance before adjustment on May 31.
| SANDHILL
HOTEL Trial Balance May 31, 2022 |
||||||
|---|---|---|---|---|---|---|
|
Debit |
Credit |
|||||
|
Cash |
$ 2,523 | |||||
|
Supplies |
2,600 | |||||
|
Prepaid Insurance |
1,800 | |||||
|
Land |
15,023 | |||||
|
Buildings |
72,400 | |||||
|
Equipment |
16,800 | |||||
|
Accounts Payable |
$ 4,723 | |||||
|
Unearned Rent Revenue |
3,300 | |||||
|
Mortgage Payable |
38,400 | |||||
|
Common Stock |
60,023 | |||||
|
Rent Revenue |
9,000 | |||||
|
Salaries and Wages Expense |
3,000 | |||||
|
Utilities Expense |
800 | |||||
|
Advertising Expense |
500 |
|||||
|
$115,446 |
$115,446 |
|||||
Other data:
| 1. | Insurance expires at the rate of $300 per month. | |
| 2. | A count of supplies shows $1,190 of unused supplies on May 31. | |
| 3. | (a) Annual depreciation is $3,240 on the building. | |
| (b) Annual depreciation is $2,640 on equipment. | ||
| 4. | The mortgage interest rate is 5%. (The mortgage was taken out on May 1.) | |
| 5. | Unearned rent of $2,600 has been earned. | |
| 6. |
Salaries of $770 are accrued and unpaid at May 31. |
Prepare an adjusted trial balance on May 31.
|
SANDHILL HOTEL |
||
|---|---|---|
|
Debit |
Credit |
|
|
enter an account title |
$enter a debit balance |
$enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
enter an account title |
enter a debit balance |
enter a credit balance |
|
$enter a total for the debit column |
$enter a total for the credit column |
|
In: Accounting