Koontzs production manager has suggested using activity-based costing instead of either the plantwide or departmental approaches. To facilitate the necessary calculations, she assigned the companys total manufacturing overhead cost to five activity cost pools as follows:

Activity Cost Pool	Activity Measure	Manufacturing Overhead
Machining	Machine-hours in Molding	$ 417,500
Assemble and pack	Direct labor-hours in Assemble and Pack	282,500
Order processing	Number of customer orders	230,000
Setups	Setup hours	340,000
Other (unused capacity)		80,000
		$ 1,350,000

She also determined that the average order sizes for the Basic and Advanced models are 400 units and 50 units, respectively. The molding machines require a setup for each order. One setup hour is required for each customer order of the Basic model, and three hours are required to set up for an order of the Advanced model.

The company pays a sales commission of 5% for the Basic model and 10% for the Advanced model. Its traceable fixed advertising costs include $150,000 for the Basic model and $200,000 for the Advanced model. The remainder of the companys selling and administrative costs are organization-sustaining in nature.

Using the information provided by the production manager, calculate The total selling and administrative cost traced to the Basic model and the Advanced model using the activity-based approach. (spreadsheet)