\begin{tabular}{l|l|l} & A B & C \\ \hline 1 & The Master Budget \end{tabular} 2 Sales and cash collections budgets 4 Augustine Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has projected sales to be: 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. 21 Requirements 221 Prepare a sales budget for all four months, showing the breakdown between cash and credit sales. 232 Prepare a cash collections budget for December and January. 24 a. Use cell references from the prior requirement, if applicable. 26 Saving \& Submitting Solution 271 Save file to desktop. 28 a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 292 Upload and submit your file to be graded. 30 a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet 31 b. Click Choose button under step 3; locate the file you just saved and click Open 32 c. Click Upload button under step 3 33 d. Click Submit button under step 4 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.) 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 3 you will be marked wrong. Use cell references from the prior requirement, if applicable.) \begin{tabular}{l|l|l} & A B & C \\ \hline 1 & The Master Budget \end{tabular} 2 Sales and cash collections budgets 4 Augustine Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has projected sales to be: 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. 21 Requirements 221 Prepare a sales budget for all four months, showing the breakdown between cash and credit sales. 232 Prepare a cash collections budget for December and January. 24 a. Use cell references from the prior requirement, if applicable. 26 Saving \& Submitting Solution 271 Save file to desktop. 28 a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 292 Upload and submit your file to be graded. 30 a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet 31 b. Click Choose button under step 3; locate the file you just saved and click Open 32 c. Click Upload button under step 3 33 d. Click Submit button under step 4 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.) 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 3 you will be marked wrong. Use cell references from the prior requirement, if applicable.)