Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question ! Maestro Sdn. Bhd. is a manufacturer of food products located in West Malaysia. The company is preparing its sales and purchase budget for

image text in transcribed

image text in transcribed

Question ! Maestro Sdn. Bhd. is a manufacturer of food products located in West Malaysia. The company is preparing its sales and purchase budget for the period of five months namely March, April, May, June, and July 2019. Listed below are the additional information given by the company: (i) Sales for the month of January and February 2019 were 20,000 and 22,000 units respectively. (ii) From the month of March 2019 onwards, each month sales unit are expected to be increased by 10 per cent from the previous month sales. Sales price per unit was at USDIO. (11 i) Cash sales is 70 per cent and the balance is credit sales. 80 per cent of the credit sales will be collected one month after the sales while balance of 20 per cent will be collected two months after sales. (iv) The cost of goods sold is estimated to be 40 per cent from each month sales figure. The company wish to have its closing inventory for each month at 30 per cent from the estimated cost of goods sold of the next month. (v) The company has agreed to pay its supplier on a 60 per cent basis and the balance will be paid next month. (vi) 2 per cent cash discount is further deducted for the 70 per cent cash collected. (vii) 1 per cent cash discount is further received for the 60 per cent purchases payment made. (viii) The currency exchange from January until September are given on a quarterly basis as per below table. Refer Below - Table I : Currency Exchange Rate USD/RM. Table 1: Currency Exchange Rate USD/RM Quarter Exchange Rate Quarter 1 (Jan - Mac) RM4.10 Quarter 2 (Apr June) RM4.15 Quarter 3 (July Sept) RM4.20 Quarter 4 (Oct - Dec) RM4.25 (a) Prepare a sales budget, cash collection schedule, purchase budget and purchase payment schedule in RM value for the month of March until July 2019 by using the given template below. Table 2: Budget Templates Sales Budget Template March April May June July Sales (Unit) Sales (RM) Cash Collection Schedule Template March April May June July Cash Sales Collection (70%) Credit Sales Collection 1 (80%) Credit Sales Collection 2 (20%) Total Collection Purchase Budget Template March April May June July Sales (RM) Cost of Goods Sold Closing Inventory Opening Inventory Total Purchases Purchase Payment Schedule Template March April May June July Purchases (RM) Purchase Payment 1 Purchase Payment 2 Total Payment

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

Auditing IT Infrastructures For Compliance

Authors: Robert Johnson, Marty Weiss, Michael G. Solomon

3rd Edition

1284236609, 9781284236606

More Books

Students also viewed these Accounting questions

Question

Describe some common hazards in the contemporary workplace

Answered: 1 week ago