Prep a schedule of cash disbursement. Previous schedules have been included for reference.
A B C D E F Direct Materials Budget Q1 Q2 Q3 Q4 Total Production 5700 15450 5700 3195 30045 Materials per unit 60 60 60 60 60 Production needs 342000 927000 342000 191700 1802700 Add: desired ending inventory 139050 51300 28755 56430 56430 Total needed 481050 978300 370755 248130 1859130 Less: Beginning Inventory 51,300 139050 51300 28755 51,300 Materials to be purchased 429,750 839250 319455 219375 1,807,830 Purchase price $90 $90 $90 $90 $90 Cost of purchase $38,677,500 $75,532,500 $28,750,950 $19,743,750 $162,704,700 Schedule of Cash disbursements Q1 Q2 Q3 Q4 TotalA listing of the estimated balances in the company's ledger accounts as of December 31, 2020 is given below: Cash 97,625 Accounts receivable 162,864 Inventory-raw materials 76,950 Inventory-finished goods (450 units) 106,142 Prepaid insurance 45,000 Prepaid prop. tax 16,000 Capital assets $1,695,000 Less: Acc. Dep. 820.000 875,000 $ 1.379.581 Accounts payable $ 58.077 Income tax payable 32,500 Capital stock 800,000 Retained earnings 489,004 $ 1.379.581A B C D E F Pepsi Inc Production Budget For year ended December 31,2021 Q1 Q2 Q3 Q4 Total Budgeted sales in units 4500 16500 6000 3000 30,000 Add: desired ending inventory of finished goods 1650 600 300 495 Total needs 495 6150 17100 6300 3495 Less: beginning inventory of finished goods 30,495 450 1650 600 300 Required production 450 5700 15450 5700 3195 30,045 2022 Q1 Q2 Q3 Q4 Total Budgeted sales in units 4950 18150 6600 3300 33,000 Add: desired ending inventory of finished goods 1815 660 330 Total needs 6765 18810 6930 Less: beginning inventory of finished goods 495 1815 660 Required production 6270 16995 6270The President, desperately needing the budget completed, has approached you, a management accounting student, for help in preparing the budget for the coming fiscal year. Your conversations with the president and your investigations of the company's records have revealed the following information: 1. Sam's|sales forecast consisted of these few lines: For the year ended December 31, 2020: 26,000 units at $290.00 each For the year ended December 31, 2021: 30,000 units at $290.00 each For the year ended December 31, 2022: 33,000 units at $290.00 each 2. History has shown that sales are seasonal, with 55% of sales occurring in the second quarter, 20% in the third quarter, 15% in the first quarter, and the remaining 10% in the last quarter.The primary raw material used is 4x6 cedar boards. Each table averages 60 linear feet of wood (including a wastage allowance), which the company purchases for $1.50 per linear foot. Pepsi Inc finds it necessary to maintain an inventory balance equal to 15% of the following quarter's production needs of cedar as a precaution against stock-outs. Opening raw materials inventory consists of 51,300 linear feet of cedar. Pepsi Inc pays for 80% of a quarter's purchases in the quarter of purchase and 20% in the following quarter.Pepsi Inc Sales Budget For Year ended December 31,2021 Q1 Q2 Q3 Q4 Total Budgeted Sales in units 4,500 16,500 6,000 3,000 30,000 Selling Price per unit $290 $290.00 $290.00 $290.00 $290 Total budgeted sales $1,305,000 $4,785,000.00 $1,740,000.00 $870,000.00 $8,700,000 Pepsi Inc Schedule of Cash Receipts For yeard ended December 31, 2021 Q1 Q2 Q3 Q4 Total Cash sales $391,500 $1,914,000 $696,000 $3,480,000 $6,481,500 Credit sales collected dur $469,800 $1,722,600 $626,400 $313,200 $3,132,000 Credit sales collected in f 162,864 $281,880 $1,033,560 $375.840 $1,854,144 Total cash collections $1,024,164 $3,918,480 $2,355,960 $4, 169,040 $11,467,644The President, desperately needing the budget completed, has approached you, a management accounting student, for help in preparing the budget for the coming fiscal year. Your conversations with the president and your investigations of the company's records have revealed the following information: 1. Maggie's sales forecast consisted of these few lines: For the year ended December 31, 2020: 26,000 units at $290.00 each For the year ended December 31, 2021: 30,000 units at $290.00 each For the year ended December 31, 2022: 33,000 units at $290.00 each 2. History has shown that sales are seasonal, with 55% of sales occurring in the second quarter, 20% in the third quarter, 15% in the first quarter, and the remaining 10% in the last quarter
