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
-
Sandhill, Inc.'s static budget at 3,000 units of production includes $12,990 for direct labor, $3,990 for utilities (variable), and total fixed costs of $25,000. Actual production and sales for the...
-
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...
-
Care facilities are expensive. Your mother wants a single room with her own bathroom. The annual estimated cost is $100,000, but your mother does not anticipate entering the facility for four years....
-
Best Buy is a specialty retailer of consumer electronics, including personal computers, entertainment software, and appliances. Best Buy operates retail stores in addition to the Best Buy, Media...
-
Question: Splash is a California corporation that develops resorts. Lawrence, a Splash owner-executive, is hoping to land a $700 million dollar contract with a developing country in Southeast Asia....
-
The budget director of Gourmet Grill Company requests estimates of sales, production and other operating data from the various administrative units every month. Selected information concerning sales...
-
An insurance policy sells for ?$600 Based on past? data, an average of 1 in 100 policyholders will file a ?$ 20,000 ?claim, an average of 1 in 250 policyholders will file a ?$ 50,000 ?clai...
-
Blue Angel Investors has a success ratio of 10% with its venture funding. Blue Angel requires a rate of return of 20% for its portfolio of lending, and the average length on its loan is five years....
-
Can you please me to understand how improvement rates are calculated using the below? The first unit took 10 hours and the fourth unit 8.1 hours. What is the improvement rate?
-
Applying Castellano's Model of Employee Engagement , analyze the root causes of the HILL's problem and their manifestation.
-
What exactly are the differences you noted between the TV series and the novel? Why do you suppose these differences exist--and how do they help us understand Dexter in different ways. Essentially,...
-
CPA Exam Adapted: A company purchased a computer on May 1, for $12,000 with an estimated salvage value of $1,500 and a 3-year life. What is the depreciation expense for the year ended December 31,...
-
Does bad faith exist in a distributive bargaining scenario? For instance, when selective presentation is used, does it ever become an exercise in bad faith?
-
sales are $ 5 0 0 , 0 0 0 , variable costs are $ 2 0 0 , 0 0 0 , and fixed costs are $ 2 4 0 , 0 0 0 , what is the contribution margin ratio?
-
build a system of management indicators that support a digital program (internet, landing pages, social media, virtual store, etc. for building brand value)
-
A number of years ago the United Food and Commercial Workers Union organized 800 workers of the 1035 employees at one of the Wilson Brothers food operations in Toronto, Ontario. The employees include...
-
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...
-
Use the exponent distributive rule to expand \((2 \times 19)^{14}\).
-
Simplify the following: 1. \(\left(\frac{7^{9}}{10^{5} \times 6^{3}} ight)^{8}\) 2. \(\left(\frac{4}{a^{9} b^{6}} ight)^{2}\)
-
Use negative exponents to rewrite the following expressions with no denominator: 1. \(\frac{6^{3}}{13^{8}}\) 2. \(\frac{c^{5}}{2^{9}}\)
Study smarter with the SolutionInn App