A consulting company has designed the accompanying spreadsheet model to compute a project's revenues and profits. The costs ofeach project include technology costs, labor costs, and project manager (PM) bonus. The PM bonus is computed as 10% of the profit ofthe project if the project makes a profit and 0 if the project loses money. The spreadsheet model seems to be producing erroneousresults.Click here for the Excel Data Filea. Use the model auditing tools to identify the error. The error is due toO circular referenceO incorrect cell referenceO invalid user inputsO none of the aboveb. Repair the spreadsheet so that it produces correct outcomes. What should be the PM bonus for Project 1? What is the project profitfor Project 2?PM bonus for Project 1:Final project profit for Project 2: Project 1 Project 2 Project 3Project revenue:50,0007500035000Technology costs: 5,00035001000Labor costs:350005000037000PM bonus:000Project profit:000

Answer:The question describes a situation where a consulting company's spreadsheet model is used to…

Answered: A consulting company has designed the…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter28: Statistics And Linear Regression (stats)

Section: Chapter Questions

Problem 4R

See similar textbooks

Similar questions

Complete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision…
Complete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision…
Complete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision…
AMT, Inc., is considering the purchase of a digital camera for maintenance of design specifications by feeding digital pictures directly into an engineering workstation where computer-aided design files can be superimposed over the digital pictures. Differences between the two images can be noted, and corrections, as appropriate, can then be made by design engineers. Solve, a. You have been asked by management to determine the PW of the EVA of this equipment, assuming the following estimates: capital investment = $345,000; market value at end of year six = $120,000; annual revenues = $120,000; annual expenses = $8,000; equipment life = 6 years; effective income tax rate = 50%; and after-tax MARR = 10% per year. MACRS depreciation will be used with a five-year recovery period. b. Compute the PW of the equipment’s ATCFs. Is youranswer in Part (a) the same as your answer in Part (b)?
You do not have to start from scratch, but note, these are completely independent pro formas. They must update accordingly from the data worksheets. Plan on showing your analysis and discussing the proforma changes that occur under each new scenario and how it affects profitability. Use a formatted text box (not a comment) to explain your recommendations under each new pro forma. This will be approximately a 2-3 paragraph endeavor. Scenario One: “What if” Analysis for adding flavored ice coffees. Your client is unsure if she should sell flavored ice coffees. She thinks she can sell a coffee to every second customer and it seems to be lucrative because the coffee sells for $3.75 each and costs him only $1.60 to purchase. Unfortunately your client is afraid that he would cannibalize his soft drink sales with the coffee customers (one soft drink less for every coffee sold). It will cost him $5,250 to purchase the equipment and insurance costs would rise by another…
Can someone help me figure out this problem? Complete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your…
The Elegant Software Company recently completed the development and testing of a new software program thatprovides the ability to transfer data from among a variety of operating systems. The company believes this productwill be quite successful and capitalized all of the costs of designing, developing, coding, and testing the software.These costs will be amortized over the expected useful life of the software on a straight-line basis.Required:1. Was Elegant correct in its treatment of the software development costs? Why?2. Explain the appropriate method for determining the amount of periodic amortization for any capitalized software development costs
An analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A 1 Price per Unit 2 Cost per Unit 3 Profit per Unit Price_per_Unit Cost per Unit Profit$_per_Unit 4. 5 Fixed Costs 6 Variable Costs Fixed Costs VariableCosts Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name Price_per_Unit Cost per Unit Profit$_per_Unit Fixed Costs VariableCosts
Using the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total fixed cost, and R2. The plotted data points using the graphing function. Compare the results to your solutions in E4-2 and E4-3 and explain the reasons for the results.
Scenario You are the project manager working on a Market Mailing project. The client informed your project team during the project planning phase that the project must be completed on time in order to sync with the launch of the new product. Also, the client informed you and the team that there is no cash reserve for the project so the project has to be completed within budget. Below is the status update that two project team members (Jennifer and Ben) put together. Based on the project's performance to date, complete the Rating Project Risk exercise on the next page. Task| Budgeted Actual Percent works Estimate Planned Planned Actual Projected| Planned to Actual Resource Resource Utilization Utilization works end date work complete complete date start start date end cost cost date to date 60 hours I $600 50 hours I $500 June 15 March June 15 120 hours / $1200 120 hours / $1200 A 30% 90 hours March 25% 30% I $900 15 30 May 15 April 8 B 30% April 1 May 30 30% 60 hours I $600 50% Rating…
Please find the Asset Beta (IndustryBeta) based on the following information below: Currently, Ljutic A/I Inc. has hired a consulting firm (Oakland Association-OA) to estimate the size of the market and hence expected unit sales for its main product (E-toral application sensor). OA’s work resulted in unit sales estimates of 318,331, 341,342, 368,769, 383,432, and 376,532 units respectively for the next five years conditioned on Ljutic adhering to an average sales price of $568 per unit for the first two years and $387 in years three, four, and five. From that point going forward, growth in unit sales is predicted to be 2.72% indefinitely. The results of an independent outside analysis by a leading market research firm has determined that the company can manufacture its product line at a variable cost per unit expected to be $63.47 growing at 2.23% per year for the first 5 years and 3.17% per year indefinitely thereafter while overall fixed costs are estimated to be $10,482,000…
2) AMT, Inc., is considering the purchase of a digital camera for maintenance of design specifications by feeding digital pictures directly into an engineering workstation where computer-aided design files can be superimposed over the digital pictures. Differences between the two images can be noted, and corrections, as appropriate, can then be made by design engineers. a) You have been asked by management to determine the PW of the EVA of this equipment, assuming the following estimates: capital investment = $345,000; market value at end of year six = $120,000; annual revenues = $120,000; annual expenses $8,000; equipment life 6 years; effective income tax rate 50%; and after-tax MARR = 10% per year. MACRS depreciation will be used with a five-year recovery period. b) Compute the PW of the equipment's ATCFS. Is your answer in Part (a) the same as your answer in Part (b)? 1

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Essentials Of Business Analytics

Statistics

ISBN:

9781285187273

Author:

Camm, Jeff.

Publisher:

Cengage Learning,

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Essentials Of Business Analytics

Statistics

ISBN:

9781285187273

Author:

Camm, Jeff.

Publisher:

Cengage Learning,

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS