Hello,

I am having a hard time with this question. Any assistance would be greatly appreciated. If you can show how you arrived at the answer in an excel sheet, that would be good so I can learn how to work the problem. Thank you.

Ricardo's Corp produces one model of tables. Partial information for the company follows:

Required:

1. Complete Ricardo's cost data table. (Round your Cost per Unit answers to 2 decimal places.)

Tables Produced and Sold 470 Units 830 Units 1880 Units

Total costs $122,200

Variable costs

Fixed costs per year

Total costs $122,200 $0 $0

Cost per unit

Variable cost per unit

Fixed cost per unit

Total cost per unit $544.00

2. Calculate Ricardo's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $610. (Round your Margin Ratio percentage answers to 2 decimal places (i.e. .1234 should be entered as 12.34%.))

470 Units 830 Units 1880 Units

Total Contribution Margin

Contribution Margin Ratio

3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $610. (Round your answers to the nearest whole dollar amount.)

470 Units 830 Units 1880 Units

Net Operating Income (Loss