Pelangi Water Pot Sdn Bhd sells water filter and its components for domestic and commercial uses....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Pelangi Water Pot Sdn Bhd sells water filter and its components for domestic and commercial uses. The company management would like to prepare budgets for a period of 4 months. Below is the relevant information for a four-month period: 1. All sales are on account. Collections from customers are scheduled according to the following percentages of sales: in the month of sales...... in the first month after sales • in the second month after sales 2. The company determines the desired ending inventory level at 60% of the following month's sales. Cost of goods sold for each month is equal to RM20,000 plus 50% of total sales of the current month. All purchases are made on account, and the payments will be made accord- ing to the following percentages: . • one month after purchases two months after purchase 3. Estimated monthly expenses to be incurred: . Promotions and advertising • Depreciation • Insurance • Employees salaries. • Sales commissions 4. Actual and forecasted sales according to months: • November 2018 (actual) December 2018 (actual) . January 2019. February 2019 . . • March 2019 • April 2019 May 2019 40% 30% .. 30% . . 40% 60% RM5,000 . RM1,500 ... RM600 RM3,500 12% of Sales RM250,000 RM300,000 RM330,000 RM450,000 RM550,000 RM600,000 RM660,000 Instructions Prepare the followings for the months of January through April, 2019: a. Sales budget b. Schedule of cash collections from customers c. Purchases, ending inventory and cost of goods sold budgets d. Schedule of payments for purchases e. Operating expenses budget f. Statement of Profit or Loss Budget Pelangi Water Pot Sdn Bhd sells water filter and its components for domestic and commercial uses. The company management would like to prepare budgets for a period of 4 months. Below is the relevant information for a four-month period: 1. All sales are on account. Collections from customers are scheduled according to the following percentages of sales: in the month of sales...... in the first month after sales • in the second month after sales 2. The company determines the desired ending inventory level at 60% of the following month's sales. Cost of goods sold for each month is equal to RM20,000 plus 50% of total sales of the current month. All purchases are made on account, and the payments will be made accord- ing to the following percentages: . • one month after purchases two months after purchase 3. Estimated monthly expenses to be incurred: . Promotions and advertising • Depreciation • Insurance • Employees salaries. • Sales commissions 4. Actual and forecasted sales according to months: • November 2018 (actual) December 2018 (actual) . January 2019. February 2019 . . • March 2019 • April 2019 May 2019 40% 30% .. 30% . . 40% 60% RM5,000 . RM1,500 ... RM600 RM3,500 12% of Sales RM250,000 RM300,000 RM330,000 RM450,000 RM550,000 RM600,000 RM660,000 Instructions Prepare the followings for the months of January through April, 2019: a. Sales budget b. Schedule of cash collections from customers c. Purchases, ending inventory and cost of goods sold budgets d. Schedule of payments for purchases e. Operating expenses budget f. Statement of Profit or Loss Budget
Expert Answer:
Answer rating: 100% (QA)
Here are the budgets for January to April 2019 a Sales Budget Jan RM330000 Feb RM450000 Mar RM550000 ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Rice Products Pty. Ltd. is a local firm that produces two moulded plastic products: kickboards and pool buoys. The products are manufactured in a two step process and each process is treated as a...
-
3. Calculate the work done, W=mgh for a mass of 300 g. Then, using the accepted value for the specific heat of water, calculate the change in heat, Q=cmAT for the same data point. a) Calculate the...
-
Write a method to take an integer array as a parameter and return how many elements having the same digits in each element in the array for example if we have array 1 1 , 4 4 , 1 4 , 2 3 , 1 2 , 5 6...
-
What happens to light when it falls on a material that has a natural frequency equal to the frequency of the light?
-
Use the magnitudes of the earthquakes listed in Data Set 21 Earthquakes and test the claim that the sample is from a population with a mean greater than 2.50. Use a 0.01 significance level. Use the...
-
What are the various types of pulley used for flat belt?
-
Suppose a Corse store in Kansas City, Missouri, ended May 2012 with 700,000 units of merchandise that cost an average of $6 each. Suppose the store then sold 650,000 units for $8,450,000 during June....
-
Encouraging team productivity can be a major issue in many organizations. Inclusive and Exclusive are the two common management styles most organizations exhibit. Discuss the effectiveness or...
-
S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments...
-
8. Researchers study the effect of distracted driving on driving behavior. Driving behavior is measured by the number of mistakes recorded on a simulator. There are 36 participants who are randomly...
-
How do Reports and Proposals adapt to diverse cultural contexts and linguistic frameworks to foster inclusivity and global relevance ?
-
Kubin Company s relevant range of production is 1 9 , 0 0 0 to 2 0 , 0 0 0 units. When it produces and sells 1 9 , 5 0 0 units, its average costs per unit are as follows: Average Cost per Unit Direct...
-
A user powers on a device and begins searching for a familiar SSID. To what kind of network is the user attempting to connect?
-
A soccer player performs a penalty kick. From a stationary static position, they run towards the ball and kick it towards the goal. Explain with as much detail as possible which biomechanical...
-
14 Samira wants to compare the heights of boys and girls when they are 14 years old. (a) She takes a random sample of five boys from the local running club and five girls from her class at school....
-
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company's costs: Fixed Cost Cost per Car...
-
The sales department of P. Gillen Manufacturing Company has forecast sales in March to be 20,000 units. Additional information follows: Finished goods inventory, March 1 . . . . . . . . . . . . . . ....
-
Jerico Beverages manufactures its own soda pop bottles. The bottles are made from polyethylene terephthalate (PET), a lightweight yet strong plastic. The company uses as much PET recycled resin...
-
The Ohio State Fair is one of the largest state fairs in the United States. It draws nearly one million visitors over the twelve-day period each July and August. The fair is a nonprofit organization....
-
McIntyre Industries manufactures iPhone case covers. Sarabeth Anderson, the CEO, is trying to decide whether to adopt a lean thinking model. She expects that adopting lean production would save...
-
Obtain the quasi steady lift coefficient, Eq. 8.51, and the boundary layer edge velocity, Eq. 8.52 for a chordwise flexible and parabolically cambered thin airfoil whose equation is given by Eq....
-
Derive the equations of continuity, Eq. 8.44, and the vorticity transport, Eq. 8.45, for skewed coordinates as shown in Fig. 8.38. Eq. 8.44 Eq. 8.45 Fig. 8.38 de = tan -[-(h+WaLE) /U]
-
Obtain the time dependent but steady lift coefficient, Eq. 8.48, and the boundary layer edge velocity, Eq. 8.49 for a chordwise flexible parabolically cambered thin airfoil whose equation is given by...
Study smarter with the SolutionInn App