Cash budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 20% of its merchandise for cash. Of sales on account, 75% are expected to be; collected in full in the month following the sale and the remainder the following month. Depreciation, insurance, and property tax expense represent $40,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in June, and the annual property taxes are paid in October. Of the remainder of the manufacturing costs, 90% axe expected to be paid in the month in which they are incurred and the balance in the following month. All sales and administrative expenses are paid in the month incurred. Current assets as of January 1 include cash of $45,000, marketable securities of $65,000, and accounts receivable of $290,000 ($240,000 from December sales and $50,000 from Novembersales). Sales on account in November and December were $200,000 and $240,000, respectively. Current liabilities as of January 1 include a $50,000, 8%, 90-day note payable due March 20 and $18,000 of accounts payable incurred in December for manufacturing costs. All selling and administrative expenses are paid in cash in the period the)' are incurred. It is expected that $20,000 in dividends will be received in January. An estimated income tax payment of $15,000 will be made in February. Shoe Mart's regular quarterly dividend of $5,000 is expected to be declared in February and paid in March. Management desires to maintain a minimum cash balance of $35,000. Instructions On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

BuyFind

Survey of Accounting (Accounting I)

8th Edition
Carl Warren
Publisher: Cengage Learning
ISBN: 9781305961883
BuyFind

Survey of Accounting (Accounting I)

8th Edition
Carl Warren
Publisher: Cengage Learning
ISBN: 9781305961883

Solutions

Chapter
Section
Chapter 13, Problem 13.3.2P
Textbook Problem

Cash budget
The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

Chapter 13, Problem 13.3.2P, Cash budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next

The company expects to sell about 20% of its merchandise for cash. Of sales on account, 75% are expected to be; collected in full in the month following the sale and the remainder the following month. Depreciation, insurance, and property tax expense represent $40,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in June, and the annual property taxes are paid in October. Of the remainder of the manufacturing costs, 90% axe expected to be paid in the month in which they are incurred and the balance in the following month. All sales and administrative expenses are paid in the month incurred. Current assets as of January 1 include cash of $45,000, marketable securities of $65,000, and accounts receivable of $290,000 ($240,000 from December sales and $50,000 from Novembersales). Sales on account in November and December were $200,000 and $240,000, respectively. Current liabilities as of January 1 include a $50,000, 8%, 90-day note payable due March 20 and $18,000 of accounts payable incurred in December for manufacturing costs. All selling and administrative expenses are paid in cash in the period the)' are incurred. It is expected that $20,000 in dividends will be received in January. An estimated income tax payment of $15,000 will be made in February. Shoe Mart's regular quarterly dividend of $5,000 is expected to be declared in February and paid in March. Management desires to maintain a minimum cash balance of $35,000.

Instructions

On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

Expert Solution

Want to see the full answer?

Check out a sample textbook solution.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Chapter 13 Solutions

Survey of Accounting (Accounting I)
Ch. 13 - That behavioral problems are associated with...Ch. 13 - When would a company use zero-based budgeting?Ch. 13 - Under what circumstances would a static budget be...Ch. 13 - How do computerized budgeting systems aid firms in...Ch. 13 - What is the first step in preparing a master...Ch. 13 - Why should the production requirements set forth...Ch. 13 - Why should the timing of direct materials...Ch. 13 - In preparing the budget for the Cost of goods...Ch. 13 - a. Discuss the purpose of the cash budget. b. If...Ch. 13 - How does a schedule of collections from sales...Ch. 13 - Give an example of how the capital expenditures...Ch. 13 - What arc the basic objectives in the use of...Ch. 13 - How can standards be used by management to help...Ch. 13 - What is meant by reporting by the "principle of...Ch. 13 - How often should standards be revised?Ch. 13 - How are standards used in budgetary performance...Ch. 13 - a. What are the two variances between the actual...Ch. 13 - The materials cost variance report for Nickols...Ch. 13 - a. What are the two variances between the actual...Ch. 13 - A new assistant controller recently said: "All the...Ch. 13 - Would the use of standards be appropriate in a...Ch. 13 - Flexible budget for selling and administrative...Ch. 13 - Static budget vs. flexible budget The production...Ch. 13 - Flexible budget for Fabrication Department...Ch. 13 - Sales and production budgets Ultimate Audio...Ch. 13 - Professional fees earned budget Day & Spieth,...Ch. 13 - Professional labor cost budget Based on the data...Ch. 13 - Direct materials purchases budget Zippy's Frozen...Ch. 13 - Direct materials purchases budget Coca-Cola...Ch. 13 - Direct labor cost budget Donner Racket Company...Ch. 13 - Production and direct labor cost budgets Levi...Ch. 13 - Factory overhead cost budget Nutty Candy Company...Ch. 13 - Cost of goods sold budget The controller of Pueblo...Ch. 13 - Schedule of cash collections of accounts...Ch. 13 - Schedule of cash collections of accounts...Ch. 13 - Schedule of cash payments Tadpole Learning Systems...Ch. 13 - Schedule of cash payments Organic Physical Therapy...Ch. 13 - Capital expenditures budget On August 1, 20Y4. the...Ch. 13 - Standard product cost Sorrento Furniture Company...Ch. 13 - Budget performance report McAIisters Bottle...Ch. 13 - Direct materials variances The following data...Ch. 13 - Standard direct materials cost per unit from...Ch. 13 - Standard product cost, direct materials variance...Ch. 13 - Direct labor variances The following data relate...Ch. 13 - Direct labor variances Death Valley Bicycle...Ch. 13 - Direct materials and direct labor variances At the...Ch. 13 - Direct labor standards for nonmanufacturing...Ch. 13 - Factory overhead cost variances The following data...Ch. 13 - Factory overhead cost variances Osceola Textiles...Ch. 13 - Factory overhead variance corrections The data...Ch. 13 - Factory overhead cost variance report Topeka...Ch. 13 - Sales, production, direct materials purchases, and...Ch. 13 - Sales, production, direct materials purchases, and...Ch. 13 - Sales, production, direct materials purchases, and...Ch. 13 - Sales, production, direct materials purchases, and...Ch. 13 - Budgeted income statement and supporting budgets...Ch. 13 - Budgeted income statement and supporting budgets...Ch. 13 - Budgeted income statement and supporting budgets...Ch. 13 - Budgeted income statement and supporting budgets...Ch. 13 - Budgeted income statement and supporting budgets...Ch. 13 - Budgeted income statement and supporting budgets...Ch. 13 - Budgeted income statement and supporting budgets...Ch. 13 - Budgeted income statement and supporting budgets...Ch. 13 - Cash budget The controller of Shoe Mart Inc. asks...Ch. 13 - Cash budget The controller of Shoe Mart Inc. asks...Ch. 13 - Direct materials and direct labor variance...Ch. 13 - Direct materials and direct labor, variance...Ch. 13 - Standards for nonmanufacturing expenses The...Ch. 13 - Standards for nonmanufacturing expenses The...Ch. 13 - Standards for nonmanufacturing expenses The...Ch. 13 - Standards for nonmanufacturing expenses The...Ch. 13 - Standards for nonmanufacturing expenses The...Ch. 13 - Standards for nonmanufacturing expenses The...Ch. 13 - Standard factory overhead variance report Seabury....Ch. 13 - Process yield Perez Inc. manufactures various...Ch. 13 - Process yield Perez Inc. manufactures various...Ch. 13 - Process yield Perez Inc. manufactures various...Ch. 13 - Process yield Perez Inc. manufactures various...Ch. 13 - Process yield Perez Inc. manufactures various...Ch. 13 - Process yield Perez Inc. manufactures various...Ch. 13 - Process yield Hendrick Motorsports sponsors cars...Ch. 13 - Process yield Hendrick Motorsports sponsors cars...Ch. 13 - Process yield Hendrick Motorsports sponsors cars...Ch. 13 - Process yield Hendrick Motorsports sponsors cars...Ch. 13 - Process yield Hendrick Motorsports sponsors cars...Ch. 13 - Utilization rate Hilton Worldwide Holdings Inc....Ch. 13 - Utilization rate Hilton Worldwide Holdings Inc....Ch. 13 - Utilization rate Hilton Worldwide Holdings Inc....Ch. 13 - Utilization rate Hilton Worldwide Holdings Inc....Ch. 13 - Utilization rate Stop-X-Stay and Paradise Inn...Ch. 13 - Utilization rate Stop-X-Stay and Paradise Inn...Ch. 13 - Utilization rate Stop-X-Stay and Paradise Inn...Ch. 13 - Utilization rate Stop-X-Stay and Paradise Inn...Ch. 13 - Utilization rate The East Memorial Hospital...Ch. 13 - Utilization rate The East Memorial Hospital...Ch. 13 - Utilization rate The East Memorial Hospital...Ch. 13 - Utilization rate The East Memorial Hospital...Ch. 13 - Utilization rate Delta Air Lines (DAL) reported...Ch. 13 - Utilization rate Delta Air Lines (DAL) reported...Ch. 13 - Utilization rate Delta Air Lines (DAL) reported...Ch. 13 - Utilization rate Southwest Airlines Co. (LUV)...Ch. 13 - Utilization rate Southwest Airlines Co. (LUV)...Ch. 13 - Utilization rate Southwest Airlines Co. (LUV)...Ch. 13 - Ethics and professional conduct in business The...Ch. 13 - Evaluating budgeting systems Children's Hospital...Ch. 13 - Evaluating budgeting systems Children's Hospital...Ch. 13 - Service company static decision making A bank...Ch. 13 - Service company static decision making A bank...Ch. 13 - Objectives of the master budget Domino's Pizza LLC...Ch. 13 - Integrity and evaluating budgeting systems The...Ch. 13 - Integrity and evaluating budgeting systems The...Ch. 13 - Ethics and professional conduct in business using...Ch. 13 - Variance interpretation Harmony Industries Inc. is...

Additional Business Textbook Solutions

Find more solutions based on key concepts
In what ways is economics a science?

Principles of Microeconomics (MindTap Course List)

Looking at the statement of cash flows, what factors can explain the charge in the company's cash position over...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

What is the role of accounting in business?

Corporate Financial Accounting