Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribedimage text in transcribedimage text in transcribed

= =

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

Wiley CPAexcel Exam Review 2018 Study Guide Auditing And Attestation

Authors: Wiley

1st Edition

1119480671, 978-1119480679

More Books

Students also viewed these Accounting questions

Question

What is quality of work life ?

Answered: 1 week ago

Question

What is meant by Career Planning and development ?

Answered: 1 week ago

Question

What are Fringe Benefits ? List out some.

Answered: 1 week ago

Question

What is the preferred personality?

Answered: 1 week ago

Question

What is the relationship between humans?

Answered: 1 week ago