Inventory information, direct materials Plastic Metal 290 kilos 50 kilos Beginning inventory Target ending inventory Cost of beginning inventory 410 kilos 40 kilos 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: (Click the icon to view the information for the two products.) Pet Transport accounts for direct materials using a FIFO cost flow assumption. |(Click the icon to view the account information.) 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.) Read the requirements. Dog-errific 1,125 225 lbs. lbs. 2,925 525 Total quantity of direct material to be used lbs. lbs. 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 (1) i - X Requirements i X Data Table u Cost driver information Cat-allac Dog-errific Number of units per batch 25 13 e 1.25 hours 2.00 hours Setup time per batch Inspection time per batch Requirements Prepare the following for April: 1. Revenues budget 2. Production budget in units 3. Direct material usage budget and direct material purchases budget 4. Direct manufacturing labour cost budget 5. Manufacturing overhead cost budgets for each of the three activities 6. Budgeted unit cost of ending finished goods inventory ending inventories budget 7. Cost of goods sold budget 8. Non-manufacturing costs budget 9. Budgeted income statement (ignore income taxes) 0.5 hours 0.6 hour O 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. Print Done Print Done roblem 14.3.13 i 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 o 7 in the following tables: i X Data Table Input prices Direct materials Plastic 4 per kilo Metal 3 per kilo Direct manufacturing labour 14 per direct manufacturing labour hour Input quantities per unit of output Cat-allac Dog-eriffic Direct materials Sales and inventory information, finished goods Cat-allac Dog-eriffic Expected sales in units 580 240 Selling price 190 275 Target ending inventory in units 45 25 Beginning inventory in units 25 40 Beginning inventory in euros 2,500 7,440 Pet Transport uses a FIFO cost flow assumption for finished good inventory. Plastic 3 kilos 5 kilos Metal 0.5 kilos 1 kilo 3 kilos 5 hours Direct manufacturing labour-hours (DMLH) Machine-hours (MH) 13 MH 21 MH Inventory information, direct materials Print Done Plastic Metal Beginning inventory 290 kilos 50 kilos ny number in the edit fields, then click Check Answer. Print Done