VALERIE3 - Mangu&Co. SalesBudget 1 2 3 4 5 6 7 8 9 10 11 12...

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

View Full Document Right Arrow Icon
Sales Budget Month 1 2 3 4 5 6 7 8 9 10 11 12 Year Budgeted Sales (Quantity)  250 276 240 255 320 380 401 420 400 401 400 423 4166 Price $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 Total Sales $50,000.00 $55,200.00 $48,000.00 $51,000.00 $64,000.00 $76,000.00 $80,200.00 $84,000.00 $80,000.00 $80,200.00 $80,000.00 $84,600.00 $833,200.00 95% 5% Schedule of Expected Cash Collections Year Beginning Blanace 0 0 First Month $47,500.00 $2,500.00 $50,000.00 Second Month $52,440.00 $2,760.00 $55,200.00 Third Month $45,600.00 $2,400.00 $48,000.00 Fourth Month $48,450.00 $2,550.00 $51,000.00 Fifth Month $60,800.00 $3,200.00 $64,000.00 Sixth Month $72,200.00 $3,800.00 $76,000.00 Seventh Month $76,190.00 $4,010.00 $80,200.00 Eighth Month $79,800.00 $4,200.00 $84,000.00 Ninth Month $76,000.00 $4,000.00 $80,000.00 Tenth Month $76,190.00 $4,010.00 $80,200.00 Eleventh Month $76,000.00 $4,000.00 $80,000.00 Twelfth Month $80,370.00 $4,230.00 $84,600.00 Total Cash Collection $47,500.00 $54,940.00 $48,360.00 $50,850.00 $63,350.00 $75,400.00 $79,990.00 $83,810.00 $80,200.00 $80,190.00 $80,010.00 $84,370.00 $4,230.00 $833,200.00 Production Budget Month 1 2 3 4 5 6 7 8 9 10 11 12 Year Budgeted Sales (Quantity)  250 276 240 255 320 380 401 420 400 401 400 423 4166 $55.20 $48.00 $51.00 $64.00 $76.00 $80.20 $84.00 $80.00 $80.20 $80.00 $84.60 $71.20 $71.20 Total Needs $305.20 $324.00 $291.00 $319.00 $396.00 $460.20 $485.00 $500.00 $480.20 $481.00 $484.60 $494.20 $4,094.80 0 $55.20  $48.00  $51.00  $64.00  $76.00  $80.20  $84.00  $80.00  $80.20  $80.00  $84.60  $0.00  Required Production 305.2 268.8 243 268 332 384.2 404.8 416 400.2 400.8 404.6 409.6 4094.8 Sale ercentage of Sales Collected in the Period  After  the Sa Add Desired Ending Inventory of  Finished Goods Less Beginning Inventory of Finished  Goods
Background image of page 1

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

View Full DocumentRight Arrow Icon
Direct Material Budgets Month 1 2 3 4 5 6 7 8 9 10 11 12 Year Required Production 305.2 268.8 243 268 332 384.2 404.8 416 400.2 400.8 404.6 409.6 4094.8 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 12 Production Needs 305.20 268.80 243.00 268.00 332.00 384.20 404.80 416.00 400.20 400.80 404.60 409.60 4,237.20 26.88 24.30 26.80 33.20 38.42 40.48 41.60 40.02 40.08 40.46 40.96 35.75 13,145.74 Total Needs 332.08 293.10 269.80 301.20 370.42 424.68 446.40 456.02 440.28 441.26 445.56 445.35 17,382.94
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.

This note was uploaded on 08/09/2011 for the course ACCOUNTING --- taught by Professor --- during the Spring '11 term at Universidad Iberoamericana.

Page1 / 5

VALERIE3 - Mangu&Co. SalesBudget 1 2 3 4 5 6 7 8 9 10 11 12...

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