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,
Tailored to your instructions

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
• Category: Academic Papers
• 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 Hennah, written on 2020-03-12

I have been taking help from Insta Research since 2015 and believe me, this place is incredible in giving the best help in assignments and essays. I also ask them to run plagiarism in my essays that I have written, and they always gave me accurate results. I am literally blessed to have a strong bonding with this site so that in any need of urgency, I contact them and find them always beside me. Thank you!
Reviews: 5

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

The writer 0223 is really helpful. He gave me the best essay ever. Love you loads for such a great job and thanks again.