Inventory information, direct materials Plastic Metal Beginning inventory 290 kilos 50 kilos Target ending inventory 410 kilos 40 kilos Cost of beginning inventory 1,102 140 Pet Transport Company makes two pet carriers, the Cat-allac and the Dog-eriffic. They are both made of plastic with metal doors, but the Cat-allac is smaller. Information for the two products for the month of April is given in the following tables: E (Click the icon to view the information for the two products.) Pet Transport uses an activity-based costing system and classifies overhead into three activity pools: Setup, Processing and Inspection. Activity rates for these activities are 130 per setup hour, 5 per machine hour, and 20 per inspection hour, respectively. Other information follows: (Click the icon to view the other information.) Pet Transport accounts for direct materials using a FIFO cost flow assumption. Read the requirements. (Click the icon to view the account information.) Dog-errific 1,125 Ibs. 225 Ibs. Total quantity of direct material to be used 2,925 Ibs. 525 Ibs. Cost Budget Available from beginning direct materials inventory (under a FIFO cost-flow assumption) Plastic 1102 Metal 140 To be purchased this period Plastic Metal Direct materials to be used this period i Requirements Data Table Requirements Prepare the following for April: Revenues budget Cost driver information 1. Cat-allac Dog-errific 2. Production budget in units Number of units per batch 25 13 3. Direct material usage budget and direct material purchases budget Setup time per batch 1.25 hours 2.00 hours 4. Direct manufacturing labour cost budget Inspection time per batch 0.5 hours 0.6 hour 5. Manufacturing overhead cost budgets for each of the three activities 6. ending Budgeted unit cost of ending finished goods inventory inventories budget Non-manufacturing fixed costs for March equal 30,000, of which half are salaries. Salaries are expected to increase 5% in April. The only variable non-manufacturing cost is sales commission, equal to 1% of sales revenue. 7. Cost of goods sold budget 8. Non-manufacturing costs budget 9. Budgeted income statement (ignore income taxes) Print Done Print Done roblem 14.3.13 Data Table ansport Company makes two pet carriers, the Cat-allac and the Dog-eriffic. They are both mad with metal doors, but the Cat-allac is smaller. Information for the two products for the month d n in the following tables: Input prices Direct materials Data Table Plastic 4 per kilo Metal 3 per kilo Sales and inventory information, finished goods Direct manufacturing labour 14 per direct manufacturing labour hour Cat-allac Dog-eriffic Input quantities per unit of output Expected sales in units 580 240 Cat-allac Dog-eriffic Selling price 190 275 Direct materials Target ending inventory in units 45 25 Plastic 3 kilos 5 kilos Beginning inventory in units 25 40 Metal 0.5 kilos 1 kilo Beginning inventory in euros 2,500 7,440 Direct manufacturing labour-hours (DMLH) 3 kilos 5 hours Pet Transport uses a FIFO cost flow assumption for finished good inventory. Machine-hours (MH) 13 21 MH Inventory information, direct materials Print Done Plastic Metal Beainning inventory 290kilos 50 kilos ny number in the edit fields, then click Check Answer. Print Done