By using the exhibits please answer questions 2 and 3. A blank chart is posted for how I need the answers documented.

2. Prepare production, purchasing (aluminum), and cash budgets for Travel-Space Trailers for the first six months of 2021. (Hints: 1. Spreadsheet programs are wonderful. 2. Formats have been provided by your instructor; use them.) After preparing the budgets: a. Discuss any issues you suspect may exist in Travel-Space Trailers' cost estimates, including the costs of aluminum, equipment, and selling and administration costs. b. Discuss any issues you suspect may exist in Travel-Space Trailers' financing plans. c. Discuss any issues you notice in Travel-Space Trailers' procedures for preparing budgets. 3. Using the budgets you prepared for the previous question, produce two or three graphs visualizing what you consider to be the most important data to consider, such as: a. Trailer production during the first six months of the year. b. Cash collections and disbursements during the first six months of the year. Explain how each of these visualizations illustrates one or more of the issues you raised in the previous questions. EXHIBITS If your instructor has provided you with alternative data values, be sure to use the alternative data. EXHIBIT 4. SHEET ALUMINUM BUDGETED COST $8.00 cost per square yard EXHIBIT 7. ACCOUNTS PAYABLE FOR ALUMINUM AND OTHER MATERIALS PURCHASED DURING DECEMBER 2020 A/P : Aluminum $700,000 A/P : Other materials $150,000 EXHIBIT 10. ACTUAL AND BUDGETED SALES November 2020 (actual) December 2020 (actual) $1,439,000 January 2021 (budgeted) $2,131,000 February 2021 (budgeted) $2,500,000 March 2021 (budgeted) $4,000,000 April 2021 (budgeted) $5,000,000 $3,000,000 May 2021 (budgeted) $2,200,000 June 2021 (budgeted) $1,100,000 EXHIBIT 11. ACCOUNTS RECEIVABLE COLLECTION SCHEDULE Of a month's sales collected in: Month of sale Month following sale Second month following sale - The remainder is uncollectible - EXHIBIT 12. SUGGESTED CONSTANT PRODUCTION LEVELS First suggested level Second suggested level \begin{tabular}{|l|} \hline Wages \\ Heat, light, \& power \\ Equipment rental \\ Equipment purchases \\ Selling \& admin \\ \hline Total cash disbursements \\ \hline Excess [deficiency] \\ \hline Financing: \\ Borrowings: Original \\ Borrowings: Additional \\ Repayments \\ Interest \\ To be invested [excess) \\ \hline Total financing \\ \hline Cash balance ending \\ \hline \end{tabular}