# Question

Program Susan Lewis, owner of a florist shop, is interested in predicting the cost of delivering floral arrangements. She collected monthly data on the number of deliveries and the total monthly delivery cost (depreciation on the van, wages of the driver, and fuel) for the past year.

Required:

1. Using a computer spreadsheet program such as Excel, run a regression on these data. Print out your results.

2. Using your results from Requirement 1, write the cost formula for delivery cost.

3. What is R2 based on your results? Do you think that the number of direct labor hours is a good predictor of delivery cost?

4. Using the cost formula in Requirement 2, what would predicted delivery cost be for a month with 300 deliveries?

Required:

1. Using a computer spreadsheet program such as Excel, run a regression on these data. Print out your results.

2. Using your results from Requirement 1, write the cost formula for delivery cost.

3. What is R2 based on your results? Do you think that the number of direct labor hours is a good predictor of delivery cost?

4. Using the cost formula in Requirement 2, what would predicted delivery cost be for a month with 300 deliveries?

## Answer to relevant Questions

Multiple Choice Questions 1. The following cost formula for total purchasing cost in a factory was developed using monthly data. Purchasing cost = $123,800 + ($15 x Number of purchase orders) Next month, 2,000 purchase ...Refer to the information for Farnsworth Company above. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Intercept ......... 3,212 Slope ......... ...Louise McDermott, controller for the Galvin plant of Veromar Inc., wanted to determine the cost behavior of moving materials throughout the plant. She accumulated the following data on the number of moves (from 100 to 800 in ...Suppose a firm with a contribution margin ratio of 0.3 increased its advertising expenses by $10,000 and found that sales increased by $30,000. Was it a good decision to increase advertising expenses? Suppose that the ...Head-First Company now sells both bicycle helmets and motorcycle helmets. Next year, Head- First expects to produce total revenue of $570,000 and incur total variable cost of $388,000. Total fixed cost is expected to be ...Post your question

0