View Policies Current Attempt in Progress Adam S, managing director of "Summer Breeze", a swimsuit manufacturing company, has requested you to prepare a cash budget for the months of January and February 2020. To assist in this task, they have provided the following information: Cash balance at the end of December 2019 is $40,400; Each swimsuit is sold for $10 each and actual sale for November and December 2019 and projected sale for January and February 2020 are as follows: November December January February 4,300 Cash Sales (Quantity) units 7,200 units 6,200 units 4,300 units Credit Sales 5,300 (Quantity) units 8,700 units 8,200 units 5,500 units 9,600 Total Sales units 15,900 units 14,400 units 9,800 units Analysis of past records has shown that credit sales are collected over a three-month period. With 60% being collected in the month of the sale, 30% in the next month (second month), and the remainder in the following month (third month); Projected expenditure during January and February 2020 is as follows: o A new piece of equipment costing $87,117 was purchased in December 2019. Upon purchase, the agreed credit terms were 40% on purchased (in December 2019), 40% in January 2020 and the remainder in February 2020; o Manufacturing costs (paid for immediately upon production) are budgeted at $6 per swimsuit (Assume that all the swimsuits sold are manufactured in the same month); o Selling and administrative expenses are budgeted to be $12,700 each month. Required: Prepare a cash budget for Summer Breeze for the months of January and February 2020. Please provide your answer in the table below. Please do not provide for any workings. Please round your answers to whole dollar value. All answers must be in $value. If an item is given in Units, please convert these to $values prior to inputting them in the Schedule of Receipt or Cash Budget. Schedule of Receipt January February Schedule of Receipt January November 53,000 $ December 87,000 $ $ January 82,000 $ $ February 55,000 $ Total $ $ Bank balance at beginning of month $ Anticipated Receipts Cash Sale Cash Budget January February $ $ $ Credit Sale $ $ Total receipts $ $ Anticipated Payments Manufacturing Costs $ $ Selling and Administrative expenses $ $ Capital Expenditure $ Total payments $ $ Excess (Deficit) receipts over payments $ Bank balance at End of Month $ February