Refer to the projected sales that you have calculated. Prepare a Production Budget for $3$ months ending September $2019$ and total for the quarter of $2019.$ The company's inventory at the end of each month must equal $20\%$ of next month's sales. On June $30,2019,$ inventory balance was $6,000$ units. $[10$ Marks$]$

Prepare a Direct Materials Purchase Budget in quantity and in dollar amounts for $3$ months ending September $2019$ and total for the quarter of $2019$ based on the production budget above. One unit of product requires $8$ ounces of materials and the company's policy is to maintain an ending inventory of materials equal to $30\%$ of next month's production needs. Each ounce of direct materials cost AED $3\mathrm{.}50.$ June $31,2019$ inventory balance was $48,000$ ounces. $[16$ marks$]$

Assuming that the company's policy is to pay $70\%$ of each month's cost of materials purchases in the same month and $30\%$ in the month after, prepare a Cash Disbursement $($cash payment$)$ schedule for $3$ months ending September $2019$ and total for the quarter of $2019.$ The accounts payable balance at the end of June $2019$ was AED $148,000.[17$ Marks$]$

$2$

The following are the projected cash expenditures for $2019$ in AED:

$\backslash$table$[[,$July,Sugust,Oct.,$],[\backslash$table$[[$Manufacturing$],[$Overhead$]],76,000,79,000,93,000,101,000],[$Selling Expense,$49,000,53,000,41,000,73,000],[\backslash$table$[[$Administrative$],[$Expense$]],163,000,161,000,169,000,182,000],[$Direct Labor,$90,000,111,000,132,000,120,000],[\backslash$table$[[$Equipment$],[$purchase$]],,100,000,300,000,600,000]]$

On June $30,2019,$ the company had a cash balance of AED $136,000$ on hand. The company has an arrangement with their bank to have a bank overdraft policy of maximum AED $250,000$ as and when needed and borrows in the nearest $\text{'}000s.$ The interest on the overdraft is $1\mathrm{.}2\%$ per month and paid at the time of loan repayment. The company also have a policy of maintaining a minimum cash balance of AED $100,000$ at the end of each month.Can someone please solve it