1. (a) Prepare a sales plan by month and in total

1. (a) Prepare a sales plan by month and in total. Include a schedule of projected cash collections from sales and accounts receivable, by month and in total.

The primary theme of the paper is 1. (a) Prepare a sales plan by month and in total. Include a schedule of projected cash collections from sales and accounts receivable, by month and in total. in which you are required to emphasize its aspects in detail. The cost of the paper starts from $79 and it has been purchased and rated 4.9 points on the scale of 5 points by the students. To gain deeper insights into the paper and achieve fresh information, kindly contact our support.

Requirements Table of Contents 1)Executive Summary 2)Problem Statement 3)Qualitative and quantitative Analysis with Reference to Appendix 4)Recommendations 5)Appendix for 3) Qualitative and quantitative Analysis with Reference to Appendix this is the Requirements to solve 1. (a) Prepare a sales plan by month and in total. Include a schedule of projected cash collections from sales and accounts receivable, by month and in total. (b) Prepare a purchases plan in units and in dollars. Include a schedule of projected cash payments for purchases and accounts payable, by month and in total. Note: the cost of inventory on hand is assumed to be released to cost of goods sold before costs for the purchase of additional units, i.e., a FIFO cost flow is assumed for all months. 2. Prepare a projected contribution format income statement, by month and in total. 3. Prepare a projected balance sheet as of September 30. Hint: for July and August, compute the line-of-credit interest expense and then link (with a 1 month lag) to interest payments on the projected statements of cash flow (or vice versa). For September, compute the interest expense and link forward to interest payable on the projected balance sheet. 4. Prepare projected statements of cash flow, by month and in total. The first statement of projected cash flow is presented in an internal budget format. The second statement of projected cash flow is presented in an external financial reporting format. Note: projected cash flow should be consistent across formats. 5. Use the data in cells A14:H16 within the Graph worksheet to create a cost-volume-profit graph. Ensure that your graph closely resembles a standard CVP graph to receive full credit. 6. Use the income statement and calculate the breakeven in sales dollars for the quarter. Then calculate the margin of safety ratio for the quarter. 7. Refer to the baseline projected income statement and statements of cash. (a) Compute and interpret AAPs "quality of income", where quality of income = operating cash flow ÷ net income. Operating cash flow = cash collections - cash disbursements before capital acquisitions. (b) Explain why income is greater than operating cash flow and identify at least two specific areas in which Al Ain Products may not be effectively using cash (focus on working capital components). [Hint: examine operating cash flow items from the external format cash flow statement]. 8. Refer to the baseline and review the selected benchmarking information provided by Al Ain Products` benchmarking consultant, as shown in Exhibit 4. (a) Compute (annualize as necessary) AAP`s financial metrics for the projected quarter. (b) Discuss how well AAP`s expected performance measures compare to its key competitor and the industry averages? Explain your results.

100% Plagiarism Free & Custom Written, Tailored to your instructions