AutoSave Home Insert Draw Page Layout Formulas Data Review View 9 Tell me 19 Share Cl Comments m:| m2\" v . '_| r) (a v ~+ . a. [I]? [DJV v Cg m: ._ . O + 4 . v 0 Get Add-Ins . v v V ' Slicer T[ Equation v DJ I]? v(D 27%, ' WvhvVQ l _ I C) v PivotTable Recommended Table Data from Pictures Shapes Icons pt _- V Recommended :1 v ' \\- Maps Pivotchart Sparklines - Link New Text PivotTables Picture [Eli V CO My Add Ms E Charts a) L v ED: v \"meme Comment 0 Symbol I M13 ; fx 7 A A B c o E F e H I J K L M N o P q R s T u v w 1 2 Question 2 (1 Omarks) 3 4 Western Company has projected sales and production in units for the second quarter of the coming year as follows: 5 s m:m--m- 7 -mm 45.000 65.000 8 65.000 55,000 m 9 1o Cash-related production costs are budgeted at $10 per unit produced. Ofthese production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amountto $110,000 per month. paid in the month incurred The 11 accounts payable balance on March 31 totals $200,000. which will be paid in April. 12 All units are sold on account (as credit sales) for $21 each. There are no cash sales. Cash collections from sales are budgeted at 50% in the month of sale. 40% in the month following the month of sale. and the remaining 10% in the second month following the month ofsale. Accounts receivable on April 1 totaled $520,000 ($100,000 from February's sales and the remainder from March). 13 14 I 15 Required: Clearly label whether your calculations are for part a. or part b. 16 17 3. Prepare a schedule for each month showing budgeted cash disbursements for the Western Company. (5 marks) 18 19 b. Prepare a schedule for each month showing budgeted cash receipts for the Western Company. (5 marks) 20 21 22 23 24 25 25 27 23 29 Instructions Question 1 Question 2 Question 3 Assessment Criteria + Ready 73>? Accessibility: Investigate El J-' - + 100%