Please finish requirement 7-10.
Animal Gear 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.) Animal Gear accounts for direct materials using a FIFO cost flow assumption. E (Click the icon to view the account information.) Animal Gear uses an activity-based costing system and classifies overhead into three activity pools: Setup, Processing, and Inspection. Activity rates for these activities are $105 per setup-hour, $10 per machine-hour, and $15 per inspection-hour, respectively. Other information follows: (Click the icon to view the other information.) Read the requirements. Requirement 1. Prepare the revenues budget. Revenues Budget For the Month of April Units Selling price Total revenues 530 $ 205 $ 108,650 265 310_ 82,150 $ 190,800 Cat-allac Dog-eriffic Total Requirement 2. Prepare the production budget in units. Production Budget (in Units) For the Month of April Cat-allac Budgeted units sales 530 Add target ending finished goods inventory 30 Total required units 560 Deduct beginning finished goods inventory 10 550 Units of finished goods to be produced Dog-eriffic 265 10 275 25 250 Requirement 3. Prepare the direct material usage budget and direct material purchases budget. Begin with the physical units portion, then prepare the cost budget portion of the direct material usage budget. Direct Material Usage Budget in Quantity and Dollars For the Month of April Material Enter any number in the edit fields and then click Check Answer. Total Direct Material Usage Budget in Quantity and Dollars For the Month of April Material Plastic Metal Physical Units Budget Direct materials required for Cat-allac 2,200 lbs. Dog-errific 3,700 Total quantity of direct material to be used Cost Budget Available from beginning direct materials inventory (under a FIFO cost-flow assumption) Plastic $ 943 Metal $ 203 1.500 lbs. To be purchased this period Plastic 17,350 Metal 1,820 2,023 $ 18,293 Direct materials to be used this period $ $ 20,316 Now prepare the direct material purchases budget. Direct Materials Purchases Budget For the Month of April Materials Enter any number in the edit fields and then click Check Answer. Now prepare the direct material purchases budget. Direct Materials Purchases Budget For the Month of April Materials Plastic Metal Total 3,700 lbs. Physical Units Budget To be used in production Add target ending inventory Total requirement Deduct beginning inventory 410 lbs 4,110 lbs 230 lbs 3,880 Purchases to be made Cost Budget $ $ 19,400 2,060 $ Purchases 21,460 Requirement 4. Prepare the direct manufacturing labor cost budget. Direct Manufacturing Labor Costs Budget For the Month of April Output units DMLH T otal Hourly produced per unit hours wage rate 550 3 1 ,650 $ 10 5 1,250 10 Cat-allac ??? $ Total 16,500 1 2,500 29,000 Dog-eriffic 250 | Total $ Enter any number in the edit fields and then click Check Answer. Requirement 5. Prepare the manufacturing overhead cost budgets for each of the three activities. Manufacturing Overhead Budget For the Month of April Machine setup costs 8,715 Processing costs 105,500 465 Inspection costs $ 114,680 Total Requirement 6. Prepare the budgeted unit cost of ending finished goods inventory and ending inventories budget. First, prepare the budgeted unit cost of ending finished goods inventory. (Round the hours to four decimal places and the totals to two decimal places.) Unit Costs of Ending Finished Goods Inventory April 30 Product Cat-allac Dog-errific Cost per Input per Input per unit of unit of unit of input output Total output 4 lbs. $ 20.00 6 lbs. $ 0.5 lbs. 2.00 1 lb. 3 hrs. 30.00 5 hrs. 105 0.0600 hrs. 6.30 0.2000 hrs. 11 MH 110.00 18 MH 0.0200 hrs 0.30 0.0800 hrs Total 30.00 Plastic Metal 4.00 Direct manufacturing labor Machine setup Processing 50.00 21.00 180.00 1.20 Insnertion Enter any number in the edit fields and then click Check Answer. unit of input Total unit of output 4 lbs. 0.5 lbs. Total 20.00 Plastic $ $ 2.00 Metal Direct manufacturing labor 3 hrs. unit of output 6 lbs. 1 lb. 5 hrs. 0.2000 hrs. 18 MH 0.0800 hrs. Machine setup Processing 30.00 6.30 110.00 0.30 168.60 0.0600 hrs 11 MH 0.0200 hrs. 30.00 4.00 50.00 21.00 180.00 1.20 286.20 Inspection 15 $ $ Total Now prepare the ending inventories budget. (Enter costs per unit to the nearest cent and round your answers to the nearest whole dollar.) Ending Inventories Budget April 30 Quantity Cost per unit Total Direct materials Plastic 410 $ 5 2,050 240 Metal 2,290 Finished goods Cat-allac $ 30 10 168.60 286.20 5,058 2,862 Dog-errific 7,920 10,210 Total ending inventory Requirement 7. Prepare the cost of goods sold budget. Enter any number in the edit fields and then click Check Answer. We were unable to transcribe this imageA Data Table 530 Sales and Inventory Information, Finished Goods Cat-allac Dog-eriffic Expected sales in units 265 Selling price $ 205 $ 310 Target ending inventory in units 30 Beginning inventory in units 1025 Beginning inventory in dollars $ 1,000 $ 4,650 Animal Gear uses a FIFO cost flow assumption for finished good inventory. Print Done A Data Table 25 10 Cost Driver Information Cat-allac Dog-errific Number of units per batch Setup time per batch 1.50 hours 2.00 hours Inspection time per batch 0.5 hours 0.8 hour Nonmanufacturing fixed costs for March equal $36,000, of which half are salaries Salaries are expected to increase 5% in April. The only variable nonmanufacturing cost is sales commission, equal to 1% of sales revenue. Print Done i 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 labor cost budget 5. Manufacturing overhead cost budgets for each of the three activities 6. Budgeted unit cost of ending finished goods inventory and ending inventories budget 7. Cost of goods sold budget 8. Nonmanufacturing costs budget 9. Budgeted income statement (ignore income taxes) 10. How does preparing the budget help Animal Gear's management team better manage the company? Print Done