Answered step by step
Verified Expert Solution
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
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
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