5: Hello, can someone please verify the work I have compelted and also assist me with the blanks in the graphs?

Capes Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow Sales are budgeted at $450,000 for November, $460,000 for December, and $440,000 for January . Collections are expected to be 50% in the month of sale and 50% in the month following the sale. The cost of goods sold is 75% of sales.Et The company desires an ending merchandise inventory equal to 30% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. The November beginning balance in the accounts receivable account is $80.000 The November beginning balance in the accounts payable account is $267.000. Required: 6. Prepare a Schedule of Expected Cash Collections for November and December 6. Prepare a Merchandise Purchases Budget for November and December Complete this question by entering your answers in the tabs below. SHUSHI Required A Required B Prepare a Schedule of Expected Cash Collections for November and December November $ 450,000 December $ 460,000 $ Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total cash collections 80,000 225,000 wwwwwwwwwwwwww $ 225,000 2 20.000 ........... IS 305,000 S 455,000 Required B > Required: a. Prepare a Schedule of Expected Cash Collections for November and December b. Prepare a Merchandise Purchases Budget for November and December. Complete this question by entering your answers in the tabs below. Required A Required B Prepare a Merchandise Purchases Budget for November and December. Merchandise Purchases Budget Cost of goods sold 'Add: Desired ending merchandise inventory Total needs Less: Beginning merchandise inventory Required purchases November December $ 337,500 s 345,000 103,500 99.000 441,000 444,000 101,250 103,500 5 339,750 $ 340,500