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.
-
Refer to Conceptual Example for a discussion of nuclear densities. A neutron star is composed of neutrons and has a density that is approximately the same as that of a nucleus. What is the radius of...
-
Let r 1 = coefficient of correlation between n pairs of values (Y i , X i ) and r 2 = coefficient of correlation between n pairs of values (aX i + b, cY i + d), where a, b, c, and d are constants....
-
Which of the following is true regarding the direct write-off method of accounting for uncollectibles? a. The direct write-off method does not adhere to GAAP. b. The direct write-off method does not...
-
As lawyers assembled closing documents for a refinancing of some of the outstanding debt of United States Lines (USL), a secretary working on Amendment No. 1 to the First Preferred Ship Mortgage...
-
Salaries represent the costs of employing two new machine operators at a salary of $40,000 per annum each. For the HCC machine, the company will only need to employ a new machine operator and the...
-
Record the adjusting entry for supplies remaining on hand at the end of the year equal to $3,900. Record the closing entry for revenue. Record the closing entry for expenses. Record the closing entry...
-
Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Balance Sheet March...
-
Deming believed that removing _______ from the workplace gives employees pride in their workmanship, which increases production. a. fear b. diversity c. competition d. hierarchy
-
The three experiments by Spilich et al. (1992) on the effects of smoking on performance find conflicting results. Can you suggest why the results are different?
-
Chart the time series given in Table 9.1 and decide if it is stationary and or seasonal. X y Table 9.1 1 2 2 5 3 6 st 4 6 5 4 6 5 7 7 8 5 9 8 10 9
-
A researcher claims that the percentage of adults in Egypt who own a surround sound speaker is not 40%. Describe type I and type II errors for a hypothesis test of the indicated claim.
-
As stated by a courier companys dispatch department, the number of delivery errors per million consignments has a standard deviation that is less than 2. Write the claim as a mathematical statement....
-
A satellite of mass "m" is in an elliptic orbit. Its apogee (farthest point from earth) "A" is at RA-6RE and perigee (closest point to earth) "P" is at Rp 2RE from the center of earth. (Note that at...
-
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...
-
Estimate the gravitational force and the acceleration due to gravity on a body of \(1.25 \mathrm{~kg}\) mass on the earth's surface. The radius and mass of the earth are \(6370 \mathrm{~km}\) and...
-
A reactor contains a gas mixture of \(25 \mathrm{~kg} \mathrm{NH}_{3}, 15 \mathrm{~kg} \mathrm{CO}\) and \(10 \mathrm{~kg} \mathrm{C}_{2} \mathrm{H}_{2}\). Calculate the total number of moles of the...
-
Estimate the gravitational force on a body of \(1.5 \mathrm{~kg}\) mass on the earth's surface, given that the radius and mass of the earth are \(6000 \mathrm{~km}\) and \(6 \times 10^{24}...
Study smarter with the SolutionInn App