1. Preparation of Revenue Budget for April
Sales Budget | ||
For the Month of April | ||
Products | ||
Cat-allac | Dog-eriffic | |
Expected sales in units | 500 | 215 |
Sales price per unit | $ 215 | $ 320 |
Total expected sales | $ 107,500 | $ 68,800 |
Note: Total sales = Expected sales in units × Sales price per unit
2. Preparation of Production Budget in units
Production Budget in Units | ||
For the Month of April | ||
Products | ||
Cat-allac | Dog-eriffic | |
Expected sales in units | 500 | 215 |
Add: Target ending inventory in units | 35 | 15 |
Total production required in units | 535 | 230 |
Less: Beginning inventory in units | 15 | 30 |
Units to be produced | 520 | 200 |
3. (a) Preparation of Direct Material Usage Budget
Direct Material Usage Budget | ||
For the Month of April | ||
Products | ||
Cat-allac | Dog-eriffic | |
Direct materials required to produce 1 unit: | ||
Plastic | 3 pounds | 5 pounds |
Metal | 0.5 pounds | 1 pounds |
Units to be produced | 520 units | 200 units |
Total material required: | ||
Plastic (Units to be produced × Material required to produce 1 unit) |
1,560 pounds | 1,000 pounds |
Metal (Units to be produced × Material required to produce 1 unit) |
260 pounds | 200 pounds |
3. (b) Preparation of Direct Material Purchase Budget
Direct Material Purchases Budget | ||
For the Month of April | ||
Materials | ||
Plastic | Metal | |
Materials required for production: | ||
Cat-allac | 1,560 pounds | 260 pounds |
Dog-eriffic | 1,000 pounds | 200 pounds |
Total material required for production | 2,560 pounds | 460 pounds |
Add: Target ending inventory | 420 pounds | 45 pounds |
Total Requirement | 2,980 pounds | 505 pounds |
Less: Beginning inventory | 290 pounds | 50 pounds |
Materials need to be purchased | 2,690 pounds | 455 pounds |
Material cost per pound | $ 4 | $ 3 |
Total material purchase cost | $ 10,760 | $ 1,365 |
4. Preparation of Direct Manufacturing Labor Cost Budget:
Direct Manufacturing Labor Cost Budget | ||
For the Month of April | ||
Products | ||
Cat-allac | Dog-eriffic | |
Units to be produced | 520 units | 200 units |
Direct
manufacturing labor-hours(DMLH) required to produce 1 unit |
3 hours | 5 hours |
Total
direct manufacturing labor-hours required (Units to be produced × DMLH per unit) |
1,560 hours | 1,000 hours |
Direct manufacturing labor cost per unit | $ 10 | $ 10 |
Total Direct manufacturing labor cost | $ 15,600 | $ 10,000 |
As HOMEWORKLIB RULES Q&A guidelines I have answered the first four parts (i.e. the budgets). Please upload the question again for the remaining answers.
w P i S of the month of April is given in the following tables: (Click...
Input Prices Direct materials Plastic Metal Direct manufacturing labor $ 6 per pound $ 5 per pound $ 12 per direct manufacturing labor hour Input Quantities per Unit of Output Cat-allac Dog-eriffic Direct materials Plastic Metal Direct manufacturing labor-hours (DMLH) Machine-hours (MH) 5 pounds 0.5 pounds 3 hours 12 MH 7 pounds 1 pound 5 hours 20 MH Inventory Information, Direct Materials Metal Beginning inventory Target ending inventory Cost of beginning inventory Plastic 220 pounds 400 pounds 924 70 pounds...
A 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...
Pet Luggage 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 Luggage accounts for direct materials using a FIFO cost-flow assumption. (Click the icon to view the account information.) Pet Luggage uses an activity-based costing system and...
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 Input Prices Direct materials Plastic $4 per pound Metal $3 per pound Direct manufacturing labor $14 per direct manufacturing labor hour Input Quantities per Unit of Output Cat-allac Dog-eriffic Direct materials Plastic 3 pounds 5 pounds Metal 0.5...
I only need help with the top part. I can not see the other parts to the question Animal 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.) Animal Transport accounts for direct materials using a...
P6-40 (similar to) Question Help Pet Transport Company makes two pet carriers, the Cat-allac and the Dog-eriffic. Pet Transport uses an activity-based costing system and classifies overhead into They are both made of plastic with metal doors, but the Cat-allac is smaller. three activity pools: Setup, Processing, and Inspection. Activity rates for these Information for the two products for the month of April is given in the following activities are $120 per setup-hour, $10 per machine-hour, and $10 per tables:...
P6-40 (similar to) Animal 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.) Animal Transport accounts for direct materials using a FIFO cost-flow assumption. E!! (Click the icon to view the account information.) Requirement 1. Prepare the...
Animal 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.) Animal Transport accounts for direct materials using a FIFO cost-flow assumption. 2(Click the icon to view the account information.) Animal Transport uses an activity-based costing system and...
Assume the following data for Animal Gear Company: (Click the icon to view the assumptions.) 2 (Click the icon to view budget information.) Requirements 1. Prepare a cash budget for April for Animal Gear. 2. Why do Animal Gear's managers prepare a cash budget in addition to the revenue, expenses, and operating income budget? Requirement 1. Prepare a cash budget for April for Animal Gear. Begin the cash budget by calculating the cash available, then total disbursements, and finally the...