The data collected from the sales budget for the first five months of 2020 is given for a particular product of Al Salam Corporation. As below. Months January February March April May Sales Budget (Units) 11,300 14,700 16,700 18,400 13,200 Consider the following information: Each product requires two types of materials in following quantities. Material X: 4 Units and Material Y: 5 Units. Materials equal to one half of the next month’s production are to be in hand at the end of each month. This requirement was met on January, 2010. Prepare a budget showing quantities of each type of materials to be produced each month for the first quarter of 2010.

The data collected from the sales budget for the first five months of 2020 is given for a particular product of Al Salam Corporation. As below. Months January February March April May Sales Budget (Units) 11,300 14,700 16,700 18,400 13,200 Consider the following information: Each product requires two types of materials in following quantities. Material X: 4 Units and Material Y: 5 Units. Materials equal to one half of the next month’s production are to be in hand at the end of each month. This requirement was met on January, 2010. Prepare a budget showing quantities of each type of materials to be produced each month for the first quarter of 2010.

Managerial Accounting

15th Edition

ISBN:9781337912020

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

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

Chapter6: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 1CMA: Taylor Corporation is analyzing the cost behavior of three cost items, A, B, and C, to budget for...

See similar textbooks

Similar questions

Required: Compute for the following: 1. Number of units of materials needed for production in the first quarter. 2. The desired inventory of materials at the end of the budget year. 3. The number of units of materials to be purchased in the third quarter. 4. The amount of purchases in the second quarter. 5. The total amount paid for materials purchases at the end of 2023. The production budget for the year 2023 of Mahogany Corporation per quarter is given as follows: First quarter 26,000 Second quarter 32,000 Third quarter 34,000 Fourth quarter 44,000 For every one unit of its product, 5 units of materials are needed. Materials are purchased at P6 per unit. Materials inventory at the end of each quarter is maintained at 20% of next quarter’s production requirements. For the first quarter of the year 2024, it is estimated that production requirements will be 30,000 units of materials. Accounts payable at the beginning of 2023 was projected to…
B) The data collected from the sales budget for the first five months of 2020 is given for a particular product of Al Salam Corporation. As below. Months January February March April May Sales Budget (Units) 11,300 14,700 16,700 18,400 13,200 Consider the following information: The inventory of finished product at the end of each month is to be equal to 25% of the sales estimated for the next month. On January1, 2020, there were 5,000 units of production on hand. No work in progress at the end of any month. Each product requires two types of materials in following quantities. Material X: 4 Units and Material Y: 5 Units. Materials equal to one half of the next month’s production are to be in hand at the end of each month. This requirement was met on January, 2010. Prepare a budget showing quantities of each type of materials to be produced each month for the first quarter of 2010.
Scarborough Corporation manufactures and sells two products: D-One and D-Two. In July 2018, Scarborough budget department gathered the following data to prepare budgets for 2019: 2019 Projected Sales: Product D-One Units 60,000 40,000 Price $165 $250 D-Two 2019 Inventories in Units: Expected Target January 1, 2019 20,000 8,000 Product December 31, 2019 25,000 9,000 D-One D-Two The following direct materials are used in the two products: Amount Used per Unit Direct material Unit D-One D-Two kilogram kilogram A 4 5 2 3 each 1 Projected data for 2019 with respect to direct materials are as follows: Expected Inventories January 1, 2019 32,000 kg 29,000 kg 6,000 units Direct material Anticipated Purchase price $12 5 Target Inventories December 31, 2019 36,000 kg 32,000 kg 7,000 units A B C 3 Projected direct labour requirements and rates for 2019 are as follows: Product D-One D- Two Hours per unit Rate per hour $12 2 3 16 Based on the preceding projections and budget requirements for D-One…
1. AL Jamat Inc. is preparing its annual budgets for the year ending December 31, 2020.Accounting assistants furnish the data shown below. Detail Product AProduct C Sales Budget Anticipated Volume in units Unit Selling price Production Budget: Desired ending finished goods units Beginning finished goods units Direct materials budget: Direct materials per unit (pounds) Desired ending direct materials pounds Beginning direct materials pounds Cost per pound Direct labor budget: Direct labor time per unit Direct labor rate per hour Budgeted income statement: Total unit cost 40500 20500 55 45 2500 1500 3000 1000 20 30 3000 1500 4000 1000 3 0.4 0.6 122 155 122 222 has prepared An accounting assistant manufacturing overhead budget and the selling and administrative expense budget. The latter shows selling expenses of $645,000 for product A and $345,000 for product C, and administrative expenses of $545,000 for product A and $345,000 for product C. Income taxes are expected to be the detailed…
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 $65? 9750000 b. If the beginning finished goods inventory is an estimated 6,000 units and the desired ending inventory is 11,000 units, how many units should be produced? 155000 c. What dollar amount of materials should be purchased at $5.50 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. 2139500 How much direct labor cost should be incurred if each unit produced requires 0.5 hours at an hourly rate of $22? How much manufacturing overhead should be incurred if fixed manufacturing overhead is $45,000 and variable…
Refer to the information regarding Stillwater Designs above.Required:1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales byproduct and in total for each time period.2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?
Shrek & Fiona Company, manufacturer of a single product, is preparing their annual budget for 2021: Requirements: 2. Determine production volume 3. Estimate manufacturing costs and operating expenses a. Purchases (material) budget b. Personnel budget c. Overhead budget d. Selling and administrative budget 4. Determine cash flow and other financial effects a. Cash collection schedule b. Cash disbursement for purchases, factory overhead, and selling and administrative expenses Cash budget С. 5. Formulate Projected Financial Statements (As of December 31, 2021) a. Budgeted Cost of Goods Manufactured b. Budgeted Income Statement c. Budgeted Balance Sheet
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 $70? 2$ b. If the beginning finished goods inventory is an estimated 6,000 units and the desired ending inventory is 11,500 units, how many units should be produced? units c. What dollar amount of materials should be purchased at $6 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.
The SK Industries, Inc. manufactures and sells two products, Accel Active and Accel Regular. In September 2018, SK Industries Budget Department gathered the following data in order to prepare budgets for 2019: 2019 Projected Sales Units Price Accel Active 45,000 s225 Accel Regular 75,000 Sis5 Product Expected Target Inventories Product January 1, 2019 December 31, 2019 Accel Active 9,000 12,000 Accel Regular 17,000 25,000 The following direct materials are expected to be used in the two products: |Material Used per Unit Direct Material Unit Accel Active Accel Regular pound One 6. 4 Two pound 4 2 Three pound 2 Projected data for 2019 with respect to direct materials are as follows: Direct Material Expected Purchase PriceExpected Inventories Target Inventories (January 1, 2019) December 31, 2019) One $15 27,000 lb 35,000 lb Two S7 30,000 lb 35,000 lb Three $4 4,000 lb 7,000 lb Projected direct labor requirements and rates for 2019 are as follows: Product Hours Per Unit Rate Per Hour…
Shrek and Fiona Company, manufacturer of a single product, is preparing their annual budget for 2021: Requirements:1. Formulate Projected Financial Statements (As of December 31, 2021)a. Budgeted Cost of Goods Manufacturedb. Budgeted Income Statementc. Budgeted Balance Sheet
The controller of the Stump Company is preparing the budget for 2021 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior 2 months are: LOADING... (Click the icon to view the information.) Requirements 1. Estimate the cost function for delivery. 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. Requirement 1. Estimate the cost function for delivery. Delivery costs = + ( × ) Delivery costs = + ( × ) Requirement 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. The cost function in requirement 1 is an estimate of how costs behave ▼ outside of within the relevant range, not at cost levels ▼ outside within the relevant range. If there are no months with zero miles driven represented in the delivery cost…
The Management Accountant of Kafululu Plc has prepared the following budget information for theyear ending 31st December 2022 for product A. Annual Fixed Costs K270,000.00 Variable costs per unit K90.00 Contribution to sales ratio(C/S) 75% Annual budget units 1,500 Required:a) Calculate the contribution per unit for Product A. b) Calculate the Unit Selling Price for Product A. c) Calculate the Break Even Point for Product A. d) Calculate the margin of safety in Units and in percentage terms. e) If the Selling Price per Unit is reduced by 10%, variable cost per Unit is increased to K100.00and Fixed costs remain unchanged, calculate:i. The new Breakeven Point. ii. The total units that should be sold in order to make a profit of K450,000 in 2020.(