Question: PLEASE DO IT BY EXCEL!!!! THANKS!!! Question 24 5 pts = Cinram Machines has the following estimates for its new gear assembly project: price =

PLEASE DO IT BY EXCEL!!!! THANKS!!!

Question 24 5 pts = Cinram Machines has the following estimates for its new gear assembly project: price = $1,870 per unit; variable costs = $949 per unit; fixed costs = $1.4 million; quantity = 42,000 units. Suppose the company believes all of its estimates are accurate only to within +3 percent. What value should the company use for its total variable costs when performing its best-case scenario analysis? = $40,864,538 $38,216,051 $38,578,064 O $41,802,137 $39,822,128

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Finance Question Sloan Transmissions Inc., has the following estimates for its new gear assembly project: price = $1, 200 per unit; variable costs = $240 per unit; fixed costs = $2.6 million;...

PLEASE DO IT BY EXCEL!!!! THANKS!!! Question 26 5 pts = Newton Industries is considering a project and has developed the following estimates: unit sales = 4,800, price per unit = $67, variable cost...

Please see attached Document and give answers for all. Thanks Qz 9 Firm A uses straight-line depreciation. Firm B uses MACRS depreciation. Both firms bought $75,000 worth of equipment last year that...

Q.40-50 1. A project costs $2.43 million and has no salvage value. Depreciation is straight-line to zero over the five-year life of the project. Sales are projected at 64,000 units per year, price...

please answer problem 5 using a financial calculator, show your work. Uusinesses will 10. Scenario Analysis [LO2] You are at work when a co-worker excitedly comes to your desk and shows you the...

Question 1 1 pts Managerial accounting: Managerial accounting: has its primary emphasis on the future. is required by regulatory bodies such as the SEC. focuses on the organization as a whole, rather...

Quiz - Ch11-203a-Scenario Analysis [LO2] Started: Apr 24 at 1:05pm Quiz Instructions Question 1 1 pts Olin Transmissions, Inc., has the following estimates for its new gear assembly project: price -...

1. Calculating Costs and Break-Even [LO3] Night Shades, Inc. (NSI), manufac- tures biotech sunglasses. The variable materials cost is $11.13 per unit, and the vari- able labor cost is $7.29 per unit....

3) 4) Please answer number 4 through excel with calculations provided. I only need the answer for question 4 3. Scenario Analysis [LO2] Sloan Transmissions, Inc., has the following estimates for its...

Please show work (not excel formula). Thank you 7.7 a. (5 points) Default Transmissions, Inc., has the following estimates for its new gear assembly project: price = $1,380 per unit; variable costs =...

On December 11, 2008, Bernie Madoff was arrested on one count of securities fraud. The arrest came one day after Madoff admitted to his two sons that his entire investment advisory business was just...

We have to cover all the below points of the countryallotted: My country is Puerto Rico. So below are the questions needs to be answered related to the country. a. Briefly explain about the physical...

In a free market, what factors underlie currency exchange values? Which factors best apply to long-run exchange rates and to short-run exchange rates?

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

4. Why is the digital divide problem an ethical dilemma? There may be only 11 players on the pitch during a match, but the Blackburn Rovers Football Club in the UK employs more than 800 people. As...

1. How does information technology affect socioeconomic disparities? Explain your answer. There may be only 11 players on the pitch during a match, but the Blackburn Rovers Football Club in the UK...

4. How have information systems affected laws for establishing accountability, liability, and the quality of everyday life?