Question

Croy Inc. has the following projected sales for the next five months: Month Sales in Units...

Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,590 May 3,800 June 4,560 July 4,145 August 3,950 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 $2.60 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 end of each month. Raw materials on hand at March 31 totaled 3,716 pounds.

Required: 1. Determine budgeted production for April, May, and June. (Do not round your intermediate calculations and round your final answer to the nearest whole number.)

April May June
Budgeted Production (Units)

2. Determine the budgeted cost of materials purchased for April, May, and June. (Use rounded Budgeted Production units in intermediate calculations. Round your answers to 2 decimal places.)

April May June
Budgeted Cost of Material Purchased

Homework Answers

Answer #1

Since Opening inventory of finished goods of April is not given, I am taking it as 0

Calculations Particulars April May June July August
A Sales Quantity 3590 3800 4560 4145 3950
B = A of next month x 60% Closing Inventory 2280 2736 2487 2370
C = B of previous month Opening Inventory 0 2280 2736 2487 2370
E = A + B - C Production required (1) 5870 4256 4311 4028
F Material required per unit 2 2 2 2
G = E x F Total material required 11740 8512 8622 8056
H = G of next month x 50% Closing Inventory of raw materials 4256 4311 4028
I = H of previous month Opening Inventory of raw materials 3716 4256 4311
J = G + H - I Purchases required 12280 8567 8339
K Price per unit of raw materials 2.6 2.6 2.6
L = J x K Budgeted cost of materials purchased (2) 31928.00 22274.20 21681.40
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,430 May 3,840 June 4,550 July 4,105 August 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 materials costs $3.20 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Croy Inc. has the following projected sales for the next five months:    Month Sales in Units...
Croy Inc. has the following projected sales for the next five months:    Month Sales in Units April 3,560 May 3,905 June 4,510 July 4,155 August 3,900 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 $2.70 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...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,600 May 3,810 June 4,570 July 4,170 August 4,000 Croy’s finished goods inventory policy is to have 70 percent of the next month’s sales on hand at the end of each month. Direct material costs $2.90 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...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,580 May 3,890 June 4,540 July 4,110 August 3,990 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 materials costs $2.70 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Madrid Inc. has the following budgeted production in units for the next four months: Units Month...
Madrid Inc. has the following budgeted production in units for the next four months: Units Month Produced June 90,000 July 120,000 August 210,000 September 150,000 Two pounds of raw materials are required for each unit produced. Ending raw materials inventory should equal 30% of next month’s production needs. Raw materials inventory on June 1st was 54,000 pounds. Madrid's total required raw material purchases in pounds for July are: Group of answer choices are 240,000 158,000 366,000 294,000
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September,...
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September, and October as follows: Actual: May 5,930 units June 6,240 units Forecast: July 5,910 units August 6,890 units September 5,630 units October 5,210 units Required: a. The firm’s policy is to have finished goods inventory on hand at the end of the month that is equal to 70% of the next month’s sales. It is currently estimated that there will be 4,137 units on...
Zira Co. reports the following production budget for the next four months. April May June July...
Zira Co. reports the following production budget for the next four months. April May June July Production (units) 576 630 608 588 Each finished unit requires four pounds of raw materials and the company wants to end each month with raw materials inventory equal to 40% of next month’s production needs. Beginning raw materials inventory for April was 922 pounds. Assume direct materials cost $5 per pound. Prepare a direct materials budget for April, May, and June. (Round your intermediate...
2. Zira Co. reports the following production budget for the next four months. April May June...
2. Zira Co. reports the following production budget for the next four months. April May June July Production (units) 656 710 688 668 Each finished unit requires six pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month’s production needs. Beginning raw materials inventory for April was 1,181 pounds. Assume direct materials cost $5 per pound. Prepare a direct materials budget for April, May, and June. (Round your...
ABC Company’s budgeted sales for June, July, and August are 12,400, 16,400, and 14,400 units, respectively....
ABC Company’s budgeted sales for June, July, and August are 12,400, 16,400, and 14,400 units, respectively. ABC requires 30% of the next month’s budgeted unit sales as finished goods inventory each month. Budgeted ending finished goods inventory for May is 3,720 units. Each unit that ABC Company produces uses 3 pounds of raw material. ABC requires 25% of the next month’s budgeted production as raw material inventory each month. Required: Calculate the number of pounds of raw material to be...
ABC Company’s budgeted sales for June, July, and August are 15,600, 19,600, and 17,600 units, respectively....
ABC Company’s budgeted sales for June, July, and August are 15,600, 19,600, and 17,600 units, respectively. ABC requires 30% of the next month’s budgeted unit sales as finished goods inventory each month. Budgeted ending finished goods inventory for May is 4,680 units. Each unit that ABC Company produces uses 3 pounds of raw material. ABC requires 25% of the next month’s budgeted production as raw material inventory each month. Required: Calculate the number of pounds of raw material to be...