Prepare quarterly production budgets Exercise 2 Pletcher Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales budget is as follows.2 Quarter HD-240 1 6,000 8,000 3 8,000 4 11,000 units. Management desires an ending inventory 50% Jof the next quarter's sales. Sales in the first quarter of 2021 are expected to be 3,500 The January 1, 2020, inventory of HD-240 is each quarter equal to 30% higher than sales in the same quarter in 2020. Instructions: Prepare quarterly production budgets for quarter and in total for 2020.

Prepare quarterly production budgets Exercise 2 Pletcher Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales budget is as follows.2 Quarter HD-240 1 6,000 8,000 3 8,000 4 11,000 units. Management desires an ending inventory 50% Jof the next quarter's sales. Sales in the first quarter of 2021 are expected to be 3,500 The January 1, 2020, inventory of HD-240 is each quarter equal to 30% higher than sales in the same quarter in 2020. Instructions: Prepare quarterly production budgets for quarter and in total for 2020.

Name: Prepare quarterly production budgetsExercise 2 Pletcher Company_produ
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Prepare quarterly production budgetsExercise 2 Pletcher Company_produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales budget is asfollows.2QuarterHD-24016,0008,000238,000411,0003,500The January 1, 2020, inventory of HD-240 i

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...

See similar textbooks

Similar questions

Prepare a Sales Budget, Purchases Budget and Forecasted Income Statement for 2022 third quarter of Maryland Enterprises. Using the ff. data: June July August September Units to be Sold 1,000 1,250 1,500 1,350 Selling Price P190 Unit Cost P120 Beginning Inv for July 100 units Desired Ending Inventory 10% of Last month Unit Sales ling Expenses P25 per forecasted sales in units Administrative Expenses P10,000 per month
Carla Vista Company produces and sells automobile batteries, the heavy duty HD-240. The 2022 sales forecast is as follows. Quarter 1 2 3 4 HD-240 5.900 8.260 9,440 11.800 The January 1, 2022, inventory of HD-240 is 2,360 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales Sales in the first quarter of 2023 are expected to be 25% higher than sales in the same quarter in 2022. Prepare quarterly production budgets for each quarter and in total for 2022. The January 1, 2022, inventory of HD-240 is 2.360 units Management desires an ending inventory each quarter equal to 40% of the next quarter's sales, Sales in the first quarter of 2023 are expected to be 25% higher than sales in the same quarter in 2022 Prepare quarterly production budgets for each quarter and in total for 2022 CARLA VISTA COMPANY Production Budget Product HD-240
Concord Company estimates that 2022 sales will be $34,400 in quarter 1, $41,280 in quarter 2, and $49,880 in quarter 3. Cost of goods sold is 50% of sales. Management desires to have ending merchandise inventory equal to 10% of the next quarter's expected cost of goods sold. Prepare a merchandise purchases budget by quarter for the first 6 months of 2022. v: v ✓ CONCORD COMPANY Merchandise Purchases Budget $ $ 1 Quarter $ $ 2 $ Six Months
Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as follows. Quarter HD-240 1 5,200 2 7,110 8,190 10,240 The January 1, 2020, inventory of HD-240 is 2,080 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 Product HD-240 Quarter 1
Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as follows. Quarter 1 2 3 4 HD-240 5,400 7,430 8,450 10,230 The January 1, 2020, inventory of HD-240 is 2,160 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.
ABC Corporation has estimated the following information for first quarter of 2020 for one of its products: January February March Units to be produced 128,000 140,000 152,000 Desired ending inventory of finished goods 30,000 36,000 38,000 The ending inventory at December 2019 was 28,000 units. Required: Prepare the Production Budget and the Sales Budget for the first quarter of 2020, assuming selling price per unit is $20.
Projected operating income for August 2021 must be Hen Yu presented these data for August 2021 operations of Ga Ling Co.: a. Sales are budgeted at P300,000. All sales are credit sales and a provision for doubtful accounts is made monthly at 3% of sales. b. Merchandise inventory was P70,000 at Jluly 2021 and an increase of P10,000 is planned for the month. C. All merchandise is marked up to sell at invoice cost plus 50%. d. Estimated cash disbursements for operating expenses for August 2021 is P40,000. e. Depreciation for the month is projected at P5,000. P46,000 P55,000 O P56,000 O P86,000
Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as follows. Quarter HD-240 1 5,100 2 7,410 3 8,180 4 10,470 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 COMPANYProduction Budgetchoose the accounting period For the Year Ending December 31, 2020For the Month Ended December 31, 2020For the Quarter Ended December 31, 2020 Product HD-240 Quarter 1 2 3 4 Year select an opening production budget item Beginning Finished Goods UnitBeginning Direct MaterialsDesired…
Ivanhoe Company produces and sells automobile batteries, the heavy-duty HD-240. The 2022 sales forecast is as follows. Quarter HD-240 1 4,300 2 6,020 3 4 6,880 8,600 The January 1, 2022, inventory of HD-240 is 1,720 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 2023 are expected to be 25% higher than sales in the same quarter in 2022. Prepare quarterly production budgets for each quarter and in total for 2022.
Prepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenue 2. Prepare a production budget for 2 quarters. Sales budget data for Palermo Company are given in exercise 1. 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 2019. Palermo Company Direct Labor Budget For the Six Months Ending June 30, 2019…
1.2 REQUIRED Use the information provided below to prepare the Direct Materials Purchases Budget for April 2019. INFORMATION The estimated sales volumes of Product Jip of Polo Manufacturers for April and May 2019 are as follows: Units April 18 000 May 15 000 The policy of Polo Manufacturers is to maintain a finished goods closing inventory each month at a level equal to 40% of the next month's budgeted sales. Each unit of Product Jip requires 2 kg of Material A and 1 kg of Material B. The costs per kg of Material A and Material B are R10 and R20 respectively. Inventories of materials are expected to be as follows: Material A Material B Opening inventory 5 000 kg 6 000 kg Closing inventory 1 000 kg 2 000 kg
Prepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenue