Problem: The Walton Company produces a specific item with the following information:
Sales Price $400 per unit
Variable Costs $100 per unit
Fixed Costs $150,000
Units Produced and Sold 2,000
Please use MS EXCEL to:
1) Calculate Net Income
2) Calculate the Contribution Margin per unit
3) Calculate the Contribution Margin Ratio
4) If the Walton Company sells 500 more additional units, by what amount will net income increase?
5) If the Walton Company has an additional $20,000 in sales, by what amount will net income increase?