Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

II . SpongeBob Retail seeks your assistance to develop cash and other budget information for May, June, and July. The budget is to be based

II. SpongeBob Retail seeks your assistance to develop cash and other budget information for May, June, and July. The budget is to be based on the following:
Sales
a. Each month's sales are billed on the last day of the month.
b. Customers are allowed a 3% discount if payment is made within ten days after the billing date. Receivables are booked at gross.
c. Sixty percent of the billings are collected within the discount period, 25% are collected by the end of the month, 9% are collected by the end of the second month, and 6% prove to be uncollectible.
Purchases
a. Fifty-four percent of all purchases of merchandise as well as marketing and administrative expenses are paid in the month purchased and the remainder in the following month.
b. Each month's ending inventory (in units) is equal to 130% of the next month's units of sales.
c. The cost of each unit of merchandise inventory is $20.
d. Total marketing and administrative expenses are equal to 15% of the current month's sales and include $2,000 of depreciation.
Actual and projected sales are as follows:
\table[[Month,Dollars,Units],[March,$354,000,11,800],[April,363,000,12,100],[May,357,000,11,900],[June,342,000,11,400],[July,360,000,12,000],[August,366,000,1]]
Required:
Compute the budgeted cash collections for May, June, and July.
Compute the budgeted number of units of inventory to be purchased during May, June, and July.
Compute the budgeted cash disbursements for May, June, and July.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing

Authors: Thomas D. Hubbard, J. R. Johnson, Steve Johnson, Joel D. Hubbard

6th Edition

0873932609, 9780873932608

More Books

Students also viewed these Accounting questions