with the following information if you could help me answer the following questions.

Questions

3. Expected direct materials usage is based on the input-output relationship determined by the "mix-man" or the person in charge of mixing up the batch of dry and wet material that is used to form the bricks. Each brick requires the correct amount of cement, sand, gravel, shale, pumice, and water. Over the years, the company has determined that each brick requires 6 pounds of mixed material and each pound of material costs BBI \$0.05. In addition, it is company policy to have the following requirements for desired ending direct materials inventory on hand: 4. Each batch of 100 bricks requires 1.50 direct labor hours to manufacture at a budgeted rate of $14 per hour (which includes an average hourly wage rate plus benefits). 3 5. Variable manufacturing overhead is forecast to be $6.00 per direct labor hour. Fixed manufacturing overhead is estimated to be $280,000 per quarter, of which $200,000 represents depreciation for the plant operations. If BB | refuses to raise selling prices to cover direct material cost increases, what could be done to assure that BBI's net income is equal to the original budget assuming the 5% increase in direct material prices occurs? You need to develop a coherent and realistic plan that BBI could put into place that will allow the company to earn the same net income as your original budget. At a minimum, you need to revise 4 data items in your master budget and all of your revisions must be integrated into one overall plan. IMPORTANT: YOUR REVISIONS MUST BE REALISTIC, JUSTIFIED, AND WELL EXPLAINED to earn credit. IN ADDITION, YOU MUST PROVIDE A SCREEN CAPTURE OF RELEVANT RESULTS AND EXPLAIN YOUR RATIONALE behind these revisions they must be coherent and realistic. Your instructor will run your revisions through the model to determine whether your plan achieves the original net income. REMEMBER: Your revisions must be realistic, justified AND WELL DOCUMENTED AND EXPLAINED to earn full credit. USE GOAL SEEK ON YOUR LAST INPUT CHANGE TO RECEIVE ANY CREDIT. The Rubble's say that this should be enough information for you to proceed with the planning effort. Betty has already done some figuring in her head and has provided you with check figures within the Excel Template. It is your job to see whether she's right! 5. Answer below: Pebbles learned that direct material prices per pound might be 5% higher than currently anticipated. If this occurs, by what percentage must selling prices increase each quarter to assure BBI earns the same net income as originally budgeted? USE GOAL SEEK TO RECEIVE ANY CREDIT. 9. Financing: To manage during seasonal downturns (that tough first quarter), BBI has set up a line of credit with a local bank that allows the company to borrow funds as needed at an annual rate of 5%. All borrowing is assumed to take place on the first day of the quarter, and all principal repayments are assuming to be made on the last day of a quarter. Note: Do not modify the financing area of the cash budget as these figures will automatically calculate. However, you should study and understand these computations. Boulder Brick, Inc. (BBI) has been manufacturing and selling red bricks to local and regional construction companies for over 50 years. Since BBI is based in the northeastern part of the United States, its sales are seasonal and follow the construction season, which runs primarily between April and November of any given year. Fred and Pebbles Boulder, owners of the family run company, have been managing it for many years, but have decided to start turning over some of the operations to you, their trusted friend and adviser. The Boulders have not done much formal planning from one year to the next. Fred stated recently: "The Company has just run by itself for all these years, why mess it up?" You have heard them complain for years that money is tight during the first quarter of every year, but they aren't sure how to deal with this issue. You state that, although the business has grown tremendously over the years and that they've done a great job, they should consider doing some formal planning for the upcoming year. They want to see what you've learned at COBAIS and have decided to put you in charge of preparing a business plan for 2024 . You sit down with Fred and Pebbles to discuss some of the critical elements for the master budget. They prefer a detailed, month-by-month, 12-month budget, but they ultimately decide that a quarterly budget with yearly totals will suffice. They provide you with the following 2024 estimates to get you started. 1. Quarterly Sales Forecast with Expected Selline Prices: 2. Fred has always liked to have some ending inventory units on hand - just in case. He provides you with the following desired ending finished goods inventory requirements for each quarter. He states that these are the same figures as last vear. 6. BBI has three primary Selling, General, and Administrative functions: sales and marketing, research and development, and administration. The details for each of these areas are as follows: Sales and Marketinq: Variable marketing expenses are $0.03 per brick. Fixed costs per quarter include salaries, $30,000; advertising, $20,000; depreciation, $2,000; travel, $3,000. Research and Development: The Company incurs quarterly salaries of $20,000 and spends $20,000 per quarter on design and development of new brick types. Administration: The Company incurs the following quarterly costs for administration: salaries, $50,000; depreciation, $10,000; travel, $2,000. Also, the Company pays annual insurance costs of $20,000 during the third quarter every year. 7. Capital acquisitions: BBI has always upgraded equipment on an annual basis. During 2024 they expect to spend $600,000 on new equipment during the first quarter of the year. 8. To get a better feel for their cash flow throughout the year, the Boulders have determined the following: a) 50% of sales are cash sales with the remaining sales made on credit. b) 70% of the credit sales are collected during the quarter in which sales occur and the remaining credit sales collected in the quarter following the sale. Bad debts over the years have been negligible. c) 80% of all direct materials are paid for in the quarter of purchase with the remaining portion paid for in the quarter following purchase. d) All other costs and expenses are p d d for during the quarter incurred. e) Interest expense is recognized on the current quarter's LOC balance, but not paid until the following quarter (i.e., cash interest paid lags interest expense by one quarter). f) The current tax rate is 30%. Similar to interest expense, tax expense is recognized on income earned during the quarter, but not paid until the following quarter. However, assume that BBI does not realize tax benefits from losses (i.e., no carryforward NOLs to offset future taxable income). Thus, in months where Income before Income Tax (IBIT) is negative, zero income tax expense will be recognized. Conversely, in months where IBIT is positive, income tax expense will be recognized on the income statement and paid the following month (note: your formula should use an "IF" statement to complete income tax expense). g) The company requires a minimum cash balance at all times of $100,000 to meet current working capital needs. 3. Expected direct materials usage is based on the input-output relationship determined by the "mix-man" or the person in charge of mixing up the batch of dry and wet material that is used to form the bricks. Each brick requires the correct amount of cement, sand, gravel, shale, pumice, and water. Over the years, the company has determined that each brick requires 6 pounds of mixed material and each pound of material costs BBI \$0.05. In addition, it is company policy to have the following requirements for desired ending direct materials inventory on hand: 4. Each batch of 100 bricks requires 1.50 direct labor hours to manufacture at a budgeted rate of $14 per hour (which includes an average hourly wage rate plus benefits). 3 5. Variable manufacturing overhead is forecast to be $6.00 per direct labor hour. Fixed manufacturing overhead is estimated to be $280,000 per quarter, of which $200,000 represents depreciation for the plant operations. If BB | refuses to raise selling prices to cover direct material cost increases, what could be done to assure that BBI's net income is equal to the original budget assuming the 5% increase in direct material prices occurs? You need to develop a coherent and realistic plan that BBI could put into place that will allow the company to earn the same net income as your original budget. At a minimum, you need to revise 4 data items in your master budget and all of your revisions must be integrated into one overall plan. IMPORTANT: YOUR REVISIONS MUST BE REALISTIC, JUSTIFIED, AND WELL EXPLAINED to earn credit. IN ADDITION, YOU MUST PROVIDE A SCREEN CAPTURE OF RELEVANT RESULTS AND EXPLAIN YOUR RATIONALE behind these revisions they must be coherent and realistic. Your instructor will run your revisions through the model to determine whether your plan achieves the original net income. REMEMBER: Your revisions must be realistic, justified AND WELL DOCUMENTED AND EXPLAINED to earn full credit. USE GOAL SEEK ON YOUR LAST INPUT CHANGE TO RECEIVE ANY CREDIT. The Rubble's say that this should be enough information for you to proceed with the planning effort. Betty has already done some figuring in her head and has provided you with check figures within the Excel Template. It is your job to see whether she's right! 5. Answer below: Pebbles learned that direct material prices per pound might be 5% higher than currently anticipated. If this occurs, by what percentage must selling prices increase each quarter to assure BBI earns the same net income as originally budgeted? USE GOAL SEEK TO RECEIVE ANY CREDIT. 9. Financing: To manage during seasonal downturns (that tough first quarter), BBI has set up a line of credit with a local bank that allows the company to borrow funds as needed at an annual rate of 5%. All borrowing is assumed to take place on the first day of the quarter, and all principal repayments are assuming to be made on the last day of a quarter. Note: Do not modify the financing area of the cash budget as these figures will automatically calculate. However, you should study and understand these computations. Boulder Brick, Inc. (BBI) has been manufacturing and selling red bricks to local and regional construction companies for over 50 years. Since BBI is based in the northeastern part of the United States, its sales are seasonal and follow the construction season, which runs primarily between April and November of any given year. Fred and Pebbles Boulder, owners of the family run company, have been managing it for many years, but have decided to start turning over some of the operations to you, their trusted friend and adviser. The Boulders have not done much formal planning from one year to the next. Fred stated recently: "The Company has just run by itself for all these years, why mess it up?" You have heard them complain for years that money is tight during the first quarter of every year, but they aren't sure how to deal with this issue. You state that, although the business has grown tremendously over the years and that they've done a great job, they should consider doing some formal planning for the upcoming year. They want to see what you've learned at COBAIS and have decided to put you in charge of preparing a business plan for 2024 . You sit down with Fred and Pebbles to discuss some of the critical elements for the master budget. They prefer a detailed, month-by-month, 12-month budget, but they ultimately decide that a quarterly budget with yearly totals will suffice. They provide you with the following 2024 estimates to get you started. 1. Quarterly Sales Forecast with Expected Selline Prices: 2. Fred has always liked to have some ending inventory units on hand - just in case. He provides you with the following desired ending finished goods inventory requirements for each quarter. He states that these are the same figures as last vear. 6. BBI has three primary Selling, General, and Administrative functions: sales and marketing, research and development, and administration. The details for each of these areas are as follows: Sales and Marketinq: Variable marketing expenses are $0.03 per brick. Fixed costs per quarter include salaries, $30,000; advertising, $20,000; depreciation, $2,000; travel, $3,000. Research and Development: The Company incurs quarterly salaries of $20,000 and spends $20,000 per quarter on design and development of new brick types. Administration: The Company incurs the following quarterly costs for administration: salaries, $50,000; depreciation, $10,000; travel, $2,000. Also, the Company pays annual insurance costs of $20,000 during the third quarter every year. 7. Capital acquisitions: BBI has always upgraded equipment on an annual basis. During 2024 they expect to spend $600,000 on new equipment during the first quarter of the year. 8. To get a better feel for their cash flow throughout the year, the Boulders have determined the following: a) 50% of sales are cash sales with the remaining sales made on credit. b) 70% of the credit sales are collected during the quarter in which sales occur and the remaining credit sales collected in the quarter following the sale. Bad debts over the years have been negligible. c) 80% of all direct materials are paid for in the quarter of purchase with the remaining portion paid for in the quarter following purchase. d) All other costs and expenses are p d d for during the quarter incurred. e) Interest expense is recognized on the current quarter's LOC balance, but not paid until the following quarter (i.e., cash interest paid lags interest expense by one quarter). f) The current tax rate is 30%. Similar to interest expense, tax expense is recognized on income earned during the quarter, but not paid until the following quarter. However, assume that BBI does not realize tax benefits from losses (i.e., no carryforward NOLs to offset future taxable income). Thus, in months where Income before Income Tax (IBIT) is negative, zero income tax expense will be recognized. Conversely, in months where IBIT is positive, income tax expense will be recognized on the income statement and paid the following month (note: your formula should use an "IF" statement to complete income tax expense). g) The company requires a minimum cash balance at all times of $100,000 to meet current working capital needs