i need help with the Flexible Budget Performance Report and the Write Up, thanks!

Ford Seasoning's management has compiled budgeted information regarding sales and production of 12-spice for January of 20XX. Use the information provided in the chart below to determine what quantity of 12 -spice jars Ford Seasoning must produce and sell Ford Seasoning's management has asked its accounting staff to prepare a sales budget for the first quarter of 20XX. According to managements predictions, the selling price per jar of 12 -spice will be the same for the entire three months. Because management expects sales to grow rapidly due to a new promotional strategy, they have asked the accounting staff to budget for an increase to sales over the three-month period. The expected rate of sales growth for each month is as follows. For your convenience, the per-jar sales price is also listed. Prepare Ford Seasoning's sales budget for the first quarter of 20XX. Set January's budgeted jars to be sold equal to the required sales volume determined by your CVP analysis. Then, increase the budgeted jars to be sold each month by the percentages given in the table above. Ford Seasonings management has asked its accounting staff to prepare a production budget for the upcoming quarter. Like all businesses, Ford Seasoning wants to have extra finished goods inventory on hand at the end of each period to serve as a buffer. Information about the firm's inventory balance at the beginning of the quarter and its desired level of ending inventory for each month during the quarter is as follows: Use the information from the table above and your sales budget to prepare Ford Seasoning's production budget for the upcoming quarter. Ford Seasoning's management has compited a list of standards from the various managers at the company and handed this information off to the company's accounting staff to prepare the direct materials budget. In addition to the per-jar standards, these managers have made an estimate about the quantity of direct materials needed at the end of the month. This information, as well as Ford Seasoning's current direct materials balance, is listed in the information below: The production managers and HR employees at Ford Seasoning has compiled information about standards related to direct labor requirements during January 20XX and passed it along to the accounting staff. The standards for the amount of labar hours required to make each jar of 12-spice as well as the expected average hourly costs of labor are as follows: Use information obtained from the table above and the previous budgets to prepare Ford Seasoning's direct labor budget 7 for the month of January Ford Seasonings management has provided the accounting staff with the following information related to the company's estimated manufacturing overhead for the month of January 20XX: Use the information from the table above and the previous budgets to prepare Ford Seasoning's manufacturing Cost of Goods Sold Budget Ford Seasoning's management has asked the accounting staff to used the information obtained from the prior budgets to determine the company's expected manufacturing cost per jar for the month and then prepare the firm's cost of goods sold budget for period. Requirement One Determine Ford Seasoning's total cost to manufacture one jar of 12-spice during January. 1. Requirement Two The following info relates to Ford Seasoning's beginning inventory: 4 Finished Jars in Beginning Inventory, 1-1-XX \begin{tabular}{rrrrr} Quantity & \multicolumn{2}{r}{ Unit Cost } & \multicolumn{2}{r}{ Total Cost } \\ \hline 1,500 & $ & 7.25 & $ & 10,875 \end{tabular} Use the information regarding beginning finished goods inventory, your answer to requirement one, and info from your 5 prior budgets to prepare Ford Seasoning's cost of goods sold budget for the month of January 20X. Ford Seasoning's management has compiled the following information about their predicted selling and administrative expenses for the upcoming month Prepare Ford Seasoning's selling and administrative expense budget for the upcoming first quarter of 20. Use the information obtained from previously prepared budgets to prepare Ford Seasoning's comparative budgeted income statement for the month of January ( up until operating income.) Complete Ford Seasoning's flex budget performance report for the month. The company's actual results and budgeted amounts per unit have been provided for you. The numbers for the static budget portion of the document need to be taken from the individual 5 budgets you prepared in your master budget. Variance Analysis Prior to making the company's budget for month of January 20XX, the various managers at Ford Seasoning set the following standards related to the costs of production. 20 Determine the actual direct materials cost per pound and the actual direct labor cost per hour Requirement Calculate the following variances between Ford Seasoning's budgeted figures and the company's actual results. In approximately 2 paragraphs, please use the results of your variance analysis to write a written recommendation to the management of Ford Seasoning about how they can improve their budget for the followine neriod. and increase the orofitabilitv of the comnanv. Ford Seasoning's management has compiled budgeted information regarding sales and production of 12-spice for January of 20XX. Use the information provided in the chart below to determine what quantity of 12 -spice jars Ford Seasoning must produce and sell Ford Seasoning's management has asked its accounting staff to prepare a sales budget for the first quarter of 20XX. According to managements predictions, the selling price per jar of 12 -spice will be the same for the entire three months. Because management expects sales to grow rapidly due to a new promotional strategy, they have asked the accounting staff to budget for an increase to sales over the three-month period. The expected rate of sales growth for each month is as follows. For your convenience, the per-jar sales price is also listed. Prepare Ford Seasoning's sales budget for the first quarter of 20XX. Set January's budgeted jars to be sold equal to the required sales volume determined by your CVP analysis. Then, increase the budgeted jars to be sold each month by the percentages given in the table above. Ford Seasonings management has asked its accounting staff to prepare a production budget for the upcoming quarter. Like all businesses, Ford Seasoning wants to have extra finished goods inventory on hand at the end of each period to serve as a buffer. Information about the firm's inventory balance at the beginning of the quarter and its desired level of ending inventory for each month during the quarter is as follows: Use the information from the table above and your sales budget to prepare Ford Seasoning's production budget for the upcoming quarter. Ford Seasoning's management has compited a list of standards from the various managers at the company and handed this information off to the company's accounting staff to prepare the direct materials budget. In addition to the per-jar standards, these managers have made an estimate about the quantity of direct materials needed at the end of the month. This information, as well as Ford Seasoning's current direct materials balance, is listed in the information below: The production managers and HR employees at Ford Seasoning has compiled information about standards related to direct labor requirements during January 20XX and passed it along to the accounting staff. The standards for the amount of labar hours required to make each jar of 12-spice as well as the expected average hourly costs of labor are as follows: Use information obtained from the table above and the previous budgets to prepare Ford Seasoning's direct labor budget 7 for the month of January Ford Seasonings management has provided the accounting staff with the following information related to the company's estimated manufacturing overhead for the month of January 20XX: Use the information from the table above and the previous budgets to prepare Ford Seasoning's manufacturing Cost of Goods Sold Budget Ford Seasoning's management has asked the accounting staff to used the information obtained from the prior budgets to determine the company's expected manufacturing cost per jar for the month and then prepare the firm's cost of goods sold budget for period. Requirement One Determine Ford Seasoning's total cost to manufacture one jar of 12-spice during January. 1. Requirement Two The following info relates to Ford Seasoning's beginning inventory: 4 Finished Jars in Beginning Inventory, 1-1-XX \begin{tabular}{rrrrr} Quantity & \multicolumn{2}{r}{ Unit Cost } & \multicolumn{2}{r}{ Total Cost } \\ \hline 1,500 & $ & 7.25 & $ & 10,875 \end{tabular} Use the information regarding beginning finished goods inventory, your answer to requirement one, and info from your 5 prior budgets to prepare Ford Seasoning's cost of goods sold budget for the month of January 20X. Ford Seasoning's management has compiled the following information about their predicted selling and administrative expenses for the upcoming month Prepare Ford Seasoning's selling and administrative expense budget for the upcoming first quarter of 20. Use the information obtained from previously prepared budgets to prepare Ford Seasoning's comparative budgeted income statement for the month of January ( up until operating income.) Complete Ford Seasoning's flex budget performance report for the month. The company's actual results and budgeted amounts per unit have been provided for you. The numbers for the static budget portion of the document need to be taken from the individual 5 budgets you prepared in your master budget. Variance Analysis Prior to making the company's budget for month of January 20XX, the various managers at Ford Seasoning set the following standards related to the costs of production. 20 Determine the actual direct materials cost per pound and the actual direct labor cost per hour Requirement Calculate the following variances between Ford Seasoning's budgeted figures and the company's actual results. In approximately 2 paragraphs, please use the results of your variance analysis to write a written recommendation to the management of Ford Seasoning about how they can improve their budget for the followine neriod. and increase the orofitabilitv of the comnanv