In: Accounting
Shanghai Enterprises has asked for your assistance in preparing a cash budget for the month
of December 2020 and has provided projected sales revenue data
below
Projected sales:
October 2020
$144,000
November 2020
$205,000
December 2020
$220,000
All sales are on credit with 65% collected during the month of sale, 18% collected during the
month following the sale, 15% during the second month after the sale and 2% uncollectable.
Required:
a) Prepare the cash receipts section of a cash budget for Shanghai Enterprises for the
month of December 2020.
b) Explain how Shanghai Enterprises would go about constructing a cash budget for the first
three months of 2021. Note that Shanghai plans to purchase a major piece of equipment
costing $500,000 in February 2021.