Craig has projected sales to be \\( \\$ 92,500 \\) in April; \\( \\$ 89,500 \\) in May; \\( \\$ 105,000 \\) in June and \\( \\$ 94,600 \\) in July. The history of Craig's sales indicates \20 cash and the remaining \80 on credit. The company's collection history indicates that credit sales are collected as follows: Requirements: 1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales 2. Prepare a cash collections budget for June and July. Round all answers to the nearest dollar. 3. What does the \2 of credit sales not collected represent? Should this be of concern to Craig? Use the attached Excel spreadsheet to complete the requirements. Prepare a Sales Budget for all four months, showing breakdown between cash and credit sale Sales Budget \\begin{tabular}{l} Craig's Design and Landscaping \\\\ \\multicolumn{4}{|c||}{ Sales Budget } \\\\ \\hline \\\\ \\hline \\end{tabular} Prepare the Cash Budget for June and July. Round all answers to nearest dollar Cash Collections Budget Craig's Design and Landscaping Budgeted Cash Collections from Customers