Atlas Manufacturing had an average days-of-sales- outstanding (DSO) period of 22 days in 2023. Management expects that Atlas's DSO will decrease in 2024 to match the industry average of 17 days due to new collection software implementation. Total sales (all on credit) in 2023 were $450 million, and Atlas projects total sales (all on credit) to increase to $480 million in 2024. To achieve the lower DSO, the change in the average accounts receivable balance from 2023 to 2024 that must occur is closest to: A. $2.89 million B. -$2.89 million C. -$4.12 million D. $4.12 million

Atlas Manufacturing had an average days-of-sales- outstanding (DSO) period of 22 days in 2023. Management expects that Atlas's DSO will decrease in 2024 to match the industry average of 17 days due to new collection software implementation. Total sales (all on credit) in 2023 were $450 million, and Atlas projects total sales (all on credit) to increase to $480 million in 2024. To achieve the lower DSO, the change in the average accounts receivable balance from 2023 to 2024 that must occur is closest to: A. $2.89 million B. -$2.89 million C. -$4.12 million D. $4.12 million

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter18: Cost-volume-profit Analysis (cvp)

Section: Chapter Questions

Problem 1R: Poleski Manufacturing, which maintains the same level of inventory at the end of each year, provided...

See similar textbooks

Similar questions

Ingraham Inc. currently has $205,000 in accountsreceivable, and its days sales outstanding (DSO) is 71 days. It wants to reduce its DSOto 20 days by pressuring more of its customers to pay their bills on time. If this policy is adopted, the company’s average sales will fall by 15%. What will be the level of accountsreceivable following the change? Assume a 365-day year.
The Frozen North Construction Company would like to forecast its minimum volume of work (turnover) in order to “break even” (i.e., cover its corporate overheads) for the coming year. The company’s previous year’s corporate overheads were $900,000. The company anticipates 22% inflation and 6% growth in the firm for the coming year. It also expects to achieve a gross margin of 13% on its projects, based on old experience. The company defines gross margin as a percentage of revenue (i.e., selling price). Determine the minimum volume of work, which will allow the Frozen North Company to break even at the end of the coming year.
Brown Corporation had average days of sales outstanding of 19 days in the most recent fi scal year. Brown wants to improve its credit policies and collection practices and decrease its collection period in the next fi scal year to match the industry average of 15 days. Credit sales in the most recent fi scal year were $300 million, and Brown expects credit sales to increase to $390 million in the next fi scal year. To achieve Brown’s goal of decreasing the collection period, the change in the average accounts receivable balance that must occur is closest to: C . –$1.22 million.
Can you please provide correct answer the general accounting question?
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 Poleskis single product is 16. In recent years, profits have fallen and Poleskis 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 companys projected net income (assuming 120,000 units are sold) and the sales needed to achieve the companys net income objective for next year. Also, compute Poleskis 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.
ABB Company reported the results from sales of 5,000 units of Product Y for April 2022. See image.Assume that ABB plans to increase the selling price of Product Y by 10% in June 2022. How many units of the product would have to be sold to maintain an operating income of P20,000? Assume that ABB plans to increase the selling price of Product Y by 10% in June 2022. How many units of the product would have to be sold to earn a net income of P48,000? ABB is subject to 25% corporate income tax.
Bulawan Coin, Inc. is considering shortening its credit period from 30 days to 20 days and believes, as a result of this change, its average collection period will decrease from 36 days to 30 days. Bad debt expenses are also expected to decrease from 1.2 percent to 0.8 percent of sales. The firm is currently selling 300,000 units but believes as a result of the change, sales will decline to 275,000 units. On 300,000 units, sales revenue is $4,200,000, variable costs total $3,300,000, and fixed costs are $300,000. The firm has a required return on similar-risk investments of 15 percent. Required: (PLEASE ANSWER 5-9 ONLY) 5. How much was the marginal profit contribution? 6. How much was the cost of the marginal investment in accounts receivable? 7. How much was the cost of the marginal bad debts? 8. How much was the cost of marginal cash discounts? 9. Will you recommend the proposal or not? Please justify. For reference:…
9. An entity's accounting year ends on December 31, and it is currently preparing interim financial statements for the half year to June 30, 2010. The price of its product tends to vary. At June 30, 2010, it has inventories of 100,000 units, at a cost per unit of PI4. The net realizable at June 30, 2010 is P12 per unit. The expected net realizable value of these inventories at December 31, 2010 is P15.50 per unit. At what amount should these inventories be presented in the interim statement of financial position at June 30, 2010? a. P1,200,000 b. P1,375,000 c. P1,400,000 d. P1,550,000
Assume Will & Partners LLP has the following information on the number of sales orders received and order - processing costs for the latter half of 2022: Use the high -low method to estimate the order -processing costs if Will & Partners receives 3,500 sales orders in December (assume none of the above values are outliers) $36,000 $ 44,600 $38,400 $ 37,333 $42,000
Violet Sales Corp, reports the year-end information from 2023 as follows: Sales (35,500 units) $284,000 Cost of goods sold 105,000 Gross margin 179,000 Operating expenses 152,000 Operating income $27,000 Violet is developing the 2024 budget. In 2024 the company would like to increase selling prices by 3.5%, and as a result expects a decrease in sales volume of 14%. All other operating expenses are expected to remain constant. Assume that cost of goods sold is a variable cost and that operating expenses are a fixed cost. What is budgeted sales for 2024?
MBI Incorporated had sales of $35 million for fiscal 2022. The company's gross profit ratio for that year was 26%. Required: a. Calculate the gross profit and cost of goods sold for MBI for fiscal 2022. b. Assume that a new product is developed and that it will cost $469 to manufacture. Calculate the selling price that must be set for this new product if its gross profit ratio is to be the same as the average achieved for all products for fiscal 2022. c. From a management viewpoint, it could use the estimated selling price as a "target" in conducting marketing research studies to assess its ultimate prospects for success at this price. Complete this question by entering your answers in the tabs below. Required A Required B Required C From a management viewpoint, it could use the estimated selling price as a "target" in conducting marketing research studies to assess its ultimate prospects for success at this price.
A company is launching a new sales initiative and expects sales of $446,838 during the first year, and the gross profit margin to be 25%. To prepare for this, they plan to acquire 49 days worth of inventory. Their vendor will allow 48 days to pay its invoices. The company plans to sell only on account to its customers, so sales will be entirely credit based, and the average invoice is expected to take 44 days to collect. What amount of net working capital should be included in the initial investment? Enter your answer as a monetary amount rounded to four decimal places, but without the currency symbol. For example, if your answer is $90.1234, enter 90.1234 Type your answer...