Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need solution part 6 please Al Khaleej Automobile Company is a manufacturer and seller of automobile products. Information on actual and projected sales in

I need solution part 6 please

image text in transcribed

image text in transcribed

Al Khaleej Automobile Company is a manufacturer and seller of automobile 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 September 2019 (budget) October 2019 (budget) November 2019 (budget) December 2019 (Budget) January 2020 (budget) 45,000 40,000 25,000 20,000 34,000 Required: 1. Prepare a Sales budget in units and dirham for the months of October to December 2019 and for the quarter in total. The selling price per unit is AED 50. [5 Marks] 2. Assume that the company collects 60% of its sales in the month of the sale, 40% in the month following the sale. Prepare a Cash Receipts schedule for 3 months ending December 2019 and total for the last two quarters of 2019. Accounts Receivable balance as of September 30, 2019 was AED 900,000. [15 Marks] 3. Refer to the projected sales that you have calculated. Prepare a Production Budget for 3 months ending December 2019 and total for the last quarter of 2019. The company's inventory at the end of each month must equal 20% of next month's sales. On September 30, 2019, inventory balance was 8,000 units. [10 Marks] 4. Prepare a Direct Materials Purchase Budget in quantity and in dollar amounts for 3 months ending December 2019 and total for the last 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.50. September 30, 2019 inventory balance was 88,800 ounces. [16 marks] 5. 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 December 2019 and total for the last quarter of 2019. The accounts payable balance at the end of September 2019 was AED 351,960. [17 Marks] 6. The following are the projected cash expenditures for 2019 in AED: Sept. Oct. Nov. Dec. 93,000 101,000 90,000 59,000 Manufacturin g Overhead 41,000 73,000 44,000 42,000 Selling Expense 169,000 182,000 150,000 147,000 Administrativ e Expense Direct Labor 132,000 120,000 90,000 90,000 300,000 600,000 Equipment purchase On September 30, 2019, the company had a cash balance of AED 147,840 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 '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. In November, the company plans to pay a dividend of AED 300,000. 7. Prepare a Cash Budget for the last 3 months of 2019. [30 Marks)

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_2

Step: 3

blur-text-image_3

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

More Books

Students also viewed these Accounting questions

Question

Find the derivative. f(x) 8 3 4 mix X O 4 x32 4 x32 3 -4x - x2

Answered: 1 week ago

Question

7. Identify six intercultural communication dialectics.

Answered: 1 week ago