Ex 3-17 Name:
Enter the data in columns C and E below. When you have entered all data points, the scattergraph
to the right and below will be correct.
Radiology Total
Month Tests Cost
January 2800 133500
February 2600 135060
March 3100 175000
April 3500 170600
May 3400 176900 40.3
June 3700 186600
July 3840 174450
August 4100 195510
September 3450 185300
1) Examine this scattergraph.
2) Cost Visits Variable =
Change in cost
High Change in visits
Low
Change Variable = =
Fixed = total cost at high – variable cost
Fixed = –
Fixed =
Cost formula is:
Y = + X Visits
3) Predicted cost is:
Y = + (3,500)
Y = +
Y =
$-
$50,000
$100,000
$150,000
$200,000
$250,000
– 500 1,000 1,500 2,000 2,500 3,000 3,500 4,000 4,500
Total Cost
Radiology Tests
Scattergraph
Ex 3-17 Name:
Enter the data in columns C and E below. When you have entered all data points, the scattergraph
to the right and below will be correct.
Radiology Total
Month Tests Cost
January 2,800 133,500$ 2800 133500
February 2,600 135,060 2600 135060
2) Cost Visits Variable =
Change in cost
High 195,510$ 4,100 Change in visits
Low 135,060 2,600
Change 60,450$ 1,500 Variable = 60,450$ = $40.30 per visit
SOLUTION
$250,000
Scattergraph
Ex 3-20 Name:
Enter the appropriate amounts in the shaded cells in columns C, E, and G.
Use the chart in Exhibit 3-14 for the t value for the 95 percent confidence
interval.
1)
Y = F + VX
Y = + X
2)
Y = + x
Y = +
Y =
Yf+
+ x
< Yf <
tp
Se
Ex 3-20 Name:
Enter the appropriate amounts in the shaded cells in columns C, E, and G.
Use the chart in Exhibit 3-14 for the t value for the 95 percent confidence
interval.
1)
Y = F + VX
Y = $17,350 +$12.00 X
SOLUTION
Cost Formula @ 340 orders
95% Confidence Interval
Ex 3-21 Name:
Enter the appropriate amounts in the shaded cells in columns C, E, H, and K.
Use the chart in Exhibit 3-14 for the t value for the 95 percent confidence
interval.
1)
Y = F + VX
Y = +
X1+X2+X3
X1 = Number of orders
X2 =
Number of wedding cakes
X3 = Number of gift baskets
2)
Y = + + +
Y =
3)
Yf+
+ x
< Yf <
Cost Equation
Anticipated order filling costs
95% Confidence Interval
tp
Se
Ex 3-21 Name:
Enter the appropriate amounts in the shaded cells in columns C, E, H, and K.
Use the chart in Exhibit 3-14 for the t value for the 95 percent confidence
interval.
1)
Y = F + VX
X3 = Number of gift baskets
2)
3)
Yf+
SOLUTION
95% Confidence Interval
Se
Cost Equation
Anticipated order filling costs
tp
X1 = Number of orders
X2 =