budget prob - $4,670.00 $11,670.00 Selling $25,000.00...

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

View Full Document Right Arrow Icon
Sales Budget Cash Budget 1st quarter 2nd quarter 3rd quarter 1st quarter 2nd quarter 3rd quarter Sales $140,000.00 $280,000.00 $325,000.00 Receivables $105,000.00 $243,600.00 q1 q2 COGS $84,000.00 $168,000.00 $195,000.00 COGS merch. $111,000.00 $177,000.00 Op. Inv. 29000 56000 Gross profit $56,000.00 $112,000.00 $130,000.00 Payments $66,600.00 $137,400.00 Purchase $111,000.00 $177,000.00 Consumed $84,000.00 $168,000.00 Fixed Expenses Variable Selling $13,070.00 $32,670.00 Closing $56,000.00 $65,000.00 Depreciation $3,125.00 $3,125.00 $3,125.00 Variable Adm.
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,670.00 $11,670.00 Selling $25,000.00 $25,000.00 $25,000.00 Administrative $18,550.00 $18,550.00 $18,550.00 Total Fixed Expenses $46,675.00 $46,675.00 $46,675.00 Variable Expenses Selling Expenses $19,600.00 $39,200.00 $45,500.00 Administrative $7,000.00 $14,000.00 $16,250.00 Bad Debts $2,800.00 $5,600.00 $6,500.00 Total Variable Exp. $29,400.00 $58,800.00 $68,250.00 Total Operating Exp. $76,075.00 $105,475.00 $114,925.00 Net Profit-$20,075.00 $6,525.00 $15,075.00...
View Full Document

This note was uploaded on 12/07/2011 for the course MBA 0001 taught by Professor Akshat during the Spring '09 term at Institute of Management Technology.

Ask a homework question - tutors are online