Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order Processing Costs 1 3,300 $90,970 2 1,650 55,412 3 4,840 132,770

please answer do not image.

Please do not give solution in image format thanku

Please Do not Give image format Allocate manufacturing, ordering, and selling costs to the two customer groups by using an activity-based management (ABM) allocation basis. Calculate the net profit before tax (NPBT) for each customer group using an ABM allocation basis.

Cop

Month Yachts Shipped Shipping Cost       January 6  $          11,650 February 4                 9,100 March 3                 7,825 April 8              14,200 May 2                 6,550 June 7              12,925 July 5              10,375 A. Using the high-low method, create the cost formula for C&C Yachts’ shipping costs. B. Prepare a scatter graph of the shipping data using excel.  Then use the least-squares regression method to come up with the cost equation that represents the line of best fit. Comment on the accuracy of this equation and how it compares to your high-low method estimation. C. What would you estimate shipping costs to be if C&C Yachts shipped 10 yachts in a single month? Use the cost formula you obtained in part A. Compare this to the cost equation you came up with in Part B.

Please answer all parts

Don't give answer in image format

Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. UnitsProduced TotalLumberCost TotalUtilitiesCost Total MachineDepreciationCost 7,000 shelves $84,000    $9,550    $140,000    14,000 shelves 168,000    17,600    140,000    28,000 shelves 336,000    33,700    140,000    35,000 shelves 420,000    41,750    140,000    1. Determine whether the costs in the table are variable, fixed, mixed, or none of these. Lumber   Utilities   Depreciation   2. For each cost, determine the fixed portion of the cost, and the per-unit variable cost. If there is no amount or an amount is zero, enter "0". Recall that, for N = Number of Units Produced, Total Costs = (Variable Cost Per Unit x N) + Fixed Cost. Complete the following table with your answers. Round variable portion…

Help with what formulas were used in this excel spreadsheet.