Joshua Hill, Bramble & Hill Fabricators' production manager, has just received the company's sales budget for the first quarter.

January		February			March			April		May			June
18,600		36,270			32,550			26,970		23,000			20,000

Company policy requires an ending finished goods inventory each month that will meet 19% of the following month's sales volume. Joshua plans to have 5,208 finished bricks at a cost of $45,570 in inventory at the beginning of the year. Prepare Bramble & Hill's production budget for the first quarter. (Round answers to 0 decimal places, e.g. 5,275.)

Drop Downs

January

February

March

Quarter

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Enter a number of units

Drop Downs answers include (CHOOSE ONE) budgeted production, budgeted ending inventory, beginning inventory, budgeted unit sales, and total units required.

There are 5 rows beneath Jan, Feb, March and Quarter, the table just wont paste correctly.