Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 lockimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Construction Accounting And Financial Management

Authors: Steven J. Peterson

4th Edition

0135232872, 978-0135232873

More Books

Students also viewed these Accounting questions

Question

No main effect of A; main effect of B; no interaction

Answered: 1 week ago

Question

1. Build trust and share information with others.

Answered: 1 week ago