Question

In: Accounting

• It is now the beginning of January • Sales are forecast at 100,000 units for...

• It is now the beginning of January • Sales are forecast at 100,000 units for January, 130,000 units for February, and 150,000 units for March. • Ending inventory of finished product should be 20% of next month’s sales. • Each unit of finished product requires 0.5 lb. of materials. • Ending inventory of materials should be 10% of next month’s production needs. • Beginning inventory of finished product is 22,000 units. • Beginning inventory of materials is 5,500 lbs.

12. What is forecasted production for January?

a.               104,000 units

b.               96,000 units

c.               106,500 units

d.               102,500 units

13. If the forecasted production for February is 134,000 units. What amount of materials should be purchased in January?

a.               52,000 lbs.

*b.             53,200 lbs.

c.               54,500 lbs.

d.               51,600 lbs.

Solutions

Expert Solution

Question 12.
Answer: a.104,000 units
Explanation:
Sales in January 100000 Units
Less: Begining Inventory 22000 Units
Required production for January sales 78000 Units
Add: Required ending inventory (130000*20%) 26000 Units
Forecasted production for January 104000 Units
Question 13
Answer: b.53,200 lbs
Explanation:
Forecasted production for January 104000 units
Raw materials required (104,000*0.5lb per unit0 52000 lbs
Less: Begining inventory of materials 5500 lbs
Required materials for January Production 46500 lbs
Add: ending inventory of materials (134000*0.5*10%) 6700 lbs
Materials to be purchased in January 53200 lbs

Related Solutions

1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s sales. The inventory...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s sales. The inventory...
Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April:...
Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s...
Information for 2019: 1.   Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April:...
Information for 2019: 1.   Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April: 3,500 units. The unit sales price is $50. All sales are on credit and collections are 20% in the month of sale and 80% the following month. Accounts receivable as of December 31, 2018 is $15,000 and this amount is expected to be collected in January 2019. 2. End of month inventory must equal 60% of next month’s sales. The inventory at the end...
The Ace Battery Company has forecast its sales in units as follows:   January 1,900 May 2,450...
The Ace Battery Company has forecast its sales in units as follows:   January 1,900 May 2,450   February 1,750 June 2,600   March 1,700 July 2,300   April 2,200 Ace always keeps an ending inventory equal to 130 percent of the next month's expected sales. The ending inventory for December (January's beginning inventory) is 2,470 units, which is consistent with this policy. Materials cost $14 per unit and are paid for in the month after production. Labour cost is $7 per unit and...
The Volt Battery Company has forecast its sales in units as follows: January 3,200 May 3,750...
The Volt Battery Company has forecast its sales in units as follows: January 3,200 May 3,750 February 3,050 June 3,900 March 3,000 July 3,600 April 3,500 Volt Battery always keeps an ending inventory equal to 140% of the next month’s expected sales. The ending inventory for December (January’s beginning inventory) is 4,480 units, which is consistent with this policy.    Materials cost $15 per unit and are paid for in the month after purchase. Labor cost is $8 per unit...
***ONLY NEED QUESTIONS 6 & 7 ANSWERED*** Information for 2020: 1.   Sales forecast: January: 2,600 units;...
***ONLY NEED QUESTIONS 6 & 7 ANSWERED*** Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month...
Milton Inc. has prepared the following first quarter sales forecast: January 370 000 units February 485...
Milton Inc. has prepared the following first quarter sales forecast: January 370 000 units February 485 000 units March 545 000 units Each unit sells for $4.50. The sales budget for the first quarter is: $940 000 $4 900 000 $1 400 000 $6 300 000
. Using only the New York sales data: 1a. Forecast sales for January 5th through January...
. Using only the New York sales data: 1a. Forecast sales for January 5th through January 30th using exponential smoothing with alpha set to 0.6. Assume the sales forecast for January 4th was 456. 1b. Using your forecasts from 1a, find the mean absolute deviation of the sales forecasts for January 5th through January 29th. Again, you should not include the forecast for January 30 since there is no corresponding sales figure for that date. 1c. Using your forecasts from...
Royal Manufacturing estimates its sales at 100,000 units in the first quarter and that sales will...
Royal Manufacturing estimates its sales at 100,000 units in the first quarter and that sales will increase by 10,000 units each quarter over the year. Company policy requires a 25% ending inventory of finished goods. Each unit sells for $35. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Cash collections for the third quarter are budgeted at?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT