AutoSave OFF A AFSC... Assignment 6 Budgeting (2022-23) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 12 AA = ab Wrap Text v General Insert v Ex AY- O. Ex Delete v Z Paste BIU BY DV Av E = Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data L96 X V f. B D E F G H K L M N 0 P Q R S T U W X 88 89 90 collections in March should be budgeted to be: 91 A. $105,000. 92 B. $110,000. 93 C. $110,800. 94 D. $113,000. 95 96 97 Part F (1 mark) 98 The Banderas Company, a merchandising firm, has budgeted its activity for December according to the following information: 99 100 1) Sales at $550,000, all for cash 101 2) Merchandise inventory on November 30 was $300,000. 102 3) Budgeted depreciation for December is $35,000. 103 4) The cash balance at December 1 was $25,000. 104 5) Selling and administrative expenses are budgeted at $60,000 for December and are paid in cash 105 6) The planned merchandise inventory on December 31 is $270,000. 106 7) The invoice cost for merchandise purchases represents 75% of the sales price. All purchases are paid for in cash. 107 108 The budgeted cash receipts for December are: 109 A. $137,500 110 B. $412,500 111 C. $550,000. 112 D. $585,000. 113 114 115 Part G (1 Mark) 116 The Banderas Company, a merchandising firm, has budgeted its activity for December according to the following information: 117 118 1) Sales at $550,000, all for cash. 119 2) Merchandise inventory on November 30 was $300,000. 120 3) Budgeted depreciation for December is $35,000. 121 4) The cash balance at December 1 was $25,000. 122 ) Selling and administrative expenses are budgeted at $60,000 for December and are paid in cash. 123 ) The planned merchandise inventory on December 31 is $270,000. 124 7) The invoice cost for merchandise purchases represents 75% of the sales price. All purchases are paid for in cash. 125 126 The budgeted cash disbursements for December are: 127 A. $382,500. Instructions Question 1 Question 2 Question 3 Assessment Criteria + Ready Accessibility: Investigate + 100%