Formulas required for A-D. Thank you.

Use the table below to swer the following question(s). In the spreadsheet below, there is data on the price, cost demand, and quantity produced for an item. There are also different "what if" values that can help a manager to calculate costs and revenue with variability in demand B A Profil Model 1 2 Data 1 s Unit Price (S) Unit Cost (5) Fixed Cost (5) Demand Quantity Produced 6 2 $ 9 10 her-/ Demand Values 120,000 40,000 $9.000 60.000 65,000 40 25 550.000 60,000 $5.000 It is important to get a good handle on what the terms used in these questions refer to (and their respective formulas) because when you have an excel spreadsheet in front of you, you want to be sure you're adding/subtracting/multiplying the correct cells together to get the value you're interested in (see page 380 for example). B) calcul Show your work! Hint: Use the formula for calculacitog revenue. A) $1,375,000 B) ($1,320,000) C) $1,430,000 D) $2,750,000 Calculate the variable cost when the demand is 60,000 units. Hint: Remember, to refer to "Quantity Produced Show your work! A) $1,430,000 B) $1,375,000 C) $2,750,000 D) S1,320,000 From the "what if" values, calculate thtal cost when demand is 48W.your work! Hint: Use the formula for calculating cost A) $2,000,000 B) $1,925,000 C) $1,100,000 D) $75,000 C) D). From the "what if" values, calculate sine profit when the demand is 65,000. Remember, you can only sell however many products you produce Use the formula for calculating net profit. Show your workt. A) 5825,000 B) $1,650,000 C) S800,000 D) 925,000