This is a two part assignment. The assignment will be done on excel and Word. On

Posted: September 25th, 2023

This is a two part assignment. The assignment will be done on excel and Word. On excel, please complete the following:
1) compute contribution margin for each channel
2) compute break even point (in terms of number of orders and dollars) for each distribution channel
(HINT  - Fixed costs are all trade show expenses.  Use depreciation for the booth as a fixed cost.  The booth cost should be considered an investment not a fixed cost)
3) Calculate the number of orders at a target profit of $100,000
4) Calculate the profitability for both the low and high order estimates
On Word complete the following:
1) Discuss the pros & cons of each sales channel