ACC445 P4T3 DB2 due 2-12-07 - Formula ($) Purchase Direct...

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

View Full Document Right Arrow Icon
ACC445-0701A-01 Cost Accounting Cara Cole/Estes Phase 4, Task 2 – Individual Project Due: 2/9/07 % Change Sales Budget 2003 2004 2005 Budget 2005 2004 2005 Budget to 04 % Change Sales 3,525,000 4,540,000 5,050,000 5,220,000 29% 11% 15% 4% 5,807,500 15% Sales Discounts 25,000 40,000 50,000 20,000 60% 25% -50% -75% 57,500 15% Net Sales 3,500,000 4,500,000 5,000,000 5,200,000 29% 11% 16% 4% 5,750,000 15% COGS 2,289,600 2,982,000 3,255,700 3,342,500 30% 9% 12% 3% Gross Margin 1,210,400 1,518,000 1,744,300 1,857,500 25% 15% 22% 7% Production Budget Projected Net Sales 5,750,000 Projected Unit Sales Price 5.47 Projected Unit Prod Price 3.52 Projected # of Units 1,051,188 Projected Total Prod Price 3,700,183 Formula (Units) Budget Production Budget Sales 1,030,188 1,051,188 27,500 48,500 COGS Budget
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Formula ($) Purchase Direct Materials $3,817,782.82 $3,700,182.82 $537,600.00 $420,000.00 640000 825000 915000 950000 650000 846500 942000 946000 98% 97% 97% 100% 34,600 80,875 98,860 (10,900) 8.6597938144 10,000 21,500 27,000 (4,000) 31,500 48,500 27,500 Budget to Actual Variance 2006 Proposed Budget Target ending FG Beg FG Inventory DM used in Production Target ending FG Beg FG Inventory 15% 2005 budget was reasonable, so we are budgeting 15% again. 2005 Budget Unit prices were reasonable, so we are budgeting the same Sales & Prod prices in 2006 2005 Budget 28% ending inventory was reasonable, so we are budgeting the same % increase in 2006...
View Full Document

Ask a homework question - tutors are online