Cost-Based Pricing A crane for Regairments 5 through 8 that Siperior rejected Barnyard a special-order offer because the $130 price nuegested by Barnyaril was too low. In response to the rejection. Barnyard asked. Superior to determine thr price at whilh it would be willing to accept the special order offer for most special arder inquiries, Superiar empleys a pricing inethad whereby price is set by marliog up relevant variable cots by 40%. 5. To atsist lack, create a spreadtheet coutaining a model for formula) with the coots (Le, the independent variables) to usu in forecasting the unit guest room price (1.e., the dependent variable) that Superior should charge Barnyard accorting to its pricine method. Comptete the following table with the detalls of your model (use as many bullet points as necassary). 6. Create a spreadsheet that contains the model inputs you iacluded in your completed table