this is what i have so far

1. The previous year's sales (2022) for the corresponding period were: The company expects the above volume of jacket sales to increase by 15% for the period July 2023 - November 2023. The budgeted selling price for 2023 is $735,00 per jacket. The company expects 10% of its sales to be eash (COD) sales. The remaining 90% of sales will be made on credit, Prepare a Sales Budget for H\&BClothine 2. The company desires to have finished goods inventory on hand at the end of each month equal to 12 percent of the following month's budgeted unit sales. Use the a ROUND function to round to the nearest whole number the number of jackets desired in ending inventory, On June 30,2023 , the company expects to have 55 jackets on hand. Use the @ROUND function to round to the nearest whole number the number of jacket units to produce. Prepare a Production budget. (NOTE: an estimate of sales in October is required to complete the production budget for September). \begin{tabular}{|c|c|c|c|c|c|} \hline & & sales budget & & & \\ \hline & July & Aug & Sep & Oct & Nov \\ \hline Unit Sales & 580 & 600 & 650 & 850 & 1,000 \\ \hline Unit Price & $735 & $735 & $735 & $735 & $735 \\ \hline Sales Rev & $426,300.00 & $441,000 & $477,750 & $624,750 & $735,000 \\ \hline Cash & $42,630.00 & $44,100 & $47,775 & $62,475 & $73,500 \\ \hline Credit & $383,670.00 & $396,900 & $429,975 & $562,275 & $661,500 \\ \hline total & $426,300.00 & $441,000 & $477,750 & $624,750 & $735,000 \\ \hline \end{tabular}