Cost-Based Pricing Asrume for Requinemente 5 through 8 that Sup er ior rejected Bannard'y special-or der offer because the 5130 price suggented by Barnyard wastoo low, In response to the rejedion. Barnyard asked. Superior to determine the price at which it woold be willing to accept the special-order ol Ger. For most spedal-order inquiriea, Superior employs a pricing method whereby price is set by marking up relevant variable costs by 4096 . 5. To a sist Jack, create a spreadsheet containing a model (or formula) with the costs (i.e., the independent variables) to use in for ecasting the unit guest room prio (i.e. the dependent variable) that Superior thould charge Barnyard according to its pricing method. Corriplete the following table with the details of your model (use as many ballet points as necesary). 6. Create a spreadsheet that contains the model inputs you in cluded in your completed table (from Requirement 5). Using your spreadsheet and Superior's 40% markup pricing method for Barnyard's special-order offer, create a model that calculates the unit guest room price that Superior should charge Barnyard to rent each guest room if it sets the special-order sales price by using its markup pricing method. (Hint: Refer to the relevant costs that you calculated in response to Requirement 2 b.) 7. Now create another model that calculates the relevant increase or decreose in profit associated with the special-or der offer. 8. Based solely on financial factors, expla in why Superior should accept or reject the special-order offer if it uses its markup pricing method to set the special-order sales price. Cost-Based Pricing Asrume for Requinemente 5 through 8 that Sup er ior rejected Bannard'y special-or der offer because the 5130 price suggented by Barnyard wastoo low, In response to the rejedion. Barnyard asked. Superior to determine the price at which it woold be willing to accept the special-order ol Ger. For most spedal-order inquiriea, Superior employs a pricing method whereby price is set by marking up relevant variable costs by 4096 . 5. To a sist Jack, create a spreadsheet containing a model (or formula) with the costs (i.e., the independent variables) to use in for ecasting the unit guest room prio (i.e. the dependent variable) that Superior thould charge Barnyard according to its pricing method. Corriplete the following table with the details of your model (use as many ballet points as necesary). 6. Create a spreadsheet that contains the model inputs you in cluded in your completed table (from Requirement 5). Using your spreadsheet and Superior's 40% markup pricing method for Barnyard's special-order offer, create a model that calculates the unit guest room price that Superior should charge Barnyard to rent each guest room if it sets the special-order sales price by using its markup pricing method. (Hint: Refer to the relevant costs that you calculated in response to Requirement 2 b.) 7. Now create another model that calculates the relevant increase or decreose in profit associated with the special-or der offer. 8. Based solely on financial factors, expla in why Superior should accept or reject the special-order offer if it uses its markup pricing method to set the special-order sales price