Concept explainers
Poleski Manufacturing, which maintains the same level of inventory at the end of each year, provided the following information about expenses anticipated for next year:
The selling price of Poleskiʼs single product is $16. In recent years, profits have fallen and Poleskiʼs management is now considering a number of alternatives. Poleski wants to have a net income next year of $250,000, but expects to sell only 120,000 units unless some changes are made.
The president of Poleski has asked you to calculate the companyʼs projected net income (assuming 120,000 units are sold) and the sales needed to achieve the companyʼs net income objective for next year. Also, compute Poleskiʼs contribution margin per unit, contribution margin ratio, and break-even point for next year. The worksheet CVP has been provided to assist you. Note that the data from the problem have already been entered into the Data Section of the worksheet.
Compute the projected net income of the company and the sales required to attain the net income objective for next year. Calculate contribution margin per unit, contribution margin ratio, and break-even point for next year.
Explanation of Solution
The projected net income, sales required to attain the net income, contribution margin per unit, contribution margin ratio, and break-even pointfor next year are calculated as follows:
Table (1)
Want to see more full solutions like this?
Chapter 18 Solutions
Excel Applications for Accounting Principles
- A retailing company believes it can sell 4 million of its main product within the upcoming financial year. The inventory manager plans to order its main product forty times over the next year. The carrying cost is $0.03 per product per year. The order cost is $600 per order. Calculate the following: i) The annual carrying costs ECM Manufacturing Company Limited has three (3) possible suppliers, all of which offer different credit terms. Apart from the slight differences in credit terms, their products and services are virtually identical. The credit terms offered by these suppliers are shown in table shown on the next page. Supplier Credit Terms Supplier 1 1/10 net 30 EOM Supplier 2 2/20 net 75 EOM Supplier 3 3/10 net 50 EOM Assuming a 365-day year, answer the following. d. What impact, if any, will “stretching” the accounts payable (net period only) of supplier 3 by 30 days, have on your answer to part b with regards to supplier 3. Ans…arrow_forwardBrody Inc. is currently selling a product at P20 per piece. The income statement for the current month showed that Brody Inc. have sold 100,000 units, variable costs of P800,000 and fixed costs of P400,000. Management is thinking of reducing the current sales price by P2 and based on studies, this will increase unit sales by 20%. If you are the company’s management accountant, what will be the financial impact of this scenario that you will report to management? a. no change in profit b. an P80,000 drop in profitability. c. a P240,000 drop in profitability. d. a P400,000 drop in profitability.arrow_forwardHiTech Electronics manufactures two new products, Tablets and Touch Screen Remotes, and sells them nationally to wholesalers and retailers. The HiTech management is very pleased with the company’s performance for the current fiscal year. Projected sales through December 31, 2022, indicate that 70,000 Tablets and 140,000 Remotes will be sold this year. The projected earnings statement, which appears below, shows that HiTech will exceed its earnings goal of 9 percent on sales after taxes. The Tablet business has been fairly stable for the last few years, and the company does not intend to change the Tablet price. However, the competition among manufacturers of Touch Screen Remotes has been increasing. HiTech’s Remotes have been very popular with consumers.In order to sustain this interest in their Remotes and to meet the price reductions expected from competitors, management has decided to reduce the wholesale price of its calculator from $22.50 to $20.00 per unit effective January 1,…arrow_forward
- The vice-president of sales and marketing, Madison Tremblay, is trying to plan for the coming year in terms of production needs to meet the forecast sales. The board of directors is very supportive of any initiatives that will lead to increased operating income for the company in the upcoming year. Waterways markets a simple water controller and timer that it mass-produces. During 2022. the company sold 322.500 units at an average selling price of $8.00 per unit. The variable costs were $1,193,250. and the fixed costs were $606,300. What is the margin of safety, both in dollars and as a ratio? (Round ratio to 2 decimal places, e.g. 25.25%) $ Margin of safety in dollars Margin of safety ratioarrow_forwardSales of Granite City Products Inc. have been on a steady decline for the last 12 months. A market research study conducted revealed that the product of Granite City Products Inc. can be sold only for $420 as opposed to the current market price charged of $520 per unit. Granite City Products Inc. has decided to revise its sales price to $420. The annual sales target volume of the product after price revision is 280 units. Granite City Products Inc. wants to earn 30% on its sales amount. What is the target operating income?arrow_forwardOne Manila Inc.'s president, Zane Cruz, is concerned about the prospects of one of the firm's major products. The president has been reviewing a marketing report with Jom Lara, marketing product manager, for their top-of-the-line stereo amplifier. The report indicates another price reduction is needed to meet anticipated competitors' reduction in sales prices. The current selling price for OMI's amplifier is P35,000 per unit. It is expected that within three months OMI's two major competitors will be selling their comparable amplifiers for P30,000 per unit. This concerns CRUZ because OMI's current cost of producing the amplifiers is P31,500, which yields a P3,500 profit on each unit sold. The situation is especially disturbing because OMI had implemented an activity-based costing (ABC) system about two years ago. The ABC system helped them better identify costs, cost pools, cost drivers, and cost reduction opportunities. Changes made when adopting ABC reduced costs on this…arrow_forward
- In an attempt to improve the company's profit performance, management is considering a number of alternative actions.Instructions:Determine the effect of each of the following on monthly profits. Each situation is to beevaluated independently of all others.1.Reduce the unit selling price by P2 per unit. Action will increase monthly sales by20,000 units. Fixed factory overhead will increase by P16,000.arrow_forwardMembers of the board of directors of Safety Place have received the following operating income data for the year ended May 31, 2018: (Click the icon to view the operating income data.) Members of the board are surprised that the industrial systems product line is not profitable. They commission a study to determine whether the company should drop the line. Company accountants estimate that dropping industrial systems will decrease fixed cost of goods sold by $80,000 and decrease fixed selling and administrative expenses by $10,000. Read the requirements. Requirement 1. Prepare a differential analysis to show whether Safety Place should drop the industrial systems product line. (Use parentheses or a minus sign to enter decreases to profits.) in operating incomearrow_forwardA firm manufactures and sells high quality business printers and ink toners. Each printer sells for $650 and each toner for $100. The average user keeps the printer for 5 years and consumes 4 toners every year. In response to a recent significant drop in printer sales (which will reduce future toner sales as well) the firm wants to lower the printer price to $500. Assume that income from toner sales occurs at year-end and the firm’s cost of capital is 10%. How much of an increase is needed in the toner price to cover the loss in printer price?arrow_forward
- Buckley Enterprise sells a product that cost $450 per unit and has a monthly demand of 5,000 units. The annual holding cost per unit is calculated as 5% of the unit purchase price. It costs the business $75 to place a single order. Currently the business places 12 orders each year. What is the total stock administrative cost of Buckley’s current inventory policy? Is this the entity’s cost minimizing solution for this product each year? Explain.arrow_forwardGarrett Industries turns over its inventory six times each year; it has an average collection period of 35 days and an average payment period of 30 days. The firm’s annual sales are $ 5 million, costs of goods sold $ 1 million while other operating costs excluding depreciation $ 2 million. Based on the data find the firm’s cash conversion cycle and resource investment requirement if it makes the following changes simultaneously: (1) Shortens the average age of inventory by 5 days. (2) Speeds the collection of accounts receivable by an average of 10 days. (3) Extends the average payment period by 10 days. If the firm pays 13% WACC, by how much, if anything, could it reduce annual costs of working capital financing?arrow_forwardThe monthly demand of DEF’s sole product is 30,000 cases. Based on data analysis, the carrying cost per case is P30 per year. For each order, ABC spends an average of P200 in worker’s wages, P700 in freight and P550 in other expenses. If ABC would like follow the EOQ model but also maintain a safety stock of 10,000 cases, how much would the total annual inventory-related costs be?arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT