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

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 $ $
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.
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?
HH Company is in the process of preparing the cash budget for the last four months of 2022 that is September to December. The following information has been made available. Sept Oct Nov Dec Projected sales quantity (units) 60,000 65,000 65,000 70,000 Additional information: Selling price is ksh 120 per unit but expected to drop by 5% from 1st Payment for goods sold is as follows; 20% in the month of sales, 70% the following month after sales and The balance in the second month after sales. Bad debt is estimated at 3% of sales value. Purchases of goods at ksh 65 per unit are as follows: September 88,000 units, October 84,000 units, November 95,000 units and December 80,000 units. Goods purchased are paid one month in arrears. Monthly expenses estimated at 15% on sales revenue are paid in the month of incurrence. The company plans to buy a delivery van at ksh 2,700,000, 40% of the cost to be paid in October and the…
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 $ $ $
Dreymon Corp. expects to sell 1,810 units of finished product in January and 2,200 units in February. The company has 240 units on hand on January 1 and desires to have an ending inventory equal to 60% of the next months sales. March sales are expected to be 2,150 units.Prepare Dreymon Corp. production budget for January and February.