Complete problem P9.5

The attached workbook should help you in solving the problem: Assignment10Workbook.xlsx

please I need help with this assignment.

Complete problem P9.5

The attached workbook should help you in solving the problem:

Complete problem P9.5

The attached workbook should help you in solving the problem:

and I put the page from the book too this all information I have.

View He Review Data Formulas Page Layout Home Insert ' ' == Calibri a. Ar === V v Paste B U Alignn 12 Font Clipboard 17 X fx F G E D A B C P9.5 $800,000 $900,000 $1,000,000 Sales Revenue Variable Cost Contribution Margin Fixed Costs Operating Income Tax Rate $154,000 $154,000 $154,000 $0 $0 $0 Net Income Break Even: Sheet1 P9.5 $800,000 $900,000 $1,000,000 Sales Revenue Variable Cost Contribution Margin Fixed Costs Operating Income Tax Rate Net Income $154,000 $154,000 $154,000 $0 $0 $0 Break Even: P9.5 $800,000 $900,000 $1,000,000 Sales Revenue Variable Cost Contribution Margin Fixed Costs Operating Income Tax Rate $154,000 $154,000 $154,000 $0 $0 Net Income $0 Break Even: Calculate the budgeted sales revenue for the coffee shop for January. P9.5 The manager of Buff's Buffet is preparing next year's budget. She wants to prepare a flexible budget for three different annual sales revenue lev- els using a contribution margin income statement. Three levels of sales revenue are to be used: $800,000, $900,000, $1,000,000. The following information is available to help prepare the flexible budget. Food cost averages 38% and variable costs averages 28% of sales revenue. Fixed labor cost is $52,000 annually, and other fixed costs are $120,000. Other variable costs average 10% of sales revenue. Income tax rate is estimated to be 29% on operating income (before tax). Using the given information, prepare Buff's flexible three-level budget using the contribution margin method. Also calculate the breakeven sales. Comment on the results of each budget level with particular reference to the effect of higher sales revenue on net income (after tax)