For this question you will complete your answer in Excel. When you are finished, upload your response by clicking "Browse My Computer".

Robbies Ribs has the following sales and cost information:

Average selling price per pound of ribs - $11.50Variable expenses per pound:

Raw material - $3.70

Variable labor and overhead - $3.20

Annual fixed costs:

Production expenses - $37,300

Selling and Administrative expenses $15,186

The companys tax rate is 30%. The companys costs have slowly been rising and profits rapidly falling. Robbie Shaw, company president, has asked your help in answering the following questions:

What is the contribution margin per pound of ribs? The contribution margin ratio?

What is the break-even point in pounds of ribs? In dollars of sales

How much revenue must be generated to produce $24,500 after-tax income? How many pounds of ribs would this represent?