BGV the maker of industrial liquidating agent is preparing the budget for 2023. The sales department...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
BGV the maker of industrial liquidating agent is preparing the budget for 2023. The sales department has indicated the annual sales of 32,000 units and the selling price to be set at RM100 per unit. The sales department have estimated that the bulk of the sales will be in the 2nd and 3rd quarter of the year. For the 1st quarter, sales will be 20% of the annual sales, the 2nd and 3rd Quarter, sales will be 30% and 40% respectively while for remaining will be in the 4th Quarter. Customers always pay 90% of their purchases within the same quarter and the remaining amount in the next quarter. The company intends to have an inventory of finished products of 1,500 units at the end of the budget year. Each quarter will also require an ending finished inventory in order not to be in a situation of a stock out. Each product requires 3kg of raw materials and 4 hours of labour time to complete. The raw material is RM10 per kg and workers are paid RM7 per hour. The production department intends to have 5,000 kg of raw materials at the end of the budget year. Each quarter will also require an ending inventory as a precaution against any shortages in the supply of raw materials. The production requires variable overheads that is set based on direct labour hours. The predetermined rate is RM1.50 per direct labour hour. Annual Fixed Overhead expenses are as follows:- a. Factory Rent RM 120,000 b. Depreciation for machines RM 30,000 C. Factory Maintenance and Cleaning RM 60,000 Other non-manufacturing expenses annually are as follows:- a. Advertising RM 150,000 b. Salaries RM 360,000 C. Office Expenses RM 30,000 d. Depreciation for office equipment is RM 40,000 e. Rent of the administration building is RM 60,000 Additional information The company will be paying the 2022 tax payable in the 2nd Quarter of 2023. An equipment will be purchased in the 1st Quarter at a cost of RM 250,000. Principal payment to reduce the Non-Current Liabilities will be made at every quarter. The amount is RM12,500 every quarter. The interest payment of RM12,000 will also be paid every quarter. Interest rate for any short-term loans will be 8% and the loan has to be settled within the same year that it is made. Dividends will be paid on the 4th Quarter. It was suggested that dividend amount is RM70,000. a. b. C. d. f. The number of ordinary shares is 1 million units. In 2022, the average share price is RM1.20. The average industry PE ratio is 6 times. INCOME STATEMENT Sales Cost of Goods Sold Gross Margin Selling and Administration Expense EBITDA Depreciation EBIT Interest Expense Earning Before Tax Corporate Tax Net Income Previous Retain Earnings Add: Net Income Less: Dividends New Retain Earnings 2022 2,500,000 1,650,000 850,000 540,000 310,000 25,000 285,000 48,000 237,000 59,250 177,750 207,250 177,750 50,000 335,000.0 BALANCE SHEET Current Assets Cash Trade Receivables Raw Materials Inventories Total Current Assets Land Plant and Machines Less: Accumulated Depreciation Plant and Machines Net TOTAL ASSETS Current Liabilities Trades Payable Taxes Payable Total Current Liabilities Non-Current Liabilities Stock Holders' Equity Common Stock Retained Earnings Total Equity TOTAL LIABILITIES AND EQUITY Required: a. b. C. 2022 49,250 70,000 80,000 200,000 399,250 1,000,000 1,645,000 900,000 745,000 2,144,250 150,000 59,250 209,250 600,000 1,000,000 335,000 1,335,000 2,144,250 Prepare a complete Master Budget for 2023. Clarify the assumptions and decisions that you have made in preparing the budget. Prepare a performance analysis on the budget which include financial ratio analysis, economic value-added analysis, and market value analysis, between 2022 and the budget. BGV the maker of industrial liquidating agent is preparing the budget for 2023. The sales department has indicated the annual sales of 32,000 units and the selling price to be set at RM100 per unit. The sales department have estimated that the bulk of the sales will be in the 2nd and 3rd quarter of the year. For the 1st quarter, sales will be 20% of the annual sales, the 2nd and 3rd Quarter, sales will be 30% and 40% respectively while for remaining will be in the 4th Quarter. Customers always pay 90% of their purchases within the same quarter and the remaining amount in the next quarter. The company intends to have an inventory of finished products of 1,500 units at the end of the budget year. Each quarter will also require an ending finished inventory in order not to be in a situation of a stock out. Each product requires 3kg of raw materials and 4 hours of labour time to complete. The raw material is RM10 per kg and workers are paid RM7 per hour. The production department intends to have 5,000 kg of raw materials at the end of the budget year. Each quarter will also require an ending inventory as a precaution against any shortages in the supply of raw materials. The production requires variable overheads that is set based on direct labour hours. The predetermined rate is RM1.50 per direct labour hour. Annual Fixed Overhead expenses are as follows:- a. Factory Rent RM 120,000 b. Depreciation for machines RM 30,000 C. Factory Maintenance and Cleaning RM 60,000 Other non-manufacturing expenses annually are as follows:- a. Advertising RM 150,000 b. Salaries RM 360,000 C. Office Expenses RM 30,000 d. Depreciation for office equipment is RM 40,000 e. Rent of the administration building is RM 60,000 Additional information The company will be paying the 2022 tax payable in the 2nd Quarter of 2023. An equipment will be purchased in the 1st Quarter at a cost of RM 250,000. Principal payment to reduce the Non-Current Liabilities will be made at every quarter. The amount is RM12,500 every quarter. The interest payment of RM12,000 will also be paid every quarter. Interest rate for any short-term loans will be 8% and the loan has to be settled within the same year that it is made. Dividends will be paid on the 4th Quarter. It was suggested that dividend amount is RM70,000. a. b. C. d. f. The number of ordinary shares is 1 million units. In 2022, the average share price is RM1.20. The average industry PE ratio is 6 times. INCOME STATEMENT Sales Cost of Goods Sold Gross Margin Selling and Administration Expense EBITDA Depreciation EBIT Interest Expense Earning Before Tax Corporate Tax Net Income Previous Retain Earnings Add: Net Income Less: Dividends New Retain Earnings 2022 2,500,000 1,650,000 850,000 540,000 310,000 25,000 285,000 48,000 237,000 59,250 177,750 207,250 177,750 50,000 335,000.0 BALANCE SHEET Current Assets Cash Trade Receivables Raw Materials Inventories Total Current Assets Land Plant and Machines Less: Accumulated Depreciation Plant and Machines Net TOTAL ASSETS Current Liabilities Trades Payable Taxes Payable Total Current Liabilities Non-Current Liabilities Stock Holders' Equity Common Stock Retained Earnings Total Equity TOTAL LIABILITIES AND EQUITY Required: a. b. C. 2022 49,250 70,000 80,000 200,000 399,250 1,000,000 1,645,000 900,000 745,000 2,144,250 150,000 59,250 209,250 600,000 1,000,000 335,000 1,335,000 2,144,250 Prepare a complete Master Budget for 2023. Clarify the assumptions and decisions that you have made in preparing the budget. Prepare a performance analysis on the budget which include financial ratio analysis, economic value-added analysis, and market value analysis, between 2022 and the budget.
Expert Answer:
Answer rating: 100% (QA)
SOLUTION a Complete Master Budget for 2023 Sales Budget 1st Quarter 20 of 32000 units 6400 units 2nd Quarter 30 of 32000 units 9600 units 3rd Quarter 40 of 32000 units 12800 units 4th Quarter Remainin... View the full answer
Related Book For
Cost Accounting A Managerial Emphasis
ISBN: 978-0133392883
6th Canadian edition
Authors: Horngren, Srikant Datar, George Foster, Madhav Rajan, Christ
Posted Date:
Students also viewed these management leadership questions
-
The company is preparing its budget for the coming year, 2017. The first step is to plan for the first quarter of that coming year. The following information has been gathered from their managers....
-
The City of Weston is preparing it's budget for the calendar year 2020. After estimating revenues from all other sources, the City calculates that it must raise $7,000,000 from property taxes. You...
-
South Coast University is preparing its budget for the upcoming academic year. This is a specialised private university that charges fees for all degree courses. Currently, 15 000 students are...
-
Outline the traditional problems associated with the flat- file model that are resolved by the database model.
-
The following jobs are waiting to be processed at Julie Morels machine center: In what sequence would the jobs be ranted according to the following rules: (a) FCFS, (b) EDD, (c) SPT (d) LPT? All...
-
Consider the following scenarios: To assist the sale of your products in a particular foreign market, it is suggested that you pay a 10 percent commission to a go-between who has access to high...
-
What is a Problem Space?
-
The following report was prepared for evaluating the performance of the plant manager of Farrar Inc., Evaluate and correct this report. Farrar Inc. Manufacturing Costs For the Quarter Ended June 30,...
-
Stock X had a return of 7.00% last year. Stocks Y and Z earned -3.00% and 11.10% respectively. The following table shows 3 portfolios: A, B, and C. What is the portfolio return under the following...
-
Bestseller Book's binding department has beginning inventory of 5,000 units and $20,000, consisting of $10,000 of direct materials and $10,000 of conversion costs. During the period, the department...
-
Which of the following pertaining to cash equivalents is false? Multiple Choice O They include long-term investments. O They must usually be within three months of their due date. They are readily...
-
The structure that converts light into usable neural messages is called the __________.
-
The purpose of the eardrum is to protect the sensitive nerves underneath it. It serves no purpose in actual hearing. True or false?
-
Which of the following statements are true? A. A two-node RAC database consists of two copies of the database files. B. A two-node RAC database consists of one shared copy of the database files. C. A...
-
One of your instructors has complied with your urgent request for a letter of recommendation and has given you an enthusiastic endorsement. Regardless of the outcome of your application, you owe...
-
__________theory states that there are three types of cones in the retina, each of which responds primarily to a different color.
-
Financial market are generally classified in the following ways except ....... A. By jurisdiction o B. By timing of delivery C. By maturity of claim D. By nature of financial claim
-
Juarez worked for Westarz Homes at construction sites for five years. Bever was a superintendent at construction sites, supervising subcontractors and moving trash from sites to landfills. He...
-
Byrd Company is a manufacturer of appliances for both residential and commercial use. The companys accounting and financial reporting system is primarily designed to meet external reporting...
-
Ronowski Company has three product lines of belts, A, B, and C, with contribution margin s of $3.60, $2.40, and $1.20 respectively. The president forecasts sales of 200,000 units in the coming...
-
Domestic Engines Company produces the same power generators in two plants, a newly renovated, automated plant in Peona, and an older, less automated plant in Modine. The following data are available...
-
What are some reasons a potential prospect might not be readily accessible? How far should you go to try to overcome such an accessibility problem before you move to the next lead?
-
List three or four criteria you could use to qualify a lead as a likely prospect. How would you find out if the lead meets these criteria?
-
Who is currently in your own network that you could use for prospecting? How might you add to your network?
Study smarter with the SolutionInn App