Q1 dropdown options)

• special-order sales revenue
• direct materials cost
• variable service overhead cost
• direct housekeeping labor cost
• facilities inspection cost
• safety approval visit cost
• all of the above choices

Q2 dropdown options)

• relevant revenues
• relevant costs
• relevant decrease in profit

Q3 dropdown options)

• brand reputation
• brand design
• brand quality

Relevant Analysis, Cost-Based Pricing, Cost Behavior, and Net Present Value Analysis for Superior Stay Resorts Special-Order Offer Relevant Analysis properties!". The annual costs incurred by Superior to fulfill 1,000,000 occupied guest room nights are as follows: 2. Create a spreadsheet that contains the model inputs you included in your completed table (from Requirement 1 ). Using your spreadsheet. a. Calculate the relevant revenues associated with the special-order offer. $ b. Calculate the relevant costs associated with the special-order offer. $ $ 3. Based solely on financial factors, explain why Superior should accept or reject Barnyard's special-order offer. The relevant cost is than the relevant revenue offered by Barnyard, making the relevant (or incremental) profit of -so, their perception of Superior's overall , exclusivity, or overall level of luxury if they learned that Superior was renting its Premier Resort at a price that likely is well below the typical Superi 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. previous table represent 500 inspections during the year. would require Superior bear the $150,000 cost of the Safety Committee's approval visit. Required: 1. Conduct a relevant analysis of the special-order offer by calculating the following: 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: b. If Superior were to accept the special-order offer which variable is included in your model: c. Using your variables from requirement 1a, select out your model