Sherman Company provides services in the retail flooring industry. The following information is available for 20x5: · Twenty percent of the firm’s services are for cash and the remaining 80% are on account. Of the credit services, 40% are collected in the month that the service is provided, with the remaining 60% collected in the following month. · Services provided in January are expected to total $250,000 and grow at the rate of 5% per month thereafter. · January’s cash collections are expected to be $240,400, and month-end receivables are forecast at $120,000. · Monthly cash operating costs and depreciation during the first quarter of the year are approximated at $250,000 and $15,000, respectively. · Sherman’s December 31, 20x4 balance sheet revealed accounts payable balances of $28,000. This amount is related to the company’s operating costs and is expected to grow to $36,000 by the end of 20x5’s first quarter. All operating costs are paid within 30 days of incurrence. · Company policy requires that a $20,000 minimum cash balance be maintained, and Sherman’s 20x4 year-end balance sheet showed that the firm was in compliance with policy by having cash of $23,000. Required: A. Determine the sales revenue earned that will appear on the income statement for the quarter ended March 31, 20x5. B. Compute the company’s first-quarter cash collections. C. Compute the cash balance that would appear on the March 31, 20x5 balance sheet. D. What are some possible actions the company could pursue if, at any time during the quarter, it finds that the cash balance has fallen below the stated minimum.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 11CE: Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted...

See similar textbooks

Related questions

Question

Sherman Company provides services in the retail flooring industry. The following information is available for 20x5: · Twenty percent of the firm’s services are for cash and the remaining 80% are on account. Of the credit services, 40% are collected in the month that the service is provided, with the remaining 60% collected in the following month. · Services provided in January are expected to total $250,000 and grow at the rate of 5% per month thereafter. · January’s cash collections are expected to be $240,400, and month-end receivables are forecast at $120,000. · Monthly cash operating costs and depreciation during the first quarter of the year are approximated at $250,000 and $15,000, respectively. · Sherman’s December 31, 20x4 balance sheet revealed accounts payable balances of $28,000. This amount is related to the company’s operating costs and is expected to grow to $36,000 by the end of 20x5’s first quarter. All operating costs are paid within 30 days of incurrence. · Company policy requires that a $20,000 minimum cash balance be maintained, and Sherman’s 20x4 year-end balance sheet showed that the firm was in compliance with policy by having cash of $23,000. Required: A. Determine the sales revenue earned that will appear on the income statement for the quarter ended March 31, 20x5. B. Compute the company’s first-quarter cash collections. C. Compute the cash balance that would appear on the March 31, 20x5 balance sheet. D. What are some possible actions the company could pursue if, at any time during the quarter, it finds that the cash balance has fallen below the stated minimum.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions