Question

In: Accounting

Question 1 Delicious Catering Supply sells various equipment and supplies to restaurants in the local and...

Question 1
Delicious Catering Supply sells various equipment and supplies to restaurants in the local and surrounding communities. The company’s executive, Encik Haziq Azim, has requested your help in preparing a cash budget for the month of May & June. Encik Haziq Azim accumulated the following information for you:

i. The cash balance at May 1 was estimated to be RM80,000.

ii. Actual sales of April and May and budgeted sales for June are as follows:
April
RM May
RM June
RM
Cash sales 120,000 110,000 105,000
Credit sales 180,000 240,000 300,000
Total sales 300,000 350,000 405,000

iii. Credit sales are collected over a two-month period. With 60% being collected in the first month and the remainder being collected in the second month.

iv. The purchases are made of 70% total sales for the current month. All purchases are paid in full in the same month of purchases.

v. Selling and administrative expenses are budgeted to be RM50,000 for each month which are included RM500 of depreciation.

vi. Equipment costing RM90,000 will be purchased in June by cash.

vii. Dividends of RM21,000 will be paid out in June.


Required:

a) Explain the THREE (3) main advantages of budgeting.                                 

b) Prepare a schedule of collection for the month of May & June.                      

c) Prepare a schedule of payment for the month of May & June.                       

d) Prepare cash budget for the month of May & June.   

Solutions

Expert Solution


Related Solutions

Question 1 Delicious Catering Supply sells various equipment and supplies to restaurants in the local and...
Question 1 Delicious Catering Supply sells various equipment and supplies to restaurants in the local and surrounding communities. The company’s executive, Encik Haziq Azim, has requested your help in preparing a cash budget for the month of May & June. Encik Haziq Azim accumulated the following information for you: (i) The cash balance at May 1 was estimated to be RM80,000. (ii) Actual sales of April and May and budgeted sales for June are as follows: April RM May RM...
Question 1 Steel Restaurant Supply sells various equipment and supplies to restaurants in the local and...
Question 1 Steel Restaurant Supply sells various equipment and supplies to restaurants in the local and surrounding communities. The company’s executive, Mr. Daniel, has requested your help in preparing a cash budget for the month of May and June. Mr. Daniel accumulated the following information for you. 1. The cash balance at May 1 was estimated to be RM120,000. 2. Actual sales of April and budgeted sales for May and June are as follows: April May June Actual Budgeted RM...
Question 1 Steel Restaurant Supply sells various equipment and supplies to restaurants in the local and...
Question 1 Steel Restaurant Supply sells various equipment and supplies to restaurants in the local and surrounding communities. The company’s executive, Mr. Daniel, has requested your help in preparing a cash budget for the month of May and June. Mr. Daniel accumulated the following information for you. 1. The cash balance at May 1 was estimated to be RM120,000. 2. Actual sales of April and budgeted sales for May and June are as follows: April May June Actual Budgeted RM...
Jana Restaurant Supply sells various equipment and supplies to restaurants in the local and surrounding communities....
Jana Restaurant Supply sells various equipment and supplies to restaurants in the local and surrounding communities. The company’s executive, Mr. Hasan, has requested your help in preparing a cash budget for the month of June. Mr. Hassan accumulated the following information for you. 1. The cash balance at May 1 was estimated to be RM20,000. 2. Actual sales of April and May and budgeted sales for June are as follows: April (RM) May (RM) June (RM) Cash sales 33,000 31,000...
Support department cost allocation Hooligan Adventure Supply produces and sells various outdoor equipment. The Molding and...
Support department cost allocation Hooligan Adventure Supply produces and sells various outdoor equipment. The Molding and Assembly production departments are supported by the Personnel and Maintenance departments. Personnel costs are allocated to the production departments based on the number of employees, and Maintenance costs are allocated based on number of service calls. Information about these departments is detailed in the following table: Personnel Department Maintenance Department Molding Department Assembly Department Number of employees 28 10       41 49   ...
Chloe’s Cafe bakes croissants that it sells to local restaurants and grocery stores. The average costs...
Chloe’s Cafe bakes croissants that it sells to local restaurants and grocery stores. The average costs to bake the croissants are $0.30 for 3,100 and $0.25 for 6,200. Required: If the total cost function for croissants is linear, what will be the average cost to bake 5,400? (Do not round intermediate calculations. Round your final answer to 4 decimal places.) Average Cost =
Great Oaks Farm grows organic vegetables and sells them to local restaurants after processing. The farm’s...
Great Oaks Farm grows organic vegetables and sells them to local restaurants after processing. The farm’s leading product is Salad-in-a-Bag, which is a mixture of organic green salad ingredients prepared and ready to serve. The company sells a large bag to restaurants for $25. It calculates the variable cost per bag at $19 (including $1 for local delivery), and the average total cost per bag is $22. Because the vegetables are perishable and Great Oaks Farm is experiencing a large...
Markus Computer Company manufactures and sells or leases various types of computer equipment. On 1/1/20, Markus...
Markus Computer Company manufactures and sells or leases various types of computer equipment. On 1/1/20, Markus leased a complete                                                computer system to Bellis Enterprises. Data relating to the lease follow:                                                                                                     Cost of equipment to Markus               $72,000               ...
Markus Computer Company manufactures and sells or leases various types of computer equipment. On 1/1/20, Markus...
Markus Computer Company manufactures and sells or leases various types of computer equipment. On 1/1/20, Markus leased a complete                                                computer system to Bellis Enterprises. Data relating to the lease follow:                                                                                                     Cost of equipment to Markus               $72,000               ...
Alexis Computer Company manufactures and sells or leases various types of computer equipment. On 1/1/17, Alexis...
Alexis Computer Company manufactures and sells or leases various types of computer equipment. On 1/1/17, Alexis leased a complete computer system to Edgar Enterprises.  Data relating to the lease follow:                 Cost of equipment to Alexis                                       $ 80,000                 Fair market value of equipment at 1/1/17                   $ 98,000                 Useful life of equipment                                               8 years                 Lease term 5 years                 Residual value at the end of the lease                     (notguaranteed by Edgar)                                    $ 15,000                 Implicit and incremental interest rates                               10%                 Initial direct costs incurred in negotiation                    $   1,000 Both the lessor and lessee...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT