Williams Company: compute break even chart

Please see the attached files. They include the instruction sheet and excel file (there are 2 sheets in this file).

COST-VOLUME-PROFIT (BREAK-EVEN)

Instructions and data to calculate break-even, target profit stated as before taxes and after taxes, under-performance losses for The Williams Company as well as preparing a break-even chart.

Instructions: You will need a small calculator to complete the assignment.

1) Enter your start time and remind yourself to keep track of the elapsed time.
2) Enter the appropriate amounts in the "yellow boxes" needed to calculate the various results. as we did in class. Enter the results in the "tan boxes"
3) Upon completing Sheet 1 of 2 sheets, you are to prepare a Break-even chart on Sheet 2, using the "line-drawing tool" at the bottom of the worksheet ("").
4) Print out this instruction sheet to remind yourself of the instructions.
5) When you are ready to begin, activate the worksheet link below to down-load the spreadsheet, where you will enter the required information and prepare the Break-even chart. When asked, Don't Update!
6) Enter your name on the first page of the spreadsheet in the box shown. Note: Failure to do so will cause your work not to be identified and no credit for the exam will be given.
7) When you are finished, save the spread sheet to the Drop Box with the title "Week 3: Class Assignment" and the assignment will be finished.

Requirements:

1) Record in the appropriate areas of the spreadsheet the correct values for
each designated "yellow" cell and each designated "tan" cell.
2) Prepare the Break-even chart from the information generated on Page 1,
Sheet 1 using the "line drawing tool" at the bottom of the sheet ("").
3) You must submit your answers two "work-days" prior to the next class session.