McKnightA_W5_TDA_Sales_Budget_Exercise(1)

McKnightA_W5_TDA_Sales_Budget_Exercise(1) - $4,860,000...

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

View Full Document Right Arrow Icon
Easy Does It, Inc. Sales Budget For the Year Ended December 31, 2011 Q1 2011 Q2 2011 Q3 2011 Q4 2011 Total A100 unit sales 48,000 57,600 64,800 43,200 213,600 Sale price @ unit $50.00 $50.00 $50.00 $50.00 $50.00 A100 sales $ $2,400,000 $2,880,000 $3,240,000 $2,160,000 $10,680,000 B400 Unit sales 60,000 69,000 78,000 51,000 258,000 Sale price @ unit $100.00 $100.00 $100.00 $100.00 $100.00 B400 sales $ $6,000,000 $6,900,000 $7,800,000 $5,100,000 $25,800,000 C500 Unit sales 24,000 36,000 32,400 21,600 114,000 Sale price @ unit $150.00 $150.00 $150.00 $150.00 $150.00 C500 sales $ $3,600,000 $5,400,000
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $4,860,000 $3,240,000 $17,100,000 Total sales $ $12,000,000 $15,180,000 $15,900,000 $10,500,000 $53,580,000 Schedule of Expected Cash Collections Percentage of sales collected in the period of sale 75% Percentage of sales collected in the period after the sale 25% AR, beg bal $2,500,000 $2,500,000 Q1 Sales 9,000,000 3,000,000 12,000,000 Q2 Sales 11,385,000 3,795,000 15,180,000 Q3 Sales 11,925,000 3,975,000 15,900,000 Q4 Sales 7,875,000 7,875,000 Total Collections $11,500,000 $14,385,000 $15,720,000 $11,850,000 $53,455,000...
View Full Document

This note was uploaded on 02/05/2012 for the course ACCT 305 taught by Professor Charlie during the Spring '11 term at University of Phoenix.

Ask a homework question - tutors are online