Tuney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as follows HD-240 Quarter 5,100 7,330 8,220 3 10,240 4 The January 1, 2020, inventory of HD-240 is 2,040 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 2021 are expected to be 25 % higher than sales in the same quarter in 2020 Prepare quarterly production budgets for each quarter and in total for 2020. TURNEY COMPANY Production Budget For the Year Ending December 31, 2020 Product HD-240 Quarter Year 21 8220 10240 5100 7330 Expected Unit Sales Add Desired Ending Finished Goods Unit Total Required Units Less:Beginning Finished Goods Unit Required Production Units Click if you would like to Show Work for this question: Open Show Work Edington Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104. The caloulators sell for $13 and $28, respectively, Because of the interse competition Edington faces, management budgets sales semiannually. Its projections for the first 2 quarters of 2020 are as follows Unit Sales Product Quarter 1 22,680 Quarter 2 xQ-103 27,210 dy xQ-104 14,160 16,740 No changes in seling prices are antiopated. Prepare a sales budget for the 2 quarters ending June 30, 2020. List the products and show for each quarter and for the 6 months, units, selling price, and total sales ty product and in total EDENGTON ELeCTRONECS INC Sales Budget For the Six Months Ending June 30, 2020 1 Quarter 1 Quarter 2 Selling Price Six Mosths Units Preduct Selling Price Total Sales Selling Price Units Total Sales Units Total Sales xQ-303 1744.6 27210 13 22680 209) 49890 3837.7 13 505. xQ-104 30900 26 14160 597,5 16740 1103.64 28) 26s0 Totals 2250 3 3604 43950 s0790 4943 DeWitt Industries has adopted the followirng production budget for the first 4 months of 2020. Units Month Units 10,150 March Month 5410 January 4,320 8,380 April February Each unit requires 3 pounds of raw materials costing $2 per pound. On December 31, 2019, the ending raw materials inventory was 6,090 pounds. Management wants to have a raw matenials inventory at the end of the month equal to 20 % of next month's production requirements Prepare a direct materials purchases budget by month for the first quarter DEWITT INDUSTRIES Direct Materials Purchases Budget For the Quarter Ending March 31, 2020 March February January Units to be Produced Direct Materials Per Unit Total Pounds Needed for Production Desired Ending Direct Materials (Pounds) Add Total Materials Required Less Beginning Direct Materials (Pounds) Direct Materials Purchases Cost Per Pound Total Cost of Direct Materials Purchases Rodriguez, Inc., is preparing its direct labor budget for 2020 from the following production budget based on a calendar year. Units Quarter Units Quarter 20,440 35,420 1 30,200 25,370 4 Each unit requires 1.80 hours of direct labor Prepare a direct labor budget for 2020. Wage rates are expected to be s18 for the first 2 quarters and $20 for quarters 3 and 4. (Round Direct labor time per unit answers to 2 decimal places eg. 52.50.) dy RODRIQUEZ, INC Direct Labor Budget For the Year Ending December 31, 2020 Quarter Year 3 1 Units to be Produced Direct Labor Time (Hours) Per Unit Total Required Direct Labor Hours Direct Labor Cost Per Hour Total Direct Labor Cost Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,600, 12,800, 14,800, 16,200. Direct labor: Time is 1.6 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor $1.20; and maintenance $0.50. Fixed everhead costs per quarter: supervisory salaries $36,210; depreciation $18,900; and maintenance $14,980 Prepare the manufacturing everhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal places, e.g. 1.25. List variable expenses before fixed expense.) ATLANTA COMPANY Manufacturing Overhead Budget For the Year Ending December 31, 2020 Quarter 1 2 Year Variable Costs Indirect Materials s Indirect Labor Maintenance Total Variable Fixed Costs Supervisory Salaries Depreciation Maintenance Total Fxed Total Manufactuning Overhead Direct labor hours Manufacturing overhead rate per direct labor hour 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,700 units quarter 1; 22,700 units quarter 2. 1. Variable costs per dollar of sales: sales commissions 5 %, delvery expense 2%, and advertising 3%. Fixed costs per quarter: sales salaries $10,900, office salaries $6,120, depreciation $4,740, insurance $1,640, ublities s880, and repairs expense $680. 2. 3. Unit selling price: $23. 4. Prepare a selling and administrative expense budget by quarters for the first 6 months of 2020. (List variable expenses before fixed expense.) KIRKLAND COMPANY Selling and Administrative Expense Budget For the Six Months Ending June 30, 2020 Quarter Six Months 2 Budgeted Sales in Units Variable Expenses Sales Commissions Delivery Expense Advertising Total Variable Fixed Expenses Sales Salaries ofice Salaries Depreciation Insurance 1 2 Six Months Budgeted Sales in Units Variable Expenses Sales Commissions Delivery Expense Advertising Total Variable Fixed Expenses Sales Salaries Office Salaries Depreciation Insurance Utilities Repairs Expense Total Fixed Total Selling and Administrative Expenses