SuperTech Battery a rapidly growing distributor of battery manufacturers, is formulating its

plans for $2018.$

The planning department of the firm has completed the revenue budget presented here.

Super Tech Battery Ltd

$2018$ Budgeted Revenues $($in thousands$)$

The accountant in the Planning and Budgeting Department is responsible for preparing the

cash$-$flow projection. The following information is to be used in preparing the cash flow

projection:

a$.$ Super Tech Battery's excellent record in accounts receivable collection is expected to

continue: $60\%$ of billings are collected the month after the sale and the remaining

$40\%2$ months after.

b$.$ The purchase of electronic components is Utility Ltd$\text{'}$s largest expenditure and is

estimated to be $40\%$ of revenues. Utility Ltd receives $70\%$ of the parts $1$ month prior

to the sale and $30\%$ during the month of sale.

Prepare Cash collection schedule and Cash payments schedule for the sale and purchase of products. Do the calculations in excel, attach excel screenshot and explain the steps and formulas on how to do it$.$