# Question: Refer to the Tulip Time data in E6 49B Use Microsoft

Refer to the Tulip Time data in E6-49B. Use Microsoft Excel to run a regression analysis, then do the following calculations.

Requirements

1. Determine the firm’s cost equation (use the output from the Excel regression).

2. Determine the R-square (use the output from the Excel regression). What does Tulip Time’s

R-square indicate?

3. Predict van operating costs at a volume of 14,500 kilometres.

Requirements

1. Determine the firm’s cost equation (use the output from the Excel regression).

2. Determine the R-square (use the output from the Excel regression). What does Tulip Time’s

R-square indicate?

3. Predict van operating costs at a volume of 14,500 kilometres.

## Answer to relevant Questions

Assume that Kent’s Tulip Time does a regression analysis on the next year’s data using Excel 2007. The output generated by Excel is as follows: Requirement 1. Determine the firm’s cost equation (use the output from the ...Bayside Apartments is a 750-unit apartment complex. When the apartments are 90% occupied, monthly operating costs total $216,825. When occupancy dips to 80%, monthly operating costs fall to $212,400. The owner of the ...Kelsey’s Ice Cream Shoppe sold 9,000 servings of ice cream during June for $3 per serving. Kelsey purchases the ice cream in large tubs from the BlueBell Ice Cream Company. Each tub costs Kelsey $15 and has enough ice ...Marty’s Entrees produces frozen meals, which it sells for $9 each. The company uses the FIFO inventory costing method, and it computes a new monthly fixed manufacturing overhead rate based on the actual number of meals ...Calculate how many units of your product you will need to sell to break even in each of the five years you have projected.Post your question