Question
This is all the information that I have. Start Excel. Open the downloaded spreadsheet named e05ch10_grader_a1_Float.xlsx . Save the file with the name e05ch10_grader_a1_Float_LastFirst ,
This is all the information that I have.
Start Excel. Open the downloaded spreadsheet named e05ch10_grader_a1_Float.xlsx. Save the file with the name e05ch10_grader_a1_Float_LastFirst, using your last and first name. If necessary, enable the content. |
The company would like a break-even analysis completed. On the Break-Even Analysis worksheet, enter the correct formula to calculate the Gross Revenue in cell D7. |
Enter the correct formula to calculate the Total Fixed Costs in D13. |
Enter the correct formula to calculate the Total Variable Costs in D17. |
Enter the correct formula to calculate the Net Income in D18. |
Management thinks an average of 75 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 75 guests per day and $0 in Net Income. |
Fill in the Expenses, Revenue, and Net Income columns (range G4:I19) using a data table. |
Format the range G4:I19 as Currency. |
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. |
Create a data table to compute Net Income in the range F5:N22. The price (row 6) needs to start at $3 and increase to $10 in $1 increments, and the number of guest (column F) needs to start at 25 and increase in increments of 5. |
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. |
Format cell F6 to hide the result of the formula in the cell. |
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. |
Add a scroll bar to the right of the inserted cells in column F that will change the days of operations per year between the values of 200 and 250 one day at a time. Enter the text Days of Operations in cell F4 and center the text. |
Add a scroll bar to the right of the first scroll bar in column I that will change the price between the values of $3 and $10 by $1 increments. Enter the text Price in cell I4. |
= =
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started