Root Beer Data

Instructions: In the yellow cells, you will cell reference the data below. The blue cells should reference the "Root Beer Data" tab.

Make

Alternative $1-$ Produce In$-$House

Direct Materials per case

Direct Labor per case

Variable Overhead per case

Total Variable costs per case

Additional Fixed costs $($per year$)$

Selling Price Per Case

Number of cases

Sales

Total variable costs

Contribution margin

Total fixed costs

Net operating income

Contribution margin ratio

Break$-$even

Buy

Alternative $2-$ Outsource Production

Purchase price per case

Variable Overhead per case

Total Variable costs per case

Additional Fixed costs $($per year$)$