AA coursehero.com C + Gold Diamante Capri... 3:8 Juice & Eatery - "... Page 6 - Discount Cl... 3:8 Juice & Eatery - ... X xlsx.xIsx Inputs Supporting Schedules Operating Budget Cash Budget Spreadsheet ID: 2324 Budget Assumptions First Month's Sales in Units 10000 Sales Growth Per Month 250 Sales Price Per Unit $12.00 Gross Margin 50% Commission 10% Ending Inventory 50% Minimum Cash Balance 20000 Interest Rate 12% Collections Payments Month 1 25% 60% Month 2 50% 40% Month 3 25% 0% Operating Expenses Per Month Payroll 16,000 Utilities 7,000 Other 19,500AA coursehero.com + Gold Diamante Capri... 3:8 Juice & Eatery - "... Page 6 - Discount Cl... 3:8 Juice & Eatery - ... X xlsx.xIsx Inputs Supporting Schedules Operating Budget Cash Budget January February March April May June July August September October November Cash Balance, Beginning 20,000 Collections Total Cash Available Less Disbursements Purchases 60,900 62,400 63,900 65,400 66,900 68,400 69,900 71,400 72,900 74,400 75,900 Commissions 12,000 12,300 12,600 12,900 13,200 13,500 13,800 14,100 14,400 14,700 15,000 Payroll 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 Utilities 7,000 7,000 7.000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 Other 19,500 19,500 19,500 19,500 19,500 19,500 19,500 19,500 19,500 19,500 19,500 Total Disbursements 115,400 117,200 119,000 120,800 122,600 124,400 126,200 128,000 129,800 131,600 133,400 Excess (deficiency) of receipts over disbursements Financing Interest Borrowings Repayments Total Financing Dividends Paid Cash Balance, EndingAA coursehero.com + Gold Diamante Capri... 3:8 Juice & Eatery - "... Page 6 - Discount Cl... 3:8 Juice & Eatery - ... X xlsx.xIsx mpuls supporting schedules operating budget vasil buuyet January February March April May Sales June July 120,000 August 123,000 September October 126,000 129,000 132,000 November December Cost of Goods Sold 135,000 138,000 141,000 144,000 147,000 150,000 153,000 Purchases 60,900 62,400 63,900 65,400 66,900 68,400 69,900 Commissions 12,000 71,400 12,300 72,900 12,600 74,400 12,900 75,900 76,500 13,200 13,500 13,800 14,100 14,400 14,700 15,000 15,300 Total Cost of Goods Sold 72,900 74,700 76,500 78,300 80,100 Gross Profit 81,900 83,700 47,100 85,500 48.300 49,500 87,300 50,700 89,100 90,900 51,900 91,800 53,100 Operating Expenses 54,300 55,500 56,700 57,900 59,100 61,200 Payroll 16,000 16,000 16,000 16,000 16,000 16,000 Utilities 16,000 16,000 7,000 16,000 7,000 7,000 16,000 16,000 7,000 16,000 7,000 Other 7,000 19,500 7,000 7,000 7,000 19,500 19,500 7,000 7,000 19,500 19,500 7,000 19,500 19,500 19,500 19,500 19,500 19,500 19,500 Total Operating Expenses 42,500 42,500 42,500 42,500 42,500 42,500 Net Income 42,500 4,600 42,500 5.800 42,500 42,500 7,000 42,500 8,200 42,500 9.400 10,600 11,800 13,000 14,200 15,400 16,600 18,7009:57 AA coursehero.com C Supporting Schedules Operating Budget Cash Budget Wally's Widgets January February April May June July September October November December Budgeted Sales in Units 10,000 10,250 10,750 11,000 11,250 11,500 11,750 12,250 Add: Ending Inventory 6.150 6,300 6,450 6.600 6,750 7.050 7.200 7.350 7.500 7,650 7.650 Total Needs 16,550 16,950 17.350 17.750 18,150 18,550 18,950 9,350 9,750 20,150 20,400 Less Beginning Inventory 6.000 6,150 6,300 6.450 6,600 6,750 6.900 7.050 7,200 7.350 7.500 7.650 Required Purchases in Units 10.150 10,400 10.900 11.150 11.400 11.650 11.90 12,150 12,650 12.750 60,900 62,400 65,400 $6,900 68,40 69,900 2,900 74.400 75.900 76,500 Budgeted Sales in Dollars 123,000 129,000 132,000 138,000 147,000 150,000 153,000 Sales Commissions in Dollars 12,000 12,900 13,200 13.500 14.10 14,400 14,700 15,000 15.300 Collection Ratio March April May June July October November December 25% 25% February 25% March 25% 50% April 25% 50% 25% May 25% 50% 25% June 25% July 25% 50% 25% Augus 25% 50% 25% September 25% 50% 25% 25% 50% 23% November 25% 50% December 25% January February March April May July September October November December 30,000 60,000 30,000 0 February 30,750 30,750 March 63,000 31.500 April 32,250 64,500 0 May 33.000 66.000 33.000 June $3.750 July 34,500 34,500 August 35.250 35,250 September 36.000 72.000 October 36,750 36,750 November 37,500 75,000 December 38.250 Total 90,750 123,D00 129.000 132,000 135,000 Payment Ratio January March April May June July August September October November December 40% 40% March 60% 40% April 60% 40% 0% May 40% June 60% 40% 0 July 60% 40% 0% 60% 40% September 609% 40% 60% 40% 0% November 60% 40% December Payments January February March April May June July August September October November December 36,540 24,360 February 37.440 March 38,340 25,56 April 39 240 26.160 May 40140 26,760 el June 27,360 July 41.940 27.960 August 42.840 28,56 13,740 29,160 0 0 44,640 29,760 November 45.540 December 45.90 36.540 61,800 64,800 66,300 67.800 70,800 72,300 73,800 76.260