May April Question 1. Abdullah and Khalid have recently won a design award for their 'wooden box' storage and have established a company, AK Wooden box Ltd, to commence production of the storage box. The 'wooden box' storage have an innovative design. Abdullah has just read a newspaper article about the importance of cash budgets in highlighting the finances required for business operations. Consequently, he has asked for your assistance in preparing a cash budget for the first-year operations, from May 2020 to April 2021. The following information has been obtained from a planning meeting with the Khalid: Consider the following sales figures for a newly formed company that makes wooden boxes: August September October November December January February March OMR 300,000 400,000 550,000 600,000 750,000 870,000 480.000 350.000 250.000 200.000 500.000 Above figures are based on orders that customers have already placed with the company after considerable hard work by the sales team. In order to secure the orders, the sales team had to negotiate payment terms with the customers. Only 10% of customers agreed to pay immediately for the wooden boxes. Of the remaining customers, 60% agreed to pay after one month and 40% after two months. Within the wooden box industry it is known that 2% of credit customers never pay (because they go out of business or dispute the invoices) the AK Wooden box Ltd has made the decision to reduce the budgeted cash inflow from the credit customers who have to pay after two months to reflect this fact (making the percentage who pay after two month 38%). June OMR July OMR OMR OMR OMR OMR OMR OMR OMR OMR OMR Sale 550.000 If the AK Wooden box Ltd has a labour cost equal to 20% of the sales value a material cost equal to 55% of the sales value and an overhead cost equal to 15% of the sales value Consider that labour is paid one month in arrears. The material supplier will not allow the AK Wooden box Ltd any credit as because it is a newly formed company, it has no track record of paying its debts. The supplier of materials is also aware that new companies often fail and go out of business thus creating irrecoverable debt. Therefore, the supplier is insisting on cash at time of delivery for all materials purchased. However, the AK Wooden box Ltd must buy the materials before they can be made into boxes. The materials required for production must be purchased and paid for in the month prior to sale. Now let us consider the overhead. Overhead is paid for in the month in which it is incurred. Included in the overhead figures above is a OMR10,000 monthly charge for depreciation. Income tax of OMR. 30,000 is due to be paid on 20 January,2021. Company issues 20,000 shares @ OMR 1.500bz in the month of September, 2020 The company is to pay bonus to worker of OMR 250,000 in the month of Decenber,2020. Plant has been ordered and is expected to be received in month of September and paid in March 2021. It will be cost OMR 120,000. The cash balance at the beginning of is estimated to be OMR130,400 positive. Required: -Prepare a cash budget for the month of May2020 to and April 2021 using MS Excel. (10 Marks)