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

UK Registered Company # 11483120


100% Pass Guarantee

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

Recent Updates

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. [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 , written on 2020-03-12

I had wasted so much money for poor quality work on other sites that I became despair to find a reliable one. I landed on Insta Research and finally, I am fully satisfied after ages from their quality of the work and instant response. Also, the rates are handy. Great going guys!
Reviews: 5

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

Very professional and effective assignment writing service.