As the new accountant for Cohen & Company, you have been asked to provide a succinct analysis of financial performance for the year just ended. You obtain the following information that pertains to the company's sole product: Units sold Sales Variable costs Fixed costs Actual 40,000 $ 380,000 210,000 145,000 Master Budget 45,000 $450,000 270,000 135,000 Required: 1. What was the actual operating income for the period? 2. What was the company's master budget operating income for the period? 3. (a) What was the total master budget variance, in terms of operating income, for the period? (b) Is this variance favorable or unfavorable? (If a variance has no amount, select "None" in the corresponding dropdown cell.) olumo varian

As the new accountant for Cohen & Company, you have been asked to provide a succinct analysis of financial performance for the year just ended. You obtain the following information that pertains to the company's sole product: Units sold Sales Variable costs Fixed costs Actual 40,000 $ 380,000 210,000 145,000 Master Budget 45,000 $450,000 270,000 135,000 Required: 1. What was the actual operating income for the period? 2. What was the company's master budget operating income for the period? 3. (a) What was the total master budget variance, in terms of operating income, for the period? (b) Is this variance favorable or unfavorable? (If a variance has no amount, select "None" in the corresponding dropdown cell.) olumo varian

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter19: Variable Costing (varcost)

Section: Chapter Questions

Problem 4R: To determine the effect of different levels of production on the company’s income, move to cell B7...

See similar textbooks

Similar questions

All applicable Cases are available with McGraw-Hill’s Connect™Accounting. Cost of goods manufactured, cost of goods sold, and income statement Determine each of the following missing amounts:Firm A Firm B Firm CBeginning raw materials inventory . . . . . . . . . . . . . . . . . $ 17,000 $ ? $ 42,000Purchases of raw materials during the year . . . . . . . . . . ? 96,000 226,000Raw materials available for use . . . . . . . . . . . . . . . . . . . ? 119,000 ?Ending raw materials inventory . . . . . . . . . . . . . . . . . . . 12,000 ? 51,000Cost of raw materials used . . . . . . . . . . . . . . . . . . . . . . 90,000 101,000 ?Direct labor costs incurred. . . . . . . . . . . . . . . . . . . . . . . 130,000 ? 318,000Variable manufacturing overhead applied. . . . . . . . . . . . ? 34,000 72,000Fixed manufacturing overhead applied. . . . . . . . . . . . . . 100,000 60,000 ?Total manufacturing costs incurred . . . . . . . . . . . . . . . . 370,000 ? ?Beginning work in process. . . . . . . . .…
The following information was extracted from the first year absorption-based accounting records of COCOMELON Co. (refer to image) If COCOMELON Co. had used variable costing in its first year of operations, how much income (loss) before income taxes would it have reported? a. (P6,000) b. P54,000 c. P26,000 d. P2,000
The following selected information was extracted from the 20x1 accounting records of Lone Oak Products: Required:1. Calculate Lone Oak’s manufacturing overhead for the year.2. Calculate Lone Oak’s cost of goods manufactured.3. Compute the company’s cost of goods sold.4. Determine net income for 20x1, assuming a 30% income tax rate.5. Determine the number of completed units manufactured during the year.6. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: indirect labor is $115,000 and other factory costs amount to $516,000.
a. Calculate the cost of goods manufactured for the year by Gopaul Electronics b.) Prepare an income statement for Gopaul Electronics for the year ended December 31, 2023, clearly showing the calculation of Cost of Goods Sold. List the non-production overheads in order of size starting with the largest. c) What is the selling price per switch if Gopaul Electronics manufactured 1,500 switches for the period under review and uses a mark-up of 33⅓% on cost?
During the current year, Sokowski Manufacturing earned income of $350,000 from total sales of $5,500,000 and average capital assets of $12,000,000. A. Based on this information, calculate asset turnover. B. Using the sales margin from the previous exercise, what is the total ROI for the company during the current year?
Ellerson Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 278,000, direct labor cost was 189,000, and overhead cost was 523,000. During the year, 100,000 units were completed. Refer to Exercise 2.21. Last calendar year, Ellerson recognized revenue of 1,312,000 and had selling and administrative expenses of 204,600. Required: 1. What is the cost of goods sold for last year? 2. Prepare an income statement for Ellerson for last year.
Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.
To determine the effect of different levels of production on the company’s income, move to cell B7 (Actual production). Change the number in B7 to the different production levels given in the table below. The first level, 100,000, is the current level. What happens to the operating income on both statements as production levels change? Enter the operating incomes in the following table. Does the level of production affect income under either costing method? Explain your findings.
What are the total costs to account for if a companys beginning inventory had $231,432 in materials, $186,450 in conversion costs, and added direct material costs ($4,231,392), direct labor ($2,313,392), and manufacturing overhead ($1,156,696)?
Choose the correct letter of answer The accounting records of Abalos Company revealed the following information: Raw materials used, P500,000; labor cost, 50% of raw materials used; overhead, 30% of raw materials used; administrative and selling expenses, 20% of labor cost. The total product cost is equivalent to: a. P1,000,000b. P 900,000c. P 750,000d. P650,000
Cost of Goods Sold As an accountant for Lee Company, your supervisor gave you the following calculations of the gross profit for the first quarter: Alternative Sales ($50 per unit) Cost of Goods Sold Gross Profit A $500,000 $200,000 $300,000 B 500,000 228,000 272,000 C 500,000 213,333 286,667 The three alternative cost flow assumptions are FIFO, average, and LIFO (the alternatives are not necessarily presented in this sequence). Lee uses the periodic inventory system. The computation of the cost of goods sold under each alternative is based on the following data: Units Cost/Unit Inventory, January 1 12,000 $20 Purchase, January 10 4,000 21 Purchase, February 15 6,000 22 Purchase, March 10 8,000 23 1. Prepare schedules proving the cost of goods sold shown here under each of the three alternatives. For average cost. LEE COMPANY Schedules of Cost of Goods Sold For First Quarter Ended March 31 FIFO LIFO Average Beginning…
The following information is given to you from which you are required to prepare a Statement of Cost and Sales for the period ended on 30th June 2023:Consumable material: KOpening stock 20,000Purchases 122,000Closing stock 10,000Direct wages 36,000Direct Expenses 24,000Factory overheads 50 % of direct wagesOffice and administration overheads 20% of works costSelling and distribution expenses K3 per unit soldUnits of finished goods:In hand at the beginning of the period (Value K12,500) 500Units produced during the period 12,000In hand at the end of the period 1,500Profit on selling price 20% There is no work-in-progress either at the beginning or at the end of the period.