Ruiz Company provides the following budgeted sales for the next four months. The company wants to end each month with ending finished goods inventory equal to 30% of next month's budgeted unit sales. Finished goods inventory on April 1 is 153 units. Prepare a production budget for the months of April, May, and June. Budgeted sales units. April 510 Budgeted sales units Add: Desired ending inventory Next period budgeted sales units Ratio of inventory to future sales Budgeted beginning inventory units Total required units Units to produce May 590 RUIZ COMPANY Production Budget April June 540 590 30% July 630 May 540 30% June 630 30%

Ruiz Company provides the following budgeted sales for the next four months. The company wants to end each month with ending finished goods inventory equal to 30% of next month's budgeted unit sales. Finished goods inventory on April 1 is 153 units. Prepare a production budget for the months of April, May, and June. Budgeted sales units. April 510 Budgeted sales units Add: Desired ending inventory Next period budgeted sales units Ratio of inventory to future sales Budgeted beginning inventory units Total required units Units to produce May 590 RUIZ COMPANY Production Budget April June 540 590 30% July 630 May 540 30% June 630 30%

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Folgerty Enterprises prepared the following sales budget: Month Budgeted Sales March $6,000 April $13,000 May $12,000 June $14,000 The expected gross profit rate is 30% and the inventory at the end of February was $10,000. Desired finished goods inventory levels at the end of the month are 20% of the next month's cost of goods sold. What is the desired beginning finished goods inventory on June 1 (in dollars)? Select one: a. $1,960 b. $840 c. $1,680 d. $9,800 e. $1,860
Atlantic Surf manufactures surfboards. The company’s budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods inventory equal (in units) to 50% of the next month’s unit sales. As of June 30, the company has 1,950 finished surfboards in inventory. July August September Budgeted sales units 3,900 7,400 4,500 Prepare the production budget for the months of July and August.
Seaworthy Company, a merchandising company, has prepared the following sales budget: Month Budgeted Sales March $200,000.00 April 202,000 May June Cost of goods sold is budgeted at 50% of sales, and the inventory at the end of February was $34,000.00. Desired inventory levels at the end of each month are 10% of the next month's cost of goods sold. What is the desired beginning inventory on June 1? 238,000 256,000 O A. $12,800.00 O B. $118,000.00 OC. $11,900.00 O D. $25,600.00
In September 2019, the budget committee of Jason Company assembles the following data: 1. 2 Expected Sales 4. October November December Cost of goods sold is expected to be 60% of sales. 3. Desired ending merchandise inventory is 20% of the next month's cost of goods sold. The beginning inventory at October 1 will be the desired amount. $1,800,000 1,700,000 V 1,600,000 Prepare the budgeted income statement for October through gross profit on sales, including a cost of goods sold schedule. V M JASON COMPANY Budgeted Income Statement For the Month Ended October 31, 2019 $ $
Zahn Co. predicts sales of 246 units in May and 500 units in June. Each month’s ending inventory should be 25% of the next month’s sales. The April 30 ending finished goods inventory is 120 units. Compute budgeted production (in units) for May. Budgeted production (in units)
Champ Incorporated budgets the following sales in units for the coming two months. Each month's ending inventory of finished units should be 60% of the next month's sales. The April 30 finished goods inventory is 114 units. May 190 Budgeted sales units Prepare the production budget for May. CHAMP, INCORPORATED Production Budget Desired ending inventory units Total required units Units to produce June 270 May
ABC Company’s budgeted sales for June, July, and August are 12,800, 16,800, and 14,800 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,840 units. Required: Calculate the number of units to be produced in June and July.
Ramos Company provides the following budgeted production for the next four months. Units to produce April 620 May June July 750 720 720 Each finished unit requires 5 pounds of direct materials. The company wants to end each month with direct materials inventory equal to 30% of next month's production needs. Beginning direct materials inventory for April was 930 pounds. Direct materials cost $2 per pound. Prepare a direct materials budget for April, May, and June. Units to produce Materials needed for production (pounds) Total materials required (pounds) Materials to purchase (pounds) Materials cost per pound Cost of direct materials purchases RAMOS COMPANY Direct Materials Budget April May June 620 750 720 units 0
Harris Inc., has budgeted sales in units for the next five months as follows: June July August September October 9,400 units 7,800 units 7,300 units 5,400 units 4,100 units Past experience has shown that the ending inventory for each month should be equal to 20% of the next month's sales in units. The inventory on May 31 contained 1,880 units. The company needs to prepare a production budget for the next five months.
Stuart Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Stuart's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of sold. April's budgeted cost of goods sold is $80,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quar Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) January February March $ 57,000 $…
Lexi Company budgets unit sales of 1,510,000 in April, 1,210,000 in May, 320,000 in June, and 1,940,000 in July. Beginning inventory on April 1 is 604,000 units, and the company wants to have 40% of next month's unit sales in inventory at the end of each month. The merchandise cost per unit is $0.50. Prepare a merchandise purchases budget for the months of April, May, and June. LEXI COMPANY Merchandise Purchases Budget April May June Next period budgeted sales units Ratio of inventory to future sales Total required units Units to purchase Cost per unit Cost of merchandise purchases $ $ $
Down Under Products' sales budget for the next four months is as follows: April May June July Unit Sales 76,000 85,000 116,000 93,000 The company wants its ending inventory levels to 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. Budgeted unit sales Total needs Required production in units Down Under Products, Limited Production Budget April 77,350 77,350 77,350 May 89,650 89,650 89,650 June 112,550 112,550 112,550 Quarter 0 0