Scenario
ABC plc sell three products, A, B and C. Some details of their sales and payments for January to July have already been entered into an MS Excel file, and this file has been provided for
completion.

Requirements
(1) Calculate the receipts, payments, totals, net receipts / payments and balances.
(2) Create a SINGLE 2-D clustered column-chart for the period using the budget completed for (1), showing BOTH:
(i) the total receipts;
(ii) the total payments.
(3) Determine the month in which the cumulative cash (the balance carried forward) will become positive.
(4) Investigate how increasing the retail price of product A to £23.00 will affect the cumulative cash.
(5) Create a line-chart from (4), with markers, showing ONLY the balances carried forward for the period.
(6) Investigate, using Excel’s Goal Seek tool, changing the price of product A so the July balance carried forward reaches £16,000.
(7) Answer the questions below, each with one concise sentence providing full context.
(i) Referring to the budget at (1), in which month will the cumulative cash become positive?
(ii) Referring to the investigation carried out in (4), in which month will the cumulative cash become positive?
(iii) What price should be charged for Product A if the balance carried forward in July is to reach £16,000?
HINT: In each case, what is the context to the situation?
Note that the answer to each question should be displayed in the area indicated within the provided MS Excel file.
(8) Print a four-page document, portrait-orientated except where stated, with numbered pages, using one side of A4 for each:
(i) the completed cash budget of (1) followed by the chart created in (2);
(ii) the completed cash budget of (1) again, this time showing formulae and including Excel row and column headings – only
include headings for this print, do not re-print the chart, do not include question answers; print in landscape orientation;
(iii) the budget showing the investigation carried out in (4) followed by the chart created in (5);
(iv) the budget showing the investigation carried out in (6) followed by the answered questions of (7);
HINT: Complete the cash budget with the original figures then make copies of the worksheet to edit for each print.
(9) Upload the Excel file and submit the paper document before the deadlines given, as per the instructions for submission.
(10) Complete the Moodle quiz at the workshop, referring to an electronic copy of your previously uploaded Excel file.