Year 2 Quarter 2 60,000 Year 3 Quarter 1 70,000 Data 1 3 4 2 Budgeted unit sales 40,000 100,000 50,000 80,000 • Selling price per unit • Accounts receivable, beginning balance • Sales collected in the quarter sales are made • Sales collected in the quarter after sales are made • Desired ending finished goods inventory is • Finished goods inventory, beginning • Raw materials required to produce one unit • Desired ending inventory of raw materials is • Raw materials inventory, beginning • Raw material costs • Raw materials purchases are paid $12 per unit $65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 and • Accounts payable for raw materials, beginning balance •Direct labor cost per hour •Direct labor hour per unit $15 per hour 0.2 hour per unit •Variable MOH rate •Total fixed MOH $2 per hour $60,000 •Variable S&A expense rate $1.80 per unit •Minimum cash balance $50,000 12% •Annual Interest rate

Year 2 Quarter 2 60,000 Year 3 Quarter 1 70,000 Data 1 3 4 2 Budgeted unit sales 40,000 100,000 50,000 80,000 • Selling price per unit • Accounts receivable, beginning balance • Sales collected in the quarter sales are made • Sales collected in the quarter after sales are made • Desired ending finished goods inventory is • Finished goods inventory, beginning • Raw materials required to produce one unit • Desired ending inventory of raw materials is • Raw materials inventory, beginning • Raw material costs • Raw materials purchases are paid $12 per unit $65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 and • Accounts payable for raw materials, beginning balance •Direct labor cost per hour •Direct labor hour per unit $15 per hour 0.2 hour per unit •Variable MOH rate •Total fixed MOH $2 per hour $60,000 •Variable S&A expense rate $1.80 per unit •Minimum cash balance $50,000 12% •Annual Interest rate

Financial & Managerial Accounting

14th Edition

ISBN:9781337119207

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter20: Variable Costing For Management Analysis

Section: Chapter Questions

Problem 20.4BPR: Salespersons' report and analysis Pachec Inc. employs seven salespersons to sell and distribute its...

See similar textbooks

Similar questions

Answer ALL FOUR Questions Question 12 Total Pop's data show the following information of January, February, March, April, May 2022 (respectively): ♦ + Additional information Finished goods inventory is required to be 20% of the next month's . Jan. Feb. Mar. Apr. May Estimated sales (units) 15,000 14,500 16,000 15,500 15,800 Sales price per unit $ 45 $ 45 $ 45 S 45 $ 45 Direct labor per unit $ 3 $ 3 $2.25 S 2 $ Labor rate per hour $ 18 $ 18 S 21 $ 21 S 2 21 requirements. The ending inventory required for direct materials is 15% of the next month's needs. Direct material requires 2 pounds per unit at a cost of $3 per pound. In January, the beginning inventory is 3,000 units of finished goods and 4,470 pounds of material. Required: Prepare the below budgets for the company: (a) a production budget for the first quarter of the year. (b) direct materials budget for the first quarter of the year. X
Problem 12 Compute the Cost of Goods Sold for 2020 of Pillows Company considering the followinginformation:  Raw materials purchased was P2,500,000 with freight-in of P120,000 Purchase returns was P50,000 and purchase discount is 60% of purchase returns Raw materials beginning was P460,000 Raw materials end was P40,000 more than the beginning inventory Direct labor is P1,000,000 Factory overhead is 50% of direct labor Total goods placed in process is 150% of manufacturing cost WIP, end is 75% of WIP, beg Finished goods beginning balance is lesser by P100,000 than the ending balance whichwas P600,000
Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit • Accounts receivable, beginning balance • Sales collected in the quarter sales are made • Sales collected in the quarter after sales are made • Desired ending finished goods inventory is • Finished goods inventory, beginning • Raw materials required to produce one unit • Desired ending inventory of raw materials is • Raw materials inventory, beginning • Raw material costs • Raw materials purchases are paid and • Accounts payable for raw materials, beginning balance $12 per unit $65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 •Direct labor cost per hour •Direct labor hour per unit $15 per hour 0.2 hour per unit $2 per hour $60,000 •Variable MOH rate…
PROBLEM 14: MMM Company started operations in 2019. The following data are abstracted from the company's production and sales records: 2019 2020 2021 of units Number produced Number of units sold Unit production cost 116,250 108,750 P 4.50 P 5.20 P 5.80 900,000 120,000 75,000 101,250 97,500 Sales revenue 600,000 975,000 19. Using the FIFO cost flow assumption, the gross profit for the year ended December 31, 2021 is: PROBLEM 15: The following quarterly cost data have been accumulated for New DDD Manufacturing, Inc.: Raw materials, 1/1/2022 Purchases of raw materials 10,000 units at P6.00 8,500 units at P7.00 11,000 units at P7.50 Raw materials transferred to work in process Work in process, 1/1/2022 Direct labor Manufacturing overhead Work in process, 3/31/2022 21,500 units 5,600 units at P13.50 P 250,000 325,000 4,200 units at P13.75 20. If New Dehi uses the FIFO method for valuing raw materials inventories, compute for the cost of goods manufactured for the quarter ended March 31,…
Problem: AAA Company produces and sells Product X: Annual Demand 24,000 units Annual cost to held one unit of inventory P11.52 Order Cost P38.40 Beg. Inventory P 0 a. What is the Economic Order Quantity? b. How much is the total Order Costs? c. How much is the total Carrying Costs?
Salespersons' report and analysis Walthman Industries Inc. employs seven salespersons to sell and distribute- its product throughout the state. Data taken from reports received from the .salespersons during the year ended December 31 are as follows: Instructions 1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. (Round whole percent to one digit after decimal point.) 2. Which salesperson generated the highest contribution margin ratio for the year and why? 3. Briefly list factors other than contribution margin that should be considered in evaluating the performance of salespersons.
Salespersons' report and analysis Pachec Inc. employs seven salespersons to sell and distribute its product throughout the slate. Data taken from reports received from the salespersons during the year ended June 30 are as Follows: Instructions 1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. 2. Which salesperson generated the highest contribution margin ratio for the year and why? 3. Briefly list factors other than contribution margin that should be considered in evaluating the performance of salespersons.
A 1 Chapter 7: Applying Excel 2 3 Data 4 Selling price per unit 5 Manufacturing costs: 6 7 8 Variable per unit produced: Direct materials Direct labor Variable manufacturing overhead 9 10 Fixed manufacturing overhead per year 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year 14 15 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year 25 Units in beginning inventory 26 Units produced during the year 27 Units sold during the year 28 Units in ending inventory 29 30 Compute the Absorption Costing Unit Product Cost 31 32 Direct materials 33 Direct labor 34 Variable manufacturing overhead 35 Fixed manufacturing overhead 36 Absorption costing unit product cost 37 19 20 Enter a formula into each of the cells marked with a ? below 21 Review Problem 1: Contrasting Variable and Absorption Costing 22 23 Compute the Ending Inventory 24 46 Compute the Variable Costing Unit Product Cost 47 48 Direct materials 49 Direct labor…
A1 fx Chapter 6: Ap B D E Chapter 6: Applying Excel 3 Data 4 Selling price per unit 5 Manufacturing costs: 6 Variable per unit produced: Direct materials $50 7 $11 8 Direct labor $6 $3 Variable manufacturing overhead 10 Fixed manufacturing overhead per year 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year 9 $120.000 $4 S70,000 14 15 Year 1 Year 2 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year 10,000 6.000 8,000 6,000 19 20 Enter a formula into each of the cells marked with a ? below 21 Review Problem 1: Contrasting Variable and Absorption Costing 22 23 Compute the Ending inventory 24 Year 1 Year 2 25 Units in beginning inventory 26 Units produced during the year 27 Units sold during the year 28 Units in ending inventory 2,000 6,000 6,000 10,000 8.000 2,000 2,000 29 30 Compute the Absorption Costing Unit Product Cost Year 1 $11 31 Year 2 $11 32 Direct materials 33 Direct labor 34 Variable manufacturing…
Question Two Pass-Well Company Limited produces a product that passes through two processes, Process 1 and Process 2. Details of activities for the month of December, 2020 is as follows; Process 1 @GH₵200.00 200hrs 3,500units GH₵20 per unit Process 2 GH₵25,000.00 600hrs 3,150units GH₵40 per unit a. You are required to prepare the relevant accounts b. You are required to prepare the relevant Accounts With practical example, differentiate between cost assignment and cost apportionment; product cost and period costs; direct Material introduced (4,000 units) Material added Labour Costs (@GH₵400 per hour) Output in units Scrap value of normal loss Note; i. Overhead is absorbed at 80% of labour costs. ii. Normal loss is estimated at 10% for both process. iii. No opening and closing stocks cost and indirect cost
O Problem Set: Module 4 1. EX.06.01 2. PR.06.02A ALGO 3. BE.06.02.ALGO 4. BE.06.03.ALGO cengagenow.com ● Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $188 per unit during the current year. Its income statement is as follows: Sales Cost of goods sold Gross profit Expenses: Selling expenses Administrative expenses Total expenses Cost of goods sold Selling expenses Administrative expenses Total variable costs Total fixed costs $16,000,000 10,600,000 Operating income The division of costs between variable and fixed is as follows: Fixed Unit variable cost Unit contribution margin + 40 Variable 70% 75% 50% $188,000,000 (101,000,000) $87,000,000 (26,600,000) $60,400,000 Management is considering a plant expansion program for the following year that will permit an increase of $11,280,000 in yearly sales. The expansion will increase fixed costs by $5,000,000 but will not affect the relationship between sales and variable costs. Required: 1. Determine the…
Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B26 enter the formula "= B5". Required: 1. Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The total expected cash collections for the year should now be $2,085,000. The required production for the year should be 274,000 units. The cost of raw materials to be purchased for the year should be $1,106,800, whereas the total cash disbursements for the year should be $1,095,980. If you do not get this answer, find the errors in your worksheet and correct them.