I need help with this problem and entering the information by using cell reference formulas

Steps to Perform: Step Instructions Points Possible 1 1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong) 12 2 2. Prepare a cash collections budget for December and January (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Use cell references from the prior requirement, if applicable) 10 Total Points 22 M N H K 1 The Master Budget 2 Sales and cash collections budgets 3 4 Augustine Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has projected sales to be: 5 October November December January 6 $904,000 $964,000 $1,045,000 $936,000 7 8 Augustine's sales are: 9 20% cash 10 80% credit 11 12 The company's collection history indicates that credit sales are collected as follows: 13 30% in the month of the sale 14 60% in the month after the sale 15 8% two months after the sale 16 2% are never collected 17 18 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you 19 copy/paste from the Instruction tab you will be marked wrong. 20 21 Requirements 22 1 Prepare a sales budget for all four months, showing the breakdown between cash and credit sales. 23 2 Prepare a cash collections budget for December and January 24 a. Use cell references from the prior requirement, if applicable. 25