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.
-
Explain why categorizing fixed asset expenditures as expenses or capital assets is important.
-
Consider the lynx data available in the \(\mathrm{R}\) package tsDyn. These data consist of annual totals of Canadian lynx trapped in the Mackenzie River district of NW Canada during 1821-1934....
-
Purina entered in a contract with the defendant to sell the defendant piglets, known as weanlingsbaby pigs that have been weaned. It is uncontested that the buyer breached and that Purina is entitled...
-
Ashkar Company ordered a machine on January 1, 2012, at an invoice price of $21,000. On the date of delivery, January 2, 2012, the company paid $6,000 on the machine, with the balance on credit at 10...
-
3. Write a test program which has a static method that takes a shape argument and displays information about it (its radius, its area and volume, if applicable). Writing this to display information...
-
1. Why did Tiffany become a takeover target? 2. Acquisitions are one tool to execute corporate strategy. Why did LVMH acquire Tiffany? In your answer, focus on product and geographic diversification....
-
Reduce each of the following equations into canonical form and find the general solution. vii. yum-2xyu, + xu = u, +u, %3D viii. U- 2 sin xuy - cos xuyy-cos xu, =0 COS %3D
-
For the design described in 4.20.5, add NOPs to this instruction sequence to ensure correct execution in spite of missing support for forwarding. Problems 4.20.5 If we assume forwarding will be...
-
Discuss the distinctive features of accounting and assurance in Hong Kong under the one country two systems approach.
-
If you bought and held shares of the Priceline Group, the online provider of travel-related reservations and search services, from 2014 to 2019, you would have been one happy camper. During that...
-
Following the financial crisis of 2008, American consumers cut back on new car purchases. In response to the decline in car sales, Congress passed the program Cash for Clunkers, which allowed...
-
Find the total resistance of each group of series resistors shown in Figure 467. Data in Figure 467 . (a) ***** (b) (c) **** (d) *****
-
You have a 6% annual payment perpetual bond. If the market interest rates are 5% and the bond has a nominal $1,000 par value, what is the current market value of this bond? Show your work! A 15-year...
-
Floyd Distributors, Inc., provides a variety of auto parts to small local garages. Floyd purchases parts from manufacturers according to the EOQ model and then ships the parts from a regional...
-
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...
-
Which of Parks statements regarding the asset allocation approaches is correct? A. Only Statement 3 B. Only Statement 4 C. Both Statement 3 and Statement 4 Kevin Kroll is the chair of the investment...
-
The suitability concern discussed by Kroll and Park most likely deals with: A. governance. B. transparency. C. investment horizon. Kevin Kroll is the chair of the investment committee responsible for...
-
Based on the forecasted environment, liquidity planning should take into account that general partners may: A. call capital at a slower pace. B. make distributions at a faster pace. C. exercise an...
Study smarter with the SolutionInn App