Assignment Question
Use the Amortization Spreadsheet as a starter file to keep relevant notes and formulas from this course. In the Formula Tab, create a cheat sheet with formulas for all the following calculations. Be sure to define/identify all the variables for each formula.
Assignment 3 submission: 1. Variable cost calculation for a batch of units 2. Break-even point 3. Contribution Margin 4. Calculating a Net price after discount 5. Calculating a discount based on net price and list price 6. Calculating a price after a markup is applied 7. Calculating a markup based on price and cost 8. Calculating a margin based on unit contribution and price 9. Write down the HST/GST applicable rate for shipping product out of your Ontario business to all 10 provinces 10. USD cost based on CAD posted rate 11. CAD cost based on USD posted rate
