We're Open
+44 7340 9595 39
+44 20 3239 6980

# [Solved] 1. (a) Prepare a sales plan by month and in total. Include a schedule of projected cash collections from sales and accoun

100% Pass and No Plagiarism Guaranteed

### [Solved] 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 this assignment, you are required to prepare a sales plan by month and in total include a schedule of projected cash collections from sales and accounts receivable. Furthermore, prepare a purchases plan add a schedule of projected cash payments for purchases and accounts payable. Present a clear and appropriate statements with required calculations and explain your answer.

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,

International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

## STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

#### We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Nov,10,2018

Nov,10,2018

Nov,10,2018

### Details

• Title: [Solved] 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.
• Price: £ 69
• Post Date: 2021-10-05T04:11:29+00:00
• No Plagiarism Guarantee
• 100% Custom Written

### Customer Reviews

[Solved] 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.
Reviews: 5

### A masterpiece of assignment by John P. , written on 2020-03-12

The rates are a bit expensive for me of the essay writing service but the overall look is amazing. The references and formatting are done beautifully. So, I feel that the high rates are worth all these qualities. I want to thank you for great help.
Reviews: 5

### A masterpiece of assignment by Izkiyah , written on 2020-03-12

The support team is quite friendly and gives you the best solutions. I literally came here crying and went smiling like an idiot. My HR assignment is written beautifully with all the specifications I wanted. This is the best platform to get helped in assignments for me. All the people are supportive. Keep it up you all!