Please provides a detailed analysis and calculations, I will rate you a full star and recommendations, Thank you.

Munzad Clock Company (B)- Munzad Clock recently ventured into inexpensive drone manufacturing as a potential diversification strategy. However, the accountant of the company has prepared a budget that is calculated using only one estimated volume of sales. He has asked you to help him set up a spreadsheet that can be used for sensitivity analysis in the budgeting process. This year, it appears that the company may not meet the expectations, which could result in a loss. The accountant is concerned that the company will incur a loss again next year and wants to develop a budget that will easily reflect changes in the assumptions. After gathering information about next year's operations, he will provide information using a what-if sensitivity analysis Following are the assumptions regarding revenues, direct materials and labor costs, and inventory levels: $102 Direct materials per clock Motor Sensors Body materials Direct labore $52 $22 Hourse Assemblye 0.54 0.12 Cost per hour $30e Packing Assembly Packing Assembly Packing $15e Cost per drone $15e $1.50 Inventory Information Beginning Target Ending Direct materials: Motore $5,000 $7,000 Sensors $3,000 $3.2002 Body materials $1,000 $1,2002 2,000 drones 2.200 drones Finished goods (units) Finished goods (cost) $97,8504 t Revenue assumptions: $75e Selling price Volume of drone sales 80,000 Following are estimated manufacturing overhead costs. Both fixed and variable overhead will be allocated based on the number of drones produced. $160,250 Estimated variable manufacturing overhead costs: Supplies Indirect labore Maintenance 200,650 80,200 Miscellaneous 40,1004 Total variable overhead costs $481,200 Estimated fixed manufacturing overhead costse Amortization $211,728 28,872 Property taxes Insurance 67,368 Plant management 240,6002 Fringe benefits 336,840 76,998 Miscellaneous Total fixed overhead costs $962,400 Following is the information that the accountant collected about support department costs: Fixed costs Support department: Administratione $1,034, 580 Marketing Distribution 620,748 310,3742 Customer service 103,4582 $2,069,160 The company's managers budget cash flows on a quarterly basis so that they can plan short-term investments and borrowings. Drone sales are highest during the spring and summer. Sales are fairly even within each quarter, but sales vary across quarters as follows: 10% 50% January-Marche April-June- July-September October-December 30% 10% Accounts receivable at the end of the prior year, consisting of sales made during December, totaled $90,000. Payments from customers are usually received as follows: 10% Pay during the month goods are received Pay the next month 47% Bad debts 3% The managers plan to maintain beginning inventory quantities during January and February but to increase inventories to the targeted levels by the end of March and maintain those levels throughout the rest of the year. The company pays its vendors 10 days after raw materials are received, so approximately two-thirds of all purchases are paid in the month of production and one-third are paid the following month. Accounts payable at the end of the prior year totaled $13,000. Employee wages and other production costs are paid during the month incurred. Property taxes are paid in two equal installments on March 31 and September 30, and insurance is paid annually on June 30. Support costs are paid evenly throughout the year. Estimated income tax payments are made at the end of each quarter, based on 25% of total estimated taxes for the year. In addition to customer receipts, the company expects to receive $10,000 in proceeds from the sale of equipment during January. The company also plans to purchase and pay for new equipment costing $50,000 during January. The company finances its short-term operations with a line of credit from the bank, which had a balance of $150,000 at the end of the prior year. The line of credit agreement requires the company to maintain a minimum cash balance of $100,000 (non-interest bearing). The company's line of credit requires quarterly interest payments at an annual rate of 5.5% (For simplicity, assume that all borrowings and repayments occur on the last of day of each quarter.) Additional information: Assume an income tax rate of 25% The budget indicates that the company is likely to incur a loss during the next period. The accountant asks you to assist him in developing sensitivity analyses that will help the manager identify possible ways to avoid a loss. To perform sensitivity analysis, you will change volume of production, volume of sales, selling prices, direct material prices, wage rates, and overhead and support department costs. Questions 1. Prepare all relevant budgets from the information provided. 2. Identify the assumptions that are relevant for sensitivity analysis. Relevant assumptions are assumptions that the manager could potentially influence by changing the company's operating plans. 3. Identify possible changes in budget assumptions that might eliminate the forecasted loss (i.e. that would lead to a breakeven) and perform sensitivity analysis. 4. Describe uncertainties and their effects on the assumptions you made in Part 2.4 Munzad Clock Company (B)- Munzad Clock recently ventured into inexpensive drone manufacturing as a potential diversification strategy. However, the accountant of the company has prepared a budget that is calculated using only one estimated volume of sales. He has asked you to help him set up a spreadsheet that can be used for sensitivity analysis in the budgeting process. This year, it appears that the company may not meet the expectations, which could result in a loss. The accountant is concerned that the company will incur a loss again next year and wants to develop a budget that will easily reflect changes in the assumptions. After gathering information about next year's operations, he will provide information using a what-if sensitivity analysis Following are the assumptions regarding revenues, direct materials and labor costs, and inventory levels: $102 Direct materials per clock Motor Sensors Body materials Direct labore $52 $22 Hourse Assemblye 0.54 0.12 Cost per hour $30e Packing Assembly Packing Assembly Packing $15e Cost per drone $15e $1.50 Inventory Information Beginning Target Ending Direct materials: Motore $5,000 $7,000 Sensors $3,000 $3.2002 Body materials $1,000 $1,2002 2,000 drones 2.200 drones Finished goods (units) Finished goods (cost) $97,8504 t Revenue assumptions: $75e Selling price Volume of drone sales 80,000 Following are estimated manufacturing overhead costs. Both fixed and variable overhead will be allocated based on the number of drones produced. $160,250 Estimated variable manufacturing overhead costs: Supplies Indirect labore Maintenance 200,650 80,200 Miscellaneous 40,1004 Total variable overhead costs $481,200 Estimated fixed manufacturing overhead costse Amortization $211,728 28,872 Property taxes Insurance 67,368 Plant management 240,6002 Fringe benefits 336,840 76,998 Miscellaneous Total fixed overhead costs $962,400 Following is the information that the accountant collected about support department costs: Fixed costs Support department: Administratione $1,034, 580 Marketing Distribution 620,748 310,3742 Customer service 103,4582 $2,069,160 The company's managers budget cash flows on a quarterly basis so that they can plan short-term investments and borrowings. Drone sales are highest during the spring and summer. Sales are fairly even within each quarter, but sales vary across quarters as follows: 10% 50% January-Marche April-June- July-September October-December 30% 10% Accounts receivable at the end of the prior year, consisting of sales made during December, totaled $90,000. Payments from customers are usually received as follows: 10% Pay during the month goods are received Pay the next month 47% Bad debts 3% The managers plan to maintain beginning inventory quantities during January and February but to increase inventories to the targeted levels by the end of March and maintain those levels throughout the rest of the year. The company pays its vendors 10 days after raw materials are received, so approximately two-thirds of all purchases are paid in the month of production and one-third are paid the following month. Accounts payable at the end of the prior year totaled $13,000. Employee wages and other production costs are paid during the month incurred. Property taxes are paid in two equal installments on March 31 and September 30, and insurance is paid annually on June 30. Support costs are paid evenly throughout the year. Estimated income tax payments are made at the end of each quarter, based on 25% of total estimated taxes for the year. In addition to customer receipts, the company expects to receive $10,000 in proceeds from the sale of equipment during January. The company also plans to purchase and pay for new equipment costing $50,000 during January. The company finances its short-term operations with a line of credit from the bank, which had a balance of $150,000 at the end of the prior year. The line of credit agreement requires the company to maintain a minimum cash balance of $100,000 (non-interest bearing). The company's line of credit requires quarterly interest payments at an annual rate of 5.5% (For simplicity, assume that all borrowings and repayments occur on the last of day of each quarter.) Additional information: Assume an income tax rate of 25% The budget indicates that the company is likely to incur a loss during the next period. The accountant asks you to assist him in developing sensitivity analyses that will help the manager identify possible ways to avoid a loss. To perform sensitivity analysis, you will change volume of production, volume of sales, selling prices, direct material prices, wage rates, and overhead and support department costs. Questions 1. Prepare all relevant budgets from the information provided. 2. Identify the assumptions that are relevant for sensitivity analysis. Relevant assumptions are assumptions that the manager could potentially influence by changing the company's operating plans. 3. Identify possible changes in budget assumptions that might eliminate the forecasted loss (i.e. that would lead to a breakeven) and perform sensitivity analysis. 4. Describe uncertainties and their effects on the assumptions you made in Part 2.4