Please show ALL WORK and STEPS. PLEASE EXPLAIN ALL STEPS. Please WRITE your work with BLACK PEN and PAPER. WRITE NEATLY - NO CURSIVE. After attaching your written work, PLEASE TYPE YOUR FINAL ANSWERS. PLEASE FOLLOW ALL INSTRUCTIONS HERE AND IN THE ATTACHED QUESTION.

Quick Supply distributes office supplies to small to medium sized offices throughout the Region of Waterloo, Ontario. Quick Supply sets its prices by marking up its cost of goods sold by 5%. For example, if Quick Supply paid $100 to buy supplies from manufacturers, Quick Supply would charge its customers $105 to purchase these supplies. For years, Quick Supply believed that the 5% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Quick Supply decided to implement an ABC system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities, as shown below: Activity Cost Pool Customer deliveries Manual order processing Electronic order processing Line item picking Other organization-sustaining costs Activity Measure Number of deliveries Number of manual orders Number of electronic orders Number of line items picked NA Total Cost $ 400,000 300,000 200,000 500,000 600,000 Total Activity 5,000 deliveries 4,000 orders 12,500 orders 400,000 line items Total selling and administrative expense $2,000,000 Quick Supply gathered the data below for two typical offices that it serves-City Office and County Office (both offices purchased a total quantity of office supplies that had cost Quick Supply $30,000 to buy from manufacturers): Activity Measure Number of deliveries Number of manual orders Number of electronic orders Number of line items picked Activity City Office County Office 12 0 15 8 0 80 100 Required: 1. Compute the total revenue that Quick Supply would receive from City Office and County Office. City Office County Office Total revenue received 2. Compute the activity rate for each activity cost pool. (Round your answers to 2 decimal places.) Activity Cost Pool Customer deliveries Activity rate per delivery per manual order Manual order processing Electronic order processing Line item picking per electronic order per line item picked 3. Compute the total activity costs that would be assigned to City Office and County Office. City Office County General Total activity costs 4. Compute Quick Supply's customer margin for City Office and County Office. (Hint: Do not overlook the $30,000 cost of goods sold that Quick Supply incurred serving each office.) City Office County Office Customer margin (loss)