Concept explainers
Windsor Company is preparing its
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.
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps
- Variable Costs Total Variable Costs Depreciation Supervision Total Costs Total Fixed Costs Direct Labor Activity Level Direct Materials Fixed Costs Finished Units Overheadarrow_forwardThe budgeted units for sales in January, February and March are 25,000, 55,000 and 35,000 andselling price is $ 12, 15 and 20 per unit respectively. Please determine the total budgeted sales in unitsand dollars for the quarter ended March 31, 2021.arrow_forwardRodriguez, Inc., is preparing its direct labor budget for 2020 from the following production budget based on a calendar year. Quarter Units Quarter 3 1 2 20,000 25,000 4 Units 35,000 30,000 Each unit requires 1.50 hours of direct labor. Prepare a direct labor budget for 2020. Wage rates are expected to be $16 for the first 2 quarters and $18 for quarters 3 and 4. (Round Direct labor time per unit answers to 2 decimal places, eg. 52.50.) $ $ RODRIQUEZ, INC. Direct Labor Budget 2 Quarter $ $ 3 $ $ 4 Yeararrow_forward
- The Company produces widgets. The sales forecast for 2022 is as follows: 2022 Quarter 1 3,000 Units 2022 Quarter 2 8,000 Units 2022 Quarter 3 5,000 Units 2022 Quarter 4 6,000 Units 2023 Quarter 1 5,000 Units The beginning of the year inventory of widgets was 900 units. Management desires and ending inventory each quarter of 30% of the following quarter's sales units. Prepare the quarterly production budget for each quarter of 2022 (No need to indicate the total for the year).arrow_forwardWaterway Company estimates that unit sales will be 10, 100 in quarter 1;12,500 in quarter 2:14,200 in quarter 3; and 17,700 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 2022arrow_forwardBlossom Company expects to produce 1,200,000 units of product XX in 2022. Monthly production is expected to range from 70,000 to 100,000 units. Budgeted variable manufacturing costs per unit are as follows: direct materials $3, direct labour $6, and overhead $9. Budgeted fixed manufacturing costs per unit for depreciation are $4 and for supervision $1. Prepare a flexible manufacturing budget for the relevant range value using increments of 15,000 units. (List variable costs before fixed costs.) BLOSSOM COMPANY Monthly Flexible Manufacturing Budget $ $ $arrow_forward
- Also include the total of the six monthsarrow_forwardShown below are the totals from 2025 period budgets. Revenue budget $100,000 Materials usage from production budget 15,000 Labor cost budget 20,000 Manufacturing overhead budget 20,000 General and administrative budget 30,000 Capital expenditure budget 20,000 Work in Progress Inventories Beginning of 2002 10,000 End of 2002 5,000 Finished Goods Inventory Beginning of 2002 15,000 End of 2002…arrow_forwardThe 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 Product Accel Active 45,000|s225 |Units Price Accel Regular 75,000 S1s5 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. Two pound 4 2 Three pound 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 Accel…arrow_forward
- 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…arrow_forwardWhat is another way of saying "Interest earned on interest"?arrow_forwardKipp Industries has the following production budget for 2022: 2022 Quarter 1 3,000 Units 2022 Quarter 2 8,000 Units 2022 Quarter 3 5,000 Units 2022 Quarter 4 6,000 Units 2023 Quarter 1 5,000 Units Each unit requires 2.5 hours of direct labor and workers are paid $20 per hour. Prepare a Direct Labor Budget for each of the quarters of 2022. (No need to show the total for the year).arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education