
©2016 DeVry/Becker Educational Development Corp. All Rights Reserved.
| Professional | Billing Rate per Hour |
| Max Walliston | $640 |
| Alexa Boutin | 220 |
| Jacob Abbington | 100 |

The table depicts four professionals and the hours they each spent on two different clients, plus the total hours for each client. The details of the table are as follows:

The details of the spreadsheet are as follows:
Department: Design
Cost Driver: CAD–design–hours
Manufacturing Overhead in 2017: dollar 35,000
Usage of Cost Drivers by Customer Contract
Southern Motors: 150
Caesar Motors: 250
Jupiter Auto: 100
Department: Production
Cost Driver: Engineering–hours
Manufacturing Overhead in 2017: dollar 25,000
Usage of Cost Drivers by Customer Contract
Southern Motors: 130
Caesar Motors: 100
Jupiter Auto: 270
Department: Engineering
Cost Driver: Machine–hours
Manufacturing Overhead in 2017: dollar 220,000
Usage of Cost Drivers by Customer Contract
Southern Motors: 300
Caesar Motors: 3,700
Jupiter Auto: 1,000
Total manufacturing overhead in 2017: dollar 280,000

The table depicts costs from the forming department and the assembly department for basic and deluxe styles of trophies, as well as totals. The details of the table are as follows:

The table depicts annual production in units, direct material costs, direct manufacturing labor costs, direct manufacturing labor-hours, machine-hours, number of production runs, and inspection-hours for mathematical and financial products. The details of the table are as follows:
| Total | |
| Machining costs | $440,000 |
| Setup costs | 110,000 |
| Inspection costs | 120,000 |

The table depicts cost driver, overhead costs in 2020, and quantity of cost drivers used by each of three projects, Chandler, Henry, and Manley for three departments, design, engineering, and construction, as well as total overhead costs. The details of the table are as follows:

The details of the information of Aniline are as follows:
Standard job:
Number of printing jobs: 2,400
Price per job: dollar 1,700
Cost of supplies per job: dollar 210
Direct labor costs per job: dollar 170
Printing machine-hours per job: 10
Printing machine-hours per job: 6
Total number of purchase orders: 330
Design costs: dollar 7,000
Marketing costs as a percentage of revenues: 4 percent
Special job
Number of printing jobs: 1,200
Price per job: dollar 2,000
Cost of supplies per job: dollar 310
Direct labor costs per job: dollar 220
Printing machine-hours per job: 10
Printing machine-hours per job: 9
Total number of purchase orders: 430
Design costs: dollar 35,000
Marketing costs as a percentage of revenues: 4 percent
Total
Cost of printing machine operations: dollar 1,008,000
Setup costs: dollar 781,200
Purchase order costs: dollar 27,360
Design costs: dollar 42,000
Marketing costs as a percentage of revenues: dollar 259,200
Administration costs: dollar 309,120
Cause-and-effect relationship between allocation base and activity cost
Cost of printing machine operations: Indirect costs of operating printing machines increase with printing machine-hours
Setup costs: Indirect setup costs increase with setup-hours
Purchase order costs: Indirect purchase order costs increase with number of purchase orders
Design costs: Design costs are allocated to standard and special jobs based on a special study of the design department
Administration costs: Demand for administrative resources increases with direct labor costs

The table depicts units sold, selling price, direct material cost per unit, direct manufacturing labor cost per hour, direct manufacturing labor-hours per unit, production runs, material moves, machine setups, machine-hours, and number of inspections for interior and exterior doors. The details of the table are as follows:
1. Units sold
2. Selling price
3. Direct material cost per unit
4. Direct manufacturing labor cost per hour
5. Direct manufacturing labor-hours per unit
6. Production runs
7. Material moves
8. Machine setups
9. Machine-hours
10. Number of inspections

The table depicts activity cost and activity-cost driver for five different activities: production scheduling, material handling, machine setup, assembly, and inspection. The details of the table are as follows:
| Ordering | $95 per purchase order |
| Delivery and receipt of merchandise | $76 per delivery |
| Shelf stocking | $19 per hour |
| Customer support and assistance | $0.15 per item sold |

The table depicts revenues, cost of goods sold, store support, and activity-area usage including ordering, delivery, shelf stocking, and customer support for baked goods, milk and fruit juice, and frozen foods. The details of the table are as follows:

The table depicts gross sales, sales returns: number of items, sales returns: amount, number of orders: regular, and number of orders: rush for Chains 1 through 4. The details of the table are as follows:
| Activity | Cost-Driver Rate |
| Regular order processing | $22 per regular order |
| Rush order processing | $110 per rush order |
| Returned items processing | $10 per item |
| Catalogs and customer support | $1,400 per customer |

The table depicts budgeted overhead, activity driver, and budgeted quantity of activity driver for five indirect-cost pools: purchasing, material handling, machine maintenance, product inspection, and packaging, plus total budgeted overhead. The details of the table are as follows:
| Job 215 | Job 325 | |
| Number of purchase orders | 26 | 5 |
| Number of material moves | 14 | 3 |
| Machine-hours | 20 | 80 |
| Number of inspections | 12 | 5 |
| Units produced | 16 | 6 |

The table depicts use of six individual banking services, activity-based cost per transaction, and account balance for three customers. The details of the table are as follows:
| Lopez Enterprises | Clinical Inc. | |
| Professional labor | 2,500 hours | 2,500 hours |

The table depicts direct costs, including research support labor, computer time, travel and allowances, telephones/faxes, and photocopying for Lopez Enterprises and Clinical Inc, as well as total costs. The details of the table are as follows:

The table depicts direct cost per hour and indirect cost per hour for partner and associate. The details of the table are as follows:

Depreciation: 60,000 dollars
Rent: 120,000 dollars
Other overhead: 240,000 dollars
Total overhead costs, 900,000 dollars
| Activity-Cost Pool | Activity Measure | Budgeted Total Activity for the Year |
| Direct manufacturing labor support | Number of direct manufacturing labor-hours | 30,000 direct manufacturing labor-hours |
| Order processing | Number of customer orders | 500 orders |
| Design support | Number of custom design-hours | 2,490 custom design-hours |
| Other | Facility-sustaining costs allocated to orders based on direct manufacturing labor-hours | 30,000 direct manufacturing labor-hours |
| Direct Manufacturing Labor Support | Order Processing | Design Support | Other | Total | |
| Wages and salaries | 40% | 25% | 30% | 5% | 100% |
| Depreciation | 25% | 10% | 15% | 50% | 100% |
| Rent | 30% | 25% | 10% | 35% | 100% |
| Other overhead | 20% | 30% | 35% | 15% | 100% |

Wages and salaries: 360,000 dollars
Depreciation: 72,000 dollars
Supplies: 120,000 dollars
Other overhead: 288,000 dollars
Total overhead costs: 840,000 dollars
| Activity-Cost Pool | Activity Measure | Total Activity for the Year |
| Estimating jobs | Number of job estimates | 250 estimates |
| Lawn care | Number of direct labor-hours | 10,000 direct labor-hours |
| Landscape design | Number of design hours | 500 design hours |
| Other | Facility-sustaining costs that are not allocated to jobs | Not applicable |
| Estimating Jobs | Lawn Care | Landscape Design | Other | Total | |
| Wages and salaries | 5% | 70% | 15% | 10% | 100% |
| Depreciation | 10% | 65% | 10% | 15% | 100% |
| Supplies | 0% | 100% | 0% | 0% | 100% |
| Other overhead | 15% | 50% | 20% | 15% | 100% |

The table depicts technician labor, depreciation, materials, administration, maintenance, sanitation, and utilities costs for x-rays, ultrasound, CT scan, and MRI as well as totals. Number of procedures, minutes to clean after each procedure, and minutes for each procedure are included as well. The details of the table are as follows:
1. Technician labor
2. Depreciation
3. Materials
4. Administration: 20,000
5. Maintenance: 250,000
6. Sanitation: 252,500
7. Utilities: 151,100
8. Totals:
9. Number of procedures
10. Minutes to clean after each procedure
11. Minutes for each procedure
| Administration | Number of procedures |
| Maintenance (including parts) | Capital cost of the equipment (use Depreciation) |
| Sanitation | Total cleaning minutes |
| Utilities | Total procedure minutes |

The details of the spreadsheet are as follows:
General supermarkets chain:
Revenues: dollar 3,704,000
Cost of goods sold: dollar 3,612,000
Gross margin: dollar 92,000
Drugstore chains:
Revenues: dollar 3,145,000
Cost of goods sold: dollar 2,990,000
Gross margin: dollar 155,000
Mom-and-pop single stores:
Revenues: dollar 1,988,000
Cost of goods sold: dollar 1,804,000
Gross margin: dollar 184,000
Total for Pharmassist:
Revenues: dollar 8,837,000
Cost of goods sold: dollar 8,406,000
Gross margin: dollar 431,000
Other operating costs: dollar 313,075
Operating income: dollar 117,925
| Activity Area | Cost Driver |
| Order processing | Number of customer purchase orders |
| Line-item processing | Number of line items ordered by customers |
| Delivering to stores | Number of store deliveries |
| Cartons shipped to store | Number of cartons shipped |
| Stocking of customer store shelves | Hours of shelf stocking |

The details of the spreadsheet are as follows:
Number of orders processed:
General supermarkets chain: 200
Drugstore chains: 500
mom-and-pop single stores: 1,800
Total cost of activity in 2020: dollar 87,500
Number of line-items ordered
General supermarkets chain: 2,100
Drugstore chains: 4,800
Mom-and-pop single stores: 15,600
Total cost of activity in 2020: dollar 67,500
Number of store deliveries made:
General supermarkets chain: 110
Drugstore chains: 280
Mom-and-pop single stores: 990
Total cost of activity in 2020: dollar 67,620
Number of cartons shipped to stores:
General supermarkets chain: 34,000
Drugstore chains: 23,000
Mom-and-pop single stores: 23,000
Total cost of activity in 2020: dollar 80,000
Number of shelf stocking hours
General supermarkets chain: 310
Drugstore chains: 210
Mom-and-pop single stores: 95
Total cost of activity: dollar 10,455
Total cost of activity in 2020: dollar 313,075.

Direct materials, purses: 319,155 dollars
Direct materials, backpacks: 454,995 dollars
Direct manufacturing labor, purses: 99,000 dollars
Direct manufacturing labor, backpacks: 113,000 dollars
Setup: 64,000 dollars
Shipping: 73,000 dollars
Design: 169,000 dollars
Plant utilities and administration: 221,000 dollars
Total: 1,513,160 dollars
| Backpacks | Purses | Total | |
| Number of bags | 6,175 | 3,075 | 9,250 |
| Hours of production | 1,665 | 2,585 | 4,250 |
| Number of batches | 120 | 80 | 200 |
| Number of designs | 2 | 2 | 4 |

Professional salaries include the following:
4 physicians times 200,000 dollars: 800,000 dollars
2 x-ray technicians times 50,000 dollars: 100,000 dollars
12 nurses times 60,000 dollars: 720,000 dollars
1 nutritionist times 50,000 dollars: 50,000 dollars
For a total of 1,670,000 dollars
Medical supplies: 600,000 dollars
Rent and clinic maintenance: 180,000 dollars
Laboratory services: 216,000 dollars
General overhead, including administrative staff: 540,000 dollars
Total: 3,206,000 dollars
| Urgent Care | Living Well | Total | |
| Physicians | 3 | 1 | 4 |
| X-ray technicians | 2 | 2 | |
| Nurses | 7 | 5 | 12 |
| Nutritionist | 1 | 1 |
| Urgent Care | Living Well | Total | |
| Square feet of clinic space | 6,000 | 10,000 | 16,000 |
| Patient visits | 17,500 | 22,500 | 40,000 |
| Number of laboratory tests | 15,000 | 3,000 | 18,000 |

Zarson’s Netballs Budgeted Costs and Activities for the Year Ended December 31, 2020 are as follows:
| Basketballs | Volleyballs | |
| Number of balls | 58,000 | 85,000 |
| Machine-hours | 13,500 | 10,500 |
| Number of setups | 450 | 300 |
| Square footage of production space used | 3,200 | 8,000 |
Huntington Boards Budgeted Costs for the Year Ended December 31, 2020 | |
| Direct materials—Basic boards | $260,000 |
| Direct materials—Competition boards | 450,000 |
| Direct manufacturing labor—Basic boards | 307,500 |
| Direct manufacturing labor—Competition boards | 512,500 |
| Machine setup costs | 90,000 |
| Machine maintenance and utility costs | 251,100 |
| Indirect labor costs | 330,000 |
| Facility rent | 254,000 |
| Machine depreciation | 63,500 |
| Basic | Competition | |
| Units produced | 5,200 | 7,500 |
| Machine hours | 31,200 | 52,500 |
| Number of setups | 400 | 800 |
| Direct labor-hours | 15,000 | 25,000 |

Plum Electronics Income Statement for the Fiscal Year Ended November 30, 2020 is as follows:

The table depicts direct materials, direct manufacturing labor, machine costs, total direct costs, manufacturing overhead costs, and total cost of goods sold for Mammoth (total and per unit) and Maximum (total and per unit). The details of the table are as follows:
Note: Mammoth requires 1.5 hours per unit and Maximum requires 3.5 hours per unit. The direct manufacturing labor cost is 13.20 dollars per hour.
Note: Machine costs include lease costs of the machine, repairs, and maintenance. Mammoth requires 8 machine-hours per unit and Maximum requires 4 machine-hours per unit. The machine-hour rate is 19.80 dollars per hour.
Note: Manufacturing overhead costs are allocated to products based on machine-hours at the rate of 27.50 dollars per hour.

The table depicts cost-allocation base, total activity cost, units of the cost-allocation base for Mammoth, units of the cost-allocation base for Maximum, and total units of the cost allocation base for soldering, shipments, quality control, purchase orders, machine power, and machine setups, as well as total manufacturing overhead. The details of the table are as follows:

Pet World Product Line Information for the Year Ended December 31, 2020 is as follows:
1. Revenues
2. Cost of merchandise
3. Salary of department manager
4. Number of purchase orders placed
5. Number of boxes received
6. Square feet of store space

Pet World S G and A Costs for the Year Ended December 31, 2020 are as follows:
Receiving department expense: 160,500 dollars
Selling expense: 310,000 dollars
Rent: 432,000 dollars
Store manager’s salary: 120,000 dollars
Utilities: 62,000 dollars
Total: 1,270,500 dollars