THE TRAVEL PHOTOGRAPH ANNUAL BUDGET: May June July August Sales 200 1,000 2,000 2,500 Cost of goods sold Supplies 40 200 400 500 Gross profit mar

profileFin-Acc-Boss
 (Not rated)
 (Not rated)
Chat

THE TRAVEL PHOTOGRAPH        
ANNUAL BUDGET:        
 May  June   July   August     
        
Sales  200      1,000      2,000      2,500        
        
Cost of goods sold        
Supplies  40      200      400      500        
        
Gross profit margin  160      800      1,600      2,000        
        
Prepare the cash flow budget considering the following elements:        
1- The photograph is always paid 30 days after the sale        
2- The photograph has to pay his supplies cash on delivery        
3- At the beginning of June the bank account amounts to  ($1,000); this means that he is using the line of credit        
THE FISHING POND -  Seasonal business       
       
  August   September   October   November   December   January   February
       
Sales  75,000      45,000      20,000      5,000      -      
       
Cost of goods sold       
Supplies  15,000      9,000      4,000      1,000      -      
Guides  22,500      13,500      6,000      1,500      -      
Total Cost of good sold  37,500      22,500      10,000      2,500      -      
       
Gross profit margin  37,500      22,500      10,000      2,500      -      
       
Operational Expenses  8,000      8,000      8,000      8,000      8,000      8,000      8,000   
       
Net profit  29,500      14,500      2,000      (5,500)     (8,000)     (8,000)     (8,000)  
       
Prepare the cash flow budget for September to December considering the following elements:       
1- Sales receipts       
a- On average, 20% of the sales are received 30 days before the sales as deposits       
b- On average,  80% of the sales are received on delivery       
2- The pond pays its supplies 30 days later       
3- The guides are paid the day of the sales       
4- The operational expenses are paid in the same month as the purchase       
5- The pond will purchase $5,000 worth of equipement in September       
6- The pond will contract a loan of $4,000 in September to pay for the equipment       
7- The pond will start reimbursing the loan in September at the amount of $115 per month       
8- At the beginning of September the bank account amounts to  $40, 000       
9- What is going to happen in January and February       
THE COUNTRY FESTIVAL      
The Festival takes place in August; it is in operation only from May to September      
      
  May   June   July   August   September  TOTAL
      
REVENUES      
Sales       -     
Stand rentals  5,000      10,000      20,000        35,000   
Entrance fees     50,000       50,000   
Grant from the municipality  80,000          80,000   
TOTAL REVENUES  85,000      10,000      20,000      50,000      -      165,000   
       -   
Cost of goods sold       -   
Cost of stands  3,000      6,000      12,000      -       21,000   
Other supplies  1,000      5,000      14,000      35,000      -      55,000   
Manpower  10,000      10,000      18,000      25,000      7,000      70,000   
Total Cost of good sold  14,000      21,000      44,000      60,000      7,000      146,000   
       -   
Gross profit margin  71,000      (11,000)     (24,000)     (10,000)     (7,000)     19,000   
       -   
Administration costs  4,000      4,000      4,000      6,000      1,000      19,000   
       -   
Net profit  67,000      (15,000)     (28,000)     (16,000)     (8,000)     -   
      
Prepare the cash flow budget for April to September considering the following elements:      
1- Stand receipts      
a- On average, 80% of the stand sales are received 30 days before the sales as deposits      
b- On average,  20% of the stand sales are received in August      
2- Half of the grant is received in May and the rest in September after the final reports      
3- The entrance fees are cash of course      
4- The costs of stands      
a- A deposit of $5,000 is paid in May for the stands reservation       
b- The final payment is done in July      
5- The other supplies are paid 30 days after the purchase      
6- The manpower is paid in the current month      
7- The administration expenses are paid 30 days after the purchase      
8- At the beginning of April the bank account amounts to $0      
9- What is going to happen in October      

    • 9 years ago