Bi-Rize, Inc. incurred the following production volumes and costs for the last six months of the current year Inputs Production (Units) Total Cost July 3,000 $111,700 August 2,980 110,600 September 3,250 118,250 October 2,520 100,200 November 2,260 93,500 December 3,110 114,800 Outputs Production (Units) Total Cost Highest level Lowest level Difference Variable cost per unit Fixed cost
a. What is the formula for the maximum value of the units range.
b. What is the formula for the minimum value of the units range.
c. What is the formula for the difference d. Enter in C12 the VLOOKUP function to determine the cost associated with the highest level.
e. Enter in C13 the VLOOKUP function to determine the cost associated with the lowest level (or copy C12 to C13).
f. Copy B14 To C14 g. Enter in B16 the formula for the variable cost per unit.
h. Enter in B18 the formula for the fixed cost.