Data Year 2 Quarter Year 3 Quarter 1 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 •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

Data Year 2 Quarter Year 3 Quarter 1 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 •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

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.
Communication Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Date Units Purchased Unit Cost Total Cost April 6 31,000 36.60 1,134,600 May 18 33,000 39.00 1,287,000 June 6 40,000 39.60 1,584,000 July 10 40,000 42.00 1,680,000 August 10 27,200 42.75 1,162,800 October 25 12,800 43.50 556,800 November 4 8,000 44.85 358,800 December 10 8,000 48.00 384,000 200,000 8,148,000 Sales: April 16,000 units May 16,000 June 20,000 July 24,000 August 28,000 September 28,000 October 18,000 November 10,000 December 8,000 Total Units 168,000 Total sales 10,000,000 The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.
QUESTION 5 A) A company sells product X & Y Sales for the year ended 2019 are: X: 5000 units @ ¢10 each Y: 3000 units @ ¢12 each The company expects to sell the following units in 2020: X: 6000 units @ ¢15 each Y: 4500 units @ ¢18 each Additional information: i) Budgeted opening stock X: 1000 units Y: 800 units Budgeted closing stock: X: 2000 units Y: 1500 units ii) Materials A and B are used to produce products X and Y based on the following ratio in order to produce one unit of X & Y Product Material A Material B X 3kg 2kg Y 2kg 1kg Purchase price ¢10 per Kg ¢12 per kg iii) Material A Material B Opening stock 8000 5000 Closing stock 6000 3500 (iv) The company has only one grade of labour and uses 3 hours to produce one unit of X 2 hours to produce one unit of Y Labour rate would be ¢20 per hour Required: Prepare the following budgets for 2020 Sales budget Production budget Direct Material usage budget Direct Material purchase budget Direct labour…
Item 3 Item 3 10 points Sims Company, a manufacturer of tablet computers, began operations on January 1, 2019. Its cost and sales information for this year follows. Manufacturing costs Direct materials $ 40 per unit Direct labor $ 60 per unit Overhead costs Variable $ 30 per unit Fixed $ 7,000,000 (per year) Selling and administrative costs for the year Variable $ 770,000 Fixed $ 4,250,000 Production and sales for the year Units produced 100,000 units Units sold 70,000 units Sales price per unit $ 350 per unit 1. Prepare an income statement for the year using variable costing.2. Prepare an income statement for the year using absorption costing.
Twenty Twenty One Corp.Income StatementFor the month ended December 31, 2020Sales (P10/unit) ...................................................................................................... P900,000Variable Costs:Variable Cost of Goods Sold:Beginning Inventory ............................................................. P125,000Variable Cost of Goods Manufactured ............................... 400,000----------------Total Goods Available for Sale ........................................... 525,000Ending Inventory ................................................................. 75,000----------------Variable Cost of Goods Sold .............................................. 450,000Variable Selling Expense ....................................................... 90,000 540,000----------------- -------------------Contribution Margin ................................................................................................ P360,000Fixed Costs:Manufacturing…
Twenty Twenty One Corp.Income StatementFor the month ended December 31, 2020Sales (P10/unit) ...................................................................................................... P900,000Variable Costs:Variable Cost of Goods Sold:Beginning Inventory ............................................................. P125,000Variable Cost of Goods Manufactured ............................... 400,000----------------Total Goods Available for Sale ........................................... 525,000Ending Inventory ................................................................. 75,000----------------Variable Cost of Goods Sold .............................................. 450,000Variable Selling Expense ....................................................... 90,000 540,000----------------- -------------------Contribution Margin ................................................................................................ P360,000Fixed Costs:Manufacturing…
PROBLEM 6 The following information pertains to AAA Manufacturing Company’s Product X: Annual Demand 33,750 units Annual cost to hold one unit of inventory P15 Setup cost (or the cost to initiate a production run P500 Beginning inventory of Product X 0 At present, the company produces 2,250 units of Product X per production run, for a total of 15 production runs per year. The Company is considering to use the EOQ model to determine the economic lot size and the number of production runs that will minimize the total inventory carrying cost and setup cost for Product X. At present, the company’s total annual inventory costs is If the EOQ model is used, the economic lot size is If the EOQ model is used, the number of production runs should be If the EOQ model is used, the total annual inventory costs, compared with that under present system, will increase (decrease)…
PROBLEM 14: MMM Company started operations in 2019. The following data are abstractedfrom the company’s production and sales records: 2019 2020 2021 Number of units produced 120,000 116,250 101,250 Number of units sold 75,000 108,750 97,500 Unit production cost P 4.50 P 5.20 P 5.80 Sales revenue 600,000 900,000 975,000 Using the FIFO cost flow assumption, the gross profit for the year ended December 31, 2021 is:
Problem 1. (40%) The EG Company produces and sells one product. The following data refer to the year just completed:Units in beginning inventory ..........................0Units produced................................................8,900Units sold........................................................8,500Units in ending inventory ...............................400Variable costs per unit:Direct materials ...........................................$26Direct labor..................................................$25Variable manufacturing overhead ...............$4Variable selling and administrative expense.................................................................$4Fixed costs:Fixed manufacturing overhead ....................$249,200Fixed selling and administrative expense....$17,000Sales Price is $100 per unit.Required: b. Prepare an income statement for the year using absorption costing.c. Prepare a contribution format income statement for the year using variable costing.d.…
Ch. 8 Homework 2 Please solve and explain the following problem Croy Inc. has the following projected sales for the next five months: MonthSales in UnitsApril 3,850May 3,875June 4,260July 4,135August 3,590 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct material costs $3.10 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Raw materials on hand at March 31 totaled 3,865 pounds. 1) Determine budgeted production for April, May, and June. 2) Determine the budgeted cost of materials purchased for April, May, and June
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