A Question 2 (of 2) Ce Products is preparing its broget le lamaary, February and March 2021, and has collected and assembled the following information and assumptions for its income statement and cash flow Selling Pre, pecun Cost of Goods Sed, per un Budgeted monthly operating expenses February March Apr G HI 66 marks REQUIRED: In the areas provided, prepare Celmor's budgeted schedules Some of the year total amount cels already have calculations Please ensure you complete any missing "total" amounts where necessary. Marks are based on arriving at correctly calculated amounts Cell referencing is, as always, encouraged Color Products Budgetest meome Statement arti 3,500 3,000 4.200 1,200 $30.00 $30.00 $11.00 $12.00 $17.00 $17.00 $17.00 $17.00 Gold $10,000 per north $2,049 mod 15% of the mos Depreciation Expense Vanale being Exper Tatal Operating Exper Quarter 201 Manf " Oh colections of sales reve Accounts Receivable her, December 31, 2019 1 Percentage of Sales collected in month of sale scentage of tales collected is month following the Cash payments on test of goods sold Accounts Payte balance, December 31, 201 Percentage of coos punt toe in month incred Parcentage of CO pd for in towing moth 570,000 (all of which is to be collected in lanuary) 45% of which to be paid y 545,000 25% co 7% of Co provide ine Rem descriptions. Total Cash Collecti Celor Products Schedule of Budgeted Cash Collectio Quarter 201 January February Ma x Total Cash Collection Cash payments on operating expenses Paid for an applicable) in the month incurred Other cash flow information 1 Cash dadens paid per month qpment purchase for cush $2,000 per month $4,09 February Operating Line of Ge Minimum end of month cash balance desired Annual interest on borrowed cash prodde ne tem descret $15,000 4% paid when principal repa Total Cash Payments-COGS Products Schedule of Cash Payments: Cost of Goods Sold 1st Quarter, 2021 January February Mand Styles Cells Editing Ideas K L M Cellmor Products Schedule of Cash Payments: Operating Expenses