1.The minimum cash balance for each month must be $15,000.

2.Collections and disbursement amounts are found in the instructions, and the variables tabs.

3.After subtracting total disbursements from total available cash, the balance should be either your ending bank balance, or the beginning determination for how much you need to borrow. (Deficiency plus minimum balance)

4.If you have excess cash, the amount greater than the minimum balance should be used to pay off any remaining borrowings.

5.For this exercise, there will be no interest earned from excess cash, nor interest expense from borrowing.

Student: Master Instructions: Cells1.with yellow shading must be completed 2. All portions must be delivered through a file upload on Canvas. No exceptions will be allowed or graded. 3. Deliverables are due when listed in Canvas. No late submissions will be accepted, regardless of reason. 4. Solutions will be available after the due date, and no late submissions will be accepted 5. is to be done individually. Any cheating discovered will result in an immediate zero (0) All work for the entire project Project Instructions are as follows 1. in units, sales price and pay rates by department and individual are listed below Sales, Month Sales Sales Price (Units) per Unit January February March April May June July August September October November December 5,000 5,000 5,000 7,000 9,000 9,000 9,000 9,000 9,000 8,000 7,000 6,000 $ $ $ $ $ $ $ $ $ $ $ $ 2,000.00 2,100.00 2,200.00 2,300.00 2,500.00 3,000.00 3,000.00 3,000.00 2,900.00 2,500.00 2,200.00 2,100.00 2. Production Budget, Ending Inventory must be equal to 50% of the next month's sales volume. The sales manager believes sales will remain the same one year to the next. On the The3. following employees work for the organization and make the amount per hour listed. Alhagie Bill Bob Chance Donna Jim Joshua Kally Maciel Maletha Sam Shareka Thomas Tim William 18.24 18.00 15.00 11.18 12.63 12.50 16.50 14.55 11.62 17.48 17.20 18.00 16.00 9.85 22.55 The4. advertising rate is 15% of Sales The5. Sales Commission rate is $15,000 plus $350 for each unit sold The6. travel and entertainment rate is 5% of Sales The7. Income Tax rate is 40% 8. Admistrative Expenses are as follows Monthly Officers Salaries Office Support Salaries Rent Expense Office Supplies Utilities $ $ $ $ $ 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 55%9.of sales are collected in the current month, 40% are collected in the month after the sale, and 5% are uncollectible 10, Disbursements are made as follows: 11 Disbursement Current Next Direct Materials Direct Labor FOH SGA 40% 95% 80% 55% 60% 5% 20% 45% The beginning cash balance is $15,000 0 Sales (Units) Month January February March April May June July August September October November December Employee Shareka Joshua Kally Alhagie Chance Bob Bill Jim Sam Tim Thomas William Maciel Maletha Donna 5,000 5,000 5,000 7,000 9,000 9,000 9,000 9,000 9,000 8,000 7,000 6,000 Sales Price $ $ $ $ $ $ $ $ $ $ $ $ 2,000.00 2,100.00 2,200.00 2,300.00 2,500.00 3,000.00 3,000.00 3,000.00 2,900.00 2,500.00 2,200.00 2,100.00 Rate 18.00 16.50 14.55 18.24 11.18 15.00 18.00 12.50 17.20 9.85 16.00 22.55 11.62 17.48 12.63 Sales Bu 14 January Units Price per unit Total Sales $ $ February 5,000 2,000.00 $ 10,000,000 $ March 5,000 2,100.00 $ 10,500,000 $ April 5,000 2,200.00 $ 11,000,000 $ 7,000 2,300.00 16,100,000 Production Budget (Ending Inventory mus January February March April Beginning Balance Sold Ending Inventory 3,000 5,000 2,500 2,500 5,000 2,500 2,500 5,000 3,500 3,500 7,000 4,500 Produced 4,500 5,000 6,000 8,000 Sales Budget May $ $ June 9,000 2,500.00 $ 22,500,000 $ July 9,000 3,000.00 $ 27,000,000 $ August 9,000 3,000.00 $ 27,000,000 $ September 9,000 3,000.00 $ 27,000,000 $ October 9,000 2,900.00 $ 26,100,000 $ 8,000 2,500.00 20,000,000 uction Budget (Ending Inventory must equal 50% of the next month's sales) May June July August 4,500 9,000 4,500 4,500 9,000 4,500 4,500 9,000 4,500 September October 4,500 4,500 4,000 9,000 9,000 8,000 4,500 4,000 3,500 9,000 9,000 9,000 9,000 8,500 7,500 November $ $ December 7,000 2,200.00 $ 15,400,000 $ 6,000 2,100.00 12,600,000 November December 3,500 3,000 7,000 6,000 3,000 2,500 6,500 5,500 Engine Components Steel Aluminum rubber wire spark plugs Direct Materials (Engine) Per Unit Price 25 15 5 30 2 Total 2.00 1.25 7.00 0.19 4.00 Components 50.00 18.75 35.00 5.70 8.00 Total 117.45 Steel Aluminum rubber wire Fiberglass Paint Bob Bill Jim Sam Tim Hours per unit Prior Year Units FOH per Unit 2.00 1.25 7.00 0.19 3.00 27.00 Components 6.00 7.50 98.00 29.45 108.00 13.50 262.45 Direct Materials (Assembly) Per Unit Price Trailer Safety Vest Decals Wax 1 1 15 0.25 Cost Total Employee 1.00 1.10 0.80 1.25 2.00 15.00 18.00 12.50 17.20 9.85 15.00 19.80 10.00 21.50 19.70 6.15 72.55 86.00 Shareka Joshua Kally Alhagie Chance Hours per unit 362.98 21.56 1.00 18.00 ### 21.56 15.00 4.50 404.04 Direct Labor (Assembly) Cost Total Employee 1.60 1.80 2.30 3.40 2.80 18.00 16.50 14.55 18.24 11.18 28.80 29.70 33.47 62.02 31.30 11.90 78.47 185.29 Hours per unit Thomas William Maciel Maletha Donna Factory Overhead (FOH) (Body) Cost Total 0.50 0.40 0.75 1.60 0.25 16.00 22.55 11.62 17.48 12.63 8.00 9.02 8.72 27.97 3.16 3.50 80.28 56.86 Factory Overhead (FOH) (Assembly) 2,650,000.00 Prior Year Dollars 3,015,500.00 Prior Year Dollars 137,500.00 Prior Year Units 137,500.00 Prior Year Units 19.27 FOH per Unit Total Total Direct Labor (Body) Factory Overhead (FOH) (Engine) Prior Year Dollars 3 6 14 155 36 0.5 Total Total Direct Labor (Engine) Employee Direct Materials (Body) Per Unit Price 21.93 FOH per Unit 2,984,500.00 137,500.00 21.71 Direct Materials January Production Level Direct Materials Direct Labor Factory Overhead (FOH) February 4,500 $ $ $ 3,527,730 $ 1,476,655 $ 283,091 $ March ### 3,527,730 $ 1,476,655 $ 283,091 $ April May June 5,300 7,100 8,100 4,154,882 $ 1,739,171 $ 333,418 $ 5,565,974 $ 2,329,833 $ 446,655 $ 6,349,914 $ 2,657,979 $ 509,564 $ July ### 6,349,914 $ 2,657,979 $ 509,564 $ August 8,100 6,349,914 $ 2,657,979 $ 509,564 $ September ### 6,349,914 $ 2,657,979 $ 509,564 $ October November December 7,700 6,800 5,900 6,036,338 $ 2,526,720 $ 484,400 $ 5,330,792 $ 2,231,389 $ 427,782 $ 4,625,246 $ 1,936,058 $ 371,164 $ Totals Total Cost Per Unit Totals 5,400 4,233,276 1,771,986 339,709 Per Unit 79,600 $ $ $ 62,401,624 $ 26,120,382 $ 5,007,564 $ $ 93,529,569 783.94 328.15 62.91 $ 1,174.99 FOH Budget January Sales (Units) Sales (Dollars) Selling Expenses (Variable) Advertising Expense Sales Salaries Expense Travel and Entertainment Total Selling Expenses Administrative Expenses (Fixed) Officers Salaries Office Support Salaries Rent Expense Office Supplies Utilities Total Administrative Expenses Total SGA February March April May June July August September October November December 882.13 882.13 882.13 882.13 9,000.00 8,000.00 7,000.00 6,000.00 26,100,000.00 20,000,000.00 15,400,000.00 12,600,000.00 882.13 5,000.00 10,000,000.00 ### ### 10,500,000.00 882.13 5,000.00 11,000,000.00 882.13 7,000.00 16,100,000.00 ### 9,000.00 22,500,000.00 882.13 9,000.00 27,000,000.00 882.13 9,000.00 27,000,000.00 882.13 9,000.00 27,000,000.00 1,500,000.00 1,765,000.00 500,000.00 3,765,000.00 1,575,000.00 ### 525,000.00 3,865,000.00 1,650,000.00 1,765,000.00 550,000.00 3,965,000.00 2,415,000.00 2,465,000.00 805,000.00 5,685,000.00 3,375,000.00 3,165,000.00 1,125,000.00 7,665,000.00 4,050,000.00 3,165,000.00 1,350,000.00 8,565,000.00 4,050,000.00 3,165,000.00 1,350,000.00 8,565,000.00 4,050,000.00 3,165,000.00 1,350,000.00 8,565,000.00 3,915,000.00 3,165,000.00 1,305,000.00 8,385,000.00 3,000,000.00 2,815,000.00 1,000,000.00 6,815,000.00 2,310,000.00 2,465,000.00 770,000.00 5,545,000.00 1,890,000.00 2,115,000.00 630,000.00 4,635,000.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 ### 60,000.00 16,000.00 ### 13,500.00 ### 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 ### 60,000.00 16,000.00 ### 13,500.00 ### 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 3,962,500.00 4,062,500.00 4,162,500.00 5,882,500.00 7,862,500.00 8,762,500.00 8,762,500.00 8,762,500.00 8,582,500.00 7,012,500.00 5,742,500.00 4,832,500.00 - Budgeted Income Statement January Sales Cost of Goods Sold Gross Profit Selling and Administrative Expenses Income From Operations Income Tax (40%) Net Income IS Sales February March April May June July August September October 882.13 ### 882.13 882.13 882.13 882.13 882.13 882.13 ### 882.13 10,000,000.00 5,874,972.95 4,125,027.05 3,962,500.00 162,527.05 65,010.82 97,516.23 10,500,000.00 5,874,972.95 4,625,027.05 4,062,500.00 562,527.05 225,010.82 337,516.23 11,000,000.00 5,874,972.95 5,125,027.05 4,162,500.00 962,527.05 385,010.82 577,516.23 16,100,000.00 8,224,962.14 7,875,037.86 5,882,500.00 1,992,537.86 797,015.15 1,195,522.72 22,500,000.00 10,574,951.32 11,925,048.68 7,862,500.00 4,062,548.68 1,625,019.47 2,437,529.21 27,000,000.00 10,574,951.32 16,425,048.68 8,762,500.00 7,662,548.68 3,065,019.47 4,597,529.21 27,000,000.00 10,574,951.32 16,425,048.68 8,762,500.00 7,662,548.68 3,065,019.47 4,597,529.21 27,000,000.00 10,574,951.32 16,425,048.68 8,762,500.00 7,662,548.68 3,065,019.47 4,597,529.21 26,100,000.00 10,574,951.32 15,525,048.68 8,582,500.00 6,942,548.68 2,777,019.47 4,165,529.21 20,000,000.00 9,399,956.73 10,600,043.27 7,012,500.00 3,587,543.27 1,435,017.31 2,152,525.96 14.00 November December 882.13 882.13 15,400,000.00 8,224,962.14 7,175,037.86 5,742,500.00 1,432,537.86 573,015.15 859,522.72 12,600,000.00 7,049,967.55 5,550,032.45 4,832,500.00 717,532.45 287,012.98 430,519.47 225,200,000.00 103,399,524.00 121,800,476.00 78,390,000.00 43,410,476.00 17,364,190.40 26,046,285.60 Cash Budget January Beginning Cash Balance February 15,000.00 Add: Receipts Collections from Customers Total Receipts Total Available Cash Less: Disbursements Direct Materials Direct Labor Manufacturing Overhead SGA Expenses Income Taxes Total Disbursements Excess (Deficiency) of Cash Minimum Required (Ending Balance) Amount to be (borrowed) Invested Bank Balance (Before Adjustments) Less: Repayments Bank Balance (After Adjustments) Borrowing Balance (Beginning) Plus: Borrowings Less: Repayments Borrowing Balance (Ending) - March April May June July August September October November December \fStudent: Master Instructions: Cells1.with yellow shading must be completed 2. All portions must be delivered through a file upload on Canvas. No exceptions will be allowed or graded. 3. Deliverables are due when listed in Canvas. No late submissions will be accepted, regardless of reason. 4. Solutions will be available after the due date, and no late submissions will be accepted 5. is to be done individually. Any cheating discovered will result in an immediate zero (0) All work for the entire project Project Instructions are as follows 1. in units, sales price and pay rates by department and individual are listed below Sales, Month Sales Sales Price (Units) per Unit January February March April May June July August September October November December 5,000 5,000 5,000 7,000 9,000 9,000 9,000 9,000 9,000 8,000 7,000 6,000 $ $ $ $ $ $ $ $ $ $ $ $ 2,000.00 2,100.00 2,200.00 2,300.00 2,500.00 3,000.00 3,000.00 3,000.00 2,900.00 2,500.00 2,200.00 2,100.00 2. Production Budget, Ending Inventory must be equal to 50% of the next month's sales volume. The sales manager believes sales will remain the same one year to the next. On the The3. following employees work for the organization and make the amount per hour listed. Alhagie Bill Bob Chance Donna Jim Joshua Kally Maciel Maletha Sam Shareka Thomas Tim William 18.24 18.00 15.00 11.18 12.63 12.50 16.50 14.55 11.62 17.48 17.20 18.00 16.00 9.85 22.55 The4. advertising rate is 15% of Sales The5. Sales Commission rate is $15,000 plus $350 for each unit sold The6. travel and entertainment rate is 5% of Sales The7. Income Tax rate is 40% 8. Admistrative Expenses are as follows Monthly Officers Salaries Office Support Salaries Rent Expense Office Supplies Utilities $ $ $ $ $ 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 55%9.of sales are collected in the current month, 40% are collected in the month after the sale, and 5% are uncollectible 10, Disbursements are made as follows: 11 Disbursement Current Next Direct Materials Direct Labor FOH SGA 40% 95% 80% 55% 60% 5% 20% 45% The beginning cash balance is $15,000 0 Sales (Units) Month January February March April May June July August September October November December Employee Shareka Joshua Kally Alhagie Chance Bob Bill Jim Sam Tim Thomas William Maciel Maletha Donna 5,000 5,000 5,000 7,000 9,000 9,000 9,000 9,000 9,000 8,000 7,000 6,000 Sales Price $ $ $ $ $ $ $ $ $ $ $ $ 2,000.00 2,100.00 2,200.00 2,300.00 2,500.00 3,000.00 3,000.00 3,000.00 2,900.00 2,500.00 2,200.00 2,100.00 Rate 18.00 16.50 14.55 18.24 11.18 15.00 18.00 12.50 17.20 9.85 16.00 22.55 11.62 17.48 12.63 Sales B 14 January Units Price per unit Total Sales $ $ February 5,000 2,000.00 $ 10,000,000 $ March 5,000 2,100.00 $ 10,500,000 $ April 5,000 2,200.00 $ 11,000,000 $ 7,000 2,300.00 16,100,000 Production Budget (Ending Inventory mu January February March April Beginning Balance Sold Ending Inventory 3,000 5,000 2,500 2,500 5,000 2,500 2,500 5,000 3,500 3,500 7,000 4,500 Produced 4,500 5,000 6,000 8,000 Sales Budget May $ $ June 9,000 2,500.00 $ 22,500,000 $ July 9,000 3,000.00 $ 27,000,000 $ August 9,000 3,000.00 $ 27,000,000 $ September 9,000 3,000.00 $ 27,000,000 $ October 9,000 2,900.00 $ 26,100,000 $ 8,000 2,500.00 20,000,000 duction Budget (Ending Inventory must equal 50% of the next month's sales) May June July August September October 4,500 9,000 4,500 4,500 9,000 4,500 4,500 9,000 4,500 4,500 9,000 4,500 4,500 9,000 4,000 4,000 8,000 3,500 9,000 9,000 9,000 9,000 8,500 7,500 November $ $ December 7,000 2,200.00 $ 15,400,000 $ November 6,000 2,100.00 12,600,000 December 3,500 7,000 3,000 3,000 6,000 2,500 6,500 5,500 Engine Components Steel Aluminum rubber wire spark plugs Direct Materials (Engine) Per Unit Price 25 15 5 30 2 Total 2.00 1.25 7.00 0.19 4.00 Components 50.00 18.75 35.00 5.70 8.00 Total 117.45 Steel Aluminum rubber wire Fiberglass Paint Bob Bill Jim Sam Tim Hours per unit Prior Year Units FOH per Unit 2.00 1.25 7.00 0.19 3.00 27.00 Components 6.00 7.50 98.00 29.45 108.00 13.50 262.45 Direct Materials (Assembly) Per Unit Price Trailer Safety Vest Decals Wax 1 1 15 0.25 Cost Total Employee 1.00 1.10 0.80 1.25 2.00 15.00 18.00 12.50 17.20 9.85 15.00 19.80 10.00 21.50 19.70 6.15 72.55 86.00 Shareka Joshua Kally Alhagie Chance Hours per unit 362.98 21.56 1.00 18.00 ### 21.56 15.00 4.50 404.04 Direct Labor (Assembly) Cost Total Employee 1.60 1.80 2.30 3.40 2.80 18.00 16.50 14.55 18.24 11.18 28.80 29.70 33.47 62.02 31.30 11.90 78.47 185.29 Hours per unit Thomas William Maciel Maletha Donna Factory Overhead (FOH) (Body) Cost Total 0.50 0.40 0.75 1.60 0.25 16.00 22.55 11.62 17.48 12.63 8.00 9.02 8.72 27.97 3.16 3.50 80.28 56.86 Factory Overhead (FOH) (Assembly) 2,650,000.00 Prior Year Dollars 3,015,500.00 Prior Year Dollars 137,500.00 Prior Year Units 137,500.00 Prior Year Units 19.27 FOH per Unit Total Total Direct Labor (Body) Factory Overhead (FOH) (Engine) Prior Year Dollars 3 6 14 155 36 0.5 Total Total Direct Labor (Engine) Employee Direct Materials (Body) Per Unit Price 21.93 FOH per Unit 2,984,500.00 137,500.00 21.71 Direct Materials January Production Level Direct Materials Direct Labor Factory Overhead (FOH) $ $ $ February March April May June July August September October November December 4,500 4,500 5,300 7,100 8,100 8,100 8,100 8,100 7,700 6,800 5,900 3,527,730 $ 1,476,655 $ 283,091 $ 3,527,730 $ 1,476,655 $ 283,091 $ 4,154,882 $ 1,739,171 $ 333,418 $ 5,565,974 $ 2,329,833 $ 446,655 $ 6,349,914 $ 2,657,979 $ 509,564 $ 6,349,914 $ 2,657,979 $ 509,564 $ 6,349,914 $ 2,657,979 $ 509,564 $ 6,349,914 $ 2,657,979 $ 509,564 $ 6,036,338 $ 2,526,720 $ 484,400 $ 5,330,792 $ 2,231,389 $ 427,782 $ 4,625,246 $ 1,936,058 $ 371,164 $ Totals Total Cost Per Unit Totals 5,400 4,233,276 1,771,986 339,709 Per Unit 79,600 $ $ $ 62,401,624 $ 26,120,382 $ 5,007,564 $ $ 93,529,569 783.94 328.15 62.91 $ 1,174.99 FOH Budget January Sales (Units) Sales (Dollars) Selling Expenses (Variable) Advertising Expense Sales Salaries Expense Travel and Entertainment Total Selling Expenses Administrative Expenses (Fixed) Officers Salaries Office Support Salaries Rent Expense Office Supplies Utilities Total Administrative Expenses Total SGA February March April May June July August September October November December 882.13 882.13 882.13 882.13 9,000.00 8,000.00 7,000.00 6,000.00 26,100,000.00 20,000,000.00 15,400,000.00 12,600,000.00 882.13 5,000.00 10,000,000.00 ### ### 10,500,000.00 882.13 5,000.00 11,000,000.00 882.13 7,000.00 16,100,000.00 ### 9,000.00 22,500,000.00 882.13 9,000.00 27,000,000.00 882.13 9,000.00 27,000,000.00 882.13 9,000.00 27,000,000.00 1,500,000.00 1,765,000.00 500,000.00 3,765,000.00 1,575,000.00 ### 525,000.00 3,865,000.00 1,650,000.00 1,765,000.00 550,000.00 3,965,000.00 2,415,000.00 2,465,000.00 805,000.00 5,685,000.00 3,375,000.00 3,165,000.00 1,125,000.00 7,665,000.00 4,050,000.00 3,165,000.00 1,350,000.00 8,565,000.00 4,050,000.00 3,165,000.00 1,350,000.00 8,565,000.00 4,050,000.00 3,165,000.00 1,350,000.00 8,565,000.00 3,915,000.00 3,165,000.00 1,305,000.00 8,385,000.00 3,000,000.00 2,815,000.00 1,000,000.00 6,815,000.00 2,310,000.00 2,465,000.00 770,000.00 5,545,000.00 1,890,000.00 2,115,000.00 630,000.00 4,635,000.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 ### 60,000.00 16,000.00 ### 13,500.00 ### 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 ### 60,000.00 16,000.00 ### 13,500.00 ### 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 100,000.00 60,000.00 16,000.00 8,000.00 13,500.00 197,500.00 3,962,500.00 4,062,500.00 4,162,500.00 5,882,500.00 7,862,500.00 8,762,500.00 8,762,500.00 8,762,500.00 8,582,500.00 7,012,500.00 5,742,500.00 4,832,500.00 - Budgeted Income Statement January Sales Cost of Goods Sold Gross Profit Selling and Administrative Expenses Income From Operations Income Tax (40%) Net Income IS Sales February March April May June July August September October 882.13 ### 882.13 882.13 882.13 882.13 882.13 882.13 ### 882.13 10,000,000.00 5,874,972.95 4,125,027.05 3,962,500.00 162,527.05 65,010.82 97,516.23 10,500,000.00 5,874,972.95 4,625,027.05 4,062,500.00 562,527.05 225,010.82 337,516.23 11,000,000.00 5,874,972.95 5,125,027.05 4,162,500.00 962,527.05 385,010.82 577,516.23 16,100,000.00 8,224,962.14 7,875,037.86 5,882,500.00 1,992,537.86 797,015.15 1,195,522.72 22,500,000.00 10,574,951.32 11,925,048.68 7,862,500.00 4,062,548.68 1,625,019.47 2,437,529.21 27,000,000.00 10,574,951.32 16,425,048.68 8,762,500.00 7,662,548.68 3,065,019.47 4,597,529.21 27,000,000.00 10,574,951.32 16,425,048.68 8,762,500.00 7,662,548.68 3,065,019.47 4,597,529.21 27,000,000.00 10,574,951.32 16,425,048.68 8,762,500.00 7,662,548.68 3,065,019.47 4,597,529.21 26,100,000.00 10,574,951.32 15,525,048.68 8,582,500.00 6,942,548.68 2,777,019.47 4,165,529.21 20,000,000.00 9,399,956.73 10,600,043.27 7,012,500.00 3,587,543.27 1,435,017.31 2,152,525.96 14.00 November December 882.13 882.13 15,400,000.00 8,224,962.14 7,175,037.86 5,742,500.00 1,432,537.86 573,015.15 859,522.72 12,600,000.00 7,049,967.55 5,550,032.45 4,832,500.00 717,532.45 287,012.98 430,519.47 225,200,000.00 103,399,524.00 121,800,476.00 78,390,000.00 43,410,476.00 17,364,190.40 26,046,285.60 Cash Budget January Beginning Cash Balance February March April May June July August September October November December 15,000.00 230,227.44 475,240.96 394,741.29 300,600.12 1,500,977.55 4,411,001.89 8,716,026.23 13,021,050.57 17,488,331.51 21,334,933.20 23,536,032.19 Add: Receipts Collections from Customers Total Receipts Total Available Cash 5,500,000.00 5,500,000.00 5,515,000.00 9,775,000.00 9,775,000.00 10,005,227.44 10,250,000.00 10,250,000.00 10,725,240.96 13,255,000.00 13,255,000.00 13,649,741.29 18,815,000.00 18,815,000.00 19,115,600.12 23,850,000.00 23,850,000.00 25,350,977.55 25,650,000.00 25,650,000.00 30,061,001.89 25,650,000.00 25,650,000.00 34,366,026.23 25,155,000.00 25,155,000.00 38,176,050.57 21,440,000.00 21,440,000.00 38,928,331.51 16,470,000.00 16,470,000.00 37,804,933.20 13,090,000.00 13,090,000.00 36,626,032.19 Less: Disbursements Direct Materials Direct Labor Manufacturing Overhead SGA Expenses Income Taxes Total Disbursements Excess (Deficiency) of Cash Minimum Required (Ending Balance) 1,411,092.00 1,402,822.01 226,472.73 2,179,375.00 65,010.82 5,284,772.56 230,227.44 15,000.00 3,527,730.00 1,476,654.75 283,090.91 4,017,500.00 225,010.82 9,529,986.48 475,240.96 15,000.00 3,778,590.80 1,726,045.33 323,352.73 4,117,500.00 385,010.82 10,330,499.68 394,741.29 15,000.00 4,719,318.80 2,300,299.96 424,007.27 5,108,500.00 797,015.15 13,349,141.17 300,600.12 15,000.00 5,879,550.00 2,641,571.28 496,981.82 6,971,500.00 1,625,019.47 17,614,622.57 1,500,977.55 15,000.00 6,349,914.00 2,657,978.55 509,563.64 8,357,500.00 3,065,019.47 20,939,975.66 4,411,001.89 15,000.00 6,349,914.00 2,657,978.55 509,563.64 8,762,500.00 3,065,019.47 21,344,975.66 8,716,026.23 15,000.00 6,349,914.00 2,657,978.55 509,563.64 8,762,500.00 3,065,019.47 21,344,975.66 13,021,050.57 15,000.00 6,224,483.60 2,533,283.26 489,432.73 8,663,500.00 2,777,019.47 20,687,719.06 17,488,331.51 15,000.00 5,754,119.60 2,246,155.95 439,105.45 7,719,000.00 1,435,017.31 17,593,398.31 21,334,933.20 15,000.00 5,048,573.60 1,950,825.00 382,487.27 6,314,000.00 573,015.15 14,268,901.02 23,536,032.19 15,000.00 4,468,458.00 1,780,189.34 346,000.00 5,242,000.00 287,012.98 12,123,660.32 24,502,371.87 15,000.00 Amount to be (borrowed) Invested Bank Balance (Before Adjustments) Less: Repayments Bank Balance (After Adjustments) Borrowing Balance (Beginning) Plus: Borrowings Less: Repayments Borrowing Balance (Ending) 230,227.44 230,227.44 - - 475,240.96 475,240.96 - 394,741.29 394,741.29 - 300,600.12 300,600.12 - 1,500,977.55 ### 1,500,977.55 ### ### - 4,411,001.89 4,411,001.89 - 8,716,026.23 8,716,026.23 - 13,021,050.57 13,021,050.57 - - - 17,488,331.51 21,334,933.20 ### 17,488,331.51 21,334,933.20 ### ### - - 23,536,032.19 23,536,032.19 - 24,502,371.87 24,502,371.87 - \f