Question

Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: April May Unit Sales 76,000 85,000 116,000 93,000 June July The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of- month inventory levels must equal 15% of the following month's unit sales. The inventory at the end of March was 11,400 units. Required: Prepare a production budget by month and in total, for the second quarter. Down Under Products, Ltd., Production Budget April May 85,000 June 116,000 Quarter 277,000 76,000 Budgeted units sales Add: Desired units of ending finished goods inventory Total needs 76,000 85,000 116,000 277,000 Less: Units of beginning finished goods inventory Required production in units 76,000 85,000 116,000 277,000

Answer 1

Quarter April June May Budgeted units sales Add: Desired units of ending finished goods inventory Total needs 85000 116000 277000 76000 13950 44100 12750 17400 129950 321100 88750 102400 Less: Units of beginning finished goods inventory Required production in units 17400 41550 11400 12750 279550 89650 112550 77350