Scribd
Upload
74 views3 pages

Sales and Cash Flow Projections Analysis

The document contains sales projections and production requirements for 4 quarters. It shows estimated unit sales, projected sales revenue, beginning and ending finished goods inventory, units to be produced and sold each quarter. It also shows the units required for production, desired ending raw materials inventory, total units required and units to be purchased each quarter. The second problem provides collections, cash balances and disbursements for 3 months. It shows sales amounts by month, total collections, cash balances at the beginning and end of each month after accounting for receipts and payments.

Uploaded by

Venus Palmenco
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
74 views3 pages

Sales and Cash Flow Projections Analysis

The document contains sales projections and production requirements for 4 quarters. It shows estimated unit sales, projected sales revenue, beginning and ending finished goods inventory, units to be produced and sold each quarter. It also shows the units required for production, desired ending raw materials inventory, total units required and units to be purchased each quarter. The second problem provides collections, cash balances and disbursements for 3 months. It shows sales amounts by month, total collections, cash balances at the beginning and end of each month after accounting for receipts and payments.

Uploaded by

Venus Palmenco
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

PROBLEM 4

Requirement 1
1st 2nd 3rd 4th
Estimated sales in units 16000 20000 22000 22000
Unit Price 30.00 30.00 30.00 30.00
Projected Sales in Units 480,000.00 600,000.00 660,000.00 660,000.00

Requirement 2
1st 2nd 3rd 4th
Beginning Finished Goods 3000 4000 4400 4400
Add: Units to be produced 17000 20400 22000 22600
Total Units Avail for Sale 20000 24400 26400 27000
Less: Desired Ending FG Invty 4000 4400 4400 5000
Units to be Sold 16000 20000 22000 22000

Requirement 3
1st 2nd 3rd 4th
Units required for Production 51000 61200 66000 67800
Add: Desired Ending RM Invty 12240 13200 13560 15000
Total Units Required 63240 74400 79560 82800
Less: Beginning Invty RM 12500 12240 13200 13560
Units to be Purchased 50740 62160 66360 69240

PROBLEM 5
Requirement 1
COLLECTIONS: APRIL MAY JUNE
Sales in Prior Months 141,000.00 7,200.00 -
April Sales 40,000.00 150,000.00 8,000.00
May Sales - 60,000.00 225,000.00
June Sales - - 50,000.00
Total Collections 181,000.00 217,200.00 283,000.00

Requirement 2 APRIL MAY JUNE


Cash beginning 26,000.00 27,000.00 20,200.00
Add: Receipts
Collections 181,000.00 217,200.00 283,000.00
Proceeds from Loan 30,000.00 - -
Total Cash Available 237,000.00 244,200.00 303,200.00
Less: Disbursements
Payment for Merchandise 108,000.00 120,000.00 180,000.00
Payment for Payroll 9,000.00 9,000.00 8,000.00
Payment for Lease 15,000.00 15,000.00 15,000.00
Payment for Advertising 70,000.00 80,000.00 60,000.00
Payment for Acquired Eqpt 8,000.00 - -
Payment for Loan - -
Payment for Interest
210,000.00 224,000.00 263,000.00
Net Cash, Ending 27,000.00 20,200.00 40,200.00

Requirement 3
Total
80000
30.00
2,400,000.00

Total
3000
82000
85000
5000
80000

Total
246000
15000
261000
12500
248500

You might also like