Matt owns a machine shop. in reviewing the shop's utility bills for the past 12 months, he found that the highest bill of $2, 700 occurred in august when the worked 1, 300 machine hours. the lowest utility bill of $2, 500 occurred in december when the machines worked 800 machine hours. 1. calculate the variable rate per machine hour and the total fixed utility cost. 2. show the equation for determining total utility cost for the machine shop. 3. if matt anticipates using 1, 200 machine hours in january, predict the shop's total utility bill using the equation from requirement 2. calculate the variable rate per machine hour and the total fixed utility cost. first, calculate the variable rate per machine hour. select the formula labels, then enter the amounts and compute the variable rate per machine hour. (use the high-low method. round your answer to the nearest cent.)/= variable rate per machine hour/= calculate the total fixed cost. select the formula labels, then enter the amounts and compute the total fixed cost. (use the highest point.) - = total fixed cost + = show the equation for determining total utility cost for the machine shop. (times) + = total utility cost. if matt anticipates using 1, 200 machine hours in january predict the shop's total utility bill using the equation form requirement 2.

The variable rate is 0.4 $/machine-hour.

The equation fot the utility bill is .

If Matt anticipates using 1200 machine hours in January, his utility bill will be $ 2660.

Explanation:

We have two points in the year that will let us calculate the fixed utility cost and the variable utility cost.

We will end up with a equation of a line, like this

Where C (M) is the total utility cost, v is the variable utility cost per machine hour, M are the machines running hours and F is the fixed utility cost.

We have two unknowns and two equations, so it can be solved.

First we can substract the two bills (the highest and the lowest) and equal that to the equation of the line we described

The variable rate is 0.4 $/machine-hour.

Then we can replace v in one of the equations

The fixed utility cost are 2180 $/month.

The equation fot the utility bill is .

If Matt anticipates using 1200 machine hours in January, his utility bill will be $ 2660.

a manufacturer of printed circuit boards uses exponential smoothing with trend to forecast monthly demand of its product. at the end of december, the company wishes to forecast sales for january. the estimate of trend through november has been 200 additional boards sold per month. average sales have been around 1000 units per month. the demand for december was 1100 units. the company uses α = 0.20 and β = 0.10. make a forecast including trend for the month of january.