I need assistance preparing the Manufacturing cost per unit budget and the budgeted income statement.

Your total Cost Per Unit in the budgeted CPU budget should be somewhere between $460 and $470. Your net income for the quarter should be somewhere between $1,400,000 and $1,500,000.Prepare a Budgeted Manufacturing Cost: per unit budget. Refer to exhibit 9-11 for guidance. To calculate FMDHr'unit calculate total FMOH for the year and divide this by budgeted production for the year. The total prdductic-n volume for the year is budgeted at S display cupboards. Prepare a Budgeted Income Statement for the quarter for Decorldeas. Assume interest expense of $12}, and income tax expense of 24% of income before taxes. DecorIdeas's goal for the quarter is to make its net income greater than 10% of its sales revenue. To determine whether the company achieves the goal, use @IF function. In the IF function, you need to label \"Achieved" if it achieves the goal (if the condition is met) or \"Not Achieved\" if it does not achieve {if the condition is not met). Use the CELL right next to 'Net Income' cell to make the IF function that returns one of the labels based on whether the condition {net income 3:- sales revenue*ll]%) is met or not. For each regairement below gregore budgets by month {or October. November. and December and a total budget for the Quarter. The previous year's sales [2021122) for the corresponding period were: October 2,0013 display cupboards November 2,3013 display cupboards December 4,0013 display cupboards January 4,4{l display cupboards February 3,6130 display cupboards The company expects the above volume of display cupboard sales to increase by 15% for the period October 2022 February 21123. The budgeted selling price for 2022 is $735.01} per display cupboard. The company expects 5% of its sales to be cash [COD] sales. The remaining 95% of sales will be made on credit. Prepare a Sales Budget for Decorldeas. . The company desires to have nished goods inventory on hand at the end of each month equal to 15 percent of the following month's budgeted unit sales. On September 3U, 2(122, there were 4511 display cupboards on hand. (Note, an estimate of sales in January is required in order to complete the production budget for December]. Prepare a Production budget. . The display cupboards require two direct materials: oak shelving wood and hickory plywood backing board. ak shelving wood: Thirty (30) feet of 125:1 oak shelving wood are required for each cupboard produced- Management desires to have materials on hand at the end of each month equal to 11} percent of the following month's cupboard production needs. The beginning inventory of oak wood, October 2022, was 10,150 feet of wood. ak wood is expected to cost $5.00 per foot. Hickory plywood backing board is purchased by the sheet and 2 backing boards can be cut from each sheet. Management desires to have plywood on hand at the end of each month equal to 15 percent of the following month's production needs. The beginning inventory of plywood, October 2022, was 100 sheets. Hickory plywood is expected to cost $45 per sheet. (Note, budgeted production in January is required in order to complete the direct materials budget for December. Also, use the @RDUND function to round up to the nearest whole number the number of sheets of plywood to purchase \"DM quantities to purchase\"). Prepare a Direct Materials budget. Also, because two direct materials are required for production - oak wood and hickory plywood - you will need a separate schedule for each direct material. 4. Each display cupboard requires 10 hours of direct labor. Decorldeas uses a series of table saws, table routers and sanders set up for specialized operations to achieve production efciencies. Direct labor costs the company $22 per hour. Prepare a Direct Labor budget. 5. Decorldeas budgets indirect materials [e.g., wood screws, sandpaper, stain, packaging) at $25.50 per display cupboard. Decorldeas treats indirect labor and utilities as mixed costs. The variable components are $10.40 per display cupboard for indirect labor and $3.20 per display cupboard for utilities. The following xed costs per month are budgeted for indirect labor, $50,000, utilities, $10,000, and other, $65,800. Prepare a Manufacturing |[Iverbead budget. :5. Variable selling and administrative expenses are $100.50 per display cupboard sold. Fixed selling and administrative expenses are $30,000 per month. These costs are not itemized, i.e., the budget has only two line items variable operating expenses and fixed operating expenses. Prepare an l[lperating Expenses budget. T. Prepare a Budgeted Manufacturing Cost per unit budget. Refer to exhibit 9-11 for guidance. To calculate Fl'leHfunit calculate total FMDH for the year and divide this by budgeted production for the year. The total production volume for the year is budgeted at 50,000 display cupboards