10.
January | February | March | ||
Estimated sales (units) | 770 | 840 | 910 | |
+ | Desired ending inventory (units) | 84 (840*10%) | 91 (910*10%) | 98 (980*10%) |
- | Beginning inventory (units) | 77 (770*10%) | 84 | 91 |
= | Required production (in units) | 777 | 847 | 917 |
11.
January | February | March | ||
Required production (in units) | 770 | 840 | 770 | |
Raw material needed per unit (Ibs) | 5 | 5 | 5 | |
= | Production needs (Ibs) | 3,850 (770*5) | 4,200 (840*5) | 3,850 (770*5) |
+ | Desired ending inventory (Ibs) | 420 (4,200*10%) | 385 (3,850*10%) | 455 (910*5*10%) |
- | Beginning inventory (Ibs) | 100 | 420 | 385 |
= | Raw material to be purchased (Ibs) | 4,170 | 4,165 | 3,920 |
Cost per raw material (per Ib) | 0.20 | 0.20 | 0.20 | |
= | Cost of raw material purchases | $834 (4170*0.20) | $833 (4165*0.20) | $784 (3920*0.20) |
12.
January | February | March | ||
Required production (in units) | 770 | 840 | 770 | |
Direct labor hours per unit (in hours) | 0.25 (15mins/60mins) | 0.25 | 0.25 | |
= | Total DL hours required | 192.5 (770*0.25) | 210 (840*0.25) | 192.5 (770*0.25) |
Direct labor cost per hour | $9 | $9 | $9 | |
= | Total direct labor cost | $1,732.5 (192.5*$9) | $1,890 (210*$9) | $1,732.5 (192.5*$9) |
Ex 10.11.12 because im lost. with explainatiin please! xercise 10 Luigi expects the following sales of...
Production Budget and Direct Materials Purchases Budgets Peanut Land Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows: Unit Sales Dollar Sales ($) January 40,000 72,000 February 45,000 81,000 March 60,000 108,000 April 42,000 75,600 Company policy requires that ending inventories for each month be 20% of next month's sales. At the beginning of January, the inventory of peanut butter is...
Production Budget and Direct Materials Purchases Budgets Peanut-Fresh Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows: Unit Sales Dollar Sales ($) January 48,000 100,800 February 46,000 96,600 March 55,000 121,000 April 58,000 125,200 Company policy requires that ending inventories for each month be 20% of next month's sales. At the beginning of January, the inventory of peanut butter is 14,500...
16. Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in units 320 360 380 320 Each month's ending Finished Goods Inventory in units should be 40% of the next month's sales. March 31 Finished Goods inventory is 128 units. A finished unit requires five pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 280 pounds of direct material B. Each...
Trebblehorn Industries has adopted the following sales budget for the first 3 months of 2017. Month Units January 11,000 February 15,000 March 13,000 Management requires 30% of next month sales to be in ending inventory. Each unit requires 5 pounds of raw materials costing $3 per pound. Management wants to have a raw materials inventory at the end of the month equal to 35% of next month's production requirements. April's expected sales are 12,000 with a total of 13,500 required...
Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: a. Estimated sales at $125 per unit: January 25,000 units February 30,000 units March 45,000 units April 50,000 units b. Estimated finished goods inventories: January 1 2,000 units January 31 10% of next month’s sales February 28 10% of next month’s sales March 31 10% of next month’s...
1. 2. A E 3 4 5 6 7 8 9 B D Budget Assumptions For the months of January, February, and March January February Selling price per unit $200 $200 Budgeted sales (units) 12,000 15,000 Budgeted sales (units) April Budgeted production (units) April Ratio of ending finished goods inventory to next month's sales Ratio of ending raw materials inventory to next month's requirements Number of units in finished goods inventory, January 1 Number of pounds in raw materials inventory,...
May 735 pple Company provides the following data for the next three months. Feb 780 Jan 685 Budgeted production units Beginning Raw Materials inventory-Ibs. Ending Finished Goods Inventory - units 705 160 Apple had decided that Raw Materials desired ending inventory shou month's production needs. Each unit of production takes four pounds w Materials desired ending inventory should be 40% of the next Each unit of production takes four pounds of raw materials. What is the quantity (lbs.) of Raw...
Please Do part B Garver Industries has budgeted the following unit sales: 2020 January February March April May Units 10,000 8,000 9,000 11,000 15,000 The finished goods units on hand on December 31, 2019, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated...
Pina Company's sales budget projects unit sales of part 1987 of 10,700 units in January, 12,200 units in February, and 13,000 units in March. Each unit of part 198Z requires 3 pounds of materials, which cost $4 per pound. Pina Company desires its ending raw materials inventory to equal 40% of the next month's production requirements, and its ending finished goods inventory to equal 20% of the next month's expected unit sales. These goals were met at December 31, 2016....
Project #2 Sales Projections in Units January February March April May 13.402 45,819 44,164 53,722 52,482 Projected Sales Price/Unit $ 450.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $16.00 Fixed Costs $5,519 Production: Desired Ending Inventory Beginning Inventory (new business) 59.0% 0 64.6% Materials Desired Ending Inventory Number of Materials per Unit Projected Cost/Material Unit Beginning Inventory (new business) 11.0 $23.00 0 Direct Labor Time per Unit (in hours) Cost per Hour 1.00 $21.00 Manufacturing Overhead Variable Cost/Unit $5.00...