Question
40 Celor Products is preparing its budget for January, February and March 2021, and has collected 41 and assembled the following information and assumptions for
40 Celor Products is preparing its budget for January, February and March 2021, and has collected 41 and assembled the following information and assumptions for its income statement and cash flow 43 January February March Apr To view date.ensure you've entered your name/student in the cells above 4 Budgeted sales and cost of goods sold 57 REQUIRED: the areas provided, prepare Celeor's budgeted schedules Some of the year total amount ceh already have collations 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. Budgeted monthly operating expenses per month per month per month of the man's sales 5 Sales Cost of Goods Sold Gross Margin Salaries Expenses Other Fixed Expenses Depreciation Expense Varble Selling Expense Total Operating Expens Operating Income Budgeted Income Statement (Partia January Ma Cabad K24 61 M M 15 CM x Fort % Cash collections of sales revenue (all of which is to be collected in January) 70 PE 7 n 14 Cash payments on cost of goods sold (of which to be paid in mary of COGS COGS s Cash payments un operating expenses 171 Th Other cash flow information Total Cash Collection ee them descriptions Cefnor Products Schedule of Budgeted Cash Collec 1202) Marsh Cell Products Schedule of Cash Papeets Cost of Goods Sold Garter 200 February Ma so other cash flow information: 37 Operating tine of Credit per month In January in February paid when prinopal repaid 53 Any amount can be borrowed and if so, is borrowed at the beginning of the month where borrowing is needed. Any loan repayments (and interest) are repaid at the end of the month where applicable provide line item descriptions Total Cash Payments Co Cerd Schedule of Cash Payment Cost of Goods Sold January Quarter, 2003 February Marc Product Schedule of Cash Payments Operating Fa Can be borrowed and if so, is borrowed at the beginning of the month where borrowing is needed. ayments (and interest) are repaid at the end of the month where applicable Cellmor Products Schedule of Cash Payments: Operating Expenses M January 1st Quarter, 2021 February Marc Lat operating expenses in space provided, as applicab Total Cash Payments Operating Cash balance, beginning Add cash collections Total cash available Les cash payments Cellmor Products Cash Budget anuary $16,000 1st Quarter, 2021 February Mard Cash balance, beginning Add cash collections Total cash available Less cash payments: Cost of Goods Sold Operating Expenses J Total cash payments Excess (deficiency) of cash Financing: Borrowing Repayments Interest Total financing Cash balance, ending Cellmor Products Cash Budget January $16,000 1st Quarter, 2021 February Row: 106 Marc Conditional Format as Cell Formatting Table Styles Styles H 4 Insert Delete Format Sort & Find & Ideas Filter Select Cells Editing Ideas Total cash payments Excess (deficiency) of cash Financing: Borrowing Repayments Interest Total financing Cash balance, ending Calculate the budgeted Accounts Receivable AND Accounts Payable balances as at 31-Mar-21 Accounts Receivable Accounts Payable A ENG 916 AM 12/14/2020 dewte Pomer 8940 82 num lock
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started