Project A Excel Template - PROJECT A - Case 9-30 Student...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
PROJECT A - Case 9-30 Student Name: Michele Baker SALES BUDGET: April May June Quarter Budgeted unit sales 65,000 100,000 50,000 215,000 Sales in Units Selling price per unit 10 10 10 10 x price per unit Total Sales 650,000 1,000,000 500,000 2,150,000 Total Sales SCHEDULE OF EXPECTED CASH COLLECTIONS: April May June Quarter February sales 26,000 26,000 Current month's sales x 20% March sales 28,000 4,000 32,000 (+) previous mont's sales x 70% April sales 130,000 455,000 65,000 650,000 (+) two month's ago sales x 10% May sales 20,000 70,000 90,000 Total Cash Collection for current month June sales 10,000 10,000 ** do this for each month Total Cash Collections 184,000 479,000 145,000 808,000 MERCHANDISE PURCHASES BUDGET: April May June Quarter Budgeted unit sales 65,000 100,000 50,000 215,000 Add desired ending inventory 40,000 20,000 12,000 72,000 40% of next month's sales Total needs 105,000 120,000 62,000 287,000 add desired end inv. And budgeted unit sales Less beginning inventory 16,000 40,000 20,000 76,000 subtract begin inv.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online