Question
Al Rahmani Dairy Company is a manufacturer and seller of dairy products.Information on actual and projected sales in units is given below for the Use
Al Rahmani Dairy Company is a manufacturer and seller of dairy products.Information on actual and projected sales in units is given below for the Use this information to answer all parts of question one.
Month | Units | |
July2021(budget) | 24,000 | |
August2021 (budget) | 35,000 | |
September2021 (budget) | 45,000 | |
October2021(budget) | 40,000 | |
November2021(budget) | 25,000 | |
Required: |
- do aSalesbudgetinunitsanddirhamforthemonthsofJulytoSeptember2021 and for the quarter in total. The selling price per unit is AED 50.
- Assume that the company collects 60% of its sales in the month of the sale, 40% in themonthfollowingthesale.make CashReceiptsschedulefor3monthsending September2021andtotalforthequarterof2021. AccountsReceivablebalanceasof June 30, 2021 was AED 240,000.
- Refer to the projected sales that you have calculated. Prepare a Production Budgetfor3monthsendingSeptember2021andtotalforthequarterof2021.Thecompany's inventory at the end of each month must equal 20% of next month's sales. On June 30, 2021, inventory balance was 6,000 units.
- do aDirectMaterialsPurchaseBudgetinquantityandindollaramountsfor3 months ending September 2021 and total for the quarter of 2021 based on the production budget above. One unit of product requires 8 ounces of materials and the company'spolicyistomaintainanendinginventoryofmaterialsequalto30%ofnext month's production needs. Each ounce of direct materials cost AED 3.50. June 31, 2021 inventory balance was 48,000 ounces.
5. Assumingthat thecompany's policyis to pay70% ofeach month's cost ofmaterials purchases in the same month and 30% in the month after, prepare a Cash Disbursement (cash payment) schedulefor 3 months ending September 2021 and total for the quarter of 2021. The accounts payable balance at the end of June 2021 was AED 148,000.
6. Thefollowingaretheprojectedcashexpendituresfor2021in AED:
July | August | Sept. | Oct. | |
Manufacturing Overhead | 76,000 | 79,000 | 93,000 | 101,000 |
Selling Expense | 49,000 | 53,000 | 41,000 | 73,000 |
Administrative Expense | 163,000 | 161,000 | 169,000 | 182,000 |
DirectLabor | 90,000 | 111,000 | 132,000 | 120,000 |
Equipment purchase | 100,000 | 300,000 | 600,000 |
OnJune30,2021,thecompanyhadacashbalanceofAED136,000onhand.Thecompanyhas 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 '000s. The interest on the overdraft is 1.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.
PrepareaCashBudget forthethird quarterof 2021.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started