On January 1, 2022, the Bramble Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2022. Sales units: Ending raw materials inventory: Ending finished goods inventory: Third-quarter production: First quarter 5,800; second quarter 6,960; third quarter 8,120. 40% of the next quarter's production requirements. 25% of the next quarter's expected sales units. 8,470 units. The ending raw materials and finished goods inventories at December 31, 2021, follow the same percentage relationships to production and sales that occur in 2022. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound. Prepare a production budget by quarters for the 6-month period ended June 30, 2022. BRAMBLE COMPANY Production Budget 1 Quarter EX 2

On January 1, 2022, the Bramble Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2022. Sales units: Ending raw materials inventory: Ending finished goods inventory: Third-quarter production: First quarter 5,800; second quarter 6,960; third quarter 8,120. 40% of the next quarter's production requirements. 25% of the next quarter's expected sales units. 8,470 units. The ending raw materials and finished goods inventories at December 31, 2021, follow the same percentage relationships to production and sales that occur in 2022. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound. Prepare a production budget by quarters for the 6-month period ended June 30, 2022. BRAMBLE COMPANY Production Budget 1 Quarter EX 2

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

Scannell, Inc. sells tire rims. Its sales budget for the nine months ended September 30, 2024, and additional information follow: (Click the icon to view the budget.) (Click the icon to view additional information.) Prepare an inventory, purchases, and cost of goods sold budget for each of the first three quarters of the year. Compute cost of goods sold for the entire nine-month period. Plus: Less: More info Scannell, Inc. Inventory, Purchases, and Cost of Goods Sold Budget Nine Months Ended September 30, 2024 Quarter Ended March 31 In the past, cost of goods sold has been 40% of total sales. The director of marketing and the financial vice president agree that each quarter's ending inventory should not be below $15,000 plus 10% of cost of goods sold for the following quarter. The marketing director expects sales of $200,000 during the fourth quarter. The January 1 inv ory was $19,000. Print Done X Data table Cash sales, 30% Credit sales, 70% Total sales $ $ Quarter Ended June 30…
Crane Company expects to have a cash balance of $36,000 on January 1,2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $68,000, February $120,000.Payments for direct materials: January $40,000, February $60,000.Direct labor: January $24,000, February $36,000. Wages are paid in the month they are incurred.Manufacturing overhead: January $16,800, February $20,000. These costs include depreciation of $1,200 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $12,000, February $16,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $9,600 in cash. Crane Company has a line of credit at a local bank that enables it to borrow up to $20,000. The company wants to maintain a minimum monthly cash balance of $16,000. Prepare a cash budget for January and February. ReceiptsCollections from…
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 $ $
Paradise Corporation budgets on an annual basis for its fiscal year. The following beginning and ending inventory levels (in units) are planned for next year. Beginning Ending Inventory Inventory Raw material* 58,000 68,000 Finished goods 98,000 68,000 * Three pounds of raw material are needed to produce each unit of finished product. If Paradise Corporation plans to sell 570,000 units during next year, the number of units it would have to manufacture during the year would be: Multiple Choice O 600,000 units 540,000 units 512,000 units 570,000 units
In May 2022, the budget committee of Crane Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. 2. 3. 4. (a) Expected sales: June $400,000, July $480,000. Cost of goods sold is expected to be 75% of sales. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sold. The beginning inventory at June 1 will be the desired amount. Compute the budgeted merchandise purchases for June. CRANE STORES Merchandise Purchases Budget $ $
Sunland Inc. is preparing its annual budgets for the year ending December 31, 2025. Accounting assistants furnish the data shown below. Product JB 50 Product JB 60 Sales budget: Anticipated volume in units 480,000 240,000 Unit selling price $30 $35 Production budget: Desired ending finished goods units 36,000 18,000 Beginning finished goods units 30,000 12,000 Direct materials budget: Direct materials per unit (pounds) 2 3 Desired ending direct materials pounds 36,000 12,000 Beginning direct materials pounds 48,000 18,000 Cost per pound $3 $4 Direct labor budget: Direct labor time per unit 0.4 0.6 Direct labor rate per hour $12 $12 Budgeted income statement: Total unit cost $13 $20 An accounting assistant has prepared the detailed manufacturing overhead budget and the selling and administrative expense budget. The latter shows selling expenses of $672,000 for product JB 50 and $432,000 for product JB 60, and administrative expenses of $648,000 for product JB 50 and $408,000 for product…
Whispering Winds Company estimates that unit sales will be 10,500 in quarter 1; 12,600 in quarter 2; 13,800 in quarter 3; and 17,800 in quarter 4. Management wants 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. WHISPERING WINDS COMPANY Production Budget For the Six Months Ending June 30, 2022 Quarter 1 2 Total
Sunland Company has accumulated the following budget data for the year 2022: 1. 2. 3. 4. 5. 6. Sales: 29,200 units; unit selling price $82 Cost of one unit of finished goods: direct materials, 2 kg at $5 per kilogram; direct labour, 3 hours at $13 per hour; and manufacturing overhead, $5 per direct labour hour Inventories (raw materials only): beginning, 9,900 kg; ending, 15,700 kg Raw materials cost: $5 per kilogram Selling and administrative expenses: $219,000 Income taxes: 30% of income before income taxes Prepare a schedule showing the calculation of the cost of goods sold for 2022. SUNLAND COMPANY Computation of Cost of Goods Sold For the Year Ending December 31, 2022 Cost of goods sold Manufacturing overhead Beginning inventory Direct materials Ending inventory Number of units sold Selling and administrative expenses Direct labour Cost of one unit of finished goods eTextbook and Media $ $ $
Kirkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2020, the following data are available. Sales: 20,500 units quarter 1: 22.200 units quarter 2 Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 3% Fixed costs per quarter: sales salaries $10,500, office salaries $6,250, depreciation $4,340, insurance $2,000, utilities $860, and repairs expense $690. 4. Unit selling price: $24. 1. 2 3. Prepare a selling and administrative expense budget by quarters for the first 6 months of 2020. (List variable expenses before fixed expense)
Parlex Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2019, the following data are available. . Sales: 20,000 units quarter 1; 22,000 units quarter 2. Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 4%. Fixed costs per quarter: sales salaries $10,000, office salaries $8,000, depreciation $4,200, insurance $1,500, utilities $800, and repairs expense $500. Unit selling price: $20. Instructions: Prepare a selling and administrative expense budget by quarters for the first 6 months of 2019.
Walt Bach Company has accumulated the following budget data for the year 2019. Sales: 40000 units, unit selling price $50. Cost of one unit of finished goods: Direct materials 2 pounds at $5 per pound, direct labor 1.5 hours at $12 per hour, and manufacturing overhead $6 per direct labor hour. Inventories (raw material only): Beginning, 10000 pounds; ending, 15000 pounds. Raw materials cost: $5 per pound. Selling and administrative expenses: $200000 Income taxes: 30% of income before income taxes. Prepare a schedule showing the computation of cost of goods sold for 2019.
E9-3A Budget Preparation Westport Company is preparing its master budget for May. Use the estimates provided to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories E and W estimate sales of 50,000 and 100,000 units, respectively, and the unit selling price is $30? b. If the beginning finished goods inventory is an estimated 6,000 units and the desired ending inventory is 7,000 units, how many units should be produced? c. What dollar amount of materials should be purchased at $2 per pound if each unit of product requires 2.5 pounds and beginning and ending materials inventories should be 12,000 and 13,500 pounds, respectively? d. How much direct labor cost should be incurred if each unit produced requires 0.5 hours at an…