The management team of Magnificent Modems, Incorporated (MMI) wants to investigate the effect of several different growth rates on sales and cash receipts. Cash sales for the month of January are expected to be $10,000. Credit sales for January are expected to be $50,000. MMI collects 100 percent of credit sales in the month following the month of sale. Assume a beginning balance in accounts receivable of $48,000. Required Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2 percent and 4 percent. The results at a growth rate of 1 percent are shown as an example. Cash sales Sales on account Total budgeted sales 2 percent 4 Percent Sales Budget January $ 210,000 50,000 $ 60,000 Cash sales Sales on account Total budgeted sales Current cash sales. Plus collections from accounts receivable Total budgeted collections. Use the following forms, assuming a growth rate of 2 percent and 4 percent: Schedule of Cash Receipts Complete this question by entering your answers in the tabs below. Current cash sales Plus collections from accounts receivable Total budgeted collections January $ Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2 percent. Sales Budget $ Schedule of Cash Receipts $ February $ 10,100 50,500 $ 60,600 10,000 50,000 60,000 January $ < 2 percent January $ 10,000 48,000 $ 58,000 10,000 48,000 58,000 March $ 10,201 51,005 $ 61,206 Growth rate of 2% February March Growth rate of 2% March February 50,000 February $ 10,100 50,000 $ 60,100 4 Percent > March $ 10,201 50,500 $ 60,701
The management team of Magnificent Modems, Incorporated (MMI) wants to investigate the effect of several different growth rates on sales and cash receipts. Cash sales for the month of January are expected to be $10,000. Credit sales for January are expected to be $50,000. MMI collects 100 percent of credit sales in the month following the month of sale. Assume a beginning balance in accounts receivable of $48,000. Required Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2 percent and 4 percent. The results at a growth rate of 1 percent are shown as an example. Cash sales Sales on account Total budgeted sales 2 percent 4 Percent Sales Budget January $ 210,000 50,000 $ 60,000 Cash sales Sales on account Total budgeted sales Current cash sales. Plus collections from accounts receivable Total budgeted collections. Use the following forms, assuming a growth rate of 2 percent and 4 percent: Schedule of Cash Receipts Complete this question by entering your answers in the tabs below. Current cash sales Plus collections from accounts receivable Total budgeted collections January $ Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2 percent. Sales Budget $ Schedule of Cash Receipts $ February $ 10,100 50,500 $ 60,600 10,000 50,000 60,000 January $ < 2 percent January $ 10,000 48,000 $ 58,000 10,000 48,000 58,000 March $ 10,201 51,005 $ 61,206 Growth rate of 2% February March Growth rate of 2% March February 50,000 February $ 10,100 50,000 $ 60,100 4 Percent > March $ 10,201 50,500 $ 60,701
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please do not give solution in image format thanku
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
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.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education