Cray Inc. has the following projected sales for the next five months: 3,500 3,00
ID: 2563874 • Letter: C
Question
Cray Inc. has the following projected sales for the next five months: 3,500 3,005 4,620 4.200 3,910 August 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.40 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 peroent of the next month's production needs on hand at the end of each month. Raw materials on hand at March 31 totaled 3,703 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.) Budgeted Production (Units) 3,703 4.263 4,410 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.) Budgeted Cost of Material Purchased25,17700 Cost of Material Purchased 25,17700 16,396 o$ 15,495 50Explanation / Answer
Cost of raw material purchased is as calculated below:
Working Note:
Ending direct material for June is 50% of July prod
July Production is 4,055 units (4,200 sales + (50 % of Aug sales ) - Clsoing inventory if June
= 4,200+1,955- 2,100 = 4,055
Raw material Budget Croy Inc For the Quarter Enfded June Particulars April May June Planned production units (a) 3,703 4,263 4,410 *Direct Material required per unit (b) 2.0 2.0 2.0 Direct Material Required for production (c ) 7,405 8,525 8,820 Budgeted ending Direct Material (d) (50% of next month production 4,263 4,410 4,055 Beginning Direct Material (e ) 3,703 4,263 4,410 Budgeted direct material purchase f= c+d-e 7,965 8,673 8,465 Cost per unit (g) $3.4 $3.4 $3.4 BudgetedDM purchases $27,081 $29,487 $28,781