Could I get the excel equations for this, just the formulas. Thanks! Arial 12A A

ID: 2658824 • Letter: C

Question

Could I get the excel equations for this, just the formulas. Thanks!

Arial 12A A Paste B l u.??? Alignment Num ber Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard Font Styles D16 Olin Transmissions, Inc., has the following estimates for its new gear assembly project 2price $1,400 per unit; variable costs-$220 per unit; fixed costs $3.9 million; quantity 85,000 units. Suppose the company believes all of its estimates are accurate only to within +15 percent. What values should the company use for the four variables given here when it performs its best-case scenario analysis? What about the worst-case scenario? 4 SPrice accuracy 6 Variable cost accuracy 7 Fixed cost accuracy 8 Quantity accuracy 15% 15% 15% 15% 10 11 Complete the following analysis. Do not hard code values in your calculations. 12 13 14 Scenario 15 Base case 16 Best case 17 Worst case 18 Fixed costs 220$3,900,000 Unit sales Unit price Unit variable cost 85,000 S 1,400 $ Sheet1 READY 100% Attempt(s) 1/ Hint

Explanation / Answer

Scenario

Unit sales

Unit price

Unit Variable cost

Fixed cost

Base case

85000

1400

220

3900000

Best case

85000*1.15

97750

1400*1.1.5

1610

220*(1-.15)

187

3900000*(1-.15)

3315000

Worst case

85000*.85

72250

1400*.85

1190

220*(1+.15)

253

3900000*(1+.15)

4485000