Question: 10 Create a data table in the range F5:N22. The price (row 6) needs to start at $4 and increase to $11 in $1 increments,

 10 Create a data table in the range F5:N22. The price
(row 6) needs to start at $4 and increase to $11 in

10 Create a data table in the range F5:N22. The price (row 6) needs to start at $4 and increase to $11 in $1 increments, and the number of guests (column F) needs to start at 35 and increase in increments of 5. Be sure to add a reference to cell D19 in cell F6. Format the data in the data table so any net profit under $5,000 has a light red background and dark red text, data that is above or equal to $5,000 and below $5,000 will have a light. yellow background and dark yellow text, and anything $6,000 or greater will have a light green background and dark green text. 11 D Extreme H20 Break-even Analysis for River Float Project Two-Variable Data Table Price $6.00 $1.000 $12.00 $4.00 75 225 $6.21 $113,269 $5.00 35 22 $9.00 St. SILO 25 90 55 ce Revenue Average Number of Guests (per day) Days of Operations per Year Price Gross Revenue Expenses 10 Flved Costs 11 Site Development 12 Equipment 13 Insurance 14 Total Fixed Costs Variable costs 16 Labor expense (per day! 17 Transportation (per guest) 10 Total Variable costs 19 Net Income 20 Date table 21 Baw out 32 Cunninput chelt 28 DE 35 $32,200 $3,450 $1,400 $37,050 05 70 75 ES $275 $0.85 $76,219 SO ? X 90 95 100 105 110 115 : Can 29 30 31 92 19 34 the Analysis PriceAndOuest DayAndre

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!