Production Budget | |||
July | August | September | |
Expected unit sales | 5970 | 6840 | 5580 |
Add Desired ending finished goods Inventory | 5130 | 4185 | 3997.5 |
Total production Required | 11100 | 11025 | 9577.5 |
Less Beginning finished goods inventory | 4478 | 5130 | 4185 |
No of Unit to be Produced | 6622 | 5895 | 5392.5 |
Purchase budget | ||
July | August | |
No of Unit to be produced | 6622 | 5895 |
Pound Required per unit | 4 | 4 |
Estimated Usage of Raw Material | 26488 | 23580 |
Add Desired ending Raw material | 11790 | 10785 |
Total Material Required | 38278 | 34365 |
Less Beginning Raw Material | 26300 | 11790 |
The number of pounds of raw materials to be purchased | 11978 | 22575 |
Osage Inc. has actual sales for May and June and forecast sales for July August September,...
Scottsdale Co. has actual sales for July and August and forecast sales for September October, November, and December as follows: $ 98,900 105,200 Actual: July August Forecast September October November December 114,200 94,300 121, 3ee 107,400 Based on past experience, it is estimated that 28% of a month's sales are collected in the month of sale, 49% are collected in the month following the sale, and 6% are collected in the second month following the sale. Required: Calculate the estimated...
Croy Inc. has the following projected sales for the next five months Month April May June July August Sales in Units 3,520 3,920 4,600 4,130 3,950 Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct material costs $3.10 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month's production needs on hand at the...
London Industries Limited has the following information: 2017 July August Budgeted Sales Units Budgeted Production Units 19,200 16,400 18,800 23,600 25,600 20,000 16,000 18,000 22,000 30,000 October Each unit requires 6 pounds of raw materials that are estimated to cost an average of $10 per pound. They also have a policy of maintaining a raw materials inventory at the end each month equal to 20% of the pounds needed for the following month's production. There were 16,000 pounds of raw...
Croy Inc. has the following projected sales for the next five months Month April May June July August Sales in Units 3.850 3.875 4.260 4,135 3.590 Croy's finished goods inventory policy is to have 60 percent of the next month's sales on hand at the end of each month. Direct material costs $3.10 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month's production needs on hand at the...
Selling price $75.00 June 8000 July 9000 August 10000 September 12000 Credit Sales Collected in the month of the sale 40% Following month 60% Ending finished goods inventory of the following month's unit sales 20% Ending raw materials inventory of the following month's raw materials production needs 10% Raw materials purchases are paid for in the month of purchase 30% Following month 70% Pounds of raw materials required for each unit of finished goods 5 Raw materials cost per pound...
Bengal Co. provides the following sales forecast for the next three months: July August September Sales units 12,000 12,700 6,300 The company wants to end each month with ending finished goods inventory equal to 25% of the next month's sales. Finished goods inventory on June 30 is 3,000 units. The budgeted production units for August are: Multiple Choice 15,700 units. 11,125 units. 14,275 units. 11,100 units. 10,950 units.
1. (6 points) Kroger Corporation had the following budget information related to the unit sales: 25,000 July August September 53,000 21,000 34,000 October Of the units budgeted, the Electronics Division sells 60% at a price of $35 per unit and the remainder are sold by the Toy Division at a price of $20 per unit. INSTRUCTIONS Prepare separate sales budgets for each division and for the company in total for the third quarter of 2019. 2. (12 points) The following...
Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,300 August 105,300 Forecast: September 114,800 October 94,300 November 122,900 December 106,300 Based on past experience, it is estimated that 29% of a month’s sales are collected in the month of sale, 48% are collected in the month following the sale, and 9% are collected in the second month following the sale. Required: Calculate the estimated cash...
Required: 1. Prepare a production budget for Supermix for the months July, August, September, and October. 3. Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total. Complete this question by entering your answers in the tabs below. Required 1 Required 3 Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter...
Croy Inc. has the following projected sales for the next five months: Month April May June July August Sales in Units 3,480 3,945 4,510 4,190 3,970 Croy's finished goods inventory policy is to have 60 percent of the next month's sales on hand at the end of each month. Direct material costs $3.10 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month's production needs on hand at the...