Im needing help with questions 2-3. I have also posted the picture of the formatted spreadsheet and exhibits to use for the spreadsheet.

questions 2-3

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 4. SHEET ALUMINUM BUDGETED COST $8.00 cost per square yard EXHIBIT 5. RAW MATERIALS INVENTORY Sheet aluminum on hand at the end of each month Raw materials irventory budpet Decomber 31,2020 50.0% of the following months production needs 39,000 square yards \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{21} & \multicolumn{8}{|c|}{ PRODUCIION BUDGET } \\ \hline & & lan & Feb & March & April & May & June & Six Months \\ \hline & Budgeted sales & x2 & & & & & & \\ \hline & Add: desired ending inventory & & & & & & & \\ \hline 5 & Total needs & & & & & F & & \\ \hline 6 & Less: beginning inventory & & & & & & & \\ \hline 7 & Trailer production & + & & & & & & \\ \hline & E & +2 & E & & +2 & & & \\ \hline 9 & \multicolumn{8}{|c|}{ PURCHASES BUDGET } \\ \hline 10 & & tan & Feb & March & April & May & June & Six Months \\ \hline 11 & Trailer production & & & & & & & x2= \\ \hline 12 & Sheet metal needs per trailer & & & & & & & + \\ \hline 13 & Total production needs & x2=x2 & & & & & & \\ \hline 14 & Add: desired ending inventory & & & & & & & \\ \hline 15 & Total materials needs & & & & & & +2 & \\ \hline 16 & Less: beginning inventory & & & & & & & \\ \hline 17 & Total sheet metal purchases & & & & & & & \\ \hline 11 & Cost per square yard & & & & & & & \\ \hline & Total cost & & & & & & & \\ \hline \end{tabular} EXHIBIT 9. ACTUAL 2020 AND PROJECTED 2021 SALES EXHIBITS If your instructor has provided you with alternative data values, be sure to use the alternative data. EXHIBIT 6. BUDGETED EXPENSES FOR THE FIRST SIX MONTHS 2021 \begin{tabular}{|c|c|c|c|} \hline & January & February & March \\ \hline Aluminum & $816,000 & $1,056,000 & $288,000 \\ \hline Other materials & 54,000 & 264,000 & m,000 \\ \hline Wages & 624,000 & 1,008,000 & 1,104,000 \\ \hline Heat, light, \& power & 130,000 & 195,000 & 220,000 \\ \hline Equipment rental & 390,000 & 390,000 & 390,000 \\ \hline Equipment purchases & 300,000 & 300,000 & 300,000 \\ \hline Depreciation & 250,000 & 250,000 & 250,000 \\ \hline \multirow[t]{2}{*}{ Selling \& admin } & 400,000 & 400,000 & 400,000 \\ \hline & April & May & June \\ \hline Aluminum & $552,000 & $336,000 & $240,000 \\ \hline Other materials: & 138,000 & 84,000 & 90,000 \\ \hline Wages & 672,000 & 432,000 & 240,000 \\ \hline Heat, light, \& power & 135,000 & 110,000 & 110,000 \\ \hline Equipment rental & 340,000 & 340,000 & 340,000 \\ \hline Equipment purchases & 300,000 & 300,000 & 300,000 \\ \hline Depreciation & 275,000 & 275,000 & 275,000 \\ \hline Selling 8 admin & 400,000 & 400,000 & 400,000 \\ \hline \end{tabular} 1. Discuss the validity and reasonableness of Travel-Space Trailers' sales projections. The sales projections for Travel-Space Trailers are interesting. The actual sales in 2020 were $23,322, while the projected sales for 2021 are $28,000 which is less than double the previous year's sales. The data from 2015 to 2020 khows a consistent increase, and the jump in the projected sales could be due to expected market growth, a new product, or new marketing strategies. 2. Prepare production, purchasing (aluminum), and cash budgets for Travel-Space Trailers for the first six months of 2021. (Be sure to use the formatted spreadsheet provided) 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 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 25% 10% - The remainder is uncollectible - 60% EXHIBIT 12 SUGGESTED CONSTANT PRODUCTION LEVELS First suggested level 3,000 Second suggested level 3,500 \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ A } & B & C & D \\ \hline 31 & Aluminum & Other materials \\ \hline 33 & Wages \\ \hline 34 & Heat, light, \& power \\ \hline 35 & Equipment rental \\ \hline 36 & Equipment purchases \\ \hline 37 & Selling \& admin \\ \hline 38 & Total cash disbursements \\ \hline 39 & Excess (deficiency) \\ \hline 40 & Financing: \\ \hline 41 & Borrowings: Original \\ \hline 42 & Borrowings: Additional \\ \hline 43 & Repayments \\ \hline 44 & Interest \\ \hline 45 & To be invested (excess) \\ \hline 46 & Total financing \\ \hline 47 & Cash balance ending. \\ \hline \end{tabular} 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 4. SHEET ALUMINUM BUDGETED COST $8.00 cost per square yard EXHIBIT 5. RAW MATERIALS INVENTORY Sheet aluminum on hand at the end of each month Raw materials irventory budpet Decomber 31,2020 50.0% of the following months production needs 39,000 square yards \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{21} & \multicolumn{8}{|c|}{ PRODUCIION BUDGET } \\ \hline & & lan & Feb & March & April & May & June & Six Months \\ \hline & Budgeted sales & x2 & & & & & & \\ \hline & Add: desired ending inventory & & & & & & & \\ \hline 5 & Total needs & & & & & F & & \\ \hline 6 & Less: beginning inventory & & & & & & & \\ \hline 7 & Trailer production & + & & & & & & \\ \hline & E & +2 & E & & +2 & & & \\ \hline 9 & \multicolumn{8}{|c|}{ PURCHASES BUDGET } \\ \hline 10 & & tan & Feb & March & April & May & June & Six Months \\ \hline 11 & Trailer production & & & & & & & x2= \\ \hline 12 & Sheet metal needs per trailer & & & & & & & + \\ \hline 13 & Total production needs & x2=x2 & & & & & & \\ \hline 14 & Add: desired ending inventory & & & & & & & \\ \hline 15 & Total materials needs & & & & & & +2 & \\ \hline 16 & Less: beginning inventory & & & & & & & \\ \hline 17 & Total sheet metal purchases & & & & & & & \\ \hline 11 & Cost per square yard & & & & & & & \\ \hline & Total cost & & & & & & & \\ \hline \end{tabular} EXHIBIT 9. ACTUAL 2020 AND PROJECTED 2021 SALES EXHIBITS If your instructor has provided you with alternative data values, be sure to use the alternative data. EXHIBIT 6. BUDGETED EXPENSES FOR THE FIRST SIX MONTHS 2021 \begin{tabular}{|c|c|c|c|} \hline & January & February & March \\ \hline Aluminum & $816,000 & $1,056,000 & $288,000 \\ \hline Other materials & 54,000 & 264,000 & m,000 \\ \hline Wages & 624,000 & 1,008,000 & 1,104,000 \\ \hline Heat, light, \& power & 130,000 & 195,000 & 220,000 \\ \hline Equipment rental & 390,000 & 390,000 & 390,000 \\ \hline Equipment purchases & 300,000 & 300,000 & 300,000 \\ \hline Depreciation & 250,000 & 250,000 & 250,000 \\ \hline \multirow[t]{2}{*}{ Selling \& admin } & 400,000 & 400,000 & 400,000 \\ \hline & April & May & June \\ \hline Aluminum & $552,000 & $336,000 & $240,000 \\ \hline Other materials: & 138,000 & 84,000 & 90,000 \\ \hline Wages & 672,000 & 432,000 & 240,000 \\ \hline Heat, light, \& power & 135,000 & 110,000 & 110,000 \\ \hline Equipment rental & 340,000 & 340,000 & 340,000 \\ \hline Equipment purchases & 300,000 & 300,000 & 300,000 \\ \hline Depreciation & 275,000 & 275,000 & 275,000 \\ \hline Selling 8 admin & 400,000 & 400,000 & 400,000 \\ \hline \end{tabular} 1. Discuss the validity and reasonableness of Travel-Space Trailers' sales projections. The sales projections for Travel-Space Trailers are interesting. The actual sales in 2020 were $23,322, while the projected sales for 2021 are $28,000 which is less than double the previous year's sales. The data from 2015 to 2020 khows a consistent increase, and the jump in the projected sales could be due to expected market growth, a new product, or new marketing strategies. 2. Prepare production, purchasing (aluminum), and cash budgets for Travel-Space Trailers for the first six months of 2021. (Be sure to use the formatted spreadsheet provided) 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 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 25% 10% - The remainder is uncollectible - 60% EXHIBIT 12 SUGGESTED CONSTANT PRODUCTION LEVELS First suggested level 3,000 Second suggested level 3,500 \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ A } & B & C & D \\ \hline 31 & Aluminum & Other materials \\ \hline 33 & Wages \\ \hline 34 & Heat, light, \& power \\ \hline 35 & Equipment rental \\ \hline 36 & Equipment purchases \\ \hline 37 & Selling \& admin \\ \hline 38 & Total cash disbursements \\ \hline 39 & Excess (deficiency) \\ \hline 40 & Financing: \\ \hline 41 & Borrowings: Original \\ \hline 42 & Borrowings: Additional \\ \hline 43 & Repayments \\ \hline 44 & Interest \\ \hline 45 & To be invested (excess) \\ \hline 46 & Total financing \\ \hline 47 & Cash balance ending. \\ \hline \end{tabular}