Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me fill in charts and explain to me u will attempt to estimate, using reasonable assumptions, what a simplified contribution margin mat income
please help me fill in charts and explain to me
u will attempt to estimate, using reasonable assumptions, what a simplified contribution margin mat income statement would look like for the business you choose. For example, Step 1: Estimate how many customers per hour or day they have and guess what the average transaction size might be. It doesn't matter if you are correct, just be reasonable. Use these estimates to forecast annual revenue and annual customer or transaction counts. Step 2: Imagine their expenses and classify them into variable and fixed. List three or four of each. For example, a car repair shop might have the following costs: Variable: 4 mechanics at $30 per hour including benefits Parts cost at 20% of revenue Utilities to run the power tools $3 per transaction Fixed: Employee to answer phone, and deal with customers $40,000 per year including benefits Advertising expense on Google $2,000 per month Monthly rent on the building, $5,000 per month Business taxes paid to city $12,000 per year . . . Step 3: Use this information to build a contribution margin format income statement in Excel that is based on formulas so that you can make changes to volume or margins. 1 Step 1 - Revenue 2 3 Estimate how many customers per hour or day they have and guess what the average transaction size might be. It doesn't matter if you are correct, just be 4 reasonable. Use these estimates to forecast annual revenue and annual customer or transaction counts. 5 6. Description Input Stated Assumptions 7 of Customer's 8 Average Transaction 9 of Annual transactions 10 Annual Estimated Revenue 11 12 Step 2.viable/Fixed Expenses Imagine your business expenses and classify them into variable and feed List three or four of each Amount Stated Assumptions Variable Expense Description Amount Fixed Expense Description Suated Assumptions 9 10 1 Step 3 - Contribution Margin Income Statement 2 3 Build a contribution margin format income statement in Excel that is based on formulas so that you can make changes to volume or margins. 6 7 Income Statement 8 For the Year Ended December 2021 9 10 Total Per Unit 11 XXXXX 12 13 Less: XXXXXX 14 15 16 17 18 XXXXXXXXXX 19 20 Less: XXXXXX 21 22 23 24 25 XXXXXXXXXX 26 27 28 u will attempt to estimate, using reasonable assumptions, what a simplified contribution margin mat income statement would look like for the business you choose. For example, Step 1: Estimate how many customers per hour or day they have and guess what the average transaction size might be. It doesn't matter if you are correct, just be reasonable. Use these estimates to forecast annual revenue and annual customer or transaction counts. Step 2: Imagine their expenses and classify them into variable and fixed. List three or four of each. For example, a car repair shop might have the following costs: Variable: 4 mechanics at $30 per hour including benefits Parts cost at 20% of revenue Utilities to run the power tools $3 per transaction Fixed: Employee to answer phone, and deal with customers $40,000 per year including benefits Advertising expense on Google $2,000 per month Monthly rent on the building, $5,000 per month Business taxes paid to city $12,000 per year . . . Step 3: Use this information to build a contribution margin format income statement in Excel that is based on formulas so that you can make changes to volume or margins. 1 Step 1 - Revenue 2 3 Estimate how many customers per hour or day they have and guess what the average transaction size might be. It doesn't matter if you are correct, just be 4 reasonable. Use these estimates to forecast annual revenue and annual customer or transaction counts. 5 6. Description Input Stated Assumptions 7 of Customer's 8 Average Transaction 9 of Annual transactions 10 Annual Estimated Revenue 11 12 Step 2.viable/Fixed Expenses Imagine your business expenses and classify them into variable and feed List three or four of each Amount Stated Assumptions Variable Expense Description Amount Fixed Expense Description Suated Assumptions 9 10 1 Step 3 - Contribution Margin Income Statement 2 3 Build a contribution margin format income statement in Excel that is based on formulas so that you can make changes to volume or margins. 6 7 Income Statement 8 For the Year Ended December 2021 9 10 Total Per Unit 11 XXXXX 12 13 Less: XXXXXX 14 15 16 17 18 XXXXXXXXXX 19 20 Less: XXXXXX 21 22 23 24 25 XXXXXXXXXX 26 27 28 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started