ATC 8-6 Spreadsheet Assignment Using Excel Irvine Publications established the following standard price and costs for a hardcover picture book that the company produces. Standard price and variable costs Sales price $48.00 Materials cost 12.00 Labor cost 6.00 Overhead cost 8.40 Selling, general, and administrative costs 9.60 Expected fixed costs Manufacturing overhead $180,000 Selling, general, and administrative 72,000 Irvine planned to make and sell 30,000 copies of the book. Page 3 Required Construct a spreadsheet like the one shown in Exhibit 8.1 to illustrate a static budget and a flexible budget for production volumes of 28,000, 29,000, 30,000, 31,000, and 32,000.

ATC 8-6 Spreadsheet Assignment Using Excel Irvine Publications established the following standard price and costs for a hardcover picture book that the company produces. Standard price and variable costs Sales price $48.00 Materials cost 12.00 Labor cost 6.00 Overhead cost 8.40 Selling, general, and administrative costs 9.60 Expected fixed costs Manufacturing overhead $180,000 Selling, general, and administrative 72,000 Irvine planned to make and sell 30,000 copies of the book. Page 3 Required Construct a spreadsheet like the one shown in Exhibit 8.1 to illustrate a static budget and a flexible budget for production volumes of 28,000, 29,000, 30,000, 31,000, and 32,000.

Accounting

27th Edition

ISBN:9781337272094

Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Chapter21: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 21.28EX: Appendix Absorption costing income statement On June 30, the end of the first month of operations,...

See similar textbooks

Similar questions

Communication The controller of New Wave Sounds Inc. prepared the following product profitability report for management, using activity-based costing methods for allocating both the factory overhead and the marketing expenses. As such, the controller has confidence in the accuracy of this report. Home Theater Speakers Wireless Speakers Wireless Headphones Total Sales 1,500,000 1,200,000 900,000 3,600,000 Cost of goods sold 1,050,000 720,000 810,000 2,580,000 Gross profit 450,000 480,000 90,000 1,020,000 Marketing expenses 600,000 120,000 72,000 792,000 Income from operations (150,000) 360,000 18,000 228,000 In addition, the controller interviewed the vice president of marketing, who provided the following insight into the company's three products: The home theater speakers are an older product that is highly recognized in the marketplace. The wireless speakers are a new product that was just recently bunched. The wireless headphones are a new technology that has no competition in the marketplace, and it is hoped that they will become an important future addition to the companys product portfolio. Initial indications are that the product is well received by customers. The controller believes that the manufacturing costs for all three products are in line with expectations. Based on the information provided: 1. Calculate the ratio of gross profit to sales and the ratio of income from operations to sales for each product. 2. Write a brief (one page) memo using the product profitability report and the calculations in (1) to make recommendations to management with respect to strategies for the three products.
Appendix Absorption costing income statement On June 30, the end of the first month of operations, Tudor Manufacturing Co. prepared the following income statement, based on the variable existing concept: Sales (420,000 units) 7,450,000 Variable cost of goods sold: Variable cost of goods manufactured (500,000 units x 14 per unit) 7,000,000 Less ending inventory (80,000 units x 14 per unit) 1,120,000 Variable cost of goods sold 5,880,000 Manufacturing margin 1,570,000 Variable selling and administrative expenses 80,000 Contribution margin 1,490,000 Fixed costs: Fixed manufacturing costs 160,000 Fixed selling and administrative expenses 75,000 235,000 Income from operations 1,255,000 a. Prepare an absorption costing income statement. b. Reconcile the variable costing income from operations of 1,255,000 with the absorption costing income from operations determined in (a).
Exercise 8-41 (Algo) Prepare a Production Cost Report: FIFO Method (LO 8-2, 4, 5) Lansing, Inc. provides the following information for one of its department’s operations for June (no new material is added in Department T). WIP inventory—Department T Beginning inventory (8,600 units, 20% complete with respect to Department T costs) Transferred-in costs (from Department S) $ 41,030 Department T conversion costs 11,110 Current work (19,700 units started) Prior department costs 100,470 Department T costs 198,240 The ending inventory has 3,600 units, which are 50 percent complete with respect to Department T costs and 100 percent complete for prior department costs. Required: Complete the production cost report using FIFO. (Round "Cost per equivalent unit" to 2 decimal places.)
Exercise 7-15 (Static) Comprehensive Activity-Based Costing Exercise [LO7-2, LO7-3, LO7-4, LO7-5] Advanced Products Corporation has supplied the following data from its activity-based costing system: Overhead CostsWages and salaries$ 300,000Other overhead costs100,000Total overhead costs$ 400,000 Activity Cost PoolActivity MeasureTotal Activity for the YearSupporting direct laborNumber of direct labor-hours20,000DLHs Order processingNumber of customer orders400orders Customer supportNumber of customers200customers OtherThis is an organization- sustaining activityNot applicable Distribution of Resource Consumption Across Activities Supporting Direct LaborOrder ProcessingCustomer SupportOtherTotal Wages and salaries40%30%20%10%100% Other overhead costs30%10%20%40%100% During the year, Advanced Products completed one order for a new customer, Shenzhen Enterprises. This customer did not order any other products during the year. Data concerning that order follow: Data Concerning the…
Problem 8-63 (Algo) Solving for Unknowns: FIFO Method (LO 8-4, 5) For each of the following independent cases, use FIFO costing to determine the information requested. Required: a) At the start of the period, 3,700 units were in the work-in-process inventory; 3,100 units were in the ending inventory. During the period, 9,600 units were transferred out to the next department. Materials and conversion costs are added evenly throughout the production process. FIFO costing is used. How many units were started during this period?b. Beginning inventory amounted to 1,100 units. This period, 4,600 units were started and completed. At the end of the period, the 3,200 units in inventory were 40 percent complete. Using FIFO costing, the equivalent production for the period was 6,100 units. What was the percentage of completion of the beginning inventory?c. The ending inventory included $81,900 for conversion costs. During the period, 41,300 equivalent units were required to complete the…
ACC 307 – HW #4 – Chapters 7 and 8 The Beal Manufacturing Company’s costing system has two direct-cost categories: direct materials and direct manufacturing labor. Manufacturing overhead (both variable and fixed) is allocated to products on the basis of standard direct manufacturing laborhours (DLH). At the beginning of 2012, Beal adopted the following standards for its manufacturing costs: Direct materials Direct manufacturing labor Manufacturing overhead: Input 3 lb. at $5 per Ib. 5 hrs. at $15 per hr. Cost per Output Unit $ 15.00 75.00 $6 per DLH $8 per DLH Variable 30.00 40.00 Fixed Standard manufacturing cost per output unit $160.00 The denominator level for total manufacturing overhead per month in 2012 is 40,000 direct manufacturing labor-hours. Beal's flexible budget for January 2012 was based on this denominator level. The records for January indicated the following: Direct materials purchased Direct materials used Direct manufacturing labor Total actual manufacturing overhead…
ACC 307 – HW #4 – Chapters 7 and 8 The Beal Manufacturing Company’s costing system has two direct-cost categories: direct materials and direct manufacturing labor. Manufacturing overhead (both variable and fixed) is allocated to products on the basis of standard direct manufacturing laborhours (DLH). At the beginning of 2012, Beal adopted the following standards for its manufacturing costs: Direct materials Direct manufacturing labor Manufacturing overhead: Input 3 lb. at $5 per Ib. 5 hrs. at $15 per hr. Cost per Output Unit $ 15.00 75.00 $6 per DLH $8 per DLH Variable 30.00 40.00 Fixed Standard manufacturing cost per output unit $160.00 The denominator level for total manufacturing overhead per month in 2012 is 40,000 direct manufacturing labor-hours. Beal's flexible budget for January 2012 was based on this denominator level. The records for January indicated the following: Direct materials purchased Direct materials used Direct manufacturing labor Total actual manufacturing overhead…
ACC 307 – HW #4 – Chapters 7 and 8 The Beal Manufacturing Company’s costing system has two direct-cost categories: direct materials and direct manufacturing labor. Manufacturing overhead (both variable and fixed) is allocated to products on the basis of standard direct manufacturing laborhours (DLH). At the beginning of 2012, Beal adopted the following standards for its manufacturing costs: Direct materials Direct manufacturing labor Manufacturing overhead: Input 3 lb. at $5 per Ib. 5 hrs. at $15 per hr. Cost per Output Unit $ 15.00 75.00 $6 per DLH $8 per DLH Variable 30.00 40.00 Fixed Standard manufacturing cost per output unit $160.00 The denominator level for total manufacturing overhead per month in 2012 is 40,000 direct manufacturing labor-hours. Beal's flexible budget for January 2012 was based on this denominator level. The records for January indicated the following: Direct materials purchased Direct materials used Direct manufacturing labor Total actual manufacturing overhead…
Exercise 6-48 (Algo) Two-Stage Cost Allocation and Predetermined Rates (LO 6-3, 4, 5) Channing Corporation makes two products (A1 and B2) that require direct materials, direct labor, and overhead. The following data refer to operations expected for next month. A1 B2 Total Revenue $ 170,000 $ 510,000 $ 680,000 Direct material 65,000 130,000 195,000 Direct labor 54,000 128,250 182,250 Overhead: Direct-material related 42,900 Direct-labor related 40,095 Required: Channing uses a two-stage cost allocation system, It uses direct-material costs to allocate direct-materials related overhead and direct-labor costs to allocate direct-labor related overhead costs. a. Compute the direct-material related overhead rate for next month. b. Compute the direct-labor related overhead rate for next month. c. What is the total overhead allocated to product A1 next month? d. What is the total…
Exercise 9-31 (Algo) Reported Costs and Decisions (LO 9-1) McNulty, Inc., produces desks and chairs. A new CFO has just been hired and announces a new policy that if a product cannot earn a margin of at least 15 percent, it will be dropped. The margin is computed as product gross profit divided by reported product cost. Manufacturing overhead for year 1 totaled $880,000. Overhead is allocated to products based on direct labor cost. Data for year 1 show the following. Chairs Desks Sales revenue $ 1,001,000 $ 2,469,600 Direct materials 598,000 940,000 Direct labor 120,000 430,000 Required: a-1. Based on the CFO's new policy, calculate the profit margin for both chairs and desks. a-2. Which of the two products should be dropped? b. Regardless of your answer in requirement (a), the CFO decides at the beginning of year 2 to drop the chair product. The company cost analyst estimates that overhead without the chair line will be $790,000. The…
Problem 8-63 (Algo) Solving for Unknowns: FIFO Method (LO 8-4, 5) For each of the following independent cases, use FIFO costing to determine the information requested. Required: a. In the beginning inventory, 4,600 units were 40 percent complete with respect to materials. During the period, 37,000 units were transferred out. Ending inventory consisted of 6,900 units that were 60 percent complete with respect to materials. How many units were started and completed during the period?b. At the start of the period, 3,700 units were in the work-in-process inventory; 3,100 units were in the ending inventory. During the period, 9,600 units were transferred out to the next department. Materials and conversion costs are added evenly throughout the production process. FIFO costing is used. How many units were started during this period?c. Beginning inventory amounted to 1,100 units. This period, 4,600 units were started and completed. At the end of the period, the 3,200 units in inventory were…
Problem 6-61 (Static) Account Analysis, Two-Stage Allocation, and Product Costing (LO 6-2, 4, 5) Tiger Furnishings produces two models of cabinets for home theater components, the Basic and the Dominator. Data on operations and costs for March follow: Basic Dominator Total Units produced 1,000 250 1,250 Machine-hours 4,500 2,500 7,000 Direct labor-hours 3,000 2,000 5,000 Direct materials costs $ 10,000 $ 3,750 $ 13,750 Direct labor costs 64,500 35,500 100,000 Manufacturing overhead costs 175,000 Total costs $ 288,750 Tiger Furnishings’s CFO believes that a two-stage cost allocation system would give managers better cost information. She asks the company’s cost accountant to analyze the accounts and assign overhead costs to two pools: overhead related to direct labor cost and overhead related to machine-hours. The analysis of overhead accounts by the cost accountant follows:…