6) ABC makes & sells doors & windows. Prepare a sales & production budget. Estimates: Doors Windows March 1 Inventory (Units) 680 550 March 30 Inventory 400 300 Expected Sales: North (Units) 1400 1100 South 1800 1600 Unit selling prices: $180 $130

6) ABC makes & sells doors & windows. Prepare a sales & production budget. Estimates: Doors Windows March 1 Inventory (Units) 680 550 March 30 Inventory 400 300 Expected Sales: North (Units) 1400 1100 South 1800 1600 Unit selling prices: $180 $130

Name: 6) ABC makes & sells doors & windows. Prepare a sales & production bud
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: 6) ABC makes & sells doors & windows. Prepare a sales & production budget. Estimates: Doors WindowsMarch 1 Inventory (Units) 680 550March 30 Invento

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 2CMA

See similar textbooks

Similar questions

How many units are in beginning inventory it 32,000 units are budgeted for sales, 35,000 units are produced, and the desired ending inventory is 9,000 units?
If a company has a beginning merchandise inventory of $50,000, a desired endingmerchandise inventory of $30,000, and a budgeted cost of goods sold of $300,000,what is the amount of required inventory purchases?a. $320,000 c. $380,000b. $280,000 d. $300,000
Based on the following production and sales data of Frixion Co. for March of the current year, prepare the following: Product T Product X Estimated inventory, March 1 28,000 units 20,000 units Desired inventory, March 31 32,000 units 15,000 units Expected sales volume: Territory I 320,000 units 260,000 units Territory II 190,000 units 130,000 units Unit sales price $6 $14 i need help creating a production budget Frixion Co. Production Budget For the Month Ending March 31 Product T Product X Sales (units) Total (units) available Total units to be produced
Softlan Limited manufactures one product known as Eco1. The following information relates to the preparation of the budget for the year to 31 March 2020: 1) Sales budget details for product Eco1: Expected selling price per unit: RM100. Expected sales in units: 10,000. All sales are on credit terms. 2) Eco1 requires 5 units of raw material E and 10 units of raw material C. E is expected to cost RM3 per unit and C RM4 per unit. All goods are purchased on credit terms. 3) Two departments are involved in producing Eco1: machining and assembly. The following information is relevant: Direct labour per unit of product (hours) Direct labour rate per hour RM Machining 1.00 6 Assembling 0.50 8 4) The finished production overhead costs are expected to amount to RM100,000. 5) At 1 April 2019, 800 units of Eco1 are expected to be in stock at a value of RM52,000, 4,500 units of raw material E at a value of RM13,500, and 12,000 units of raw materials at a value of RM48,000. Stocks of both finished…
7. Based on the following production and sales estimates for May, prepare the sales and production budgets: Estimated beginning inventory (units), May 1 18,000 Desired ending inventory (units), May 31 21,600 Expected sales volume (units): Area W 6,000 Area X 7,000 Area Y 8,000 Unit sales price $20
You have been presented with the following information by the Budget Committee of the organization in which you work: Sales forecast January – April 2020 Details Study lamps Accent lights Expected selling price per unit $300 $500 Sales Volume forecast: January 2 000 units 1 000 units February 2 500 units 1 500units March 3 000 units 1 000 units April 2 000 units 1 200 units Additional information: (i) Beginning inventories: study lamps 300 units; accent lights 200 units. (ii) The ending inventory for each product at the end of each month is to be maintained at 20% of the budgeted sales for the next month. (iii) To make one study lamp, four (4) units of raw material lumber are used, while five (5) units of raw material aluminum are used to make one accent lights. Required: The Production Budgets for both products for January to March 2020.
You have been presented with the following information by the Budget Committee of the organization in which you work: Sales forecast January – April 2020 Details Study lamps Accent lights Expected selling price per unit $300 $500 Sales Volume forecast: January 2 000 units 1 000 units February 2 500 units 1 500units March 3 000 units 1 000 units April 2 000 units 1 200 units Additional information: (i) Beginning inventories: study lamps 300 units; accent lights 200 units. (ii) The ending inventory for each product at the end of each month is to be maintained at 20% of the budgeted sales for the next month. (iii) To make one study lamp, four (4) units of raw material lumber are used, while five (5) units of raw material aluminum are used to make one accent lights. Required: The Sales Budget for both products for January to March 2020. The Direct Material usage budget.
NUBD Company desires an ending inventory of P140,000. It expects sales of P800,000 and has a beginning inventory of P130,000. Cost of sales is 65% of sales. Budgeted purchases are
l Shams Company produces and sells two products; T3 and Z4. The company estimated the sales of the products as 45000 units for T3 and 35000 units for Z4. The opening stock and estimated closing stock units are given in the table below. T3 Z4 Opening Stock 12000 14000 Closing Stock 7000 9000 Which of the following shows the number of units to be produced in the Production Budget. Select one: a. T3 = 51000 and Z4 = 41000 b. T3 = 42500 and Z4 = 32500 c. T3 = 40000 and Z4 = 30000 d. T3 = 49000 and Z4 = 39000
A company manufactures three types of product X, Y and Z. The company plans a 15% increase in finished goods stock at the end of the period. Product X Product Y Product Z Sales in Units 2000 2250 3000 Prices 100 125 150 Opening Stock 900 700 1100 Determine the production budget for the 3 products. Choose one from the following: A Product X Product Y Product Z 1035 805 1265 B Product X Product Y Product Z 2,000 2,250 3,000 C Product X Product Y Product Z 3,035 3,055 4,265 D Product X Product Y Product Z 2,135 2,355 3,165
Bean There Inc. manufactures coffee makers. Selected budget and actual information for 2020 are provided below: Budget Information Actual Information Units sold 1 36,000 Sales in dollars $ 1,272,335 1,363,217 Average selling price per unit $ 50 4 Variable cost per unit $ 30 5 Variable cost in total 2 $ 817,930 Fixed selling and admin $ 302,900 $ 293,200 Operating income 3 6 Calculate on excel: 1. Complete the missing information above (1,2,3,4,5,6) 2. Prepare a flexible budget based on the actual quantity of units sold 3. Prepare a performance report comparing actual results to budgeted results in contribution income statement format. Ensure that the report breaks down variances between actual and budget into price and volume variances for sales, variable costs, and selling and admin expenses including which variances are favorable and which…
Based on the following production and sales data of Jackson Co. for March of the current year. Product T Product X Estimated inventory, March 1 26,000 units 18,000 units Desired inventory, March 31 32,000 units 15,000 units Expected sales volume: Area I 320,000 units 260,000 units Area II 190,000 units 130,000 units Unit sales price $4 $12 a. Prepare Sales budget. Jackson Co. Sales Budget For Month Ending March 31, 20XX Product and Area Unit Sales Volume Unit Selling Price Total Sales Product T: Area I $ $ Area II Total $ Product X: Area I $ $ Area II Total $ Total revenue from sales $ b. Prepare a production budget. Jackson Co. Production Budget For Month Ending March 31, 20XX Product T (units) Product X (units) Sales Plus desired ending inventory, March 31, 20XX Total Less estimated beginning inventory, March 1, 20XX Total…