Bi-rize inc incurred the following production volumes and

Reference no: EM13610855

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.

Reference no: EM13610855

Questions Cloud

If ho b1 0 is not rejected what is the best estimate for : if ho b1 0 is not rejected what is the best estimate for the value of the response variable for any value of the

Find the optimal compression ration in terms of the upper : it is fair to assume that the heat rejection from an otto cycle is typically to the ambient at a temperature tmin the

If starla invests a total of 44400 through a seriesof 12 : starla has decided to retire in 12 years. she has 44400available today and wants to invest the money to supplemement

Mg lighting had sales of 2000 units at 85 per unit last : mg lighting had sales of 2000 units at 85 per unit last year. the marketing manager projects a 12 percent decrease in

Bi-rize inc incurred the following production volumes and : bi-rize inc. incurred the following production volumes and costs for the last six months of the current year inputs

What is the best point estimate of the population mean net : in a test of effectiveness of garlic for lowering cholesterol 42 subjects were treated with garlic in a processed

Burton manufacturing company leases equipment from : burton manufacturing company leases equipment from nelsonleasing for an annual lease rental of 100000. thelease term is

Calculate the entropy change in btulbmr b calculate the : steam is contained in a rigid container at an initial pressure of 100 psia and 600 f. the pressure is reduced to 10

A electric flux of 141 nm2c passes through a flat : an electric flux of 141 n.m2c passes through a flat horizontal surface that has an area of 0.72 m2. the flux is due to

User Account

All Pages