Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Before doing and saying violating honor code I want to make it clear I am done with question 1 i need answer for question 2

image text in transcribed

image text in transcribed

Before doing and saying violating honor code I want to make it clear I am done with question 1 i need answer for question 2 and 3 please i have spend alot of money on posting question and this is my last one please answer the questions its a big request i cannot solve question 2 and 3 I have solved question 1 with excel sheet

Financial Analysis Assignment (50 points) Due: Sunday, April, 19, 2020 During your study of Chapter 13, you learned about utilizing sensitivity analysis to analyze and evaluate the effects of changing volumes, costs, contribution margins, etc. on business decisions. Review the Information below and complete the requirements for the assignment. "Adapted from the textbook: Classic Limo, Inc. provides limousine service to Tri-Cities airport. The price of the service is foed at a flat rate for each trip and most costs of providing the service are stable for each trip. Marc Pence, the owner, budgets Income by estimating two factors that fluctuate with the economy, the fuel cost associated with each trip and the number of customers who will take trips. Looking at next year, Marc develops the following estimates of contribution margin (price less variable cost of the trip, including fuel) and for the estimated number of customers. Although Marc understands that it is not strictly true, he assumes that the cost of fuel and the number of customers are independent Scenario Contribution Margin Per Ride Number of Customers (Price - Variable cost) Excellent 10,500 6,000 $15 4.500 In addition to the costs of a ride, Marc estimates that other service costs are $50,000 plus ss for each customer (ride in excess of 6,000 rides. Annual administrative and marketing costs are estimated to be $25,000 plus 10% of the contribution margin. Required: 1) Using the above information, construct an Excel spreadsheet to prepare an analysis of the possible operating income for Classic Limo, Inc, similar to that inhibit 13.15 on page 58 of the textbook. You must submit this part of the assignment as an Excel and the formulas for all calculations. You will be graded on the answers provided, formulas/calculations, and presentation. If you would like feedback on this part of the assigment before submitting please email your preadsheet to me at least 48 hours prior to the due date. 2) If you were manager of Class Lima, Inc. and had to choose only one budget scenario to use for planning for the year, which one of the nine scenarios would you choose? This should be based on the scenario that is most likely. Be sure not to just go with the one you or the company would prefer 3) Write a two-page paper detailing the thought process used to make the final budgeting decision The paper must include what assumptions were made fie. - location of airport, economic conditions and the full rationale behind your decision. While you have to freedom to make certain a mptions to support your selection, you must use at least two outside sources with factual information to support your decision as well-fuel prices, weather conditions, tourism statistics). There is not one right answer. You will be graded on whether the rationale you provide actually supports the selection you made. There are many different angles from which to write this type of paper. Because this is a 'mini' research project, you must be concise and focus on just a few key items. You should also think about how areas outside of accounting like marketing and economics, might affect your decision, References should be cited using APA format. Your submission will be graded on a 50-point scale for the course and also assessed using the Integrative Business Knowledge rubric provided. Please be sure to review the rubric before starting your paper and incorporate as many areas outside of accounting into this project as are appropriate. Financial Analysis Assignment (50 points) Due: Sunday, April, 19, 2020 During your study of Chapter 13, you learned about utilizing sensitivity analysis to analyze and evaluate the effects of changing volumes, costs, contribution margins, etc. on business decisions. Review the Information below and complete the requirements for the assignment. "Adapted from the textbook: Classic Limo, Inc. provides limousine service to Tri-Cities airport. The price of the service is foed at a flat rate for each trip and most costs of providing the service are stable for each trip. Marc Pence, the owner, budgets Income by estimating two factors that fluctuate with the economy, the fuel cost associated with each trip and the number of customers who will take trips. Looking at next year, Marc develops the following estimates of contribution margin (price less variable cost of the trip, including fuel) and for the estimated number of customers. Although Marc understands that it is not strictly true, he assumes that the cost of fuel and the number of customers are independent Scenario Contribution Margin Per Ride Number of Customers (Price - Variable cost) Excellent 10,500 6,000 $15 4.500 In addition to the costs of a ride, Marc estimates that other service costs are $50,000 plus ss for each customer (ride in excess of 6,000 rides. Annual administrative and marketing costs are estimated to be $25,000 plus 10% of the contribution margin. Required: 1) Using the above information, construct an Excel spreadsheet to prepare an analysis of the possible operating income for Classic Limo, Inc, similar to that inhibit 13.15 on page 58 of the textbook. You must submit this part of the assignment as an Excel and the formulas for all calculations. You will be graded on the answers provided, formulas/calculations, and presentation. If you would like feedback on this part of the assigment before submitting please email your preadsheet to me at least 48 hours prior to the due date. 2) If you were manager of Class Lima, Inc. and had to choose only one budget scenario to use for planning for the year, which one of the nine scenarios would you choose? This should be based on the scenario that is most likely. Be sure not to just go with the one you or the company would prefer 3) Write a two-page paper detailing the thought process used to make the final budgeting decision The paper must include what assumptions were made fie. - location of airport, economic conditions and the full rationale behind your decision. While you have to freedom to make certain a mptions to support your selection, you must use at least two outside sources with factual information to support your decision as well-fuel prices, weather conditions, tourism statistics). There is not one right answer. You will be graded on whether the rationale you provide actually supports the selection you made. There are many different angles from which to write this type of paper. Because this is a 'mini' research project, you must be concise and focus on just a few key items. You should also think about how areas outside of accounting like marketing and economics, might affect your decision, References should be cited using APA format. Your submission will be graded on a 50-point scale for the course and also assessed using the Integrative Business Knowledge rubric provided. Please be sure to review the rubric before starting your paper and incorporate as many areas outside of accounting into this project as are appropriate

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Loren A Nikolai, D. Bazley and Jefferson P. Jones

10th Edition

324300980, 978-0324300987

More Books

Students also viewed these Accounting questions

Question

Define epistemology.

Answered: 1 week ago

Question

4. Give examples of five potential appraisal problems.

Answered: 1 week ago

Question

6. Explain how to install a performance management program.

Answered: 1 week ago