Assignment #3 Excel File Home Insert Draw Page Layout Formulas Data Review View Help Foxit PDF Tell me what you want to do Aa Colors Width: Automatic Gridlines Headings A Fonts Height: Automatic View View Themes Margins Orientation Size Effects Print Breaks Background Print Area Bring Titles Scale: 70% Print Print Forward Send Backward Themes Page Setup Scale to Fit Sheet Options K43 A B fx E F G H 27 Palabala prepares monthly cash budgets. Relevant data from assumed operating budges 28 for the first two months of the 2022 are as follows: 29 January February 30 Sales $100,000 $150,000 31 Direct Materials Purchases $50,000 $60,000 32 Direct Labour $20,000 $30,000 33 Manufacturing Overhead $10,000 $15,000 34 Depreciation $5,000 $3,500 35 36 All sales are 50% cash 50% in the month following sale. 37 38 All Expenses are paid in the month of sale 39 40 Sales for December was $80,000 41 42 Direct Materials purchases for December was $40,000 43 44 Cash balance on 1st January 2022 was $20,000. 45 Required: 46 Prepare the cash budget for the two (2) months January to February 2022. 47 Sheet1 Sheet2 Sheet3 Ready Accessibility: Investigate a 10 marks J K L M N G DELL) Selection Align Group Rotate Pane Arrange = Sign in Share P Q R S T + 100% 03:37 25/06/2022 2