show evidence budget plan

exercise 5,6,7,8

manufacturing, ending, selling, cash budget

all information i have is was in the bottom sales, production and cash disburtment! is the first 3 that i have. what do you need?

thats what i need!

Comprehensive Budget Budgeted sales of the company's only product for the next four quarters are: 50,000 units 60,000 units 65,000 units 55,000 units The selling price is $20 per unit. You determine the break down of monthly sales. The following elements of the master budget will be prepared: 1. Sales budget (with a schedule of expected cash collections). 2. Production budget 3. Direct materials budget (with a schedule of expected cash disbursements for materials) 4. Direct labor budget. 5. Manufacturing overhead budget 6. Ending finished goods inventory budget. 7. Selling and administrative budget. 8. Cash budget 9. Budgeted income statement. 10. Budgeted balance sheet. production budget Budgeted Sales Add: Desired Ending Inventory Total Needs Less Beginning Inventory Required Production January February March April May June July August Septembe October November Deces 20,000 20,000 10,000 20,000 20,000 20,000 20,000 20,000 25,000 20,000 20,000 8,000 4,000 8,000 8,000 8,000 8.000 8,000 10,000 8,000 8,000 6,000 28,000 24,000 18,000 28.000 28,000 28,000 28,000 30,000 33,000 28,000 26,000 8,000 4,000 8,000 8,000 8,000 8,000 8,000 10,000 8,000 8,000 16,000 14,000 20,000 20,000 20,000 20,000 22.000 23,000 20,000 18,000 15,00 6,400 direct materials budget Production Materials per unit (pounds) Production Needs Add: Desired Ending In vetory Total Needed Less: Beginning Inventory Materials to be purchased January February March April May June July August Septembe October November Dece 16,000 14.000 20,000 20,000 20,000 20,000 22,000 23,000 20,000 18,000 10 10 10 10 10 10 10 10 10 10 10 10 160,000 140,000 200,000 200,000 200,000 200,000 230,000 2.30,000 200,000 180,000 16,000 14,000 20,000 20,000 20,000 20,000 22,000 23,000 20,000 18,000 174,000 160,000 220,000 220,000 220,000 220,000 253,000 250,000 218,000 16,000 14,000 20,000 20,000 20,000 20,000 22.000 23,000 20,000 18,000 158,000 146.000 200.000 200.000 200.000 200.000 231,000 227,000 198,000 May cash disbanements January February March April Junc Accounts Payable 12.31.20 $50,000 July August Septamber October November December January Purchases 50% of 50% of February Purchases 50% of $158,000 79,00 50% of $158.000 79,000 March Purchases 50% of 146,000 73.900 5096 of $146,000 73,000 April Purchases 50% of $200,000 100,000 50% of $200,000 100,000 May Purchases 50% of $200,000 100,000 50% of $200,000 100,000 June Purchases 50% of $200,000 100.000 50% of $200,000 100,000 July Purchases 50% of $200,000 100,000 50% of $200,000 100,000 August Purchases 50% of 5231,000 115.500 50% of S231,000 115.500 September Purchases 50% of S227,000 113,500 50% of $227,000 113,500 October Purchases 99,000 50% of $198.000 50% of $198.000 November Purchases 50% of 50% of December Purchases 50% of 50% of Total Cash Disbursements $152,000 $173,000 $200,000 $200,000 $200,000 $215.500 5229100 5212.500 00066