Question 4 (3 Marks) XYZ produces phone case. The company has three different models, which are sold to local retail stores in UAE. The Sales manager expects the following sales for the next year: Case Silver Gold Strass Selling price $50 60 90 Annual sales (units) 80 000 60 000 40 000 The budgeted annual sales are distributed by month in the following percentages: Month Percentage of annual sales January February 3 March 4 April 4 1 May 5 June July August September October November December The cash from sales is collected, 70% in the month of sale and the remainder in the following month BS Mailings Review View Tell me 111 c | | Heading 2 OL No No Spacing Heading 1 Title 7 Required Prepare a monthly sales budget in units and dollars for all three models combined for the months June to December, Show the receivables in the balance sheet at the end of July to December and the budgeted cash collections from sales for July to December XYZ Sales Budget for the month June to December Aug Sept Oct Months OY SALES IN UNITS June July Nov Dec Total ver Gold Stress BUDGETED PRICES PER UNIT Silver Gold Strass BUDGETED SALES DOLLARS Silver Gold Sera TOTAL, BUDGETED SALES RECEIVABLES CASH COLLECTIONS NA NA NA Kingdom O Focus . dvA W DO ooo 000