Please help, I am not certain I this is correct and now I am stuck. Thank you in advance.
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | |||||||
1. Direct Material Purchase Budget | |||||||
Q1 | Q2 | Q3 | Q4 | Total | |||
Budgeted units to be produced | 300 | 330 | 350 | 400 | 1,380 | ||
Raw material needed per unit | 5 | 5 | 5 | 5 | 5 | ||
Total Mat Required | 1,500 | 1,650 | 1,750 | 2,000 | 6,900 | ||
Add: Desired Ending Inventory | 30% | 495 | 525 | 600 | 280 | 280 | |
Total Need | 1,995 | 2,175 | 2,350 | 2,280 | 7,180 | ||
Less: Beginning Inventory | -860 | -495 | -525 | -600 | -860 | ||
Budgeted Purchase of Raw Mat | 1,135 | 1,680 | 1,825 | 1,680 | 6,320 | ||
Cost per Unit of RM | $ 2.00 | $ 2.00 | $ 2.00 | $ 2.00 | $ 2.00 | ||
Budgeted Purchase of Raw Mat $ | $ 2,270 | $ 3,360 | $ 3,650 | $ 3,360 | $ 12,640 | ||
2. Direct Labor Budget | |||||||
Q1 | Q2 | Q3 | Q4 | Total | |||
Budgeted units to be produced | 300 | 330 | 350 | 400 | 1,380 | ||
Labor hours per unit | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | ||
Total HOurs Required | 225.00 | 247.50 | 262.50 | 300.00 | 1035.00 | ||
Per Hour Price | $ 35 | $ 35 | $ 35 | $ 35 | $ 35 | ||
Budgeted Direct Labor Cost | $ 7,875 | $ 8,663 | $ 9,188 | $ 10,500 | $ 36,225 | ||
3. Manufacturing overhead budget | |||||||
Q1 | Q2 | Q3 | Q4 | Total | |||
Budgeted Production | 300 | 330 | 350 | 400 | 1,380 | ||
Variable Overhead cost per kit | $ 0.75 | $ 0.75 | $ 0.75 | $ 0.75 | $ 0.75 | ||
Budgeted VOH | $ 225 | $ 248 | $ 263 | $ 300 | $ 1,035 | ||
Budget FOH | $ 155 | $ 155 | $ 155 | $ 155 | $ 620 | ||
Budgeted manufacturing overhead cost | $ 380 | $ 403 | $ 418 | $ 455 | $ 1,655 | ||
Direct Labor Hours | 225.00 | 247.50 | 262.50 | 300.00 | 1,035.00 | ||
Budgeted manufacturing overhead cost | $ 1,655 | ||||||
Predetermined overhead rate | 1.60 |
Please help, I am not certain I this is correct and now I am stuck. Thank...
Inc. manufactures model airplane kits and projects production at 150, 270, 350, and 700 kits for the next four quarters. Prepare Kevin's direct materials budget, direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number. Direct materials are 7 ounces of plastic per kit and the plastic costs $1 per ounce. Indirect...
Thanks!!!!! Question Help Trevor, Inc. manufactures model airplane kits and projects production at 350, 680, 600, and 450 kits for the next four quarters. (Click the icon to view the manufacturing information.) Prepare Trevor's direct materials budget, direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number Begin by preparing Trevor's direct...
Preston, Inc., manufactures model airplane kits and projects production at 300, 420, 650, and 550 kits for the next four quarters Click the icon to view the manufacturing information.) Prepare Preston's direct materials budget, direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number Begin by preparing Preston's direct * More Info...
Luther, Inc. manufactures model airplane kits and projects production at 550, 450, 400, and 300 kits for the next four quarters (Click the icon to view the manufacturing information.) Prepare Luther's direct materials budget direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number CCS-54 (millar to) ther, Inc. manufactures model airplane...
Oliver, Inc. manufactures model airplane kits and projects production at 500, 530, 550, and 650 kits for the next four quarters. Direct materials are 5 ounces of plastic per kit and the plastic costs $3 per ounce. Indirect materials are considered insignificant and are not included in the budgeting process. Beginning Raw Materials Inventory is 890ounces, and the company desires to end each quarter with 20% of the materials needed for the next quarter's production. Oliver desires a balance of...
Austin, Inc., manufactures model airplane kits and projects production at 150, 620, 250, and 750 kits for the next four quarters A (Click the icon to view the manufacturing information.) Prepare Austin's direct materials budget, direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number. Austin, Inc. Direct Materials Budget For the...
GOOD MORNING LADIES AND GENTLEMEN, PLS I NEED HELP WITH THIS HOMEWORK BEFORE I CAN POST IT, THAT MEANS I'M STUCK, HAIF OF MY CLASS AS WELL, PLS HELP US, I WILL LEAVE A COMMENT AND THUMBS UP AS I ALWAYS DO, I KNOW OTHER WILL DO 2. THANKS Kelvin, Inc. manufactures model airplane kits. Direct materials are 2 ounces of plastic per kit and the plastic costs $5 per ounce. Indirect materials are considered insignificant and are not included...
Wilber, Inc. manufactures model airplane kits and projects production at 600, 360, 250, and 400 kits for the next four quarters. Direct materials are $6 per kit. Indirect materials are considered insignificant and are not included in the budgeting process. Beginning Raw Materials Inventory is $650, and the company desires to end each quarter with 10% of the materials needed for the next quarter's production. Wilber desires a balance of $650 in Raw Materials Inventory at the end of the...
Grady, Inc. manufactures model airplane kits and projects production at 550, 530, 400, and 550 kits for the next four quarters. Direct materials are $12 per kit. Indirect materials are considered insignificant and are not included in the budgeting process. Beginning Raw Materials Inventory is $600, and the company desires to end each quarter with 30% of the materials needed for the next quarter's production. Grady desires a balance of $600 in Raw Materials Inventory at the end of the...
next month's sales. Prepare ril, May, and June Sales buu Le E22-24 Preparing an operating budget- manufacturing overhead budgets direct materials, direct labor, and Grady, Inc manufactures model airplane kits and projects production at 650, 500 450, and 600 kits for the next four quarters. Direct materials are 4 ounces of plastic per kit and the plastic costs $1 per ounce. Indirect materials are considered insignifi- cant and are not included in the budgeting process. Beginning Raw Materials Inven- tory...