I know this one is a little long but still all a single question, so if you'd like me to post it in multiple questions - i'd gladly do so. I just ask that you post your answer in a spreedsheet format with labeling and data included, thanks!

Tent Master produces two lines of tents sold to outdoor enthusiasts. The tents are cut to specifications in department A. In department B the tents are sewn and folded. The activities, costs, and drivers associated with these two manufacturing processes and the company's production support activities follow Actvty Overhead Cost Driver Department A Pattern allgnment 960 13,200 3,600 113,280 Batches Cutting Moving product 55.440 Machlne hours 54,800 Moves $323,520 6,400 750 28,950 Department B Sewing $492,800 Direct labor hours Inspecting Folding 5,000 Inspections 86,850 Units $624,650 Design Providing space Materials handling Support $484,000 Modification orders 100,000 Square feet 340,300 Square yards 440 10,000 830,000 $924,300 Additional production information on the two lines of tents follows Pup Tent 19,300 unlts 1200 moves Pop-Up Tent 9,650 unlts 2.400 moves Unlts produced Moves Batches Number of Inspections Machine hours Direct labor hours Modification orders Space occupied Material required 240 batches 300 Inspections 720 batches 8,000 MH 4,000 DLH 5.200 MH 2.400 DLH 110 modification orders 330 modification orders 5.000 square feet 490,000 square yards 5,000 square feet 340,000 square yards Required: 1. Using a plantwide overhead rate based on direct labor hours, compute the overhead cost that is ent. (Round your inte assigned to each pup tent a answers to 2 decimal places.) nd each pop-up t your intermediate calculations and final Activity Cost unit Plantwide OH rate Total Overhead CostUnits Produced Pup Tent Pop-Up Tent