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 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.
Q: Solomon Fruit Drink Company planned to make 200,000 containers of apple juice. It expected to use…
A: * As per Bartleby policy, in case multiple questions are asked then answer first three only. 1.…
Q: Balance Est. Percentage Uncollectible Age Interval Not due $63,000 2% 1-30 days past due 7,100 5%…
A: Lets understand the basics. Entity generally calculates the estimated uncollectible amount to make a…
Q: QUESTION 1 *COGS $390,000 •GM 60% %3D •Store size: 20 ft x 25 ft. •2,500 transactions •5,000 units…
A: The question is related to Marginal Costing and Cost Volume Profit Analysis.
Q: To measure the financial viability of a proposed business, which is the more powerful measure-…
A: Ratio analysis involves evaluation of various operational aspects of the business such as liquidity,…
Q: Why is preparation of the government-wide statements considered to be "challenging"?
A: Government accounting seems to be a systematic technique for gathering, categorizing, documenting,…
Q: Marin Leasing Company signs an agreement on January 1, 2020, to lease equipment to Cole Company. The…
A: Note:- Since the lessor's desired rate of return on its investment is missing in the question,…
Q: Question 1 UMU has demand for 1400 water pumps each year. The cost of a water pump to LUMU is $400.…
A: Economic order quantity is the optimal quantity to be ordered to minimize the overall cost.
Q: On Jan 5th, 2021, Issue 20,000 common shares at $11 each (100,000 authorized & $2 par value) to Jack…
A:
Q: On June 1, 2021, Demer Consulting provides services to a customer for $150,000. To pay for the…
A: The journal entries are prepared to record the day to day transactions of the business during the…
Q: Preparing Common-Size Income Statements by Using BasePeriod Horizontal AnalysisRefer to the…
A: A common size income statement would be one wherein each line item is stated as a % of the revenue…
Q: a-1. Determine the unadjusted rate of return and (use ave places. (i.e., 0.2345 should be entered as…
A: IRR is a tool that is used to calculate the return over the project cash flow or its investment. If…
Q: Using the following information: a. The bank statement balance is $3,351. b. The cash account…
A: Bank reconciliation is the method of validating all cash account balances in an entity's accounting…
Q: We-Sell Realty was organized as a corporation on August 1, 20Y7, by the issuance of common stock of…
A: The errors are listed as,
Q: A 1000 par value 10-year bond with 6.0% semiannual coupons was convertible semiannually. bought to…
A: It is the amount liable to the bondholders by the issuer of bonds. These bonds payable will be…
Q: You must evaluate a proposal to buy a new milling machine. The purchase price of the milling…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: Macinski Leasing Company Leases a new machine to Sharrer Corporation. The machine has a cost of…
A: Solution Working- Annual repayment amount = Fair value of machine / Present value of 3 years. =…
Q: Management of Great Springs Bottled Water Company has asked you, the controller, to develop a…
A: In this question, we will make Income statement of Great Springs Bottled Water and find out the…
Q: Using the following information: a. The bank statement balance is $4,690. b. The cash account…
A: Bank reconciliation reconcile the bank balance with book balance as per financial records.
Q: For the past year, Kayla, Incorporated, has sales of $46,967, interest expense of $4,088, cost of…
A: Operating Cash Flow = Net Income + Non-Cash Expense (Depreciation) As per US GAAP, Interest Paid is…
Q: Determine the monthly principal and interest payment for a 20-year mortgage when the amount fr the…
A: In this question we have to calculate the monthly interest and principal payment. Compound interest:…
Q: Prepare journal entries for each of the following transactions entered into by the City of Loveland.…
A: "Since you have posted a question with multiple subparts, we will solve the first three subparts for…
Q: Caribbean. prs a define
A: Notes : According to Generally Accepted Accounting Principles (GAAP), net pension spending in the…
Q: Reece Financial Services Co., which specializes in appliance repair services, is owned and oper-…
A: Adjusted trial balance An adjusted trial balance is a list of the ending balances in all accounts…
Q: Which of the following is a characteristic of managerial accounting?a. There is an internal focus.b.…
A: Managerial accounting (often referred to as cost accounting or management accounting) seems to be a…
Q: SydMel Ltd commences operations on 1 July 2020. One year later, on 30 June 2021, the entity prepares…
A: The calculation of the deferred tax while taking consider the accounting profit with the adjustment…
Q: Question 15 Companies can set transfer prices to shift profits between the buyer and seller…
A: Transfer Price is the price charged by the transferor department to transferee department. It is…
Q: The following information is also available: Beginning balance of Accounts Receivable P 500,000 Net…
A: >Bad Debt Expense is recorded using two methods: #1: Direct write off method: Expense is…
Q: A home theater system is on sale for $777. If the list price is $925, find the percent of markdown.…
A: Markdown means the reduction in the price of the sale value of goods. Formula: Markdown amount =…
Q: April Issued 5,000 share of Common Stock, $2 par for $17 per share. Record the journal entry.
A: Journal is the book of original entry in which all the financial transactions of the business are…
Q: Quick BQtio lor all Years Yeath As Reported Annual Balance Sheet Report Date Scale 2019 2017…
A: Formula: Quick ratio = Quick Assets / current liabilities.
Q: Rostand Inc. operates a delivery service for over 70 restaurants. The corporation has a fleetof…
A: Variance refers to the difference of budgeted and actual figures relating to revenue or expense…
Q: Primara Corporation has a standard costing system in which it applies overhead to products on the…
A: Predetermined overhead rate(fixed portion)= Budgeted fixed overhead cost/Budgeted direct labor hours…
Q: How is total cost of goods sold and the total amount billed to customers calculated?
A: A job cost sheet is a sheet which is used to record the manufacturing costs .
Q: Refer to the information for Cuneo Company above.Required:1. Prepare a common-size income statement…
A: A common-size income statement seems to be one where every line item is stated as a percentage of a…
Q: can anyone one help me to prepare general ledger for following
A: General Ledger The purpose of preparing the general ledger to know the ending balance of each…
Q: Assets Liabilities and Equity Cash Accounts receivables 34,000 Inventory Prepaid Insurance Capital…
A: Assets=Liabilities+Shareholders' Equity
Q: Which of the following is not a characteristic of a lean accounting system? Multiple Cholce Costs in…
A: lean accounting is the collection of principal and the process that provides the numerical feedback…
Q: Case Scenario1 - Hien Hien is in business selling high quality glassware to retailers. Her…
A: Note: We’ll answer the first question since the exact one wasn’t specified. Please submit a new…
Q: What other sources provide resources for capital projects funds?
A: A capital project seems to be a long-term, capital-intensive investing project with the goal of…
Q: The management of Springer plc is considering next year’s production and purchase budget. One of…
A: GIVEN The management of Springer plc is considering next year’s production and purchase budget.…
Q: How can the predetermined factory overhead rate be used in job order cost accounting to assist…
A: Factory overheads refer to the total cost of manufacturing and operating a manufacturing process, is…
Q: An accrual income statement for 2021 reveals: a. Profit from crops and livestock produced in…
A: Income statement refers to one of the statement which states the financial position of the business…
Q: The appropriate asset value reported in the balance sheet by the lessee for an operating lease is:
A: GIVEN The appropriate asset value reported in the balance sheet by the lessee for an operating…
Q: Biases like motivated reasoning and surrogation are very prevalent in the business world. Man- agers…
A: Introduction: A balanced scorecard is a type of performance monitoring method used in businesses…
Q: Shannon's income tax rate was 25% in 2021 and previous years. During the course of the audit, the…
A: Fair value adjustment Investment balance as reported(Assumed) 250000 Error adjustment 40000…
Q: Record the journal entry.
A: Answer:
Q: Year 1 Sales $161,120 Cost of Goods Sold 105,035 SG&A 42.957 Depreciation 6,687 Operating Income…
A: Debt would be defined as the sum owing for borrowed cash. The lender accepts to lend cash to the…
Q: Prior to 23 October 2027, the share capital account of Fallout Ltd had a balance of $50,000. This…
A: The correct answer for the above mentioned question is given in the following steps for your…
Q: capital controls, which investment would you choose? What are the risks associated with this trade?
A: The United States has always been ranked among the best in the world for its competitiveness and…
Q: Which of the following is an indirect cost?a. The cost of denim in a jeans factoryb. The cost of…
A: Indirect costs would be those that cannot be linked to a specific cost object or cost source. Costs…
Step by step
Solved in 2 steps with 2 images
- 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:…