d. Mr. Suncat is concerned about cash flow and has requested that you prepare a Cash Collections Schedule, a Cash Payments Schedule, and a Cash Budget for the first two months of the year using the following information: ● ● ● ● ● Cash collections for Suncat Cake Shop are 60% of sales in the month of sale, 30% collected in the month after the sale, and 10% collected in the second month after the sale. Suncat Cake Shop pays 65% of its purchases of direct materials in the month of sale, and 35% in the month after the purchase. Cake Sales Purchases November $150,000 $10,000 December $145,600 $10,600 January $160,000 $11,400 February $176,000 $12,500 Beginning cash balance was $20,000 and Mr. Suncat's required minimum balance for the Suncat Cake Shop is $15,000. Mr. Suncat estimates direct labor and manufacturing overhead to be $84,000 for January and $92,400 for February. Mr. Suncat would like to include in the Cash Budget in January, the purchase of a new industrial oven at a cost of $75,000.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![zannaperez - Last saved by user Y
Layout
12 → A A Aa
X A.
X
Font
References
ited States)
Mailings
Cake Sales
Purchases
Review View
13
脚
E - 2 -
==
Paragraph
Cach Collections
Text Predictions: On
Q Search
€0
Help
3 E
Required Production
d. Mr. Suncat is concerned about cash flow and has requested that you prepare a Cash Collections
Schedule, a Cash Payments Schedule, and a Cash Budget for the first two months of the year using the
following information:
F5
Sales
Accessibility: Good to go
November
$150,000
$10,000
Table Design Layout
Cash collections for Suncat Cake Shop are 60% of sales in the month of sale, 30% collected in the
month after the sale, and 10% collected in the second month after the sale.
Suncat Cake Shop pays 65% of its purchases of direct materials in the month of sale, and 35% in
the month after the purchase.
9
Normal
204
1511
AV
Beginning cash balance was $20,000 and Mr. Suncat's required minimum balance for the Suncat
Cake Shop is $15,000.
Mr. Suncat estimates direct labor and manufacturing overhead to be $84,000 for January and
$92,400 for February.
December
$145,600
$10,600
Mr. Suncat would like to include in the Cash Budget in January, the purchase of a new industrial
oven at a cost of $75,000.
•
No Spacing
Suncat Cake Shop
Cash Collections Schedule
For the Quarter Ended March 31, 2021
224
February
Styles
DELL
8
January
$160,000
$11,400
F8
Heading 1
247
Pho
*
March
February
$176,000
$12,500
171
@
prt sc
F10
Tatal
home
Editing
As
Focus
H
end](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2a49c474-9fcd-4b01-b47e-ebd73a584aa7%2F6c625a6d-de16-45aa-abf5-4c1793fedbe7%2Fenedf2_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)