Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

  1. do aSalesbudgetinunitsanddirhamforthemonthsofJulytoSeptember2021 and for the quarter in total. The selling price per unit is AED 50.
  2. 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.
  3. 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.
  4. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones of Managerial Accounting

Authors: Maryanne Mowen, Don Hanson, Dan Heitger, David McConomy, Bradley Witt, Jeffrey Pittman

3rd Canadian edition

176530886, 176721231, 978-0176721237

More Books

Students also viewed these Accounting questions

Question

6. How can a message directly influence the interpreter?

Answered: 1 week ago