Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. EAST WEST Trading is one of the leading business in the GCC. The company presently is in import of goods from Iran since last

image text in transcribed

4. EAST WEST Trading is one of the leading business in the GCC. The company presently is in import of goods from Iran since last twenty years. The company is expanding its operation in a new region in the GCC for which it wants to some estimates for the project. You have been assigned the task of making the projection for the cash based on the expected sales and other expense. Material : Suppliers for the purchases are paid 60% in the month of purchase and the balance in the following month. There is no opening inventory. However it is the companys policy to hold inventory at the end of the month equal to 25% of the following months sales. The material cost includes the cost of special components that will be bought in from other manufacturer. Wages: will be paid in the same month of production. Variable Overhead Expense: 65% of the expense will be paid in the month of production and the remainder will be paid one month later. Fixed Overhead expense: Fixed overheads are estimated at OMR 120,000 per annum and are expected to be incurred in equal amounts each month. 60% of the fixed overhead costs will be paid in the month in which they are incurred and 25% in the following month. The balance represents depreciation of noncurrent assets. Selling and Distribution Expense will be paid in the one month in arrears. Cash balance on 1st May 2020 is expected to be RO 122,500. Company pays interest on Debentures of RO 6000 in March and September each year Company will purchase Bus for staff in June 2020 at a cost of RO 45,000 on installment basis. The monthly Installment of RO 3,000 is payable from July 2020 onwards. The details of expected sales are given below The balance represent anticipated bad debt. Material cost is 35% of the sale value for the month. Wages will be are 25 % of the sales for the month. Variable Overhead Expense will be 5% of the

image text in transcribed

sales for the month Selling and Distribution Expense will be 10 % of the sales for the month Advance Income tax of OMR 70,000 is due to be paid in November 2020. Dividend on Investment OMR 6,000 is to be received in December 2020 Required: -Prepare a cash budget for the month of May2020 to and April 2021 using MS Excel.

4. FAST WEST was. These preply by the and deplong. The concluded pochwy PedOveral Tood verticale was pecud to be incredincipal achers of the overhead cont will be paid in this which they card 2 The balance de ces Copy paste Manched September nacho Company will purchase Bride 2.000 45.000 cc bude. The wady legybelyde 2.0.0 STIR VIS March Apa Vey wer su STIR 2 ST A 27 AI les cherche pour les To 30 . Mura 3 otheke wote wa ved en les to be meine 302 Required: -Preparacial data they and Apel 20 M monthly Installment of RO 3,000 is payable from July 2020 onwards. The details of expected sales are given below Sales Months Sales Months March April May June July August September 2,970,000 3,267,000 3,118,500 2,821,500 2,776,950 2.979,900 3,575,880 October November December Jan-21 Feb-21 Mar-21 Apr-21 3.718,915 3,891,531 3,347,024 3,297,288 3,347,559 3,595,000 3,434,500 Sales Receipts Sales will be mainly through large retail outlets. The pattern for the receipts from sales will be as Time of receipt % of Sales Value 10 30 Immediately One month later Two month later Three month later 30 20 4. FAST WEST was. These preply by the and deplong. The concluded pochwy PedOveral Tood verticale was pecud to be incredincipal achers of the overhead cont will be paid in this which they card 2 The balance de ces Copy paste Manched September nacho Company will purchase Bride 2.000 45.000 cc bude. The wady legybelyde 2.0.0 STIR VIS March Apa Vey wer su STIR 2 ST A 27 AI les cherche pour les To 30 . Mura 3 otheke wote wa ved en les to be meine 302 Required: -Preparacial data they and Apel 20 M monthly Installment of RO 3,000 is payable from July 2020 onwards. The details of expected sales are given below Sales Months Sales Months March April May June July August September 2,970,000 3,267,000 3,118,500 2,821,500 2,776,950 2.979,900 3,575,880 October November December Jan-21 Feb-21 Mar-21 Apr-21 3.718,915 3,891,531 3,347,024 3,297,288 3,347,559 3,595,000 3,434,500 Sales Receipts Sales will be mainly through large retail outlets. The pattern for the receipts from sales will be as Time of receipt % of Sales Value 10 30 Immediately One month later Two month later Three month later 30 20

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

GAO Financial Audit Manual Volume 1 Updated April 2020

Authors: United States Government GAO

2020 Edition

B091PR8396, 979-8733135977

More Books

Students also viewed these Accounting questions

Question

Describe the patterns of business communication.

Answered: 1 week ago

Question

3. Provide two explanations for the effects of mass media

Answered: 1 week ago