Budgeted sales: Q1 of 2019 30.000 cases 28,000 cases 29,000 cases 9.000 cases $22.50 dwars per w 04 Unit selling price All sales are on account (on credit). Collection pattern: Cash collected in the quarter of sale Cash collected in the quarter following sale 66% 34% Beginning FG inventory (in units) Desired ending FG inventoryext quarter's sales Desired ending FG inventory at year end 2.400 cases 30% 11,000 cases Beginning RM inventory (in units) Quantity of DM needed per unit DM cost per pound Desired ending RM inventoryext quarter's RM Desired ending RM inventory at year end 22.000 mounds 15.00 ouds $0.25 dewas 10% 24.000 mounds Cash payments to suppliers: paid in the quarter of purchase paid in the quarter following purchase 34% 66% other pawchases He wotases DL hours per unit DL rate per hour 0.50 hours $15.00 dollars Manufacturing overhead Variable MOH Fixed MOH $5.00 $24,000 UA per quarter Noncash MOH Depreciation $17,000 per quarter $0.80 my case Selling and administrative expenses Variable SA Fixed SA Advertising Executive Salaries Consulting Insurance Depreciation $5.000 mey quayley $27.000 me quarter $9.000 per quales $5,000 per quarter $4.000 per quarter WI U3 L14 Froduction Budget esired units of finished goods inventory otal needs ess units of beginning goods inventory equired production in units 8400.00 38400.00 2400.00 36000.00 8700.00 36700.00 8400.00 28300.00 2700.00 31700.00 8700.00 23000.00 1000.00 11000.00 20000.00 126800.00 2700.00 2400.00 17300.00 124400.00 Ending Finished Goods inventory Budget UV TEVE 11377 production cost per case irect materials irect labor Hanufacturing over head nit product cost ariable MOH ixed MOH 15.00 pounds 0.25 hours 0.25 hours 0.50 per pound 15.00 per hour per hour Budgeted finished goods inventory: nding finished goods inventory in cases nit product cost nding finished goods inventory in dollars Direct materials budget equired production in units of finished goods nits of raw materials needed per unit of finished goods nits of raw materials needed to meet production esired units of ending materials needed tal units of raw materials needed Ess units of beginning raw materials inventory materiale inventoru nits of raw materials to be purchased nit cost of raw materials ost of raw materials to be purchased Hule of Expected Cash Disbursements for Purchases of Materials eginning accounts payable rst-quarter purchases econd-quarter purchases hird-quarter purchases ourth-quarter purchases otal cash disbursements for materials Budgeted sales: Q1 of 2019 30.000 cases 28,000 cases 29,000 cases 9.000 cases $22.50 dwars per w 04 Unit selling price All sales are on account (on credit). Collection pattern: Cash collected in the quarter of sale Cash collected in the quarter following sale 66% 34% Beginning FG inventory (in units) Desired ending FG inventoryext quarter's sales Desired ending FG inventory at year end 2.400 cases 30% 11,000 cases Beginning RM inventory (in units) Quantity of DM needed per unit DM cost per pound Desired ending RM inventoryext quarter's RM Desired ending RM inventory at year end 22.000 mounds 15.00 ouds $0.25 dewas 10% 24.000 mounds Cash payments to suppliers: paid in the quarter of purchase paid in the quarter following purchase 34% 66% other pawchases He wotases DL hours per unit DL rate per hour 0.50 hours $15.00 dollars Manufacturing overhead Variable MOH Fixed MOH $5.00 $24,000 UA per quarter Noncash MOH Depreciation $17,000 per quarter $0.80 my case Selling and administrative expenses Variable SA Fixed SA Advertising Executive Salaries Consulting Insurance Depreciation $5.000 mey quayley $27.000 me quarter $9.000 per quales $5,000 per quarter $4.000 per quarter WI U3 L14 Froduction Budget esired units of finished goods inventory otal needs ess units of beginning goods inventory equired production in units 8400.00 38400.00 2400.00 36000.00 8700.00 36700.00 8400.00 28300.00 2700.00 31700.00 8700.00 23000.00 1000.00 11000.00 20000.00 126800.00 2700.00 2400.00 17300.00 124400.00 Ending Finished Goods inventory Budget UV TEVE 11377 production cost per case irect materials irect labor Hanufacturing over head nit product cost ariable MOH ixed MOH 15.00 pounds 0.25 hours 0.25 hours 0.50 per pound 15.00 per hour per hour Budgeted finished goods inventory: nding finished goods inventory in cases nit product cost nding finished goods inventory in dollars Direct materials budget equired production in units of finished goods nits of raw materials needed per unit of finished goods nits of raw materials needed to meet production esired units of ending materials needed tal units of raw materials needed Ess units of beginning raw materials inventory materiale inventoru nits of raw materials to be purchased nit cost of raw materials ost of raw materials to be purchased Hule of Expected Cash Disbursements for Purchases of Materials eginning accounts payable rst-quarter purchases econd-quarter purchases hird-quarter purchases ourth-quarter purchases otal cash disbursements for materials