Complete the production budget table on the next page of ABC Company given the following forecast sales in units for June to October as follows: Jun 3,000 Jul 3,300 Aug 3,600 Sep 3,900 Oct 4,000 Units Note • Company would like to maintain 200 units in its ending inventory at the end of each month. • Beginning inventory at the start of June starts at 60 units.

Complete the production budget table on the next page of ABC Company given the following forecast sales in units for June to October as follows: Jun 3,000 Jul 3,300 Aug 3,600 Sep 3,900 Oct 4,000 Units Note • Company would like to maintain 200 units in its ending inventory at the end of each month. • Beginning inventory at the start of June starts at 60 units.

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

Subject: acounting
How do I prepare the selling and administrative expense budget for the quarter ended March 31, 20X1?
FRANCORP is preparing budgets for the quarter ending March 31. Budgeted sales for the next 5 months are as follows: January February March April May 16250 units 16950 units 17200 units 18350 units 17900 units The selling price per unit is $15. Determine the total budgeted sales for the month of March. O $195.500 O $200,900 $238,550 O $258,000
please step by step answer.
(b) A sales budget is given below for one of the products manufactured by N.Ltd .For six months ended 30th June 2021. Month Units January 60,000 February 105,000 March 180,000 April 120,000 May 90,000 June 75,000 The inventory of finished goods at the end of each month equal 20% at the next month's sales Page 1 of 4 On 1t Jan 2021, finished goods inventory totaled 12,000 units. Each unit of the product requires nine units of a specialized liquid known as HN-2, sometimes this extract is in short supply for this reason, the company has a policy of maintaining an inventory at the end of each month equal to 30%of next month's production needed. This requirement was met on 1st Jan 2021. Required Prepare a budget showing the quantity of NH-2 to be purchased each month from January, February and March and in total for the three months period (ii) What is the significance of budgeting in any business organization
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
A company is preparing budgets for the quarter ending Mar 31, 2020.Jan 10,000 unitsFeb 50,000 unitsMar 30,000 unitsApr 60,000 unitsMay 40,000 unitsThe management of this company assumes the following:1) Selling price is $5.2) On Dec 31, 2019, the finished goods totaled 3,000 units. Finished goods at the end of each month must be 20% of the following month’s budgeted sales.3) All sales are on account. 70% of the credit sales are collected in the month of sale, 25% in the month following sale, and the remainders are uncollectible.4) On Dec 31, 2019, the cash balance is $10,000. Q: The company predicts only 50% of the budgeted sales in units can be achieved. Moreover, the company decides to cut the selling price to $3, and the company expects 50% of credit sales can be collected in the month of sale, 20% in the month following sale, the reminders are not collectible. The other things being the same. Please prepare the cash collection and required production (in units) for January,…
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
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
Budget for a merchandising company Nano,inc.is preparing its budget for the second quarter . The following sales data have been forecasted: April. May. June. June July U/sales. 640. 720. 780. 620. 660 Additional information follows: inventory on March 31: 192 units Desired ending inventory each month: 30% of next month's sales. How many units should be produced in April, May and June? How many units should be produced in the second quarter in total? You can Write your answers on this sheet as an excel table or a pasted word documentable.
Surf Inc. has prepared the sales forecast as shown below: Description Month 1 Month 2 Month 3 Month 4 Sales Forecast 25,000.00 27,000.00 29,000.00 23,000.00 Prepare the production budget and show the required production for Months 1-3 Beg Inv Month 1 3,500.00 Required Ending Inventory 15% of the next months budgeted sales Description Month 1 Month 2 Month 3