Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 660 May June 740 690 July 780 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 198 units. Prepare a production budget for the months of April, May, and June. Next month's budgeted sales (units) Ratio of inventory to future sales RUIZ CO. Production Budget For April, May, and June Required units of available production Units to be produced April May June 740 690 780 30%

Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 660 May June 740 690 July 780 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 198 units. Prepare a production budget for the months of April, May, and June. Next month's budgeted sales (units) Ratio of inventory to future sales RUIZ CO. Production Budget For April, May, and June Required units of available production Units to be produced April May June 740 690 780 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

Neon Inc. has a finished goods inventory of 20,000 units on July 1. The projected sales for July, August and September are 80,000 units, 90,000 units and 100,000 units, respectively. Its desired ending inventory is estimated as 20% of the current month’s budgeted sales. Determine the budgeted production for July. Group of answer choices 116,000 units 16,000 units 96,000 units 76,000 units
FRANCORP is preparing budgets for the quarter ending March 31. Budgeted sales for the next 5 months are as follows: January February March 16250 units 16950 units 17200 units 18350 units 17900 units April May The selling price per unit is $15. Determine the total budgeted sales for the entire quarter ending March 31st. O $756,000 O $815,000 O $850,350 O $750,550
Sales budget data for Paige Company are given in BE9.2. Management desires to have an ending finished goods inventory equal to 25% of the next quarter’s expected unit sales. Prepare a production budget by quarters for the first 6 months of 2020.
answer?
Spacely Sprockets' sales budget shows the following expected total sales: Month January February March April Sales $31,700 $41,700 $36,700 $31,700 The company expects 80% of its sales to be on account (credit sales). Credit sales are collected as follows: 30% In the month of sale and 68% In the month following the sale, with the remainder being uncollectible and written off in the month following the sale. Required: a. Calculate budgeted accounts receivable at the end of each month from February through April. b. Calculate budgeted cash Inflows from collection of receivables for each month from February through April. Note: Round your Intermediate calculations and final answers to the nearest whole dollar amount. a. Budgeted accounts receivable Answer is not complete. b. Budgeted cash inflows from collection of receivables February March April S 17,752 S 23,352 $ 20,552
COVID19Co produces hand tools. A sales budget for the next four months is as follows March10.700 units, April 13.600, May 16,200, and June 21.200 COVID19Co's ending finished goods inventory policy is 10% of the following month's sales. What is budgeted ending finished goods inventory for March?
GIVEN: Below is a Production Budget for the third quarter of a company's fiscal year that includes forecasted monthly unit sales. Additionally, management wishes to have 20% of the following month's unit sales as Desired Ending Inventory. July Aug Sep Q3 Oct Unit Sales: 30,000 32,000 34,000 38,000 Desired Ending Inventory: Total Required Units: Beginning Inventory: No. of Units to be Produced: 6,000 22) The Desired Beginning Inventory for August is: A) 6,000 B) 6,400 C) 6,800 D) 7,000 23) The number of units to be produced in September is: A) 34,800 B) 38,800 C) 41,600 D) 46,400
Please help me with show all calculation thanku
Infinity Inc. has provided the following projected sales units for the next quarter: Projected Sales First month Second month Third month Projected sales units 20,000 25,000 30,000 Desired ending inventory is determined to be 12% of the next month’s projected sales. What would be the budgeted production units during the second month of the quarter? Group of answer choices 25,600 units 28,600 units 31,600 units 26,400 units
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 $ $ $
Vaughan company estimates that unit sales will be 10,500 in quarter 1; 11,400 in quarter 2; 13,400 in quarter 3; and 18600 in quarter 4. management wnta to have an ending finished goods inventory equal to 21% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first six months of 2022
The following table presents selected information for Superior Flooring's monthly production budgets for the coming year. Superior's inventory policy is to have ending inventory equal to 10% of the next month's sales. April May June Desired ending inventory ? ? ? Beginning inventory 300 ? Q10 Budgeted sales 2,800 3,100 3,500 Budgeted production Q9 3,140 3,400 What is the budgeted production in April? 2,790 2,810 3,410 2,500