Delta Manufacturing has budgeted the following unit sales: 2019 Units April 25,000 May 40,000 June 60,000 July 45,000 Of the units budgeted, 40% are sold by the Coastal Division at an average price of $15 per unit and the remainder are sold by the Central Division at an average price of $12 per unit. Instructions: Prepare separate sales budgets for each division and for the company in total for the second quarter of 2020. What are the total consolidated sales dollars for quarter? Assune a calendar fiscal year end.

Delta Manufacturing has budgeted the following unit sales: 2019 Units April 25,000 May 40,000 June 60,000 July 45,000 Of the units budgeted, 40% are sold by the Coastal Division at an average price of $15 per unit and the remainder are sold by the Central Division at an average price of $12 per unit. Instructions: Prepare separate sales budgets for each division and for the company in total for the second quarter of 2020. What are the total consolidated sales dollars for quarter? Assune a calendar fiscal year end.

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

Windsor Company is preparing its master budget for 2022. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales: Sales for the year are expected to total 1,200,000 units. Quarterly sales are 25%, 25%, 25%, and 25%, respectively. The sales price is expected to be $41 per unit for the first three quarters and $44 per unit beginning in the fourth quarter Sales in the first Quarter of 2023 are expected to be 10% higher than the budgeted sales for the first quarter of 2022 Production: Management desires to maintain the ending finished goods inventories at 20% of the next quarter's budgeted sales volume. Direct materials Each unit requires 2 kg of raw materials at a cost of $10 per kilogram. Management desires to maintain raw materials inventories at 10% of the next quarter's production requirements. Assume the production requirements for the first quarter of 2023 are 410.000 kg. Prepare the Sales Budget by quarter for 2022.
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 111,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 113,000 Expected unit sales for February 2020 113,000 Expected unit sales for March 2020 118,000 Expected unit sales for April 2020 124,000 Expected unit sales for May 2020 137,000 Unit selling price $12 Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31, 2019, totaled $181,800.Direct MaterialsDirect materials cost 80 cents per pound. Two pounds of direct materials…
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 2
(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
Budget for the month of January 2020: beginning FG is 50,000 units; Sold units totaled 80,000 units and Ending FG in units is 40,000.Budgeted Cost of production are: DM is 20 per unit; DL of 30 per unit and VOH is 15 per unit. Budgeted FOH is 90,000.What is the budgeted production cost?
ABC company produces and selling a single product. The following information relates to their budgeted operations for the 2023 financial year. Sales Period Units Quarter 1 42 000 Quarter 2 48 000 Quarter 3 33 000 A closing inventory of 15% of the next period’s sales is required. The forecast sales for Quarter 4 are 36 000 units. From the company’s history it was observed that the sales units for Quarter 4 of any year are the same. The standard material cost of one unit of ﬁnished product is: Cost per Unit produced N$ Assembly Department (N$ 8 per kilo) 24 Finishing Department (N$ 10 per kilo) 20 REQUIRED: 5.1 Prepare the Direct Material Budget, in hours and in N$, for both Departments for each of the Quarter 1
Reham Co is preparing its direct labor budget for 2020 from the following production budget based on a calendar year. Quarter Units 1 20,000 2 25,000 3 35,000 4 30,000 Each unit requires 1.5 hours of direct labor. Wage rates are expected to be OMR16 for the first 2 quarters and OMR18for quarters 3 and 4. What is the Budgeted Total Direct Labor Cost for Quarter 4
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.
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
Delta Manufacturing has budgeted the following unit sales: 2019 April May June July Units 25,000 40,000 60,000 45,000 Of the units budgeted, 40% are sold by the Coastal Division at an average price of $15 per unit and the remainder are sold by the Central Division at an average price of $12 per unit. Prepare separate sales budgets for each division and for the company in total for the second quarter of 2019.