Question: Hello, I have a project where I'm operating a small washer and dryer repair shop, and I want to expand. I have the current and

 Hello, I have a project where I'm operating a small washer

Hello, I have a project where I'm operating a small washer and dryer repair shop, and I want to expand. I have the current and the project figures.

somebody take a look at my numbers and tell me how can I expand this one man operation expanding to a three man operation to a small warehouse? Can you also add unknown license and fees you may be aware off?

It does not have to be anything in great detail. Just a short explanation.

Thanks,

and dryer repair shop, and I want to expand. I have the

Monthly Assumpitions of Inventory Outflow of COGS 8 Washer & Dryers Scrapped (2 per week) 24 Washer & Dryers Sold (6 per week) 4 Fridge Scapped (1 per week) 8 Fridges Sold (2 per week) TOTAL INCOME Income Inflow of COGS 48 Washer & Dryers (12 per week) 12 Fridges (3 per week) TOTAL COST Cost Parts Cost 44 (units fixed monthy) *30 (Parts cost) - 240$ 40 4800 20 2800 7660 Deductions in Parts expense 160 80 240 1200 720 1920 1080 ***Note every Fourth month no Inventory ordered due to surplus of inventory and lack of inventory space inventory space Small Business Cash Flow Projection Starting date Cash balance alert minimum Jan-17 0 Beginning Jan-17 Cash on hand (beginning of month) CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available CASH PAID OUT Advertising Commissions and fees Contract labor Employee benefit programs Insurance (other than health) Interest expense Materials and supplies (in COGS) Meals and entertainment Mortgage interest Office expense Other interest expense Pension and profit-sharing plan Purchases for resale Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Travel Utilities Wages (less emp. credits) Vehicle Fuel Other expenses Other expenses Miscellaneous SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month) OTHER OPERATING DATA Sales volume (dollars) Accounts receivable balance Bad debt balance Inventory on hand Accounts payable balance Depreciation 0 0 0 0 Feb-17 0 Mar-17 0 Apr-17 0 May-17 0 Jun-17 0 Jul-17 0 Aug-17 0 Sep-17 0 Oct-17 0 Nov-17 0 Dec-17 0 3,640 7,280 10,920 16,480 20,120 23,760 27,400 32,960 36,600 40,240 43,880 7,660 7,660 7,660 7,660 7,660 7,660 7,660 7,660 7,660 7,660 7,660 7,660 7,660 7,660 7,660 11,300 7,660 14,940 7,660 18,580 7,660 24,140 7,660 27,780 7,660 31,420 7,660 35,060 7,660 40,620 7,660 44,260 7,660 47,900 7,660 51,540 440 440 440 440 440 440 440 440 440 440 440 440 40 1,920 40 1,920 40 1,920 40 0 40 1,920 40 1,920 40 1,920 40 0 40 1,920 40 1,920 40 1,920 40 0 1,080 1,080 1,080 1,080 1,080 1,080 1,080 1,080 1,080 1,080 1,080 1,080 300 300 300 300 300 300 300 300 300 300 300 300 240 240 240 240 240 240 240 240 240 240 240 240 4,020 4,020 4,020 2,100 4,020 4,020 4,020 2,100 4,020 4,020 4,020 2,100 4,020 3,640 4,020 7,280 4,020 10,920 2,100 16,480 4,020 20,120 4,020 23,760 4,020 27,400 2,100 32,960 4,020 36,600 4,020 40,240 4,020 43,880 2,100 49,440 Total 91,920 0 0 0 0 0 91,920 0 0 5,280 0 0 480 17,280 0 0 0 0 0 0 0 0 0 12,960 0 3,600 0 0 2,880 0 0 0 42,480 0 0 0 0 0 42,480 Cash Flow Projection [Company Name] 60,000 50,000 40,000 Cash on Hand 30,000 20,000 10,000 0 Period Cash balance alert minimum $ - Projection y Name] Cash Flow Projection Cash on Hand Minimum Alert

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!