Glorious Nature Company, a local business with twenty branches in the country has been affected by numerous emerging competitors and is considering shutting down the business for good if the cash flow for the next two months are not showing good prospects. The CEO is asking for a cash budget for May and June 2023 to assist the company's management to consider whether to shut down the business for good. Past records reveal that 20% of all credit sales are collected during the month of sale, 60% in the month following the sale, 10% in the second month following the sale and 10% in the third month following the sale. The company pays for 75% of purchases in the month after purchase, and the balance is paid in the month following that.
Glorious Nature Company, a local business with twenty branches in the country has been affected by numerous emerging competitors and is considering shutting down the business for good if the cash flow for the next two months are not showing good prospects. The CEO is asking for a cash budget for May and June 2023 to assist the company's management to consider whether to shut down the business for good. Past records reveal that 20% of all credit sales are collected during the month of sale, 60% in the month following the sale, 10% in the second month following the sale and 10% in the third month following the sale. The company pays for 75% of purchases in the month after purchase, and the balance is paid in the month following that.
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter6: Statistical Inference
Section: Chapter Questions
Problem 24P: The manager of an automobile dealership is considering a new bonus plan designed to increase sales...
Related questions
Question
5
![QUESTION 1-Compulsory
Glorious Nature Company, a local business with twenty branches in the country has been affected
by numerous emerging competitors and is considering shutting down the business for good if the
cash flow for the next two months are not showing good prospects.
The CEO is asking for a cash budget for May and June 2023 to assist the company's management
to consider whether to shut down the business for good. Past records reveal that 20% of all credit
sales are collected during the month of sale, 60% in the month following the sale, 10% in the
second month following the sale and 10% in the third month following the sale.
The company pays for 75% of purchases in the month after purchase, and the balance is paid in
the month following that.
Selling expenses amount to $6,600 per month plus 15% of monthly sales. Administrative expenses
are estimated to be at $13,100 per month, which includes $3,800 of depreciation expense. Finance
expenses are $1,750 per month. All selling and distribution, administrative, and finance and other
expenses are paid for when incurred.
The company is also planning to carry out its first retrenchment exercise during May 2023 at a
cost of $20,600. A second phase of retrenchment which will cost the company $39,000 will be
paid during June 2023. The interest due for bank loans is $1,650 and paid at the end of every
quarter of the year. The company's expected Cash at Bank balance on 1 May 2023 is $9,200.
Details of Sales and Purchases as follows:
Sales
$75,000
$66,000
$88,000
$60,500
$71,500
February 2023
March 2023
April 2023
May 2023
June 2023
Purchases
$38,500
$33,000
$55,000
$27,500
$38,500](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F24590319-d663-4005-b15a-e6246547767f%2Fa9720cf6-0e70-4b0c-89b2-c40ae7a90fe4%2Ffq47wta_processed.jpeg&w=3840&q=75)
Transcribed Image Text:QUESTION 1-Compulsory
Glorious Nature Company, a local business with twenty branches in the country has been affected
by numerous emerging competitors and is considering shutting down the business for good if the
cash flow for the next two months are not showing good prospects.
The CEO is asking for a cash budget for May and June 2023 to assist the company's management
to consider whether to shut down the business for good. Past records reveal that 20% of all credit
sales are collected during the month of sale, 60% in the month following the sale, 10% in the
second month following the sale and 10% in the third month following the sale.
The company pays for 75% of purchases in the month after purchase, and the balance is paid in
the month following that.
Selling expenses amount to $6,600 per month plus 15% of monthly sales. Administrative expenses
are estimated to be at $13,100 per month, which includes $3,800 of depreciation expense. Finance
expenses are $1,750 per month. All selling and distribution, administrative, and finance and other
expenses are paid for when incurred.
The company is also planning to carry out its first retrenchment exercise during May 2023 at a
cost of $20,600. A second phase of retrenchment which will cost the company $39,000 will be
paid during June 2023. The interest due for bank loans is $1,650 and paid at the end of every
quarter of the year. The company's expected Cash at Bank balance on 1 May 2023 is $9,200.
Details of Sales and Purchases as follows:
Sales
$75,000
$66,000
$88,000
$60,500
$71,500
February 2023
March 2023
April 2023
May 2023
June 2023
Purchases
$38,500
$33,000
$55,000
$27,500
$38,500
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Essentials of Business Analytics (MindTap Course …](https://www.bartleby.com/isbn_cover_images/9781305627734/9781305627734_smallCoverImage.gif)
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Essentials of Business Analytics (MindTap Course …](https://www.bartleby.com/isbn_cover_images/9781305627734/9781305627734_smallCoverImage.gif)
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Financial Accounting: The Impact on Decision Make…](https://www.bartleby.com/isbn_cover_images/9781305654174/9781305654174_smallCoverImage.gif)
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
![EBK CFIN](https://www.bartleby.com/isbn_cover_images/9781337671743/9781337671743_smallCoverImage.jpg)
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT