please help me calculate the order costs and the price per unit.

Download Excel spreadsheet 1. Calculate the total revenues per distributor category, and assign the customer costs to each distributor type by using revenues as the allocation base. Selling price for one unit is $150. Round calculations to the nearest dollar. 2. Conceptual Connection: Calculate the customer cost per distributor type using activity-based cost. assignments. Round the interim calculations to the nearest dollar. For non-JIT distributors by how much can the price be decreased without affecting customer profitability? Round your answer to the nearest cent. \$ per unit Download Excel spreadsheet 1. Calculate the total revenues per distributor category, and assign the customer costs to each distributor type by using revenues as the allocation base. Selling price for one unit is $150. Round calculations to the nearest dollar. 2. Conceptual Connection: Calculate the customer cost per distributor type using activity-based cost. assignments. Round the interim calculations to the nearest dollar. For non-JIT distributors by how much can the price be decreased without affecting customer profitability? Round your answer to the nearest cent. \$ per unit