Prepare a computer spreadsheet to classify the following costs into Direct Product Costs, Indirect Product Costs, and Period Costs. You will need to calculate the total direct product costs, indirect product costs, total product costs and total period costs. Plant Manager Salary (Oversees factory operations.) Rent on the Factory Assembly line workers' wages. (20 workers, 8 hours per day, 5 days a week, 50 weeks per year at $28 per hour.) Raw Materials Used Depreciation of Factory Equipment Utilities for Factory Depreciation on Sales Staff Automobiles Marketing Costs CEO Salary Administrative Secretary $120,000 $60,000 $ (Need to calculate annual cost.) $375,000 $35,000 $20,000 $30,000 $350,000 $300,000 $40,000 Check Figures: Total Direct Product Costs: 2 items totaling $1,495,000 Total Indirect Product Costs: 4 items totaling $235,000 Total Product Costs: $1,730,000 Total Period Costs: 4 items totaling $720,000