# Question: Refer to the Posies Unlimited data in E6 45B Use

Refer to the Posies Unlimited data in E6- 45B. 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 Posies Unlimited’s R- square indicate?

3. Predict van operating costs at a volume of 17,000 miles.

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 Posies Unlimited’s R- square indicate?

3. Predict van operating costs at a volume of 17,000 miles.

**View Solution:**## Answer to relevant Questions

Assume that Posies Unlimited does a regression analysis on the next year’s data using Excel. The output generated by Excel is as follows:Requirements 1. Determine the firm’s cost equation (use the output from the Excel ...Bayview Apartments is a 750- unit apartment complex. When the apartments are 90% occupied, monthly operating costs total $ 217,150. When occupancy dips to 80%, monthly operating costs fall to $ 212,800. The owner of the ...McKnight Industries is in the process of analyzing its manufacturing overhead costs. The company is not sure if the number of units produced or number of direct labor (DL) hours is the best cost driver to use for predicting ...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 ...Use the information from the Crystal Cruiseline Data Set. Draw a graph of Crystal Cruise-line’s CVP relationships. Include the sales revenue line, the fixed expense line, and the to-tal expense line. Label the axes, the ...Post your question