Integrative Exercise Relevant Analysis, Cost-Based Pricing, Cost Behavior, and Net Present Value Analysis for Superior Stay Resorts

Special-Order Offer Relevant Analysis

Superior Stay Resorts provides luxurious hotel accommodations to its high-end customer base. Superior measures business volume by the total number of occupied guest room nights during the year. For each of the past several years, Superior's sales have been considerably less than the expected annual volume of 1,200,000 total guest room nights. Therefore, the company ends each year with significant unused capacity. Given its high-fixed cost structure, Superior's profitability hinges on increasing the number of occupied guest room nights (i.e., decreasing unused capacity) throughout the year. As a result, Superior's Controller, Jack, has decided to seek out potential special-order offers from other companies. Superior's top propertyPremier Resortsits adjacent to an expansive outdoor event spaceThe Barnyardthat hosts large festivals, music concerts, boat and RV shows, rodeos, fairs, and various other athletic competitions. Superior received an offer from Barnyard's management to rent 10,000 Premier Resort guest rooms for its December event attendees at a price of $130 per guest room. Jack was excited, noting that, "This is a great way for us to make use of one of our most premier properties!".

The annual costs incurred by Superior to fulfill 1,000,000 occupied guest room nights are as follows:

Line Item Description	Amount
Variable costs per occupied guest room night:
Direct materials (e.g., specialized shampoos, slippers, lotions, candles, etc.)	$25
Variable service overhead (e.g., marble floor polish)	$30
Sales commissions	$50
Direct housekeeping labor (e.g., room cleaning)	$70
Total fixed costs:
Advertising	$ 1,500,000
Property lease and insurance	$ 4,500,000
Facility inspection	$10,000,000
Customer service online platform	$ 800,000
Landscaping	$ 1,200,000

In addition, Jack met with several of Superior's key service area managers and discovered the following additional information:

The special-order could be fulfilled without incurring any additional marketing or customer service costs.

Superior leases the Premier Resort through a multiyear contract that was renewed at the beginning of the current year.

Superior incurs costs to meticulously inspect the cleanliness and structural integrity of its facilities at particular intervals based on the current number of occupied guest rooms for the year. The total room inspection costs shown in the previous table represent 500 inspections during the year.

Barnyard requires that its Safety Committee visit and approve any hotel facility to which it sends its customers. The Safety Committee only conducts its approval the first time it uses a particular facility. The terms of the special-order offer would require Superior bear the $150,000 cost of the Safety Committee's approval visit.

Finally, Jack wants to utilize a predictive data analytics perspective (Refer to Exhibit 2.2) to conduct the various analyses needed to properly evaluate Barnyards special-order offer and decide whether to accept or reject it.

Required:

1. Conduct a relevant analysis of the special-order offer by calculating the following:

To assist Jack, create a model (i.e., formula) with the relevant revenues and relevant costs (i.e., the independent variables) to use in forecasting the relevant profit (i.e., the dependent variable) that would result if Superior were to accept the special-order offer. To help develop your model, complete the following table including the details of your model inputs (use as many bullet points as necessary).

a. Select the independent variables (without dollar amounts) in your model:

Special-order sales revenueDirect materials costVariable service overhead costDirect housekeeping labor costFacilities inspection costSafety approval visit costAll of the above choices.

b. If Superior were to accept the special-order offer which variable is included in your model:

Special-order sales revenueDirect materials costVariable service overhead costDirect housekeeping labor costFacilities inspection costSafety approval visit costAll of the above choices.

c. Using your variables from requirement 1a, select out your model:

Relevant profit = Special-Order Relevant Sales Revenues + Special-Order Relevant CostsRelevant profit = Special-Order Relevant Sales Revenues x Special-Order Relevant CostsRelevant profit = Special-Order Relevant Sales Revenues - Special-Order Relevant Costs