Budget Project(1) - Copy

Budget Project(1) - Copy - Sales Budget Budgeted...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Sales Budget April May June 2nd Quarter Budgeted Sales (units) 75,000 95,000 85,000 255,000 Selling Price per unit $4.00 $4.00 $4.00 $4.00 Total Sales $300,000.00 $380,000.00 $340,000.00 ### Production Budget Planned Ending Inventory 30% Finished Goods Inventory (Mar. 31) 39900 Cost to Manufacture per unit $1.90 April May June July August 2nd Quarter Budgeted Sales 75,000 95,000 85,000 80,000 75,000 255,000 Finished Goods End Inv. 28,500 25,500 24,000 22,500 24,000 Total Needs 103,500 120,500 109,000 102,500 279,000 Less Beginning Inventory 21,000 28,500 25,500 24,000 21,000 Required Production 82,500 92,000 83,500 78,500 258,000 Material A Purchases Budget Oz. of Material A needed for per unit 2 Planned Ending Inventory 40% Cost of raw material per oz. $0.30 1st Quarter Raw Material Inv. For Material A $17,160.00 April May June July 2nd Quarter Required Production 82,500 92,000 83,500 78,500 258,000 Raw materials needed per unit 2 2 2 2 2 Production needs (oz.) 165,000 184,000 167,000 157,000 516,000 Ending Inventory of Raw Materials 73,600 66,800 62,800 62,800 Total Needs 238,600 250,800 229,800 578,800 Less Beginning Inv. Raw Materials 57,200 73,600 66,800 57,200 Raw Materials to be Purchased 181,400 177,200 163,000 521,600 Cost of raw material per oz. $0.30 $0.30 $0.30 $0.30 Cost of raw materials to be purchased $54,420.00 $53,160.00 $48,900.00 ### Material B Purchases Budget Qt. of Material B needed for per unit 1 Planned Ending Inventory 20% Cost of raw material per at. $0.40 1st Quarter Raw Material Inv. For Material B $5,720.00 April May June July 2nd Quarter Required Production 82,500 92,000 83,500 78,500 258,000 Raw materials needed per unit 1 1 1 1 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Production needs (qt.) 82,500 92,000 83,500 78,500 258,000 Ending Inventory of Raw Materials 18,400 16,700 15,700 15,700 Total Needs 100,900 108,700 99,200 273,700 Less Beginning Inv. Raw Materials 14,300 18,400 16,700 14,300 Raw Materials to be Purchased 86,600 90,300 82,500 259,400 Cost of raw material per qt. $0.40 $0.40 $0.40 $0.40 Cost of raw materials to be purchased $34,640.00 $36,120.00 $33,000.00 ### Schedule of Cash Collections Cash Sales: 20% January Sales: 52,000 Credit Sales: 80% February Sales 60,000 Credit Sales in Month of Sale: 20% March Sales: 62,000 Credit Sales First Month After Sale: 60% Unit Sale Pric $4.00 Credit Sales Second Month After Sale: 17% A/R (net) $185,408.00 January February March April May January Total Sales $208,000.00 January Cash Sales $41,600.00 $41,600.00 January Credit Sales $166,400.00 $33,280.00 $99,840.00 $28,288.00 February Total Sales $240,000.00 February Cash Sales $48,000.00 $48,000.00 February Credit Sales $192,000.00 $38,400.00 $115,200.00 $32,640.00 March Total Sales $248,000.00 March Cash Sales $49,600.00 $49,600.00 March Credit Sales $198,400.00 $39,680.00 ### $33,728.00 April Total Sales $300,000.00 April Cash Sales $60,000.00 $60,000.00 April Credit Sales $240,000.00 $48,000.00 ### May Total Sales $380,000.00 May Cash Sales $76,000.00
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 25

Budget Project(1) - Copy - Sales Budget Budgeted...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online