please solve it properly with data

Q# 1 (15 marks) We really need to get this new material handling equipment in operation just after the new year begins. I hope we can finance it largely with cash and marketable securities, but if necessary we can get a short term loan down at Metro bank. This Statement by Beth Davies Lowry president of Global Electronics Company, concluded a meeting she had called with the firm s top management. Global is a small, rapidly growing wholesaler of consumer electronic products. The firms main product lines are small kitchen appliances and power tools. Maria Wilcox, Global Electronics general manager of marketing has recently completed a sales forecast. She believes the companys sales during the first quarter of 2021 will increase by 10% each month over the previous month s sales. Than Wilcox expects sales to remain constant for several months. Global s projected balance sheet as of Dec 31 2020 is as follow: Cash 70,000 A/c receivable 540,000 Marketable securities 30,000 Inventory 308,000 Building and equipment (net of accumulated depreciation) 1,252,000 Total assets 2,200,000 A/c payable 352,800 Bonds interest payable 25,000 Property tax payable 7,200 Bonds Payable ( 10% due in 2026 ) 600,000 Common stock 1,000,000 Retained earnings 215,000 Total liabilities and stockholders equity 2,200,000 Jack Hanson the assistant controller is the preparing a monthly budget for the first quarter of 2021. In the process the following information has been accumulated 1. Projected sales for December 2020 are 800,000. Credit sales typically are 75% of total sales. Company credit experience indicates that 10% of the credit sales are collected during the month of sales and the remainder are collected during the following month. 2. Company cost of goods sold generally runs at 70% of sales. Inventory is purchase on account and 40% of each month s purchase is paid during the month of purchase. The remainder is paid during the following month. In order to have adequate stocks of inventory on hand the firm attempts to have inventory at the end of each month equal to half of the next moths projected cost of goods sold. 3. Hasson has estimated that Company monthly expense will be as follow: Sales salaries 42,000 Advertising and promotion 32,000 Administrative salaries 42,000 Depreciation 50,000 Interest on bonds 5,000 Property taxes 1,800 In addition, sales commission run at the rate of 1% of sales. 4. Company president has indicated that the firm should invest 250,000 in an automated inventory handling system to control the movement of inventory in the firm s warehouse just after the new year begins. These equipment purchase will be finance primarily from the firm cash and marketable securities. However, president believes that the company needs to keep minimum cash balance of 50,000. If necessary, the remainder of the equipment purchase will be financed using the short term credit from local bank. The minimum period for such a loan is three months. Hanson believes short term interest rate will be 10% per year at the time of equipment purchase. If a loan is necessary President has decided it should be paid off by the end of the first quarter if possible. 5. Company board of directors has indicated an intention to declare and pay dividends of 100,000 on the last day of each quarter 6. The interest on any short term borrowing will be paid when the loan is repaid. Interest on bonds is paid semiannually on January 31 and July 31 for the preceding six- month 7. Property taxes are paid semiannually on February 28 and August 31 for the preceding six month Required: Prepare Global Electronics Company s master budget for the first quarter 2021 by completing the following schedules and statements. 1. Sales budget (01 marks) 2. Schedule of expected cash collection (1.5 marks) 3. Purchase budget (01 marks) 4. Schedule of expected cash disbursement for inventory purchase (1.5 marks) 5. Schedule of expected cash disbursement for operations expense (1.5 marks) 6. Cash budget (03 marks) 7. Budgeted income statement for the first quarter (02 marks) 8. Budgeted statement of retained earnings for the first quarter (1.5 marks) 9. Budgeted balance sheets for the first quarter (02 marks)

# 1 (15 marka) "We really need to get this new material - bedling equipment in operation just after the new year begins. I hope we can financest largely with cash and marketable securities, but if necessary we can get a short term loan down at Metro bank. This Statement by Beth Davies - Lowry president of Global Electrons Company, concluded a meeting she had called with the fimm 's top management. Global is a small, rapidly growig wholesaler of cotiser electronic products The firm's main product limes are small kitchen applumces and power tools Marsa Wilcox, Global Electronics general manager of marketing has recently completed a sales forecast. She believes the company sales durmg the first quarter of 2021 will increase by 10% each month over the previous months' sales Than Wilcox expects sales to remain content for several months Global 's projected balmace set as of Dec 31 2020 is as follow Cash 70,000 Ale receivable 540,000 Marketable secuntes 20.000 Inventory 308,000 Building and equipment (net of accumulated depreciation) 1.252,000 Total assets 2,200,000 A/c payable 352 800 Bonds interest payable 15,000 Property tax payable 7,200 Bonds Payable (10% in 2026) 600.000 Common stock 1.000.000 Retained emings 215,000 Total liabilities and stockholders equity 2,200,000 Jack Hanson the assistant controller as the preparmg 2 montialy budget for the first quarter of 2021 In the process the following information has been acculated 1. Projected sales for December 2020 are 800.000 Credit sales typically are 75% of total sales Company credit experience indicates that 10% of the credit sales are collected during the mouth of sales and the remainder are collected during the following month 2. Company cost of goods sold generally runs at 70% of sales. Inventory is purchase an account and 40% of each month's purchase is paid during the mouth of purchase. The remainders paid during the following month. In order to have adequate stocks of inventory on hand the fimm attempts to have inventory at the end of each month equal to half of the next moth's projected cost of goods sold 3 Harson he estimated that company moothly expense will be as follow Sales salaries 42.000 Advertising and promotion 32.000 Administrative salanes 42.000 Depreciation 50,000 Interest on bonds 5.000 Property taxes 1.800 In addition, sales commission run at the rate of 1% of sales 4. Company president has indicated that the firm should invest 250,000 in 20 automated eventory handling system to control the movement of investory in the fimm s' warehouse just after the new year begins. These equipment purchase will be finance primarily from the firm cash and marketable securities. However, president believes that the company needs to keep minum cash balance of 50,000. If necessary the remander of the equapment purchase will be finmced using the short term credit from local bank. The most penod for such a loan is time months Hanson believes short-term interest rate will be 10% per year at the time of # 1 (15 marka) "We really need to get this new material - bedling equipment in operation just after the new year begins. I hope we can financest largely with cash and marketable securities, but if necessary we can get a short term loan down at Metro bank. This Statement by Beth Davies - Lowry president of Global Electrons Company, concluded a meeting she had called with the fimm 's top management. Global is a small, rapidly growig wholesaler of cotiser electronic products The firm's main product limes are small kitchen applumces and power tools Marsa Wilcox, Global Electronics general manager of marketing has recently completed a sales forecast. She believes the company sales durmg the first quarter of 2021 will increase by 10% each month over the previous months' sales Than Wilcox expects sales to remain content for several months Global 's projected balmace set as of Dec 31 2020 is as follow Cash 70,000 Ale receivable 540,000 Marketable secuntes 20.000 Inventory 308,000 Building and equipment (net of accumulated depreciation) 1.252,000 Total assets 2,200,000 A/c payable 352 800 Bonds interest payable 15,000 Property tax payable 7,200 Bonds Payable (10% in 2026) 600.000 Common stock 1.000.000 Retained emings 215,000 Total liabilities and stockholders equity 2,200,000 Jack Hanson the assistant controller as the preparmg 2 montialy budget for the first quarter of 2021 In the process the following information has been acculated 1. Projected sales for December 2020 are 800.000 Credit sales typically are 75% of total sales Company credit experience indicates that 10% of the credit sales are collected during the mouth of sales and the remainder are collected during the following month 2. Company cost of goods sold generally runs at 70% of sales. Inventory is purchase an account and 40% of each month's purchase is paid during the mouth of purchase. The remainders paid during the following month. In order to have adequate stocks of inventory on hand the fimm attempts to have inventory at the end of each month equal to half of the next moth's projected cost of goods sold 3 Harson he estimated that company moothly expense will be as follow Sales salaries 42.000 Advertising and promotion 32.000 Administrative salanes 42.000 Depreciation 50,000 Interest on bonds 5.000 Property taxes 1.800 In addition, sales commission run at the rate of 1% of sales 4. Company president has indicated that the firm should invest 250,000 in 20 automated eventory handling system to control the movement of investory in the fimm s' warehouse just after the new year begins. These equipment purchase will be finance primarily from the firm cash and marketable securities. However, president believes that the company needs to keep minum cash balance of 50,000. If necessary the remander of the equapment purchase will be finmced using the short term credit from local bank. The most penod for such a loan is time months Hanson believes short-term interest rate will be 10% per year at the time of 1. Projected sales for December 2020 are 800,000. Credit sales typically are 75% of total sales. Company credit experience indicates that 10% of the credit sales are collected during the month of sales and the remainder are collected during the following month. 2. Company cost of goods sold generally runs at 70% of sales. Inventory is purchase on account and 40% of each month 's purchase is paid during the month of purchase. The remainder is paid during the following month. In order to have adequate stocks of inventory on hand the firm attempts to have inventory at the end of each month equal to half of the next moth's projected cost of goods sold. 3. Hasson has estimated that Company monthly expense will be as follow: Sales salaries 42,000 Advertising and promotion 32,000 Administrative salaries 42,000 Depreciation 50,000 Interest on bonds 5,000 Property taxes 1,800 In addition, sales commission run at the rate of 1% of sales. 4. Company president has indicated that the firm should invest 250,000 in an automated inventory handling system to control the movement of inventory in the firm s' warehouse just after the new year begins. These equipment purchase will be finance primarily from the firm cash and marketable securities. However, president believes that the company needs to keep minimum cash balance of 50,000. If necessary, the remainder of the equipment purchase will be financed using the short term credit from local bank. The nimum period for such a loan is three months. Hanson believes short-term interest rate will be 10% per year at the time of equipment purchase. If a loan is necessary President has decided it should be paid off by the end of the first quarter if possible. 5. Company board of directors has indicated an intention to declare and pay dividends of 100,000 on the last day of each quarter 6. The interest on any short-term borrowing will be paid when the loan is repaid. Interest on bonds is paid semiannually on January 31 and July 31 for the preceding six-month 7. Property taxes are paid semiannually on February 28 and August 31 for the preceding six - month Required: Prepare Global Electronics Company's master budget for the first quarter 2021 by completing the following schedules and statements. 1. Sales budget (01 marks) 2. Schedule of expected cash collection (1.5 marks) 3. Purchase budget (01 marks) 4. Schedule of expected cash disbursement for inventory purchase (1.5 marks) 5. Schedule of expected cash disbursement for operations expense (1.5 marks) 6. Cash budget (03 marks) 7. Budgeted income statement for the first quarter (02 marks) 8. Budgeted statement of retained earnings for the first quarter (1.5 marks) 9. Budgeted balance sheets for the first quarter (02 marks)