I have posted this twice but couldn't find proper/accurate results. This is full information so better not to ask for additional information which I just find as an excuse not to answer question. If you can not solve better say it upfront !! Thanks

It would be great be you solve it in excel and explain it. Thanks

Master Budget, Cash Budget and Budgeted Income Statement You just start a job as Junior accountant at Bigdream Inc. Your manager is responsible for the nationwide distribution of creator design sets. Because of the new social media influence among current generation, the company has grown rapidly, and the prompt growth forces the management team to improve their efficiency and manage their production effectively. You have just been given responsibility for all planning and budgeting of the entire lighting set division. Today is your first day, you have just given an assignment to prepare master budget for the manager, who needs to present the budget and discuss the financial objectives with the shareholders tomorrow. Your first assignment is to prepare a master budget for the next fiscal year, starting January 1, 2023. Your co-work has left a pile of files on your desk including the past sale records, product information, manufacture schedule and supplier pricing list. The company desires a minimum ending cash balance each quarter on $95,000. The Bigdream products are sold to retailers for $125 each and the sales have been in demand due to the Covid-19. However, the marketing department has been conservative toward the end of the year due market saturation. The marketing department has just sent you their forecasted quarter sales and marketing budget. Ending finished goods inventories are supposed to be equal to 25% of the next quarter's sales in units. Bigdream currently does its own assembly production in house. Each unit consists of 3 LED panels and the cost of each is $14. Each unit needs 0.12 labour hour from assemble to finish package. The hourly pay rate to the assembling workers is $12 per hour. The production manager also required desired direct material ending inventory to 30% of the next quarter production. Purchases are paid for in the following manner: 35% in the quarter of the purchase and the remaining 65% paid in the quarter following the purchase. All sales to the distributors are made on credit terms with no discount (for now), and payable within 45 days. The Bigdream has determined that only 70% of sales are collected by the end of the quarter in which the sale occurred. An additional 30% is collected in the quarter following the sale. Bad debts have been negligible, supporting the credit terms as favorable. Below is a display of the Bigdream division quarterly manufacture overhead and selling and administrative expenses: Manufacture Overhead Variable: Indirect labour $5 per labour hour Indirect Materials $2.00 per labour hour Fixed: Wages and Salaries $6,000 Utilities $6,000 Insurance $7,000 Depreciation $7,000 Selling and Administrative Variable: Sales Commissions $5 per unit Fixed (quarterly): Wages and Salaries $60,000 Utilities \$18,000 Insurance $3,000 Depreciation $5,000 Miscellaneous $9,000 Labour, Manufacture Overhead, and Selling and Administrative expenses are all paid during the month, in cash, with the exception of depreciation (of course). Bigdream will make a purchase of a parcel of land during the first quarter of 2023 for $50,000 cash. Bigdream's balance sheet at the end of the fourth quarter last year is shown below: Assets Cash $45,000 Uncollected Accounts receivable in Q4 this year: $150,000 Liabilities Accounts payable $90,000 An agreement with Bank of the West allows Bigdream to borrow up to a total loan amount of $500,000 if they need. The interest rate on these loans is 12% annually but the interest is not compounded, meaning this is simple interest only. Required: Prepare a master quarterly budget for 2023 . Include the following budget schedules and financial statements: 1) Master Budget 2) Cash Budget. Show the cash budget by quarter. 3) Budgeted Income statement by quarter and in total Master Budget, Cash Budget and Budgeted Income Statement You just start a job as Junior accountant at Bigdream Inc. Your manager is responsible for the nationwide distribution of creator design sets. Because of the new social media influence among current generation, the company has grown rapidly, and the prompt growth forces the management team to improve their efficiency and manage their production effectively. You have just been given responsibility for all planning and budgeting of the entire lighting set division. Today is your first day, you have just given an assignment to prepare master budget for the manager, who needs to present the budget and discuss the financial objectives with the shareholders tomorrow. Your first assignment is to prepare a master budget for the next fiscal year, starting January 1, 2023. Your co-work has left a pile of files on your desk including the past sale records, product information, manufacture schedule and supplier pricing list. The company desires a minimum ending cash balance each quarter on $95,000. The Bigdream products are sold to retailers for $125 each and the sales have been in demand due to the Covid-19. However, the marketing department has been conservative toward the end of the year due market saturation. The marketing department has just sent you their forecasted quarter sales and marketing budget. Ending finished goods inventories are supposed to be equal to 25% of the next quarter's sales in units. Bigdream currently does its own assembly production in house. Each unit consists of 3 LED panels and the cost of each is $14. Each unit needs 0.12 labour hour from assemble to finish package. The hourly pay rate to the assembling workers is $12 per hour. The production manager also required desired direct material ending inventory to 30% of the next quarter production. Purchases are paid for in the following manner: 35% in the quarter of the purchase and the remaining 65% paid in the quarter following the purchase. All sales to the distributors are made on credit terms with no discount (for now), and payable within 45 days. The Bigdream has determined that only 70% of sales are collected by the end of the quarter in which the sale occurred. An additional 30% is collected in the quarter following the sale. Bad debts have been negligible, supporting the credit terms as favorable. Below is a display of the Bigdream division quarterly manufacture overhead and selling and administrative expenses: Manufacture Overhead Variable: Indirect labour $5 per labour hour Indirect Materials $2.00 per labour hour Fixed: Wages and Salaries $6,000 Utilities $6,000 Insurance $7,000 Depreciation $7,000 Selling and Administrative Variable: Sales Commissions $5 per unit Fixed (quarterly): Wages and Salaries $60,000 Utilities \$18,000 Insurance $3,000 Depreciation $5,000 Miscellaneous $9,000 Labour, Manufacture Overhead, and Selling and Administrative expenses are all paid during the month, in cash, with the exception of depreciation (of course). Bigdream will make a purchase of a parcel of land during the first quarter of 2023 for $50,000 cash. Bigdream's balance sheet at the end of the fourth quarter last year is shown below: Assets Cash $45,000 Uncollected Accounts receivable in Q4 this year: $150,000 Liabilities Accounts payable $90,000 An agreement with Bank of the West allows Bigdream to borrow up to a total loan amount of $500,000 if they need. The interest rate on these loans is 12% annually but the interest is not compounded, meaning this is simple interest only. Required: Prepare a master quarterly budget for 2023 . Include the following budget schedules and financial statements: 1) Master Budget 2) Cash Budget. Show the cash budget by quarter. 3) Budgeted Income statement by quarter and in total