For this assignment you will pick a local business that is close to you or on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For this assignment you will pick a local business that is close to you or on your route of travel. You can choose any company, but it should be different from anyone else that you know from class. Take a photo of the outside of the business and include it in your final submission. The Assignment You will attempt to estimate, using reasonable assumptions, what a simplified contribution margin format 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. Step 4: Adjust your estimates to so profit looks reasonable. If your numbers show them losing a million dollars on one location, you might want to adjust some of your assumptions. Step 5: Using the numbers, calculate the break-even sales $ and units values. Step 6: Design a "what if" scenario (eg. Increase marketing by $1,000 per month and get 10 new transactions per month) and use a copy your contribution margin income statement to estimate the change in profit. Based on the result, state your recommendation on Step 6: Design a "what if" scenario (eg. Increase marketing by $1,000 per month and get 10. new transactions per month) and use a copy your contribution margin income statement to estimate the change in profit. Based on the result, state your recommendation on implementing the change. Marks: Compiling the income statement with correct format and calculations (5 marks) Reasonableness of assumptions used (1 mark) Correctness of the break-even calculations, given the assumptions. (1 mark) Execution of the scenario and recommendation correctly (2 marks) Overall appearance, clarity, organization, spelling, and grammar (1 mark) Assignment Cost /Volume/ Profit Analysis Assignment Instructions CB203 Submission: Submit your photograph and excel file for grading. Make sure each part of your file is well-labelled and your recommendation is displayed prominently. Late assignments will not be accepted, so don't wait until the last day to submit your work. You never know if something will come up preventing you from submitting so early submission ensures your grade. For this assignment you will pick a local business that is close to you or on your route of travel. You can choose any company, but it should be different from anyone else that you know from class. Take a photo of the outside of the business and include it in your final submission. The Assignment You will attempt to estimate, using reasonable assumptions, what a simplified contribution margin format 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. Step 4: Adjust your estimates to so profit looks reasonable. If your numbers show them losing a million dollars on one location, you might want to adjust some of your assumptions. Step 5: Using the numbers, calculate the break-even sales $ and units values. Step 6: Design a "what if" scenario (eg. Increase marketing by $1,000 per month and get 10 new transactions per month) and use a copy your contribution margin income statement to estimate the change in profit. Based on the result, state your recommendation on Step 6: Design a "what if" scenario (eg. Increase marketing by $1,000 per month and get 10. new transactions per month) and use a copy your contribution margin income statement to estimate the change in profit. Based on the result, state your recommendation on implementing the change. Marks: Compiling the income statement with correct format and calculations (5 marks) Reasonableness of assumptions used (1 mark) Correctness of the break-even calculations, given the assumptions. (1 mark) Execution of the scenario and recommendation correctly (2 marks) Overall appearance, clarity, organization, spelling, and grammar (1 mark) Assignment Cost /Volume/ Profit Analysis Assignment Instructions CB203 Submission: Submit your photograph and excel file for grading. Make sure each part of your file is well-labelled and your recommendation is displayed prominently. Late assignments will not be accepted, so don't wait until the last day to submit your work. You never know if something will come up preventing you from submitting so early submission ensures your grade.
Expert Answer:
Answer rating: 100% (QA)
Accelerate Co Ltd manufactures and sells four types of products under the brand name ABC D The sales ... View the full answer
Posted Date:
Students also viewed these organizational behavior questions
-
a. On average, how many customers per hour does each sales person process? b. What is the expected value of each call to VIs toll free line? c. Suppose VI pays it phone reps $12 per hour. How many...
-
For this assignment you will be required view the following two videos on YouTube. www.youtube.com/watch?v=bKJPxCPB-RE www.youtube.com/watch?v=rUns1Jbve0w 1) After watching the video please indicate...
-
Use the Price-earnings Ratio and the DuPont Model to perform an equity analysis for The ABC firm for the years 2012 and 2013. The following financial information is available for your use: Revenue:...
-
Ito calculus and Ito's Lemma. Suppose dZ is the increment of a Wiener process and dX = (X(t), t)dt + o(X(t), t)dZ. (a) If F(X,t) = e"X, what is dF(X,t) (interpreted in the sense of Ito calculus)? (b)...
-
Discuss how logistics management must evolve to reflect the differing needs for each stage of international development
-
Tulsa Drilling Company has $1 million in 11 percent convertible bonds outstanding. Each bond has a $1,000 par value. The conversion ratio is 40, the stock price is $32, and the bonds mature in 10...
-
Predicting Flight Delays (Bootstrap Forest and Boosted Trees). We return to the flight delays data for this exercise, and fit both a bootstrap forest and a boosted tree to the data. Use scheduled...
-
In the fiscal year that ended September 30, 2008, there were 24,584 age-discrimination claims filed with the Equal Employment Opportunity Commission, an increase of 29% from the previous year (The...
-
Steven's Cat Math: This weekend I observed a cat, known as Fluffy, running across a branch and attempting to jump up to another tree. Unfortunately, Fluffy missed the other tree and fell to the...
-
Kansas Seed Corn Supplies, a company with 100,000 shares of common stock outstanding, had the following transactions during 20X1, its first year in business: Sales ....... 1,000,000 pounds @ $5...
-
Mesa Inc has agreed to acquire 40% ownership stake in Velacro Mining for $225 million to help finance the development of new mining operations. The mines are expected to have an economically useful...
-
Please answer the following questions: a) Impairment tests are required for particular investments at the year-end. Indicate which investment does not require impairment test and explain why? b)...
-
Respond to Brittany's discussion in a friendly way: Brittany's discussion, The three items from the course I am taking with me are the utilization of Cash Budgets, the power of Compound Interest, and...
-
Budgeted manufacturing overhead costs $4,300,000 Budgeted machine-hours 172,000 Actual manufacturing overhead costs $4,140,000 Actual machine-hours 166,000 pop-up content ends. 1. Calculate the...
-
ABC Inc. reported $75 million in revenue for last year. On average, over the same year, the company had $25 million worth of inventory in their warehouses. Assume that units in inventory are valued...
-
Bali-Hi Corporation's state charter authorizes the corporation to issue 350000 shares of $1 par value common stock. It has issued 100000 shared of common stock to the public. It held 20000 shares of...
-
4. One classic method for composing secret messages is called a square code. The spaces are removed from the english text and the characters are written into a square (or rectangle). For example, the...
-
A sample statistic will not change from sample to sample. Determine whether the statement is true or false. If it is false, rewrite it as a true statement.
-
What are some of the issues that should be considered when conducting marketing research?
-
Why do organizations conduct marketing research?
-
What are the different methods of conducting marketing research?
Study smarter with the SolutionInn App