Using Excel Bishop Company has provided the estimated data that appear in rows 4 to 8 of the following spreadsheet

Required
Construct a spreadsheet as follows that would allow you to determine net income, break-even in units, and operating leverage for the estimates at the top of the spreadsheet, and to see the effects of changes to the estimates. Set up this spreadsheet so that any change in the estimates will automatically be reflected in the calculation of net income, break-even, and operating leverage. Spreadsheet Tip
To center a heading across several columns, such as the Income Statement title, highlight the area to be centered (Columns B, C, and D), choose Format, then choose Cells, and click on the tab titled Alignment. Near the bottom of the alignment window, place a check mark in the box titled Merge cells. The shortcut method to merge cells is to click on the icon near the middle of the top icons that contains an a in a box.

Transcribed Image Text:

Bishop Company Forecast for December, 2010 $ 10.00 $ 12.00 $ 60,000 Selling price per unit Variable custs per unit Fixed costs Units sold 20,000 Bishop Company Incorme Staterment For the month of December, 2010 Sales Variable costs Contribution margin $360,000 240,000 120,000 60,000 Fixed costs Net income Break even in unito 10,000 2.00 Operating leverage