50.1K

Verified Solution

Link Copied!

Question: Is the screenshot (my output) correct. The Production budget uses the 2021 Projections from Jan 21 to Jun 21 for sales and not actual (see exhibit 9 in the first screenshot). I added the desired inventory, I calculated that by using the required 20% of next month project production (current 20% of next months sales) I then subtracted beginning inventory which appears to be 308 + 0.2*2563 from my table. The summing all this up I got my output. To be clear this is for a production budget for a management accounting subject.

Travel-Space Trailers: A Budgeting Esperience \begin{tabular}{|l|r|r|r|r|r|r|r|} \hline & Jan & Feb & March & April & May & June & Six Honths \\ \hline Budgeted sales & 2,563 & 4,100 & 5,125 & 3,075 & 2,050 & 1,025 & 17,938 \\ \hline Add: desired ending inventory & 820 & 1,025 & 615 & 410 & 205 & 205 & 205 \\ \hline Total needs & 3,383 & 5,125 & 5,740 & 3,485 & 2,255 & 1,230 & 21,218 \\ \hline Less: beginning inventory & 821 & 820 & 1,025 & 615 & 410 & 205 & 205 \\ \hline Trailer production & 2,562 & 4,305 & 4,715 & 2,870 & 1,845 & 1,025 & 21,013 \\ \hline & & & & & & & \\ \hline \end{tabular} Travel-Space Trailers: A Budgeting Esperience \begin{tabular}{|l|r|r|r|r|r|r|r|} \hline & Jan & Feb & March & April & May & June & Six Honths \\ \hline Budgeted sales & 2,563 & 4,100 & 5,125 & 3,075 & 2,050 & 1,025 & 17,938 \\ \hline Add: desired ending inventory & 820 & 1,025 & 615 & 410 & 205 & 205 & 205 \\ \hline Total needs & 3,383 & 5,125 & 5,740 & 3,485 & 2,255 & 1,230 & 21,218 \\ \hline Less: beginning inventory & 821 & 820 & 1,025 & 615 & 410 & 205 & 205 \\ \hline Trailer production & 2,562 & 4,305 & 4,715 & 2,870 & 1,845 & 1,025 & 21,013 \\ \hline & & & & & & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer