COMMERCE 3QA3 Lecture Notes - Lecture 2: Kilogram, Profit Margin, Work Breakdown Structure
Document Summary
Practice questions (answers are on the last page) Exam 1 will have a business decision model question like this one. Excel problem 1. (4 marks for question, 6 marks for excel file) A small business owner wants to develop an excel decision model to calculate how much business income tax she should pay each quarter. Her business has two revenue sources: wholesale revenue and retail revenue. The following probability distributions describe the revenue from each source. Wholesale revenue can be reduced by up to 35-percent for wholesale business expenses. Retail revenue can be reduced by up to 55-percent for retail business expenses. The remaining revenue can be reduced by up to ,000 for personal expenses. The business income tax rate is 25-percent on the first ,000 of revenue after deductions and 45-percent on revenue after deductions over ,000: open a new excel workbook and worksheet. 0. 2: construct an excel business decision model.