Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me . I am stuck thank you. begin{tabular}{|c|c|c|} hline 6 & begin{tabular}{l} Management thinks an average of 85 guests a day would be

please help me . I am stuck thank you. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
\begin{tabular}{|c|c|c|} \hline 6 & \begin{tabular}{l} Management thinks an average of 85 guests a day would be a realistic average. Use Goal \\ Seek to find out what the price would need to be to come out exactly even with 85 guests per \\ day and $0 in Net Income. \end{tabular} & 10 \\ \hline 7 & \begin{tabular}{l} A data table with conditional formatting will help to better visualize the expenses, revenues, \\ and net income of the business. Fill in the Expenses, Revenue, and Net Income columns \\ (range G4:119) using a data table. \end{tabular} & 10 \\ \hline 8 & Format the range G4:119 as Currency. & 5 \\ \hline 9 & \begin{tabular}{l} Copy the information in range A3.D18 from the Break-Even Analysis worksheet and paste it in \\ range A4.D19 on the worksheet PriceAndGuest. Keep the source column widths. \end{tabular} & 5 \\ \hline 10 & \begin{tabular}{l} 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 \end{tabular} & 10 \\ \hline 11 & \begin{tabular}{l} 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 $5,000 or greater will have a light green \\ background and dark green text. \end{tabular} & 10 \\ \hline 12 & Format cell F6 to hide the result of the formula in the cel. & 5 \\ \hline 13 & \begin{tabular}{l} Copy the information in range A3.D18 from the Break-Even Analysis sheet to the range \\ A3.D18 on the sheet DaysAndPrice. Keep the source column widths \end{tabular} & 5 \\ \hline \end{tabular} Extreme H2O Break-even Analysis for River Float Project tevenue Number Net income Guests 50 55 60 65 70 75 80 Ex 90 95 100 105 110 115 120 Extreme H2O Break-even Analysis for River Float Project \begin{tabular}{|l|l|l|} \hline & \multicolumn{1}{|c|}{ Two-Variable Dato Table } \\ \hline & Price \\ \hline & & \\ \hline \end{tabular} Extreme H2O Break-even Analysis for River Float Project

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Frank Woods Business Accounting Volume 2

Authors: Frank Wood, Alan Sangster

14th Edition

1292209178, 9781292209173

More Books

Students also viewed these Accounting questions

Question

What is your current position?

Answered: 1 week ago